-
Introduction 0/7
-
What is SQLLecture1.1
-
What is DatabaseLecture1.2
-
What is RDBMSLecture1.3
-
DBMS vs RDBMSLecture1.4
-
SQL SyntaxLecture1.5
-
Data TypesLecture1.6
-
OperatorsLecture1.7
-
-
SQL Database 0/4
-
CREATE DatabaseLecture2.1
-
DROP DatabaseLecture2.2
-
RENAME DatabaseLecture2.3
-
SELECT DatabaseLecture2.4
-
-
SQL Table 0/10
-
What is TableLecture3.1
-
TABLE VariableLecture3.2
-
CREATE TABLELecture3.3
-
DROP TABLELecture3.4
-
DELETE TABLELecture3.5
-
RENAME TABLELecture3.6
-
TRUNCATE TABLELecture3.7
-
COPY TABLELecture3.8
-
TEMP TABLELecture3.9
-
ALTER TABLELecture3.10
-
-
SQL Select 0/14
-
SELECT StatementLecture4.1
-
SELECT UNIQUELecture4.2
-
SELECT DISTINCTLecture4.3
-
SELECT COUNTLecture4.4
-
SELECT TOPLecture4.5
-
SELECT FIRSTLecture4.6
-
SELECT LASTLecture4.7
-
SELECT RANDOMLecture4.8
-
SELECT ASLecture4.9
-
SELECT INLecture4.10
-
SELECT MultipleLecture4.11
-
SELECT DATELecture4.12
-
SELECT SUMLecture4.13
-
SELECT NULLLecture4.14
-
-
SQL Clause 0/1
-
WHERE, AND, OR, WITH, ASLecture5.1
-
-
SQL Order By 0/6
-
SQL Insert 0/4
-
INSERT StatementLecture7.1
-
INSERT INTO ValuesLecture7.2
-
INSERT INTO SELECTLecture7.3
-
INSERT Multiple RowsLecture7.4
-
-
SQL Update 0/3
-
UPDATE StatementLecture8.1
-
UPDATE JOINLecture8.2
-
UPDATE DATELecture8.3
-
-
SQL Delete 0/8
-
DELETE StatementLecture9.1
-
DELETE TABLELecture9.2
-
DELETE ROWLecture9.3
-
DELETE All RowsLecture9.4
-
DELETE Duplicate RowsLecture9.5
-
DELETE DATABASELecture9.6
-
DELETE VIEWLecture9.7
-
DELETE JOINLecture9.8
-
-
SQL Join 0/6
-
JOINLecture10.1
-
Outer Join, Inner JoinLecture10.2
-
Left JoinLecture10.3
-
Right JoinLecture10.4
-
Full JoinLecture10.5
-
Cross JoinLecture10.6
-
-
SQL Keys 0/5
-
Primary KeyLecture11.1
-
Foreign KeyLecture11.2
-
Composite KeyLecture11.3
-
Unique KeyLecture11.4
-
Alternate KeyLecture11.5
-
This content is protected, please login and enroll course to view this content!
Prev
DELETE DATABASE
Next
DELETE JOIN