Project Based SQL Course: Code like a SQL Programmer

Focused View

Brandon Brown

6:18:20

46 View

1. Introduction, Download Databases, and Course Overview

1. Lec 0.0 - Introduction.mp4

01:56

2. Lec 0.1 - How to use this resource, and the 5 star system.mp4

04:25

3. Lec 0.2 - Learning Expectations.mp4

01:20

4. Lec 0.3 - Download SQL Server.mp4

05:29

5.1 create insurance database.zip

5.2 create update database.zip

5. Lec 0.4 - Create Course Database.mp4

01:06

6.1 Insurance Database Diagram - Annotated.pdf

6. Lec 0.5 - Insurance Data Overview.mp4

11:09

2. SELECT - The mother of all queries

1.1 SQLPresentation 20181224 - Lec1 - SELECT.pptx

1. Lec 1.1 - SELECT, ORDER BY, WHERE.mp4

09:32

2.Lec 1.2 - AND OR, NULL.mp4

06:18

3.Lec 1.3 - Aggregate Functions.mp4

03:39

4.Lec 1.4 - DISTINCT vs GROUP BY.mp4

06:57

5.Lec 1.5 - Other Important Statements.mp4

07:12

6. Lec 1.6 - SELECT Exercises!.mp4

08:51

7. Project Step 16.mp4

08:18

3. JOINs - Turning tables into a database

1.1 SQLPresentation 20181224 - Lec2 - Joins.pptx

1.Lec 2.1 - INNER JOIN, LEFT JOIN.mp4

21:52

2.Lec 2.2 - Other JOINs.mp4

03:23

3.Lec 2.3 - JOIN Tips.mp4

03:05

4. Lec 2.4 - JOIN Exercises.mp4

13:53

5. Project Step 26.mp4

16:25

4. Subqueries - Queries inside of queries

1.1 SQLPresentation 20181224 - Lec3 - Sub-queries.pptx

1.Lec 3.1 - Subqueries Intro.mp4

02:09

2.Lec 3.2 - Subqueries (WHERE).mp4

05:04

3.Lec 3.3 - Subqueries (FROM).mp4

13:29

4.Lec 3.4 - Subqueries (SELECT).mp4

01:38

5. Lec 3.5 - Subquery Exercises.mp4

14:19

6. Project Step 36.mp4

13:17

5. CREATE Databases and Tables

1.1 SQLPresentation 20181224 - Lec4 - Creating Tables.pptx

1.Lec 4.1 - Databases.mp4

02:58

2.Lec 4.2 - CREATE TABLE Part 1 - Data Types.mp4

11:51

3.Lec 4.3 - CREATE TABLE Part 2 - Constraints.mp4

07:43

4.Lec 4.4 - ALTER TABLE.mp4

10:06

5.Lec 4.5 - @Variables.mp4

10:24

6. Lec 4.6 - Table Exercises.mp4

07:02

7. Project Step 46.mp4

04:34

6. INSERT, UPDATE, and DELETE data in tables

1.1 SQLPresentation 20181224 - Lec5 - Adding Data.pptx

1.Lec 5.1 - INSERT INTO.mp4

11:14

2.Lec 5.2 - UPDATE, DELETE.mp4

06:43

3.Lec 5.3 - INSERT INTO from a table.mp4

08:57

4.Lec 5.4 - UPDATE from a table.mp4

04:55

5. (BONUS) Lec 5.5 - #TemporaryTables.mp4

15:57

6. Lec 5.6 - INSERT UPDATE Exercises.mp4

27:29

7. Project Step 56.mp4

23:47

7. Stored Procedures! Turning queries into programs

1.1 SQLPresentation 20181224 - Lec6 - Stored Procedures.pptx

1.Lec 6.1 - Stored Procedures.mp4

12:48

2. Lec 6.2 - Stored Procedure Exercises.mp4

15:55

3. Project Step 66.mp4

11:11

8. Projects and Exercises

1. Project 1 - Outstanding Publish (Covered throughout course).html

2. Project 2 - Timeliness (Hard-Very Hard).html

3. Project 3 - Time to Publish (Very Hard).html

4. Exercise 1 (Hard).html

5. Exercise 2 (Medium).html

6. Exercise 3 (Medium).html

7. Exercise 4 (Medium-Hard).html

8. Exercise 5 (Easy-Medium).html

9. Simple Coding Exercise 1.html

Description

Attempt Projects and Tests on a mock database that is designed to simulate the day-to-day work of a SQL programmer

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.

Who is this for?

Intermediate SQL users

What You Need to Know?

None! If you have access to a computer then you're ready to learn SQL

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Programmer, Instructor, and former Actuary.Programming mastery comes the same way you master any other skill: practice and repetition. Learn to program the right way; not just by watching somebody else flip through slides, but from working on projects and taking tests yourself. I've designed my courses to focus on the most important topics and supply you with quality, real-world examples that will test your knowledge and creativity.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.