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

1. Introduction, Download Databases, and Course Overview

1. Lec 0.0 - Introduction

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

3. Lec 0.2 - Learning Expectations

4. Lec 0.3 - Download SQL Server

5.1 create insurance database.zip

5.2 create update database.zip

5. Lec 0.4 - Create Course Database

6.1 Insurance Database Diagram - Annotated.pdf

6. Lec 0.5 - Insurance Data Overview

2. SELECT - The mother of all queries

1.1 SQLPresentation 20181224 - Lec1 - SELECT.pptx

1. Lec 1.1 - SELECT, ORDER BY, WHERE

2.Lec 1.2 - AND OR, NULL

3.Lec 1.3 - Aggregate Functions

4.Lec 1.4 - DISTINCT vs GROUP BY

5.Lec 1.5 - Other Important Statements

6. Lec 1.6 - SELECT Exercises!

7. Project Step 16

3. JOINs - Turning tables into a database

1.1 SQLPresentation 20181224 - Lec2 - Joins.pptx

1.Lec 2.1 - INNER JOIN, LEFT JOIN

2.Lec 2.2 - Other JOINs

3.Lec 2.3 - JOIN Tips

4. Lec 2.4 - JOIN Exercises

5. Project Step 26

4. Subqueries - Queries inside of queries

1.1 SQLPresentation 20181224 - Lec3 - Sub-queries.pptx

1.Lec 3.1 - Subqueries Intro

2.Lec 3.2 - Subqueries (WHERE)

3.Lec 3.3 - Subqueries (FROM)

4.Lec 3.4 - Subqueries (SELECT)

5. Lec 3.5 - Subquery Exercises

6. Project Step 36

5. CREATE Databases and Tables

1.1 SQLPresentation 20181224 - Lec4 - Creating Tables.pptx

1.Lec 4.1 - Databases

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

3.Lec 4.3 - CREATE TABLE Part 2 - Constraints

4.Lec 4.4 - ALTER TABLE

5.Lec 4.5 - @Variables

6. Lec 4.6 - Table Exercises

7. Project Step 46

6. INSERT, UPDATE, and DELETE data in tables

1.1 SQLPresentation 20181224 - Lec5 - Adding Data.pptx

1.Lec 5.1 - INSERT INTO

2.Lec 5.2 - UPDATE, DELETE

3.Lec 5.3 - INSERT INTO from a table

4.Lec 5.4 - UPDATE from a table

5. (BONUS) Lec 5.5 - #TemporaryTables

6. Lec 5.6 - INSERT UPDATE Exercises

7. Project Step 56

7. Stored Procedures! Turning queries into programs

1.1 SQLPresentation 20181224 - Lec6 - Stored Procedures.pptx

1.Lec 6.1 - Stored Procedures

2. Lec 6.2 - Stored Procedure Exercises

3. Project Step 66

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

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy