Careers360 Logo
ask-icon
share
    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.