Course Content
المحتوى
0/32
001 Introduction to SQL: Comments and SELECT
11:42
001 Introduction to SQL: Comments and SELECT
11:42
002 SQL SELECT with WHERE, NOT, OR, and AND
11:42
003 SQL SELECT DISTINCT and ORDER BY
11:42
004 SQL SELECT with LIKE, NOT LIKE, and LIMIT
11:42
005 SQL SELECT with BETWEEN, IN, and NOT IN
11:42
006 SQL SELECT MIN, MAX, and Using ALIASES
11:42
007 SQL SELECT COUNT, AVG, and SUM
11:42
008 GROUP BY and HAVING
11:42
009 DELETE and TRUNCATE
11:42
010 INNER JOIN, LEFT JOIN, and RIGHT JOIN
11:42
011 UNION and UNION ALL
11:42
012 UPDATE and INSERT
11:42
013 CHAR, LENGTH, CONCAT, and CONCAT_WS
11:42
014 FORMAT, SELECT, INSERT, UCASE, UPPER, LCASE, LOWER
11:42
015 LEFT, RIGHT, LOCATE, LPAD, and RPAD
11:42
016 MID, REPEAT, REPLACE, and REVERSE
11:42
017 ABS, CEIL, CEILING, FLOOR, ROUND, SELECT, TRUNCATE, and DIV
11:42
018 SIGN, PI, POW, SQRT, and MOD
11:42
019 CREATE DATABASE, DROP DATABASE, CREATE TABLE, and DROP TABLE
11:42
020 Alphanumeric Values: CHAR, VARCHAR, TINYTEXT, TEXT, BLOB
11:42
021 Numeric Values: TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT, FLOAT, DOUBLE, DECIMAL, UNSIGNED
11:42
022 Date and Time Values: DATE, DATETIME, TIMESTAMP, TIME, and YEAR
11:42
023 Constraints: NOT NULL and UNIQUE
11:42
024 PRIMARY KEY
11:42
025 FOREIGN KEY
11:42
026 FOREIGN KEY and AUTO INCREMENT
11:42
027 Nested Queries
11:42
028 CREATE VIEW
11:42
029 Temporary Tables and CREATE TABLE SELECT
11:42
030 Stored Procedures
11:42
Final Exam - Mastering SQL for Professionals
Mastering SQL for Professionals

Understand how to implement foreign keys and use AUTO INCREMENT for primary key fields.

Previous
Next
0% Complete