×

Blog Create CV Courses Certificates Online Courses Communities

Login

Sign up

Join Our Telegram Channel Now to Get Any New Free Courses : Click Here

002 SQL SELECT WHERE | NOT | OR | AND

Share your inquiries now with community members Click Here

Previous Lesson Next Lesson

Sign Up and Get Free Certificate

Lessons List | 30 Lesson

001 SQL Introdução comentários e SELECT

001 SQL Introdução comentários e SELECT

002 SQL SELECT WHERE | NOT | OR | AND

002 SQL SELECT WHERE | NOT | OR | AND

003 SQL SELECT DISTINCT e ORDER BY

003 SQL SELECT DISTINCT e ORDER BY

004 SQL SELECT LIKE NOT LIKE e LIMIT

004 SQL SELECT LIKE NOT LIKE e LIMIT

005 SQL SELECT BETWEEN IN e NOT IN

005 SQL SELECT BETWEEN IN e NOT IN

006 SQL SELECT MIN MAX e Utilização de ALIASES

006 SQL SELECT MIN MAX e Utilização de ALIASES

007 SQL SELECT COUNT AVG e SUM

007 SQL SELECT COUNT AVG e SUM

008 GROUP BY e GROUPBY HAVING

008 GROUP BY e GROUPBY HAVING

009 DELETE e TRUNCATE

009 DELETE e TRUNCATE

010 INNER JOIN LEFT JOIN E RIGHT JOIN

010 INNER JOIN LEFT JOIN E RIGHT JOIN

011 UNION e UNION ALL

011 UNION e UNION ALL

012 UPDATE e INSERT

012 UPDATE e INSERT

013 CHAR LENGTH CONCAT e CONCAT WS

013 CHAR LENGTH CONCAT e CONCAT WS

014 FORMAT SELECT INSERT UCASE UPPER LCASE LOWER

014 FORMAT SELECT INSERT UCASE UPPER LCASE LOWER

015 LEFT RIGHT LOCATE LPAD RPAD

015 LEFT RIGHT LOCATE LPAD RPAD

016 MID REPEAT REPLACE REVERSE

016 MID REPEAT REPLACE REVERSE

017 ABS CEIL CEILING FLOOR ROUND SELECT TRUNCATE DIV

017 ABS CEIL CEILING FLOOR ROUND SELECT TRUNCATE DIV

018 SIGN PI POW SQRT e MOD

018 SIGN PI POW SQRT e MOD

019 CREATE DATABASE DROP DATABASE CREATE TABLE e DROP TABLE

019 CREATE DATABASE DROP DATABASE CREATE TABLE e DROP TABLE

020 Valores ALFANUMERICOS CHAR VARCHAR TINYTEXT TEXT BLOB

020 Valores ALFANUMERICOS CHAR VARCHAR TINYTEXT TEXT BLOB

021 Valores NUMERICOS TINYINT SMALLINT MEDIUMINT INT BIGINT FLOAT DOUBLE DECIMAL UNSIGNED

021 Valores NUMERICOS TINYINT SMALLINT MEDIUMINT INT BIGINT FLOAT DOUBLE DECIMAL UNSIGNED

022 Valores DATA HORA DATE DATETIME TIMESTAMP TIME e YEAR

022 Valores DATA HORA DATE DATETIME TIMESTAMP TIME e YEAR

023 CONSTRAINTS NOT NULL e UNIQUE

023 CONSTRAINTS NOT NULL e UNIQUE

024 PRIMARY KEY

024 PRIMARY KEY

025 FOREIGN KEY

025 FOREIGN KEY

026 FOREIGN KEY e AUTO INCREMENT

026 FOREIGN KEY e AUTO INCREMENT

027 QUERIES ANINHADAS NESTED QUERIES

027 QUERIES ANINHADAS NESTED QUERIES

028 CREATE VIEW

028 CREATE VIEW

029 TEMPORARY TABLE e CREATE TABLE SELECT

029 TEMPORARY TABLE e CREATE TABLE SELECT

030 STORED PROCEDURES

030 STORED PROCEDURES

Comments

Our New Certified Courses Will Reach You in Our Telegram Channel
Join Our Telegram Channels to Get Best Free Courses

We Appreciate Your Feedback

Be the First One Review This Course

Excellent		0 Reviews
Good		0 Reviews
medium		0 Reviews
Acceptable		0 Reviews
Not Good		0 Reviews

0

0 Reviews

How Much Stars ?

What is Your Feedback ?

Related Courses in Programming

React Projects Workshops

React Projects Workshops

Node js back end JavaScript

Node js back end JavaScript

Python programming language

Python programming language

Social Network Theme UI With Sass

Social Network Theme UI With Sass

Full Stack React Django

Full Stack React Django

Build a Node js App With Sequelize

Build a Node js App With Sequelize

GraphQL With React Apollo

GraphQL With React Apollo

Node js REST API With Restify Mongoose JWT

Node js REST API With Restify Mongoose JWT

Full Stack Vue js Express MongoDB

Full Stack Vue js Express MongoDB

Exploring Docker

Exploring Docker

Responsive Portfolio Website

Responsive Portfolio Website

The MERN Stack

PHP REST API High level

PHP REST API High level

Up unning With Symfony 4

Up unning With Symfony 4

JavaScript Workshops

JavaScript Workshops

PHP MySQL Stripe API Payment App

PHP MySQL Stripe API Payment App

Course Description

SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database .

Trends

Recent