Careers360 Logo
Interested in this College?
Get updates on Eligibility, Admission, Placements Fees Structure
Compare

Quick Facts

Medium Of InstructionsMode Of LearningMode Of Delivery
EnglishSelf StudyVideo and Text Based

Courses and Certificate Fees

Fees InformationsCertificate AvailabilityCertificate Providing Authority
INR 20887yesDavidson 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

Instructors

Back to top