SQL and PostgreSQL: Introductions Course for Beginners
Best Seller
58 Lectures
5h 5m 34s
Prepare for your Microsoft examination with our training course. The No_code course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft No_code test with flying colors.
$13.99$24.99
Curriculum For This Course
- 1. Section Introduction 1m 14s
- 2. Databases and SQL 3m 25s
- 3. Installing PostgreSQL 6m 1s
- 4. Setting Up the Database 10m 34s
- 1. Section Introduction 2m 10s
- 2. Select 5m 32s
- 3. Select Where 6m 12s
- 4. Multiple Wheres 9m 36s
- 5. Solution 1: Selecting From a Table 3m 46s
- 6. In, Not In 7m 21s
- 7. Between 5m 31s
- 8. CODE: SQL for BETWEEN 7m 40s
- 9. Like 5m 46s
- 10. Solution 2: Selecting From a Table 7m 31s
- 11. Order By 6m 4s
- 12. Limiting Number of Results 5m 25s
- 13. Distinct 5m 6s
- 14. Setting a Column Name Alias 4m 32s
- 1. Section Introduction 54s
- 2. Joins in SQL 2m 24s
- 3. Inner Join Part 1 4m 4s
- 4. Inner Join Part 2 3m 35s
- 5. Solution 1: Selecting from Multiple Tables 3m 59s
- 6. Left Join 3m 3s
- 7. Right Join 11m 44s
- 8. Full Join 3m 45s
- 9. Solution 2: Selecting from Multiple Tables 5m 59s
- 10. Joining More Than Two Tables 13m 47s
- 11. Union 11m 34s
- 12. Solution 3: Selecting from Multiple Tables 6m 30s
- 1. Section Introduction 54s
- 2. What are Aggregate Functions 2m 24s
- 3. Count 4m 4s
- 4. Min and Max 3m 35s
- 5. Sum 3m 59s
- 6. Average 3m 3s
- 7. Group By 11m 44s
- 8. Having 3m 45s
- 9. Solution: Aggregate Functions 5m 59s
- 1. Section Introduction 1m
- 2. What is Data Definition Language? 1m 23s
- 3. Data Types 7m 54s
- 4. Primary Keys 3m
- 5. Foreign Keys 2m 50s
- 6. Creating Tables: Part 1 10m 39s
- 7. Creating Tables: Part 2 8m 51s
- 8. Solution 1: Data Definition Language 3m 41s
- 9. Modifying Tables: Adding and Removing Columns 5m 29s
- 10. Modifying Tables: Modifying Columns 10m 12s
- 11. Removing Tables 1m 42s
- 12. Deleting All Rows from Tables 1m 58s
- 13. Solution 2: Data Definition Language 3m 35s
- 1. Section Introduction 36s
- 2. What is Data Manipulation Language? 56s
- 3. Inserting Data into Tables 9m 16s
- 4. Updating Data in Tables 7m 44s
- 5. Deleting Data from Tables 4m 31s
- 6. Solution: Data Manipulation Language 6m 6s
Hot Exams
How to Open Test Engine .dumpsqueen Files
Use FREE DumpsQueen Test Engine player to open .dumpsqueen files
Your purchase with DumpsQueen.com is safe and fast.
The DumpsQueen.com website is protected by 256-bit SSL from Cloudflare, the leader in online security.