HOT
blank

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

Business

Rating4.5
Enroll Now

SQL Mastery & Data Analysis A-Z Best & Complete Course MySQL, available at $64.99, has an average rating of 4.5, with 117 lectures, based on 3 reviews, and has 14 subscribers.

You will learn about 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). This course is ideal for individuals who are Anyone from a Highschool student to a CIO can take this course ! or Students, Data Analysts, Excel and MS Access users, Developers, Managers, Business Persons or Anyone with Basic High School Math and Analysis Skills or Just know basic math – What is Addition, What is Subtraction, Multiplication. Trigonometry, if you please. or The Smartest in the Room, the Dumbest in the Room. or The Goal is to Teach even that 'Monkey on the Tree' how to write complex queries !! It is particularly useful for Anyone from a Highschool student to a CIO can take this course ! or Students, Data Analysts, Excel and MS Access users, Developers, Managers, Business Persons or Anyone with Basic High School Math and Analysis Skills or Just know basic math – What is Addition, What is Subtraction, Multiplication. Trigonometry, if you please. or The Smartest in the Room, the Dumbest in the Room. or The Goal is to Teach even that 'Monkey on the Tree' how to write complex queries !!.

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

Summary

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

Price: $64.99

Average Rating: 4.5

Number of Lectures: 117

Number of Published Lectures: 117

Number of Curriculum Items: 118

Number of Published Curriculum Objects: 118

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will 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 Should Attend

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

Target Audiences

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

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 Wholesomecourse  on SQL Masterythat 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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Goals & Objectives

Chapter 2: Introduction To Database Systems

Lecture 1: Database Systems

Lecture 2: Typical Database Objects

Lecture 3: Typical Objects & Access in a Database System

Lecture 4: Typical Objects & Access in a Database System – 2

Lecture 5: Designing a Database System

Chapter 3: Install & Setup Database Environment – MySQL Database

Lecture 1: Download MySQL Installer

Lecture 2: Run MySQL Installer

Lecture 3: Resolve Conflicts & Install MySQL

Lecture 4: Configuration 1

Lecture 5: Configuration 2

Lecture 6: Connect to MySQL

Chapter 4: Setting up Sales Data in MySQL

Lecture 1: MySQL Workbench Interface

Lecture 2: Understanding SALES datamodel

Lecture 3: Create Database & Tables – Workout 1

Lecture 4: Create Tables – Workout 2

Lecture 5: Create Tables – Workout 3

Lecture 6: Populate Tables

Lecture 7: Populate Tables 2

Lecture 8: Populate Tables 3

Lecture 9: Delete Tables and Delete Data – DO NOT Run !

Chapter 5: Introduction to SQL

Lecture 1: Why do We Need SQL?

Lecture 2: Introduction to SELECT Statement

Lecture 3: Introduction to SELECT Statement – 2

Chapter 6: SQL Concepts

Lecture 1: SQL Concepts – Data Definition (DDL), Modification(DML), Queringy(DQL)

Lecture 2: SQL Concepts Exercises

Lecture 3: JOINS – Combining Data from Multiple Tables/Views

Lecture 4: CROSS JOINS – All combinations of rows from Tables/Views

Lecture 5: Sub Queries – Query Inside a Query, aka Nested or Sub Query.

Lecture 6: Self Joins – Joining a Table or View with Itself

Lecture 7: Workout – JOINS

Lecture 8: Workout – CROSS JOINS

Lecture 9: WORKOUT – Load ML SALES Table

Lecture 10: Explanation – Left , Right and & Full Outer Join

Lecture 11: Workout – Left , Right and & Full Outer Join – 2

Chapter 7: Understanding Transactions

Lecture 1: Transactions

Chapter 8: MySQL Architecture

Lecture 1: MySQL Architecture Introduction

Lecture 2: MySQL Architecture for Relational Database

Chapter 9: MySQL Datatypes

Lecture 1: Introduction – MySQL Datatypes

Lecture 2: Numeric Datatypes

Lecture 3: String Datatypes

Lecture 4: Workout – Numeric and Strings

Lecture 5: Date & Time

Lecture 6: Workout – Date and Time

Lecture 7: Workout 2 – Date and Time

Chapter 10: Functions & Operators

Lecture 1: Numeric – Arithmetic & Mathematical Functions and Operators

Lecture 2: String Functions & Operators

Lecture 3: String – Regular Expressions

Lecture 4: Date & Time

Lecture 5: Comparison & Logical

Lecture 6: Assignment & Flow-Control

Lecture 7: Workout 1 – F & O With SQL Files

Lecture 8: Workout 2 – F & O

Lecture 9: Workout 3 – F & O

Lecture 10: Workout 4 – F & O

Lecture 11: Workout 5 – F & O

Lecture 12: Workout 6 – F & O

Lecture 13: Workout 7 – F & O

Lecture 14: Workout 8 – F & O

Lecture 15: Workout 8 – Part 2 F & O

Lecture 16: Workout 9 – F & O

Lecture 17: Workout 10 – F& O

Lecture 18: Workout 11 – F & O

Lecture 19: Workout 12 – F & O

Lecture 20: Workout 13 – F & O

Lecture 21: Workout 14 – F & O

Lecture 22: Workout 15 – F & O

Lecture 23: Workout 16 – F & O

Lecture 24: Workout 17 – F&O

Lecture 25: Workout 18 – 1 Part1

Lecture 26: Workout 18 – 1 Part 2

Lecture 27: Workout 18 – 2- F&O

Lecture 28: Workout 19

Lecture 29: Workout 20 – 1

Lecture 30: Workout 20 – 2

Chapter 11: Functions – Aggregate & Window Functions

Lecture 1: Aggregate Functions with SQL Files

Lecture 2: Group By Modifiers

Lecture 3: Workout Aggregate Funs 1

Lecture 4: Workout Aggregate Funs 2

Lecture 5: Workout Aggregate Funs 3

Lecture 6: Workout Aggregate Funs – WIndows 1

Lecture 7: Workout Aggregate – 2

Lecture 8: Workout Aggregate – 3

Chapter 12: Window Functions

Lecture 1: Non-Aggregate Window Functions With SQL Files

Lecture 2: Workout – Non Aggregate Year on Year Sales Analysis

Lecture 3: Workout Non Aggregate Function – Yearly Sales Report

Lecture 4: Workout Window & Partition Functions – 1

Lecture 5: Workout Window & Partition Functions – 2

Instructors

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 0 votes
  • 3 stars: 1 votes
  • 4 stars: 0 votes
  • 5 stars: 2 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Relationship Building Courses to Learn in November 2024

Top 10 Storytelling Courses to Learn in November 2024

Top 10 Resilience Training Courses to Learn in November 2024