Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

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

Name: SQL Mastery & Data Analysis A-Z Best & Complete Course MySQL
Rating: 4.6 (3 reviews)

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

Created byMaverick Learning

Last updated 11/2023

English

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

Course content

20 sections • 117 lectures • 15h 47m total length

Goals & Objectives11:40
Understand what is this course about, what are the goals, objectives, expectations and pre-requisites.
The objective of this course is to impart basic, intermediate and some advanced knowledge in Relational Database systems. The workout sessions are in MySQL, however the concepts are broadly applicable to most RDBMS databases.

Database Systems11:34
Understand what is a Database system, what is the purpose, where it is used etc.
Generic concepts applicable to other RDBMS database vendors.
Typical Database Objects0:44
Understand what are the typical objects stored/available in a Database - generic enough to be applicable to a wide range of RDBMS Database vendors like Oracle, DB2, MySQL, Postgres etc.
Typical Objects & Access in a Database System11:41
Understand how objects are organized in a Database and how is access to these objects managed, segregated and protected. Generic concepts applicable to other RDBMS database vendors.
Typical Objects & Access in a Database System - 21:13
Understand how objects are organized in a Database and how is access to these objects managed, segregated and protected - Part 2
Designing a Database System8:20
Understand how a database system is designed, what are the requirements, lifecycle steps, and tasks involved.
Generic concepts applicable to other RDBMS database vendors.

Download MySQL Installer2:43
Understand how to download MySQL software for this course.
Run MySQL Installer2:43
Understand how to run the MySQL installer software to install MySQL database for this course.
Resolve Conflicts & Install MySQL3:58
Understand what conflicts you can face during the installation and how you can resolve them to successfully install MySQL database.
Configuration 14:31
Understand how to configure your newly installed MySQL database for this course.
Configuration 20:38
Understand how to configure your newly installed MySQL database for this course - Part 2
Connect to MySQL1:01
Understand how to connect to and test your newly installed and configured MySQL database for this course.

MySQL Workbench Interface11:48
Understand the MySQL workbench interface - this is where you will do all your work including creating database objects, querying etc.
Understanding SALES datamodel9:04
Understand the sample sales data model (completely fictitious data and not representative of any real world entity). You need this to understand how to build queries and interpret returned data.
Create Database & Tables - Workout 117:25
Understand how to create the required tables for the Sales data model we studied. Scripts are provided.
Study the SQLs to understand what objects are created based on our sales data model.
Create Database using createdb_sqlhandson.sql
Create Tables using dbcreatetables_sqlhandson.sql
Create Tables - Workout 25:07
Understand how to create the required tables for the Sales data model we studied. Scripts are provided in previous lecture.
Study the SQLs to understand what objects are created based on our sales data model.
Continued in this Part 2.
Create Tables - Workout 35:17
Understand how to create the required tables for the Sales data model we studied. Scripts are provided.
Study the SQLs to understand what objects are created based on our sales data model.
Continued in this Part 3.
Populate Tables7:37
Understand how to populate/load data into the required tables for the Sales data model we studied. Scripts are provided in earlier lectures.
Study the SQLs to understand what data is being loaded into which objects based on our sales data model.
Scripts are provided with sample data, you can modify the values or use the scripts as-is.
All data is fictitious.
Populate Tables 23:33
Populate Tables continued in this Part 2.
Populate Tables 32:43
Populate ML SALES table including rows with Null Values.
SALES table is a transaction table and can contain unlimited number of rows.
Scripts are provided for sample data.
All data is fictitious.
Delete Tables and Delete Data - DO NOT Run !0:09
Do not Run these scripts, these are for reference.
These scripts are to understand how to delete Data from tables (using DELETE or TRUNCATE statement).
dbclean.sql shows how to delete Tables.
Both use salesdb Database.

Why do We Need SQL?9:22
Understand what is SQL and why do we need it. Generic enough and applicable to most RDBMS database vendors.
Introduction to SELECT Statement14:03
Understand what is SELECT statement and how to use it. Generic enough and applicable to most RDBMS database vendors.
Sample queries provided.
Introduction to SELECT Statement - 210:44
SQL Included (IntroductionToSelect_WS.sql)
Additional Sample Queries also included
SQL to Update BENEFITS column of ML_PRODUCTS table.
Additional SELECT queries.
You can run update SQLs directly or modify/change the sql and try running it.

