Course Highlights
  • How to use a relational database
  • How to query data and shape results
  • How to write advanced queries and analytic functions
  • How to create and modify data in tables
Skills you will learn!
Curriculum

4 Topics
Introduction and History of SQL
Installing PostgreSQL
Basic SQL
Comments & SQL Styles

4 Topics
SQL Joins
Aggregations & Subqueries
Data Inspeciton and Converting Data
String Manipulation

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

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

  Write a Review

DavidsonX: Introduction to SQL

Go to Paid Course