The SQL MicroDegree 2021: From SQL Basics To MySQL Mastery
- Description
- Curriculum
- FAQ
- Reviews
Learn SQL from absolute scratch!
SQL is not an optional skill anymore but a necessity. It’s not crucial for data analysts but also for CS graduates who are looking for a job. Learning SQL is one of the fastest ways to improve your career possibilities as it is one of the most sought-after tech skills! Do you know that MySQL is the most preferred SQL interpreter out there? What you learn in this course would be enough to get yourself eligible for new career options. We will start from the very basics of SQL and gradually progress into teaching you everything you need to know about it. Step by step. With no steps skipped. This course is for you if you are tired of SQL courses that are too brief, too simple, or too complicated.
What Will You Learn?
-
Learn the ins and outs of SQL syntax
-
Generate reports using sales and user data
-
Analyze data using Aggregate Functions
-
Run complex queries using MySQL logical operators and string functions
-
Write all the common SQL joins
-
Creating, Modifying and Deleting Tables in a Database (DDL)
-
Inserting, Updating and Deleting Data from Tables (DML)
Why Should You Choose This Course?
-
Easy to understand
-
Time-efficient and concise
-
Shows how SQL can be crucial for data analytics and business intelligence
-
Taught in MySQL – The most popular SQL database management system.
-
7The SELECT StatementVideo lesson
-
8The SELECT ClauseVideo lesson
-
9Task 1Video lesson
-
10The WHERE ClauseVideo lesson
-
11Task 2Video lesson
-
12AND, OR & NOT OperatorsVideo lesson
-
13Task 3Video lesson
-
14The IN OperatorVideo lesson
-
15Task 4Video lesson
-
16The BETWEEN OperatorVideo lesson
-
17Task 5Video lesson
-
18The LIKE OperatorVideo lesson
-
19Task 6Video lesson
-
20The REGEXP OperatorVideo lesson
-
21Task 7Video lesson
-
22The NULL OperatorVideo lesson
-
23Task 8Video lesson
-
24The ORDER BY ClauseVideo lesson
-
25Task 9Video lesson
-
26The LIMIT ClauseVideo lesson
-
27Task 10Video lesson
-
28Inner JOINVideo lesson
-
29Task 11Video lesson
-
30JOIN Data From Multiple DatabasesVideo lesson
-
31Self JOINVideo lesson
-
32JOIN Data From Multiple TablesVideo lesson
-
33Task 12Video lesson
-
34Writing A Compound JOIN StatementVideo lesson
-
35Syntax For Implicit JOINVideo lesson
-
36OUTER JOINVideo lesson
-
37OUTER JOIN To Combine Multiple TablesVideo lesson
-
38Task 13Video lesson
-
39The USING ClauseVideo lesson
-
40Task 14Video lesson
-
41Natural JOINVideo lesson
-
42Cross JOINVideo lesson
-
43Task 15Video lesson
-
44UNIONVideo lesson
-
45Task 16Video lesson
-
46What Are Column Attributes?Video lesson
-
47Inserting A RowVideo lesson
-
48Inserting Multiple RowsVideo lesson
-
49Task 17Video lesson
-
50Inserting Hierarchical RowsVideo lesson
-
51Creating A Copy Of The TableVideo lesson
-
52Updating A Single RowVideo lesson
-
53Updating Multiple RowsVideo lesson
-
54SubqueriesVideo lesson
-
55Task 18Video lesson
-
56Deleting A RowVideo lesson

External Links May Contain Affiliate Links read more