SQL for Developers, Data Analysts and BI. MySQL for everyone Complete Course For Free With Certification | Free Udemy Course | First 1000 Users for Free |
SQL for Developers, Data Analysts and BI. MySQL for everyone
Learn SQL with MySQL Workbench from zero. Great match for beginners in SQL, coders with any experience or Data Analytics
- 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
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
Course content
6 sections • 38 lectures • 6h 15m total length
Preview
09:42
A glance at the Workbench
13:53
Install MySQL
1 question
Data Normalization
18:29
SQL and RDBMS
06:35
Normalization and SQL
4 questions
DDL review, CREATE / DROP DATABASE
16:41
CREATE DATABASE statement
6 questions
CREATE / DROP TABLE intro
15:04
CREATE / DROP TABLE quiz
6 questions
VARCHAR, TEXT, CHAR
10:53
Preview
10:08
Preview
17:13
Numbers quiz
7 questions
Preview
10:31
BLOB, ENUM, SET
11:00
String quiz
10 questions
Date and Time
06:25
DEFAULT values
06:01
Data Types
12 questions
Preview
11:26
Primary and Unique keys. NOT NULL
10:55
Keys quiz
3 questions
Foreign keys
07:10
Foreign Key Quiz
3 questions
ALTER statement
06:49
Preview
08:39
DDL Quiz
4 questions
Create your first database
1 question
EER diagram with workbench
10:33
Export DDL from EER
04:49
Create EER diagram for your schema
1 question
Import and Backup
05:29
Workbench and EER quiz
3 questions
Equator
13 questions
Preview
05:13
Insert
04:09
Upload employees test_db
04:54
DML intro
5 questions
Upload test_db from the GitHub repo
1 question
Preview
10:58
Comparison Functions and Operators
13:09
Find information about salaries
2 questions
LIKE and String Comparison
07:38
SELECT and friends
13 questions
SELECT and friends
4 questions
ORDER BY, LIMIT, Subqueries
06:52
SELECT and ORDER BY
4 questions
The power of ORDER BY
2 questions
UPDATE
10:45
Update employees information
4 questions
Preview
05:31
INSERT, UPDATE, DELETE
3 questions
Preview
14:35
Preview
09:12
GROUP BY and Aggregate Functions
6 questions
UNION
09:12
Check your knowledge of UNION
3 questions
Find salaries information
1 question
What is the beast: JOIN Clause?
11:53
JOIN types explained with diagrams (not Venn!)
11:12
The Power of JOIN
10:45
JOIN quiz
2 questions
Data relations
10:24
Greatest N per group
10:27
Greatest N Per Group
3 questions
Final test
31 questions
Instructor
Nick Ovchinnikov
Software developer
Nick Ovchinnikov
4.4 Instructor Rating
753 Reviews
73,801 Students
4 Courses
Passionate Software lead engineer. Frontend web application development is my primary skill.
Nowadays I work with Math and DS, but Frontend is still interesting to me
* Strong soft skills and leadership
* Architecture and high-level vision
* Agile methodology and lifecycle of an app
* Strong knowledge of architecture on Web-based applications
* Primary languages JS, Typescript
* React, Redux, Redux-Saga
* DBMS - Mongo, MySQL
This course includes:
6.5 hours on-demand video
2 practice tests
Assignments
Access on mobile and TV
Full lifetime access
Certificate of completion
Coupon Code: FC3460605018021B5F92
Click Here To Apply
Comments
Post a Comment