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

CreativeLive

SQL Bootcamp

via CreativeLive

Go to class Write review

Overview

Turn the information in databases into valuable insights by writing SQL queries. Once you understand the basics of viewing tables, columns, and rows, you will learn how to write queries to extract the specific information you need. In this hands-on course, you will learn PostgreSQL and the free D...

Syllabus

  • Benefits of Learning SQL
  • Connecting to Our Database
  • Getting Started & Your First Query
  • Learning the SQL Language
  • Coding Exercise PostgreSQL
  • Solution PostgreSQL Challenge
  • Data Types and Filtering Results
  • Coding Exercise Filtering with WHERE
  • Solution Filtering with WHERE
  • Pattern Matching
  • Combining Filters and Aliases
  • Coding Exercise Like and Wildcards
  • Solution Like and Wildcards
  • Database Terminology and Primary & Foreign Keys
  • Joins Combining Data from Multiple Tables
  • Exercise Inner Join
  • Solution Inner Join
  • Inner vs. Outer Joins
  • Exercise Outer Join and NULL
  • Solution Outer Join and NULL
  • Cast
  • Aggregate Functions
  • Exercise Aggregate Function and ROUND
  • Solution Aggregate Function and ROUND
  • Date Functions
  • Exercise 2.0 Date Functions
  • Solution 2.0 Date Functions
  • Grouping Data
  • Subqueries
  • Solution Subqueries
  • Aggregate Window Functions
  • Solution WIndow Functions
  • Conditionals
  • CASE Exercise
  • Views
  • Views Solution
  • String Functions
  • Learning Resources
  • Finding Datasets
  • AI and SQL
  • Challenge AI and SQL
  • Solution AI and SQL

Reviews

4.8 rating at CreativeLive based on 247 ratings

Start your review of SQL Bootcamp

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.