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
Screenshots

#