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

Focused View

Maverick Learning

15:47:03

24 View

1. Introduction

1. Goals & Objectives.mp4

11:40

2. Introduction To Database Systems

1. Database Systems.mp4

11:34

2. Typical Database Objects.mp4

00:44

3. Typical Objects & Access in a Database System.mp4

11:41

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

01:13

5. Designing a Database System.mp4

08:20

3. Install & Setup Database Environment - MySQL Database

1. Download MySQL Installer.mp4

02:43

2. Run MySQL Installer.mp4

02:43

3. Resolve Conflicts & Install MySQL.mp4

03:58

4. Configuration 1.mp4

04:31

5. Configuration 2.mp4

00:38

6. Connect to MySQL.mp4

01:01

4. Setting up Sales Data in MySQL

1. MySQL Workbench Interface.mp4

11:48

2. Understanding SALES datamodel.mp4

09:04

3.1 createdb sqlhandson.zip

3.2 dbcreatetables sqlhandson.zip

3. Create Database & Tables - Workout 1.mp4

17:25

4. Create Tables - Workout 2.mp4

05:07

5. Create Tables - Workout 3.mp4

05:17

6.1 dbpopulate sqlhandson.zip

6. Populate Tables.mp4

07:37

7. Populate Tables 2.mp4

03:33

8.1 ml sales null data.zip

8.2 ml sales.zip

8. Populate Tables 3.mp4

02:43

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.mp4

09:22

2.1 introductiontoselect.zip

2. Introduction to SELECT Statement.mp4

14:03

3.1 introductiontoselect ws.zip

3.2 sqlconcepts exercises.zip

3.3 upd ml product item benefits.zip

3. Introduction to SELECT Statement - 2.mp4

10:44

6. SQL Concepts

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

23:39

2.1 sqlconcepts exercises.zip

2. SQL Concepts Exercises.html

3. JOINS - Combining Data from Multiple TablesViews.mp4

11:41

4. CROSS JOINS - All combinations of rows from TablesViews.mp4

16:49

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

21:25

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

10:31

7.1 joins ws.zip

7.2 joins.zip

7. Workout - JOINS.mp4

09:04

8.1 cross joins.zip

8. Workout - CROSS JOINS.mp4

21:16

9.1 ml sales null data.zip

9. WORKOUT - Load ML SALES Table.mp4

03:00

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

05:40

11.1 joins ws.zip

11.2 joins.zip

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

03:34

7. Understanding Transactions

1.1 transactionsandlocking.zip

1. Transactions.mp4

24:45

8. MySQL Architecture

1. MySQL Architecture Introduction.mp4

02:08

2. MySQL Architecture for Relational Database.mp4

08:37

9. MySQL Datatypes

1. Introduction - MySQL Datatypes.mp4

08:17

2. Numeric Datatypes.mp4

13:11

3. String Datatypes.mp4

13:13

4.1 datatypes.zip

4. Workout - Numeric and Strings.mp4

16:31

5. Date & Time.mp4

06:52

6. Workout - Date and Time.mp4

06:28

7. Workout 2 - Date and Time.mp4

04:17

10. Functions & Operators

1. Numeric - Arithmetic & Mathematical Functions and Operators.mp4

06:51

2. String Functions & Operators.mp4

09:02

3. String - Regular Expressions.mp4

11:33

4. Date & Time.mp4

04:17

5. Comparison & Logical.mp4

03:57

6. Assignment & Flow-Control.mp4

22:45

7.1 functionsoperators.zip

7.2 handson.zip

7. Workout 1 - F & O With SQL Files.mp4

07:01

8. Workout 2 - F & O.mp4

04:56

9. Workout 3 - F & O.mp4

20:43

10. Workout 4 - F & O.mp4

04:35

11. Workout 5 - F & O.mp4

08:09

12. Workout 6 - F & O.mp4

07:11

13. Workout 7 - F & O.mp4

08:39

14. Workout 8 - F & O.mp4

03:32

15. Workout 8 - Part 2 F & O.mp4

01:00

16. Workout 9 - F & O.mp4

13:32

17. Workout 10 - F& O.mp4

07:40

18. Workout 11 - F & O.mp4

05:46

19. Workout 12 - F & O.mp4

10:24

20. Workout 13 - F & O.mp4

10:57

21. Workout 14 - F & O.mp4

03:24

22. Workout 15 - F & O.mp4

08:11

23. Workout 16 - F & O.mp4

