*** Proof of Product ***
Exploring the Essential Features of “Mosh Hamedani – Complete SQL Mastery”
Complete SQL Mastery
Everything you need to design and query databases in one course
COURSE OVERVIEW
- Beginner to Pro
- 11 hours of HD video
- 170 lessons
- Downloadable content
- Hands-on exercises
- English captions
Clear. Concise. Comprehensive.
Tired of piecing together disconnected tutorials or dealing with rambling, confusing instructors? This course is for you! It’s perfectly structured into a series of bite-sized, easy-to-follow videos that cover both theory and practice.
What You’ll Learn
- Understand the fundamentals of relational databases and SQL
- Master the SQL syntax and commonly used SQL commands
- Query and retrieve data from single and multiple database tables
- Use filtering, sorting, and aggregating techniques to manipulate data
- Create and modify database tables, views, and indexes
- Implement data integrity constraints and ensure data consistency
- Perform advanced SQL operations, such as subqueries and joins
- Write efficient and optimized SQL queries for improved performance
- Design databases effectively, including database schema and normalization principles
- Secure your databases
Course Content
11 Hours . 15 Sections . 170 Lessons
Getting Started (25m)
Introduction 0m 18s
What is SQL
Installing MySQL on Mac
Installing MySQL on Windows
Creating the Databases
What You’ll Learn
Follow Me Around
Learning Paths
Retrieving Data From a Single Table (60m)
The SELECT Statement 5m 50s
The SELECT Clause
The WHERE Clause
The AND, OR and NOT Operators
The IN Operator
The BETWEEN Operator 2m 12s
The LIKE Operator 5m 37s
The REGEXP Operator 9m 21s
The IS NULL Operator 2m 26s
The ORDER BY Clause 7m 06s
The LIMIT Clause 3m 26s
Retrieving Data From Multiple Tables (1h)
Inner Joins 8m 26s
Joining Across Databases 2m 47s
Self Joins 4m 13s
Joining Multiple Tables 6m 46s
Compound Join Conditions 3m 41s
Implicit Join Syntax 2m 20s
Outer Joins 6m 27s
Outer Join Between Multiple Tables 6m 18s
Self Outer Joins 2m 12s
The USING Clause 5m 22s
Natural Joins 1m 21s
Cross Joins 3m 14s
Unions 8m 29s
A Quick Note
Inserting, Updating, and Deleting Data (42m)
Column Attributes 3m 24s
Inserting a Row 5m 46s
Inserting Multiple Rows 3m 18s
Inserting Hierarchical Rows 5m 53s
Creating a Copy of a Table 8m 47s
Updating a Single Row 3m 55s
Updating Multiple Rows 3m 14s
Using Subqueries in Updates 5m 36s
Deleting Rows 1m 24s
Restoring the Databases 1m 06s
Summarizing Data (31m)
Aggregate Functions 9m 19s
The GROUP BY Clause 7m 21s
The HAVING Clause 8m 50s
The ROLLUP Operator 5m 05s
Writing Complex Query (39m)
Introduction 1m 28s
Subqueries 2m 29s
The IN Operator 3m 39s
Subqueries vs Joins 5m 07s
The ALL Keyword 4m 52s
The ANY Keyword 2m 36s
Correlated Subqueries 5m 36s
The EXISTS Operator 5m 39s
Subqueries in the SELECT Clause 4m 29s
Subqueries in the FROM Clause 2m 58s
Essential MySQL Functions (32m)
Numeric Functions 2m 54s
String Functions 5m 47s
Date Functions in MySQL 4m 08s
Formatting Dates and Times 2m 14s
Calculating Dates and Times 3m 08s
The IFNULL and COALESCE Functions 3m 29s
The IF Function 4m 54s
The CASE Operator 5m 23s
Views (19m)
Creating Views 5m 36s
Altering or Dropping Views 2m 52s
Updatable Views 5m 12s
THE WITH OPTION CHECK Clause 2m 18s
Other Benefits of Views 2m 37s
Stored Procedures (49m)
What are Stored Procedures 2m 18s
Creating a Stored Procedure 5m 34s
Creating Procedures Using MySQLWorkbench 1m 21s
Dropping Stored Procedures 2m 09s
Parameters 5m 26s
Parameters with Default Value 8m 18s
Parameter Validation 6m 40s
Output Parameters 3m 55s
Variables 4m 33s
Functions 6m 28s
Other Conventions 1m 51s
Triggers and Events (21m)
Triggers 7m 31s
Viewing Triggers 1m 20s
Dropping Triggers 0m 52s
Using Triggers for Auditing 4m 52s
Events 4m 33s
Viewing, Dropping and Altering Events 2m 04s
Transactions and Concurrency (44m)
Transactions 2m 44s
Creating Transactions 5m 11s
Concurrency and Locking 4m 07s
Concurrency Problems 7m 25s
Transaction Isolation Levels 5m 42s
READ UNCOMMITTED Isolation Level 3m 26s
READ COMMITTED Isolation Level 3m 01s
REPEATABLE READ Isolation Level 3m 29s
SERIALIZABLE Isolation Level 2m 18s
Deadlocks 6m 11s
Data Types (24m)
Introduction 0m 43s
String Types 2m 25s
Integer Types 2m 52s
Fixed-point and Floating-point Types 1m 42s
Boolean Types 0m 46s
Enum and Set Types 3m 36s
Date and Time Types 0m 44s
Blob Types 1m 17s
JSON Type 10m 24s
Designing Databases (2h)
Introduction 1m 25s
Data Modelling 2m 26s
Conceptual Models 4m 34s
Logical Models 7m 24s
Physical Models 6m 27s
Primary Keys 3m 23s
Foreign Keys 5m 48s
Foreign Key Constraints 5m 22s
Normalization 1m 24s
1NF- First Normal Form 2m 42s
Link Tables 4m 01s
2NF- Second Normal Form 6m 32s
3NF- Third Normal Form 1m 43s
My Pragmatic Advice 2m 55s
Don’t Model the Universe 4m 24s
Forward Engineering a Model 2m 35s
Synchronizing a Model with a Database 4m 48s
Reverse Engineering a Database 3m 11s
Project- Flight Booking System 0m 23s
Solution- Conceptual Model 7m 59s
Solution- Logical Model 9m 03s
Project – Video Rental Application 1m 05s
Solution- Conceptual Model 6m 59s
Solution- Logical Model 8m 29s
Creating and Dropping Databases 1m 41s
Creating Tables 3m 13s
Altering Tables 2m 56s
Creating Relationships 4m 47s
Altering Primary and Foreign Key Constraints 2m 10s
Character Sets and Collations 6m 29s
Storage Engines 2m 27s
A Quick Note
Indexing for High Performance (53m)
Introduction 0m 41s
Indexes 2m 49s
Creating Indexes 5m 00s
Viewing Indexes 3m 19s
Prefix Indexes 3m 40s
Full-text Indexes 7m 50s
Composite Indexes 5m 12s
Order of Columns in Composite Indexes 9m 16s
When Indexes are Ignored 5m 03s
Using Indexes for Sorting 7m 02s
Covering Indexese 1m 58s
Index Maintenance 1m 25s
Performance Best Practices
Securing Databases (15m)
Introduction 0m 33s
Creating a User 3m 12s
Viewing Users 1m 29s
Dropping Users 0m 48s
Changing Passwords 1m 06s
Granting Privileges 4m 53s
Viewing Privileges 1m 34s
Revoking Privileges 1m 20s
Who Is This For?
- Anyone who wants to learn to design and query relational databases
- Computer science students who want to better understand SQL
- Anyone pursuing a job in back-end development, database administration or data science
- SQL developers who want to brush up on their SQL skills
No Prior Knowledge Needed
The course covers everything you need to know in detail, so don’t worry if you’re a complete novice. You don’t even need to know what a database is!
For those with some development and database experience, you can jump in at the relevant module that fits your current level, as the course is designed sequentially.
HELLO,
I’m Mosh Hamedani.
Are you feeling stuck or overwhelmed in your coding journey? Don’t worry, I’ve got your back! Together, we’ll work to level up your skills, increase your earning potential, and build a brighter future.
Please see the full list of alternative group-buy courses available here: https://lunacourse.com/shop/
