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

Student Community: Where Questions Find Answers

Ask and get expert answers on exams, counselling, admissions, careers, and study options.