Introduction to SQL
Beginner
Online
4 Weeks
Free
Interested in this College?
Get updates on Eligibility, Admission, Placements Fees Structure
Compare 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