SQL Mastery & Data Analysis A-Z Best & Complete Course MySQL

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

One Stop Bootcamp With Lectures, Practice Sessions and Assignments WITH code samples, the only course you need.

1. Introduction

1. Goals & Objectives

2. Introduction To Database Systems

1. Database Systems

2. Typical Database Objects

3. Typical Objects & Access in a Database System

4. Typical Objects & Access in a Database System - 2

5. Designing a Database System

3. Install & Setup Database Environment - MySQL Database

1. Download MySQL Installer

2. Run MySQL Installer

3. Resolve Conflicts & Install MySQL

4. Configuration 1

5. Configuration 2

6. Connect to MySQL

4. Setting up Sales Data in MySQL

1. MySQL Workbench Interface

2. Understanding SALES datamodel

3.1 createdb sqlhandson.zip

3.2 dbcreatetables sqlhandson.zip

3. Create Database & Tables - Workout 1

4. Create Tables - Workout 2

5. Create Tables - Workout 3

6.1 dbpopulate sqlhandson.zip

6. Populate Tables

7. Populate Tables 2

8.1 ml sales null data.zip

8.2 ml sales.zip

8. Populate Tables 3

9.1 dbclean.zip

9.2 dbdelete.zip

9. Delete Tables and Delete Data - DO NOT Run !.html

5. Introduction to SQL

1. Why do We Need SQL

2.1 introductiontoselect.zip

2. Introduction to SELECT Statement

3.1 introductiontoselect ws.zip

3.2 sqlconcepts exercises.zip

3.3 upd ml product item benefits.zip

3. Introduction to SELECT Statement - 2

6. SQL Concepts

1. SQL Concepts - Data Definition (DDL), Modification(DML), Queringy(DQL)

2.1 sqlconcepts exercises.zip

2. SQL Concepts Exercises.html

3. JOINS - Combining Data from Multiple TablesViews

4. CROSS JOINS - All combinations of rows from TablesViews

5. Sub Queries - Query Inside a Query, aka Nested or Sub Query.

6. Self Joins - Joining a Table or View with Itself

7.1 joins ws.zip

7.2 joins.zip

7. Workout - JOINS

8.1 cross joins.zip

8. Workout - CROSS JOINS

9.1 ml sales null data.zip

9. WORKOUT - Load ML SALES Table

10. Explanation - Left , Right and & Full Outer Join

11.1 joins ws.zip

11.2 joins.zip

11. Workout - Left , Right and & Full Outer Join - 2

7. Understanding Transactions

1.1 transactionsandlocking.zip

1. Transactions

8. MySQL Architecture

1. MySQL Architecture Introduction

2. MySQL Architecture for Relational Database

9. MySQL Datatypes

1. Introduction - MySQL Datatypes

2. Numeric Datatypes

3. String Datatypes

4.1 datatypes.zip

4. Workout - Numeric and Strings

5. Date & Time

6. Workout - Date and Time

7. Workout 2 - Date and Time

10. Functions & Operators

1. Numeric - Arithmetic & Mathematical Functions and Operators

2. String Functions & Operators

3. String - Regular Expressions

4. Date & Time

5. Comparison & Logical

6. Assignment & Flow-Control

7.1 functionsoperators.zip

7.2 handson.zip

7. Workout 1 - F & O With SQL Files

8. Workout 2 - F & O

9. Workout 3 - F & O

10. Workout 4 - F & O

11. Workout 5 - F & O

12. Workout 6 - F & O

13. Workout 7 - F & O

14. Workout 8 - F & O

15. Workout 8 - Part 2 F & O

16. Workout 9 - F & O

17. Workout 10 - F& O

18. Workout 11 - F & O

19. Workout 12 - F & O

20. Workout 13 - F & O

21. Workout 14 - F & O

22. Workout 15 - F & O

23. Workout 16 - F & O

24. Workout 17 - F&O

25. Workout 18 - 1 Part1

26. Workout 18 - 1 Part 2

27. Workout 18 - 2- F&O

28. Workout 19

29. Workout 20 - 1

30. Workout 20 - 2

11. Functions - Aggregate & Window Functions

1.1 aggregatefunctions.zip

1.2 handson.zip

1. Aggregate Functions with SQL Files

2. Group By Modifiers

3. Workout Aggregate Funs 1

4. Workout Aggregate Funs 2

5. Workout Aggregate Funs 3

6. Workout Aggregate Funs - WIndows 1

7. Workout Aggregate - 2

8. Workout Aggregate - 3

12. Window Functions

1.1 aggregatefunctions.zip

1.2 handson.zip

1. Non-Aggregate Window Functions With SQL Files

2. Workout - Non Aggregate Year on Year Sales Analysis

3. Workout Non Aggregate Function - Yearly Sales Report

4. Workout Window & Partition Functions - 1

5. Workout Window & Partition Functions - 2

13. Prepared Statements

1.1 handson.zip

1.2 preparedstatements.zip

1. Prepared Statements in MySQL With SQL Files

2. Prepared Statements - 2

3. Prepared Statements - 3

14. Compound Statements, Stored Procedures

1. Introduction to Compound Statements

2. Compound Statements Continued - IF, CASE, WHILE,REPEAT, LOOP, Cursors

3. Error Handling in ProceduresCursors

4. Stored Routines - Procedures & Dynamic Cursors

5. StoredRoutines-Procedures, Triggers Detailed

6.1 compoundstatementsamples.zip

6.2 handson.zip

6.3 handson2.zip

6.4 loops.zip

6. Workout - Procedures 1 With SQL Files

7. Workout - Procedures 2

8. Workout - Procedures 3

9. Workout - Procedures 4

10. Workout - Procedures 5

11. Workout - Cursors 1

12. Workout - Cursors 2

13. Workout - Cursors 3

14. Workout - Cursors 3 Continued

15.1 createstoredprocedures1.zip

15.2 createstoredprocedures2.zip

15.3 createtriggers.zip

15.4 testtrigger.zip

15. Samples to Practice - Procedures & Triggers.html

15. Information Functions - DiscoveringUndestanding Your Database

1. Show Database and Schema Information

2.1 handson.zip

2.2 sql practice sqlmasterdb.zip

2. Workout 1 - Information Functions

3. Workout 2 - InformationFunctions

16. User Accounts & Permissions - Managing access to your Data

1. Users and Grants

2.1 grants.zip

2.2 handsonusersgrants.zip

2.3 users.zip

2. Workout 1 - Users and Grants

3. Workout 2 - Users and Grants

17. Assignment - Design a Date Dimension

1. Designing A Date Dimension Table.html

18. Data Encryption

1. Encryption Concepts

2.1 encryption&compressions.zip

2. Encryption - Working Session.html

19. Semi-Structured Data Support

1. Non RDBMS (NoSQL)

2. Document Store Architecture

20. Additional SQL Files

1.1 exerciseslist.zip

1.2 flowcontrolcorrection.zip

1.3 ListOfStatementsFunctions.txt

1.4 sql practice.zip

1.5 sqlmodes.zip

1.6 WorkingSessions LIST.txt

1. Additional SQL Source Files and a suggested list of Exercises.html

179,000 تومان

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

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

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

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