1 -Course Overview Who This Course Is For & What You Will Learn (41.63 MB)
1 -What Is Data (31.86 MB)
2 -What Is Database (27.39 MB)
3 -The History of Database (25.44 MB)
1 -Examples of database usage (35.24 MB)
2 -Basic terminology tables, rows and columns (19.68 MB)
3 -Lesson 1 2 Summary (22.88 MB)
1 -The History of SQL (18.05 MB)
2 -The benefits of SQL (35.1 MB)
3 -How SQL Works (24.36 MB)
1 -Exploring SQL Common Data Types (84.18 MB)
2 -Exploring NULL Values in SQL (42.46 MB)
1 -Downloading and Installing Oracle Database - SQL Developer (38.71 MB)
2 -User and Schema (57.08 MB)
3 -SID VS Service Name (29.33 MB)
4 -Connect to DataBase (54.35 MB)
1 -SQL Statements (28.64 MB)
2 -Basic syntax and structure of SQL queries (126.55 MB)
3 -Column Alias (39.64 MB)
4 -Use Asterisk (58.45 MB)
5 -Dual Table (146.13 MB)
6 -Rownum (36.27 MB)
7 -Distinct (110.49 MB)
1 -Introduction to the WHERE Clause (180.4 MB)
2 -Using the BETWEEN operator to match a range of values (85.77 MB)
3 -Using the IN operator to match multiple values (115.47 MB)
4 -Using the LIKE operator for pattern matching (115.67 MB)
5 -Null Values , Is Null , Is Not Null (80.35 MB)
6 -Using the WHERE clause with multiple conditions (225.36 MB)
1 -Sorting query results using the ORDER BY clause (168.17 MB)
2 -Sorting Multiple Columns (96.86 MB)
3 -Sorting with NULL Values (100.33 MB)
4 -Sorting DISTINCT Results (73.27 MB)
5 -ORDER BY with ROWNUM (102.82 MB)