Mysql For Everyone. Sql For Developers, Data Analysts And Bi

Learn SQL with MySQL Workbench from zero. Great match for beginners in SQL, coders with any experience or Data Analytics

What you'll learn
Create database or interact with existing databases
Learn and use: Normal forms, Datatypes, Charset and Collation
Write complex SQL queries across multiple tables with UNION and JOIN
Solve hands-on assignments and real-world use cases
Requirements
No special requirements. You will learn everything you need to know
Any experience in Computer Programming or Data Analytics is good but not required
Description
Welcome to this MySQL course! I want to start by appreciating you for trying to learn a new skill. MySQL is one of the most popular databases. What is MySQL?MySQL is currently the most popular database management system software. Its uses for managing relational databases. It's open-source DB software. MySQL support by Oracle Company. It is a fast, scalable, and easy-to-use database management system compared with Microsoft SQL Server or Oracle Database.MySQL supports many Operating Systems like Windows, Linux, macOS, etc.We'll work with the test database of employees. Let's learn about the data structure and types of this schema. Learn how to create an EER diagram with the schema of the data and export it into a ready-to-use SQL file.In this course, you will:Learn the main branches of SQL syntaxWork with the MySQL WorkbenchDesign the EER schemas and implement complex databasesUse Datatypes, Keys, Charset and CollationAnalyze data using Aggregate FunctionsBuild CRUD operations - INSERT, SELECT, UPDATE, DELETELearn and use SQL joinsAnd more!I think that RDBMS is one of the crucial skills in Computer Science and would help you in Computer Programming. Working with the data as a professional is a constant tool that won't change over time. If you learn SQL ones, this will be yours, forever, anytime, anywhere.What Jobs Require Knowledge of SQL?Data AnalyticsProduct AnalyticsData ScientistBackend or Database EngineerSQL Server Database AdministratorSenior Web or Application DeveloperMySQL Database AdministratorPHP DeveloperNodeJS DeveloperLead Software EngineerFull Stack Engineer/Developer

Overview

Section 1: Introduction

Lecture 1 Installation guide

Lecture 2 A glance at the Workbench

Lecture 3 Data Normalization

Lecture 4 SQL and RDBMS

Section 2: DDL = Data Definition Language

Lecture 5 DDL review, CREATE / DROP DATABASE

Lecture 6 CREATE / DROP TABLE intro

Lecture 7 Integers

Lecture 8 Floating-point numbers, exact precision and BIT

Lecture 9 UTF8MB4 Character Set, Collation Explained

Lecture 10 VARCHAR, TEXT, CHAR

Lecture 11 BLOB, ENUM, SET

Lecture 12 Date and Time

Lecture 13 DEFAULT values

Section 3: Indexes, Keys, ALTER

Lecture 14 Binary Search, B-trees and Keys

Lecture 15 Primary and Unique keys. NOT NULL

Lecture 16 Foreign keys

Lecture 17 ALTER statement

Lecture 18 How to construct any DDL statement?

Section 4: Workbench and EER (Enhanced Entity-Relationship) diagrams

Lecture 19 EER diagram with workbench

Lecture 20 Export DDL from EER

Lecture 21 Import and Backup

Section 5: DML = Data Manipulation Language

Lecture 22 Intro to DML

Lecture 23 Insert

Lecture 24 Upload employees test_db

Lecture 25 SELECT + WHERE

Lecture 26 Comparison Functions and Operators

Lecture 27 LIKE and String Comparison

Lecture 28 ORDER BY, LIMIT, Subqueries

Lecture 29 UPDATE

Lecture 30 DELETE

Section 6: Mighty Select

Lecture 31 Aggregate Functions (COUNT, MAX, AVG and etc)

Lecture 32 GROUP BY and HAVING

Lecture 33 UNION

Lecture 34 What is the beast: JOIN Clause?

Lecture 35 JOIN types explained with diagrams (not Venn!)

Lecture 36 The Power of JOIN

Lecture 37 Data relations

Lecture 38 Greatest N per group

Anyone interested in learning SQL - is one of today's most in-demand skills,Business owners, sales or marketing roles who are interested in better data understanding,A hands-on and highly engaging introduction to SQL for Data Analysis,Developers who wanted to build applications