11:28

24. Workout 17 - F&O.mp4

12:07

25. Workout 18 - 1 Part1.mp4

12:10

26. Workout 18 - 1 Part 2.mp4

06:30

27. Workout 18 - 2- F&O.mp4

05:53

28. Workout 19.mp4

05:19

29. Workout 20 - 1.mp4

04:43

30. Workout 20 - 2.mp4

08:13

11. Functions - Aggregate & Window Functions

1.1 aggregatefunctions.zip

1.2 handson.zip

1. Aggregate Functions with SQL Files.mp4

16:02

2. Group By Modifiers.mp4

12:37

3. Workout Aggregate Funs 1.mp4

06:45

4. Workout Aggregate Funs 2.mp4

03:50

5. Workout Aggregate Funs 3.mp4

05:14

6. Workout Aggregate Funs - WIndows 1.mp4

10:46

7. Workout Aggregate - 2.mp4

03:10

8. Workout Aggregate - 3.mp4

06:41

12. Window Functions

1.1 aggregatefunctions.zip

1.2 handson.zip

1. Non-Aggregate Window Functions With SQL Files.mp4

05:25

2. Workout - Non Aggregate Year on Year Sales Analysis.mp4

02:57

3. Workout Non Aggregate Function - Yearly Sales Report.mp4

08:01

4. Workout Window & Partition Functions - 1.mp4

04:51

5. Workout Window & Partition Functions - 2.mp4

05:29

13. Prepared Statements

1.1 handson.zip

1.2 preparedstatements.zip

1. Prepared Statements in MySQL With SQL Files.mp4

01:34

2. Prepared Statements - 2.mp4

02:36

3. Prepared Statements - 3.mp4

04:52

14. Compound Statements, Stored Procedures

1. Introduction to Compound Statements.mp4

12:59

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

20:19

3. Error Handling in ProceduresCursors.mp4

10:08

4. Stored Routines - Procedures & Dynamic Cursors.mp4

01:58

5. StoredRoutines-Procedures, Triggers Detailed.mp4

21:40

6.1 compoundstatementsamples.zip

6.2 handson.zip

6.3 handson2.zip

6.4 loops.zip

6. Workout - Procedures 1 With SQL Files.mp4

03:33

7. Workout - Procedures 2.mp4

06:37

8. Workout - Procedures 3.mp4

04:36

9. Workout - Procedures 4.mp4

07:26

10. Workout - Procedures 5.mp4

05:57

11. Workout - Cursors 1.mp4

09:13

12. Workout - Cursors 2.mp4

05:40

13. Workout - Cursors 3.mp4

17:12

14. Workout - Cursors 3 Continued.mp4

03:51

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.mp4

09:22

2.1 handson.zip

2.2 sql practice sqlmasterdb.zip

2. Workout 1 - Information Functions.mp4

08:05

3. Workout 2 - InformationFunctions.mp4

05:46

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

1. Users and Grants.mp4

15:51

2.1 grants.zip

2.2 handsonusersgrants.zip

2.3 users.zip

2. Workout 1 - Users and Grants.mp4

06:38

3. Workout 2 - Users and Grants.mp4

03:54

17. Assignment - Design a Date Dimension

1. Designing A Date Dimension Table.html

18. Data Encryption

1. Encryption Concepts.mp4

21:07

2.1 encryption&compressions.zip

2. Encryption - Working Session.html

19. Semi-Structured Data Support

1. Non RDBMS (NoSQL).mp4

00:47

2. Document Store Architecture.mp4

04:39

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

Description

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

What You'll Learn?

Understand the concept of a Database, how it is designed, implemented and queried (SQL) with MySQL as an example.
Learn SQL and Data Analysis, from Zero Knowledge to Mastery
Understand Data Modeling & Database Systems
The Datamodel, Database and SQL Concepts are Generic - They can be applied to any database system (Oracle, SQL Server, MySQL etc.)
Learn how to Create a Database, Create Tables, Views, and Procedures
Learn How to Create Users, Roles, and Manage Access/Priviliges
Learn how to Write Simple Queries and Answer Simple Business Questions
Write Complex Queries, Answer Complex Business Questions
Analyze Data from Different Perspectives and Scenarios
Hands on and Practical Exercises on MySQL Database Tool
SQL Source Files Included by Sections.
Design a simple sales datamodel and populate seed data (fictitious).

Who is this for?

Anyone from a Highschool student to a CIO can take this course !

