Learn SQL with MySQL Workbench from zero. Great match for beginners in SQL, coders with any experience or Data Analytics
Note: Course Free for limited time and limited users(500 limit) so Enroll ASAP. If not free it means you are late. Scroll Down and click Enroll Now button to get enrolled
Scroll Down and click Enroll Now Button to get enrolled into the Free Course
Apply Coupon Code: 466D1A0B477A25742A53
What you’ll learn
- Create database or interact with existing databases with SQL
- 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
This course includes:
- 6.5 hours on-demand video
- 2 practice tests
- Assignments
- Access on mobile and TV
- Full lifetime access
- Certificate of completion
Course content
6 sections • 38 lectures • 6h 15m total lengthCollapse all sections
Introduction
- Installation guide
- A glance at the Workbench
- Install MySQL
- Data Normalization
- SQL and RDBMS
- Normalization and SQL
DDL = Data Definition Language
- DDL review, CREATE / DROP DATABASE
- CREATE DATABASE statement
- CREATE / DROP TABLE intro
- CREATE / DROP TABLE quiz
- VARCHAR, TEXT, CHAR
- Integers
- Floating-point numbers, exact precision and BIT
- Numbers quiz
- UTF8MB4 Character Set, Collation Explained
- BLOB, ENUM, SET
- String quiz
- Date and Time
- DEFAULT values
- Data Types
Indexes, Keys, ALTER
- Binary Search, B-trees and Keys
- Primary and Unique keys. NOT NULL
- Keys quiz
- Foreign keys
- Foreign Key Quiz
- ALTER statement
- How to construct any DDL statement?
- DDL Quiz
- Create your first database
Workbench and EER (Enhanced Entity-Relationship) diagrams
- EER diagram with workbench
- Export DDL from EER
- Create EER diagram for your schema
- Import and Backup
- Workbench and EER quiz
- Equator
DML = Data Manipulation Language
- Intro to DML
- Insert
- Upload employees test_db
- DML intro
- Upload test_db from the GitHub repo
- SELECT + WHERE
- Comparison Functions and Operators
- Find information about salaries
- LIKE and String Comparison
- SELECT and friends
- SELECT and friends
- ORDER BY, LIMIT, Subqueries
- SELECT and ORDER BY
- The power of ORDER BY
- UPDATE
- Update employees information
- DELETE
- INSERT, UPDATE, DELETE
Mighty Select
- Aggregate Functions (COUNT, MAX, AVG and etc)
- GROUP BY and HAVING
- GROUP BY and Aggregate Functions
- UNION
- Check your knowledge of UNION
- Find salaries information
- What is the beast: JOIN Clause?
- JOIN types explained with diagrams (not Venn!)
- The Power of JOIN
- JOIN quiz
- Data relations
- Greatest N per group
- Greatest N Per Group
- Final test
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 SQL 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 syntax
- Work with the MySQL Workbench
- Design the EER schemas and implement complex databases
- Use Datatypes, Keys, Charset and Collation
- Analyze data using Aggregate Functions
- Build CRUD operations – INSERT, SELECT, UPDATE, DELETE
- Learn and use SQL joins
- And 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 Analytics
- Product Analytics
- Data Scientist
- Backend or Database Engineer
- SQL Server Database Administrator
- Senior Web or Application Developer
- MySQL Database Administrator
- PHP Developer
- NodeJS Developer
- Lead Software Engineer
- Full Stack Engineer/Developer
Who this course is for:
- 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
Show less
Note: The course is free for a limited time and limited to 500 users. Enroll as soon as possible. If it is no longer free, it means you are late, and it has already exceeded its limits.
🎫 After adding the course into Cart at Checkout page, Apply Coupon Code➛. 466D1A0B477A25742A53 Note:- After applying coupon, if it says ”This coupon has exceeded its maximum possible redemptions…”, then it means you’re Late, and first 500 coupons already redeemed.
