Introduction to SQL
Beginner
Online
4 Weeks
Free Quick Facts
| Medium Of Instructions | Mode Of Learning | Mode Of Delivery |
|---|---|---|
| English | Self Study | Video and Text Based |
Courses and Certificate Fees
| Fees Informations | Certificate Availability | Certificate Providing Authority |
|---|---|---|
| INR 20887 | yes | Davidson College, Davidson |
The Syllabus
- Introduction
- History of SQL
- Installing PostgreSQL (Windows)
- Installing PostgreSQL (Mac)
- Learning environment setup
- Basic SQL
- More Basic SQL
- Week 1 Wrap-Up
- Week 2 Introduction
- SQL Joins
- SQL Aggregations
- Subqueries
- Combining results
- Data Inspection and Conversion
- Data Manipulation
- Week 2 Wrap-Up
- Week 3 Introduction
- Analytic functions
- Variables and temporary sets
- Pivoting
- Week 3 Wrap-Up
- Week 4 Introduction
- Sample database installation
- AdventureWorks Scenario 1
- AdventureWorks Scenario 2
- AdventureWorks Scenario 3
- Week 4 Wrap-Up