Students, Data Analysts, Excel and MS Access users, Developers, Managers, Business Persons

Anyone with Basic High School Math and Analysis Skills

Just know basic math - What is Addition, What is Subtraction, Multiplication. Trigonometry, if you please.

The Smartest in the Room, the Dumbest in the Room.

The Goal is to Teach even that 'Monkey on the Tree' how to write complex queries !!

What You Need to Know?

Basic Analytical Mind, anyone above Highschool can take this.

If you have taken my Free course on SQL Mastery, it can be a big plus.

More details

Description
This is a Complete SQLÂ Mastery course with complete sql files (End to End database coding), in continuation of my free course.
All data, database objects, queries, examples, scenarios, cases, logic, in this entire course, are fictitious and and do not resemble any real world data.
There 'may be' a Million Jobs in Data Science.
There ARE MULTIÂ MILLIONÂ number Jobs needing Strong SQLÂ Skills !! For every Python resource needed, there are 5-10 SQLÂ resources need.
SQL is one of THEÂ BASICÂ needs of anyÂ IT and Business Analysis professional (Software, Analyst, Engineering, Data Management , Reporting, Business Analyst, Sales Analyst or anything !).
Anyone and Everyone - whether you are a Startup Enthusiast/Entrepreneur, Developer, Analyst, Call Center employee, Manager, Leader or just about ANYONE looking to tap the power of Software to scale up your business, career or launch your own startup, you MUSTÂ have strong SQLÂ Skills.
MySQLÂ is an opensource and ABSOLUTELYÂ FREEÂ Database system that pretty much is used by a MAJORITYÂ of Startup companies (along with PhP).
As Promised in the Teaser, we are publishing the Full Fledged SQLÂ Workout &Â Bootcamp course.
WeÂ have worked on Data Management multi-year projects for CreditÂ Card (Providian, Amex etc.), Banking (Credit Suisse, Â Wells, BoFA etc.) and many other corporations and have crunched up to billions of rows in processing (for a SINGLEÂ transaction table !). IÂ am on a mission to prepare anÂ Easy to Understand and Wholesome courseÂ on SQLÂ Mastery that anyone (from the Smartest to the Dumbest in the room) can conquer easily. IÂ want everyone to just Monkey their way to SQLÂ Mastery without feeling confused or intimidated by it.
In this Course, IÂ First attempt to explain Database and SQLÂ concepts from a Layman's perspective or a Managerial view - without specific Tool or Language semantics. After the concepts, IÂ move on to MySQLÂ specific workings in the main course.
There is PLENTYÂ of working samples, exercises and assignments for you to practice the concepts and try your own stuff.
We are including the necessary script files (CODE)Â as downloads - the downloadable resources will help you set up your Database environment to start practicing right away. For example, you may start trying the SQLÂ queries yourself along with the lectures and hands on sessions.
Some of the SQLÂ Files will not have complete SQLÂ code (intentionally), but this course sets you on the right path and independently build on what you learn.
Who this course is for:
Anyone from a Highschool student to a CIO can take this course !
Students, Data Analysts, Excel and MS Access users, Developers, Managers, Business Persons
Anyone with Basic High School Math and Analysis Skills
Just know basic math - What is Addition, What is Subtraction, Multiplication. Trigonometry, if you please.
The Smartest in the Room, the Dumbest in the Room.
The Goal is to Teach even that 'Monkey on the Tree' how to write complex queries !!

User Reviews

Rating

average 0

Total votes0

Focused display

We are experienced Data and Business Intelligence professionals with tremendous exposure to business applications of BI using several BI tools - MicroStrategy, Cognos, Business Objects, Power BI. We have designed and architect ed several enterprise Datawarehouse and BI implementations for top companies in Networking, Manufacturing, Entertainment,BFSI, Healthcare industries. Have lead several Projects/Programs for major industry verticals.Our team has designed Corporate Training programs to educate and empower analysts (from 500 up to 3000 analysts) for several Organizations.We also conduct live/personal coaching sessions for those who need additional help.We have also designed revenue generating Web Applications, Client-Server Apps, Data Integration solutions for Financial, Networking, Entertainment, Corporate Service, Manufacturing and other Industry verticals.We also Consult as Advisors to a few startups. You can contact us for more information or to discuss further.*Maverick Learning offer several courses on Data and Business Intelligence, Data Quality, Datawarehouse, Web Development, Mobile Application Development, Database Development and others.

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.