SQL: select 'zero to hero'

Course 1: Say goodbye to brute force data manipulations. Learning database basics and SQL syntax will transform the time you spend in spreadsheets, in a good way. Avoid common mistakes and correctly manage your work to ensure maximum accuracy.

Buy $99.00

Course curriculum

1. Course interaction
2. Introduction
1. Pre-course survey
1. Supplemental slides
2. Supplemental files
3. Database file
1. Chapter preview
2. 01 - Database basics
3. 02 - Data types
4. 03 - Set theory
5. 04 - Syntax basics
1. Chapter preview
2. 05 - Install SQL Server
3. 06 - Restore database
4. 07 - IDE (Part 1)
5. 08 - IDE (Part 2)
6. 09 - IDE (Part 3)
1. Chapter preview
2. 10 - Style guide (Part 1)
3. 11 - Style guide (Part 2)
4. 12 - Style guide (Part 3)
1. Chapter preview
2. 13 - Naming structures and aliases
3. 14 - Where clause
4. 15 - Group by clause
5. 16 - Order by clause
6. 17 - Exercise 1
7. 18 - From and join
8. 19 - Join types and null
9. 20 - Join types in action
10. 21 - Case statement
11. 22 - Understanding how joins work
12. 23 - Exercise 2
13. 24 - Distinct
14. 25 - Having and top
1. Chapter preview
2. 26 - Overview
3. 27 - Aggregates
4. 28 - Strings
5. 29 - Math
6. 30 - Date and time
7. 31 - Null and cast
1. Chapter preview
2. 32 - Query framework
3. Exercise 3
1. Post-course survey

About this course

46 lessons
2.0+ hours of high-quality video
Supplemental files and slides

SQL: select 'zero to hero'

Course curriculum

Introduction

Pre-course Survey

Materials

Database Basics

Installation and Orientation

Style Guide

Query Basics

Functions and Operators

Query Framework

Post-course Survey

About this course