01 course-introduction (5.05 MB)
02 introduction-to-databases (7.38 MB)
03 select-statement (7.09 MB)
04 count-distinct-limit (4.17 MB)
05 insert-statement (4.58 MB)
06 update-and-delete-statements (5.79 MB)
01 relational-database-concepts (9.01 MB)
02 types-of-sql-statements-ddl-vs-dml (3.71 MB)
03 create-table-statement (5.99 MB)
04 alter-drop-and-truncate-tables (6.48 MB)
02 how-to-create-a-database-instance-on-cloud (9.82 MB)
01 using-string-patterns-and-ranges (7.16 MB)
02 sorting-result-sets (4.88 MB)
03 grouping-result-sets (5.55 MB)
01 built-in-database-functions (10.29 MB)
02 date-and-time-built-in-functions (4.81 MB)
03 sub-queries-and-nested-selects (8.46 MB)
04 working-with-multiple-tables (12.42 MB)
01 working-with-real-world-datasets (8.5 MB)
02 getting-table-and-column-details (7.33 MB)
01 views (6.49 MB)
02 stored-procedures (5.08 MB)
03 acid-transactions (6.52 MB)
01 join-overview (6.68 MB)
02 inner-join (4.54 MB)
03 outer-joins (9.01 MB)