The Complete MySQL Bootcamp: Zero to Hero SQL Skills

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

Master MySQL: From Beginner to Advanced - Unlock SQL Skills with Hands-On Projects & Database Design Techniques

1. Introduction

1.1 Class 1 Files.zip

1. Introduction to the Data World

2. How to Install MySQL

1. How to Install MySQL

3. Basic Understanding of SDLC

1.1 Document - Hardware SDLC and Job Roles.pdf

1. Basic Understanding of SDLC

2. Basic Understanding of SDLC.html

3. Hardware Setup in the Industry

4. Hardware Setup Quiz.html

5. Typical Team Structure

6. Evolution of Data

7. Evolution of Data Quiz.html

8. Different Data Job Roles

9. Different Data Job Roles.html

4. Understanding the Business Requirements and Project Architecture

1. Understanding the Business Requirements and Project Architecture

2. Understanding the business requirements and Project Architecture Quiz.html

5. Dumping the data in the Staging Layer of the Database using Tableau Prep

1.1 AdventureWorks.xlsx

1. Dumping the data in the Staging Layer of the Database using Tableau Prep

2. Dumping Data to Staging Layer Quiz.html

6. Creating and Loading Customer Dimension Table

1.1 creating and loading customer dimension table - hop1.zip

1. Creating and Loading Customer Dimension Table

2. Creating and Loading Customer Dimension Table Quiz.html

7. Creating and Loading Other Dimension and Fact Tables

1.1 creating and loading all other tables - hop1.zip

1. Creating and Loading Other Dimension and Fact Tables

8. Creating the Customer Dimension Table with Customer Type

1.1 creating and loading customer dimension table - hop2.zip

1. Understanding the Requirements for Customer Table

2.1 Types of Joins.pdf

2. Types of Joins and where will it fail

3. Practically Understand the Joins in MySQL

4. Building the logic for Customer Dimension Table - Part 1

5. Understanding Group By

6. Building the Logic for Customer Dimension Table - Part 2

9. Loading the Final Layer with all the relevant constraints

1. Understanding the Constraints

2. Applying the Constraints in our Project Tables

10. Functions in MySQL

1. Single Row Functions

189,000 تومان

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

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

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

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