Careers360 Logo
Browse by Stream
Search Colleges, Exams, Schools & more
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

Similar Courses

MSBI and SQL Training

Microsoft Corporation via  Intellipaat

13.28 K

Oracle SQL Exam Prep

LearnQuest via  Coursera

Months 3Free

Structured Query Language using SAS

SAS Institute via  Coursera

4.12 K
View All Courses

More Courses by Davidson College, Davidson

Drug Discovery and Medicinal Chemistry

Davidson College, Davidson via  Edx

Months 5Free

Excel for Beginners

Davidson College, Davidson via  Edx

Months 4Free

AP Calculus Challenging Concepts from Calculus AB and Calculus BC

Davidson College, Davidson via  Edx

Years 1Free
View All Courses

Explore on Careers360

Download Careers360 App
All this at the convenience of your phone

  • Regular Exam Updates

  • Best College Recommendations

  • College & Rank predictors

  • Detailed Books and Sample Papers

  • Question and Answers

Scan and download the app

OR

Back to top