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

Pete Benbow
Team lead

Davidson College, Davidson

Similar Courses

MSBI and SQL Training

Microsoft Corporation via  Intellipaat

13.28 K

Oracle SQL Exam Prep

LearnQuest via  Coursera

Months 3Free
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

Ask
Question
Ask

Student Community: Where Questions Find Answers

Ask and get expert answers on exams, counselling, admissions, careers, and study options.
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

400M+

Students

36K+

Colleges

500+

Exams

3K+

eBooks

16K+

Certifications

Scan and download the app

OR

Back to top