Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Davidson College

Introduction to SQL

Davidson College via edX

Overview

SQL (Structured Query Language) is the most commonly used language to communicate with databases and extract data for application development, reporting and analytics. It is ubiquitous for industries across the world and a vital skill for aspiring data professions to have. This course will introduce you to the SQL language and give you the skills you need to query and analyze data from complex relational databases. Join this course if you are seeking to learn data skills to advance in your current field or pivot to a different field where you will interact with data.

In this SQL tutorial you will learn how to interact with the SQL server with the proper syntax, begin to use SQL commands and SQL databases, perform SQL queries, work with data types and database tables, and use

Syllabus

SQL (Structured Query Language) is the most commonly used language to communicate with databases and extract data for application development, reporting, and analytics. It is ubiquitous for industries across the world and a vital skill for aspiring data professionals to have. This course will introduce you to the SQL language and give you the skills you need to query and analyze data from complex relational databases. Join this course if you are a student or professional hoping to learn data skills to advance in your current field or pivot to a different career that is more data focused. _ ****_

Week 1

  • Introduction and History of SQL
  • Installing PostgreSQL
  • Basic SQL
  • Comments & SQL Styles

Week 2

  • SQL Joins
  • Aggregations & Subqueries
  • Data Inspeciton and Converting Data
  • String Manipulation

Week 3

  • Analytic Functions
  • Variables and Temporary Sets
  • Recursive Operations Using CTEs
  • Pivoting Data

Week 4

  • Sample Database Installation
  • 3 Final Exercises
  • Putting It All Together!

Taught by

Pete Benbow

Reviews

5.0 rating, based on 1 Class Central review

4.5 rating at edX based on 35 ratings

Start your review of Introduction to SQL

  • Anonymous
    I recently completed this course that its amazing due to its exceptional content and hands-on approach. The lectures were thorough and easy to follow, providing clarity on complex topics. What truly set this course apart was the inclusion of practical exercises. These hands-on activities not only reinforced theoretical concepts but also offered a valuable opportunity to apply the knowledge in real-world scenarios. The course's user-friendly platform and comprehensive support further contributed to an outstanding learning experience. Highly recommended for anyone seeking to learn SQL.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.