Oracle SQL and PL/SQL Training Course ( Youtube links )
1 Introduction
2 Oracle Express Download and Install
4 SQL Developer Download
5 Set up a Connection in SQL Developer
6 Create a New User
7 Our Sample Database
8 Setting Up Our Sample Data
9 How to View Data With the SELECT Statement
10 Selecting Individual Columns
11 Filtering Data with WHERE
12 Comparison Operators
13 Filtering on Partial Values with LIKE
14 Filtering on Date Values
15 Using Two Filters
16 More Than Two Filters
17 What is NULL
18 Getting Unique Records with DISTINCT
19 IN and NOT IN
20 BETWEEN and NOT BETWEEN
21 ALL Keyword
22 ANY Keyword
23 Sorting Results with the ORDER BY Clause
24 Ordering By Multiple Columns
25 Set Operators and UNION
26 UNION ALL Operator
27 INTERSECT Operator
28 MINUS Operator
29 Three or More Sets At Once
30 What are Functions
31 Counting Data
32 Using COUNT in Other Ways
33 Counting Data Within Groups with GROUP BY
34 GROUP BY with WHERE and ORDER BY
35 GROUP BY with Multiple Columns
36 GROUP BY with HAVING
37 The SUM Function
38 Using the MAX and MIN functions
39 Using the AVG function
40 What are Table Aliases
41 What Are Column Aliases
42 What Are Joins
43 Inner Join
44 Left Outer Join
45 Right Outer Join
46 Full Outer Join
47 Natural Join
48 Cartesian or Cross Join
49 Self Join
50 Joining Many Tables
---
