Sql Mastery & Data Analysis, Complete Course With Mysql

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

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.

Overview

Section 1: Introduction

Lecture 1 Goals & Objectives

Section 2: Introduction To Database Systems

Lecture 2 Database Systems

Lecture 3 Typical Database Objects

Lecture 4 Typical Objects & Access in a Database System

Lecture 5 Typical Objects & Access in a Database System - 2

Lecture 6 Designing a Database System

Section 3: Install & Setup Database Environment - MySQL Database

Lecture 7 Download MySQL Installer

Lecture 8 Run MySQL Installer

Lecture 9 Resolve Conflicts & Install MySQL

Lecture 10 Configuration 1

Lecture 11 Configuration 2

Lecture 12 Connect to MySQL

Section 4: Setting up Sales Data in MySQL

Lecture 13 MySQL Workbench Interface

Lecture 14 Understanding SALES datamodel

Lecture 15 Create Database & Tables - Workout 1

Lecture 16 Create Tables - Workout 2

Lecture 17 Create Tables - Workout 3

Lecture 18 Populate Tables

Lecture 19 Populate Tables 2

Lecture 20 Populate Tables 3

Lecture 21 Delete Tables and Delete Data - DO NOT Run !

Section 5: Introduction to SQL

Lecture 22 Why do We Need SQL?

Lecture 23 Introduction to SELECT Statement

Lecture 24 Introduction to SELECT Statement - 2

Section 6: SQL Concepts

Lecture 25 SQL Concepts - Data Definition (DDL), Modification(DML), Queringy(DQL)

Lecture 26 SQL Concepts Exercises

Lecture 27 JOINS - Combining Data from Multiple Tables/Views

Lecture 28 CROSS JOINS - All combinations of rows from Tables/Views

Lecture 29 Sub Queries - Query Inside a Query, aka Nested or Sub Query.

Lecture 30 Self Joins - Joining a Table or View with Itself

Lecture 31 Workout - JOINS

Lecture 32 Workout - CROSS JOINS

Lecture 33 WORKOUT - Load ML SALES Table

Lecture 34 Explanation - Left , Right and & Full Outer Join

Lecture 35 Workout - Left , Right and & Full Outer Join - 2

Section 7: Understanding Transactions

Lecture 36 Transactions

Section 8: MySQL Architecture

Lecture 37 MySQL Architecture Introduction

Lecture 38 MySQL Architecture for Relational Database

Section 9: MySQL Datatypes

Lecture 39 Introduction - MySQL Datatypes

Lecture 40 Numeric Datatypes

Lecture 41 String Datatypes

Lecture 42 Workout - Numeric and Strings

Lecture 43 Date & Time

Lecture 44 Workout - Date and Time

Lecture 45 Workout 2 - Date and Time

Section 10: Functions & Operators

Lecture 46 Numeric - Arithmetic & Mathematical Functions and Operators

Lecture 47 String Functions & Operators

Lecture 48 String - Regular Expressions

Lecture 49 Date & Time

Lecture 50 Comparison & Logical

Lecture 51 Assignment & Flow-Control

Lecture 52 Workout 1 - F & O With SQL Files

Lecture 53 Workout 2 - F & O

Lecture 54 Workout 3 - F & O

Lecture 55 Workout 4 - F & O

Lecture 56 Workout 5 - F & O

Lecture 57 Workout 6 - F & O

Lecture 58 Workout 7 - F & O

Lecture 59 Workout 8 - F & O

Lecture 60 Workout 8 - Part 2 F & O

Lecture 61 Workout 9 - F & O

Lecture 62 Workout 10 - F& O

Lecture 63 Workout 11 - F & O

Lecture 64 Workout 12 - F & O

Lecture 65 Workout 13 - F & O

Lecture 66 Workout 14 - F & O

Lecture 67 Workout 15 - F & O

Lecture 68 Workout 16 - F & O

Lecture 69 Workout 17 - F&O

Lecture 70 Workout 18 - 1 Part1

Lecture 71 Workout 18 - 1 Part 2

Lecture 72 Workout 18 - 2- F&O

Lecture 73 Workout 19

Lecture 74 Workout 20 - 1

Lecture 75 Workout 20 - 2

Section 11: Functions - Aggregate & Window Functions

Lecture 76 Aggregate Functions with SQL Files

Lecture 77 Group By Modifiers

Lecture 78 Workout Aggregate Funs 1

Lecture 79 Workout Aggregate Funs 2

Lecture 80 Workout Aggregate Funs 3

Lecture 81 Workout Aggregate Funs - WIndows 1

Lecture 82 Workout Aggregate - 2

Lecture 83 Workout Aggregate - 3

Section 12: Window Functions

Lecture 84 Non-Aggregate Window Functions With SQL Files

Lecture 85 Workout - Non Aggregate Year on Year Sales Analysis

Lecture 86 Workout Non Aggregate Function - Yearly Sales Report

Lecture 87 Workout Window & Partition Functions - 1

Lecture 88 Workout Window & Partition Functions - 2

Section 13: Prepared Statements

Lecture 89 Prepared Statements in MySQL With SQL Files

Lecture 90 Prepared Statements - 2

Lecture 91 Prepared Statements - 3

Section 14: Compound Statements, Stored Procedures

Lecture 92 Introduction to Compound Statements

Lecture 93 Compound Statements Continued - IF, CASE, WHILE,REPEAT, LOOP, Cursors

Lecture 94 Error Handling in Procedures/Cursors

Lecture 95 Stored Routines - Procedures & Dynamic Cursors

Lecture 96 StoredRoutines-Procedures, Triggers Detailed

Lecture 97 Workout - Procedures 1 With SQL Files

Lecture 98 Workout - Procedures 2

Lecture 99 Workout - Procedures 3

Lecture 100 Workout - Procedures 4

Lecture 101 Workout - Procedures 5

Lecture 102 Workout - Cursors 1

Lecture 103 Workout - Cursors 2

Lecture 104 Workout - Cursors 3

Lecture 105 Workout - Cursors 3 Continued

Lecture 106 Samples to Practice - Procedures & Triggers

Section 15: Information Functions - Discovering/Undestanding Your Database

Lecture 107 Show Database and Schema Information

Lecture 108 Workout 1 - Information Functions

Lecture 109 Workout 2 - InformationFunctions

Section 16: User Accounts & Permissions - Managing access to your Data

Lecture 110 Users and Grants

Lecture 111 Workout 1 - Users and Grants

Lecture 112 Workout 2 - Users and Grants

Section 17: Assignment - Design a Date Dimension

Section 18: Data Encryption

Lecture 113 Encryption Concepts

Lecture 114 Encryption - Working Session

Section 19: Semi-Structured Data Support

Lecture 115 Non RDBMS (NoSQL)

Lecture 116 Document Store Architecture

Section 20: Additional SQL Files

Lecture 117 Additional SQL Source Files and a suggested list of Exercises

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