SQL Concepts - Data Definition (DDL), Modification(DML), Queringy(DQL)23:39
Understand the basic types of SQLs - to define, create and modify data.
Generic enough and applicable to most RDBMS database vendors.
SQL Concepts Exercises0:09
Practice SELECT, UPDATE, DELETE, TRUNCATE with samples in the given file.
For INSERT statements, the Section 4 already has INSERT examples for populating data in SALES database tables.
Queries are self-explanatory.
Comments and Instructions are also included.
Generic enough and applicable to most RDBMS database vendors.
JOINS - Combining Data from Multiple Tables/Views11:41
Understand how to combine data from multiple tables or views to generate a combined report, dataset etc.
Generic enough and applicable to most RDBMS database vendors.
CROSS JOINS - All combinations of rows from Tables/Views16:49
Understand how to combine data from unrelated tables/views, resulting in all possible combinations of data merge.
Generic enough and applicable to most RDBMS database vendors.
Sub Queries - Query Inside a Query, aka Nested or Sub Query.21:25
Understand how to use a query (known as the Inner or Sub Query) as a filter (or as other) in another query (knows as the outer query).
Generic enough and applicable to most RDBMS database vendors.
Self Joins - Joining a Table or View with Itself10:31
Understand how to combine a table data with itself.
Generic enough and applicable to most RDBMS database vendors.
Workout - JOINS9:04
Practice JOIN statements on our Sales database with sample queries given. You can imagine a different business or reporting need and modify the queries and check results.
Generic enough and applicable to most RDBMS database vendors.
Workout - CROSS JOINS21:16
Practice CROSS JOIN statements on our Sales database with sample queries given. You can imagine a different business or reporting need and modify the queries and check results.
Generic enough and applicable to most RDBMS database vendors.
WORKOUT - Load ML SALES Table3:00
Creating rows with null values to understand JOIN behavior (left, right, full outer or cross join).
If you have already run these statements/created these rows in Section 4 Lecture 20, you do not need to run these INSERT statements.
All data is fictitious.
Explanation - Left , Right and & Full Outer Join5:40
Understand what are outer joins - selecting data even when no matching row is found in the other/reference table.
Generic enough and applicable to most RDBMS database vendors.
Workout - Left , Right and & Full Outer Join - 23:34
Practice different JOIN types.
SQL Files included. Some queries are common.
JOINS.sql is 2KB and JOINS_WS.sql is 5kb.

Introduction - MySQL Datatypes8:17
Understand what are the various datatypes available in MySQL database specifically.
Unique to MySQL and not readily applicable to all RDBMS databases.
Numeric Datatypes13:11
Understand Numeric data types available in MySQL.
Unique to MySQL and not readily applicable to all RDBMS databases.
String Datatypes13:13
Understand String (character or text) data types available in MySQL.
Unique to MySQL and not readily applicable to all RDBMS databases.
Workout - Numeric and Strings16:31
Working session to understand the behavior of numeric and string data types.
Sample queries are provided, you can modify the data and check results.
Unique to MySQL and not readily applicable to all RDBMS databases.
Date & Time6:52
Understand Date data types available in MySQL.
Unique to MySQL and not readily applicable to all RDBMS databases.
Workout - Date and Time6:28
Working session to understand the behavior of Date data type.
Unique to MySQL and not readily applicable to all RDBMS databases.
Workout 2 - Date and Time4:17
Working session to understand Date data types, Part 2.

Numeric - Arithmetic & Mathematical Functions and Operators6:51
Understand various numeric functions and operators in MySQL.
Specific to MySQL but concepts applicable to other RDBMS databases.
String Functions & Operators9:02
Understand various text functions and operators in MySQL.
Specific to MySQL but concepts applicable to other RDBMS databases.
String - Regular Expressions11:33
Understand what are regular expressions (patterns) and how they can be powerful for developers.
Specific to MySQL but concepts applicable to other RDBMS databases.
Date & Time4:17
Understand what are date and time related functions/operators in MySQL how they can be powerful for developers.
Specific to MySQL but concepts applicable to other RDBMS databases.
Comparison & Logical3:57
Understand what are Comparison and Logical functions/operators in MySQL.
Specific to MySQL but concepts applicable to other RDBMS databases.
Assignment & Flow-Control22:45
Understand how the control of flow /sequence of operations happens. Similar to programming languages.
Specific to MySQL but concepts applicable to other RDBMS databases.
Workout 1 - F & O With SQL Files7:01
A series of workout sessions to practice Functions and Operators in MySQL.(FOR loop)
All queries provided are fictitious.
Workout 2 - F & O4:56
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 3 - F & O20:43
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 4 - F & O4:35
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 5 - F & O8:09
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 6 - F & O7:11
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 7 - F & O8:39
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 8 - F & O3:32
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 8 - Part 2 F & O1:00
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 9 - F & O13:32
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 10 - F& O7:40
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 11 - F & O5:46
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 12 - F & O10:24
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 13 - F & O10:57
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 14 - F & O3:24
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 15 - F & O8:11
Workout session to practice Functions and Operators in MySQL. (FOR loop)
All queries provided are fictitious.
Workout 16 - F & O11:28
Workout session to practice Functions and Operators in MySQL. (Datetime)
All queries provided are fictitious.
Workout 17 - F&O12:07
Workout session to practice Functions and Operators in MySQL. (Datetime)
All queries provided are fictitious.
Workout 18 - 1 Part112:10
Workout session to practice Functions and Operators in MySQL. (Comparison)
All queries provided are fictitious.
Workout 18 - 1 Part 26:30
Workout session to practice Functions and Operators in MySQL. (Comparison)
All queries provided are fictitious.
Workout 18 - 2- F&O5:53
Workout session to practice Functions and Operators in MySQL.
All queries provided are fictitious.
Workout 195:19
Workout session to practice Functions and Operators in MySQL. (COALESCE function)
All queries provided are fictitious.
Workout 20 - 14:43
Workout session to practice Functions and Operators in MySQL.
All queries provided are fictitious.
Workout 20 - 28:13
Workout session to practice Functions and Operators in MySQL.
All queries provided are fictitious.

Requirements

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.

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 !!

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

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 12min

Introduction To Database Systems5 lectures • 34min

Install & Setup Database Environment - MySQL Database6 lectures • 16min

Setting up Sales Data in MySQL9 lectures • 1hr 3min

Introduction to SQL3 lectures • 34min

SQL Concepts11 lectures • 2hr 7min

Understanding Transactions1 lecture • 25min

MySQL Architecture2 lectures • 11min

MySQL Datatypes7 lectures • 1hr 9min

Functions & Operators30 lectures • 4hr 10min

Requirements

Description

Who this course is for: