SQL and PostgreSQL: Introductions Course for Beginners
BEST SELLER
58 Lectures
5h 5m 34s
Prepare for your examination with our training course. The course contains a complete batch of videos that will provide you with profound and thorough knowledge related to certification exam. Pass the test with flying colors.
$14.99
$19.49
Curriculum For This Course
-
1. Section Introduction1m 14s
-
2. Databases and SQL3m 25s
-
3. Installing PostgreSQL6m 1s
-
4. Setting Up the Database10m 34s
-
1. Section Introduction2m 10s
-
2. Select5m 32s
-
3. Select Where6m 12s
-
4. Multiple Wheres9m 36s
-
5. Solution 1: Selecting From a Table3m 46s
-
6. In, Not In7m 21s
-
7. Between5m 31s
-
8. CODE: SQL for BETWEEN7m 40s
-
9. Like5m 46s
-
10. Solution 2: Selecting From a Table7m 31s
-
11. Order By6m 4s
-
12. Limiting Number of Results5m 25s
-
13. Distinct5m 6s
-
14. Setting a Column Name Alias4m 32s
-
1. Section Introduction54s
-
2. Joins in SQL2m 24s
-
3. Inner Join Part 14m 4s
-
4. Inner Join Part 23m 35s
-
5. Solution 1: Selecting from Multiple Tables3m 59s
-
6. Left Join3m 3s
-
7. Right Join11m 44s
-
8. Full Join3m 45s
-
9. Solution 2: Selecting from Multiple Tables5m 59s
-
10. Joining More Than Two Tables13m 47s
-
11. Union11m 34s
-
12. Solution 3: Selecting from Multiple Tables6m 30s
-
1. Section Introduction54s
-
2. What are Aggregate Functions2m 24s
-
3. Count4m 4s
-
4. Min and Max3m 35s
-
5. Sum3m 59s
-
6. Average3m 3s
-
7. Group By11m 44s
-
8. Having3m 45s
-
9. Solution: Aggregate Functions5m 59s
-
1. Section Introduction1m
-
2. What is Data Definition Language?1m 23s
-
3. Data Types7m 54s
-
4. Primary Keys3m
-
5. Foreign Keys2m 50s
-
6. Creating Tables: Part 110m 39s
-
7. Creating Tables: Part 28m 51s
-
8. Solution 1: Data Definition Language3m 41s
-
9. Modifying Tables: Adding and Removing Columns5m 29s
-
10. Modifying Tables: Modifying Columns10m 12s
-
11. Removing Tables1m 42s
-
12. Deleting All Rows from Tables1m 58s
-
13. Solution 2: Data Definition Language3m 35s
-
1. Section Introduction36s
-
2. What is Data Manipulation Language?56s
-
3. Inserting Data into Tables9m 16s
-
4. Updating Data in Tables7m 44s
-
5. Deleting Data from Tables4m 31s
-
6. Solution: Data Manipulation Language6m 6s
