SQL Programming for Data Analysis: Ultimate Guide

سرفصل های دوره

Complete SQL Programming: MySQL, Database Management, Data Analysis, Business Intelligence and Database Design

1. Welcome to the Course

1. What You Will Learn Module 0.html

2. 0 1. Lecture 0A Course Intro

3. 0 2. Lecture 0B Download, Install and Launch MySQL

4.1 CoursePack SQL for Data Analysts.zip

5. 0 4. Demo Overview of Course Folder Structure

6. 0 5. Demo Download MySQL and Install MySQL

2. Databases, Data Modeling and Create Database

1. What You Will Learn Module 1.html

2. 1 1. Lecture 1A Databases and Data Modeling

3. 1 2. Lecture 1B Data Types and SQL Syntax

4. 1 3. Lecture 1C Create Database and ERD Model

5. 1 4. Lab 1A - Create Database and Load Data

6. 1 5. Lab 1B - How to Create ERD Data Model

3. SELECT Statements

1. What You Will Learn Module 2.html

2. 2 1. Lecture 2 SELECT STATEMENTS

3. 2 2. Lab 2A - Select Statements ORDER BY

4. 2 3. Lab 2B - Select Statements WHERE

4. Joins Inner, Outer (Left), Cross, Self and Conditional

1. What You Will Learn Module 3.html

2. 3 1. Lecture 3 Join Operations

3. 3 2. Lab 3A - Join Operations Inner and Outer (Left)

4. 3 3. Lab 3B - Join Operations Cross and Self

5. 3 4. Lab 3C - Join Operations Conditional (Temporal)

5. Set Operators

1. What You Will Learn Module 4.html

2. 4 1. Lecture 4 Set Operators

3. 4 2. Lab 4A Set Operators Union vs Union All

4. 4 3. Lab 4B Set Operators Intersect

5. 4 4. Lab 4C Set Operators Except

6. Functions and Aggregations

1. What You Will Learn Module 5.html

2. 5 1. Lecture 5 Functions & Aggregations Part 1 - Date, String, Logical and Cond

3. 5 2. Lecture 5 Functions & Aggregations Part 2 - Window Function and Agg.

4. 5 3. Lab 5A - Functions & Aggregations Scalar and String

5. 5 4. Lab 5B - Functions & Aggregations Logical

6. 5 5. Lab 5C - Functions & Aggregations Window

7. 5 6. Lab 5D - Functions & Aggregations Group By and Having

7. Sub-Queries

1. What You Will Learn Module 6.html

2. 6 1. Lecture 6 Sub-Queries

3. 6 2. Lab 6A - Sub-Queries Scalar

4. 6 3. Lab 6B - Sub-Queries Correlated

5. 6 4. Lab 6C - Sub-Queries Derived Table

8. Views, Temp Tables and CTEs

1. What You Will Learn Module 7.html

2. 7 1. Lecture 7 Views, Temp Tables and CTEs

3. 7 2. Lab 7A - Create Views

4. 7 3. Lab 7B - Create Temp Tables

5. 7 4. Lab 7C - Create Common Table Expressions (CTEs)

9. Grouping Sets and Pivot Tables

1. What You Will Learn Module 8.html

2. 8 1. Lecture 8 Grouping Sets and Pivot Tables

3. 8 2. Lab 8A - Grouping Sets RollUp

4. 8 3. Lab 8B - Create Pivot Tables

5. 8 4. Lab 8C - Create Unpivot Tables

10. Modifying Data

1. What You Will Learn Module 9.html

2. 9 1. Lecture 9 Modifying Data

3. 9 2. Lab 9A - Create Backup Tables

4. 9 3. Lab 9B - Insert Records

5. 9 4. Lab 9C - Update Records

6. 9 5. Lab 9D - Delete Records

11. Programming T-SQL

1. What You Will Learn Module 10.html

2. 10 1. Lecture 10 Programming T-SQL

3. 10 2. Lab 10A - Commenting

4. 10 3. Lab 10B - VariableParameters

5. 10 4. Lab 10C - Stored Procedures

12. Error Handling in SQL

1. What You Will Learn Module 11.html

2. 11 1. Lecture 11 Error Handling in SQL

3. 11 2. Lab 11A - Error Handling

4. 11 3. Lab 11B - Intro to Transactions

13. Capstone Projects

1. Capstone Project 1 OpenAirBnB.html

2. 12 2. Capstone Project 1 Setup Database

3. 12 3. Capstone Project 1 Question 1

4. 12 4. Capstone Project 1 Question 2

5. 12 5. Capstone Project 1 Question 3

6. 12 6. Capstone Project 1 Question 4

7. 12 7. Capstone Project 1 Question 5

8. 12 8. Capstone Project 1 Question 6

9. 12 9. Capstone Project 1 Question 7

10. 12 10. Capstone Project 1 Question 8

11. 12 11. Capstone Project 1 Question 9

12. 12 12. Capstone Project 1 Question 10

13. 12 13. Capstone Project 1 Question 11

14. 12 14. Capstone Project 1 Question 12

15. 12 15. Capstone Project 1 Question 13

16. 12 16. Capstone Project 1 Question 14

17. 12 17. Capstone Project 1 Question 15

18. 12 18. Capstone Project 1 Question 16

19. 12 19. Capstone Project 1 Question 17

20. 12 20. Capstone Project 1 Question 18

21. Capstone Project 2 E-Commerce (Extra).html

22. 12 21. Capstone Project 2 E-Commerce - Solution (Text Reminder).html

14. CONGRATULATIONS!!!

1. Course Wrap Up.html

2. Congratulations!!!

3. Bonus Lecture.html

139,000 تومان

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

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

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

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