Project Based SQL Course: Code like a SQL Programmer
4.2 (322 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,449 students enrolled

Project Based SQL Course: Code like a SQL Programmer

Attempt Projects and Tests on a mock database that is designed to simulate the day-to-day work of a SQL programmer
4.2 (322 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,449 students enrolled
Created by Brandon Brown
Last updated 3/2020
English
English [Auto]
Current price: $118.99 Original price: $169.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 1 article
  • 10 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • A complete course designed to simulate real SQL work: The database is complex, and the projects are thorough.
  • Get plenty of practice as you learn about manipulating data and database design, as well as a bit about insurance.
Requirements
  • None! If you have access to a computer then you're ready to learn SQL
Description

No more watching other people do SQL with no context or practice problems!  This course was designed to give you experience actually working on SQL problems, ensuring that you learn all the skills necessary to propel your programming careers.

This was my experience when I was learning SQL myself: I found tons of places that would show you how to write basic SQL statements, but hardly anywhere when it came to finding places that would show me real databases and fitting projects to practice those skills.

After working for years as a programmer, I made this course to give determined students a place to simulate the work environment by creating a complex database and assigning projects that will test your creativity and SQL knowledge learned throughout the course.

Who this course is for:
  • Intermediate SQL users
Course content
Expand all 43 lectures 06:21:26
+ JOINs - Turning tables into a database
5 lectures 58:38
⍟⍟⍟⍟⍟ Lec 2.1 - INNER JOIN, LEFT JOIN
21:52
★★★ Lec 2.2 - Other JOINs
03:23
★★★★ Lec 2.3 - JOIN Tips
03:05
Lec 2.4 - JOIN Exercises
13:53
Project Step 2/6
16:25
+ Subqueries - Queries inside of queries
6 lectures 49:56
⍟⍟⍟⍟⍟ Lec 3.1 - Subqueries Intro
02:09
★★★★ Lec 3.2 - Subqueries (WHERE)
05:04
⍟⍟⍟⍟⍟ Lec 3.3 - Subqueries (FROM)
13:29
★★ Lec 3.4 - Subqueries (SELECT)
01:38
Lec 3.5 - Subquery Exercises
14:19
Project Step 3/6
13:17
+ CREATE Databases and Tables
7 lectures 54:38
★★ Lec 4.1 - Databases
02:58
★★★★ Lec 4.2 - CREATE TABLE Part 1 - Data Types
11:51
★★★★ Lec 4.3 - CREATE TABLE Part 2 - Constraints
07:43
★★★ Lec 4.4 - ALTER TABLE
10:06
★★★★ Lec 4.5 - @Variables
10:24
Lec 4.6 - Table Exercises
07:02
Project Step 4/6
04:34
+ INSERT, UPDATE, and DELETE data in tables
7 lectures 01:39:02
★★★★ Lec 5.1 - INSERT INTO
11:14
★★★★ Lec 5.2 - UPDATE, DELETE
06:43
★★★ Lec 5.3 - INSERT INTO from a table
08:57
★★ Lec 5.4 - UPDATE from a table
04:55
(BONUS) Lec 5.5 - #TemporaryTables
15:57
Lec 5.6 - INSERT UPDATE Exercises
27:29
Project Step 5/6
23:47
+ Stored Procedures! Turning queries into programs
3 lectures 39:54
★★★ Lec 6.1 - Stored Procedures
12:48
Lec 6.2 - Stored Procedure Exercises
15:55
Project Step 6/6
11:11
+ Projects and Exercises
0 lectures 00:00
Project 1 - Outstanding Publish (Covered throughout course)
Project 1 - Outstanding Publish (Covered throughout course)
1 question
This project, which I am calling the Timeliness project, can be seen as the complement to the course project. The Timeliness project will be looking at already completed publishes, and determining if those publishes were completed within the required number of days.
Project 2 - Timeliness (Hard-Very Hard)
1 question
Project 3 - Time to Publish. This is certainly the most challenging query in this course.
Project 3 - Time to Publish (Very Hard)
1 question
Exercise 1 (Hard)
Exercise 1 (Hard)
1 question
Exercise 2 (Medium)
Exercise 2 (Medium)
1 question
Exercise 3 (Medium)
Exercise 3 (Medium)
1 question
Exercise 4 (Medium-Hard)
Exercise 4 (Medium-Hard)
1 question
Exercise 5 (Easy-Medium)
Exercise 5 (Easy-Medium)
1 question