English
Menu
Navigate & Settings
The Complete SQL Database Course from ZERO to HERO using MySQL.
4
Students
70
Lectures
About This Course
This comprehensive database course covers fundamental and intermediate knowledge of SQL language and database management. Students will learn the foundational principles of relational databases, including data modeling, normalization, and database design. Through hands-on exercises and projects, participants will gain proficiency in writing SQL queries to retrieve, manipulate, and manage data effectively. Topics include data definition language (DDL), data manipulation language (DML), joins, subqueries, indexes, transactions, and stored procedures. By the end of the course, students will have a solid understanding of SQL and database concepts, empowering them to design, implement, and maintain databases efficiently in real-world scenarios.
Curriculum Overview
This course includes 11 modules, 70 lessons, and 0 hours of materials.
Course Introduction
4 Parts
Course Introduction
Free
Volume
-
Downloading MySQL
Volume
-
Installing MySQL in our Computer
Volume
-
What is a Database?
Volume
-
Relationships, joins and Views
8 Parts
Introduction to Relationships
Volume
-
One to one Relationship
Volume
-
One to Many Relationship
Volume
-
Many to Many Relationship
Volume
-
Introduction to joins
Volume
-
Joins in detail
Volume
-
Joining Multiple Tables
Volume
-
Views in detail
Volume
-
Constraints and Alter Table
7 Parts
Unique Constraint
Volume
-
Check Constraint
Volume
-
Named Constraints
Volume
-
Alter table Adding Columns
Volume
-
Alter Table Dropping Columns
Volume
-
Alter table name, and Modifying Columns
Volume
-
Alter Table Constraints
Volume
-
Logical Operators and Comparisons
8 Parts
NOT EQUAL
Volume
-
NOT LIKE
Volume
-
Greater than and less than
Volume
-
48 Logical and logical or
Volume
-
Between
Volume
-
The in Operator
Volume
-
The Is NULL operator
Volume
-
Case Operator
Volume
-
Aggregate Functions
7 Parts
COUNT
Volume
-
COUNT WITH GRUP BY
Volume
-
MIN and MAX
Volume
-
Min and Max with Group By
Volume
-
Subqueries with Aggregate functions
Volume
-
SUM and AVG Functions
Volume
-
Grouping multiple Columns
Volume
-
Deep Dive into Select Statement
5 Parts
Section 6 introduction
Volume
-
Loading Database and Tables
Volume
-
Order by and Distinct command
Volume
-
LIMIT AND OFFSET
Volume
-
LIKE AND WILCARDS
Volume
-
SQL String Functions
7 Parts
MySQL string functions
Volume
-
Loading data and creating new Table
Volume
-
Concat
Volume
-
Substring
Volume
-
Replace
Volume
-
Upper and Lower
Volume
-
Reverse, TRIM, LTRIM, RTRIM, RIGHT, LEFT Commands
Volume
-
Basics of CRUD operations
8 Parts
Section Introduction CRUD
Volume
-
Types of SQL Commands
Volume
-
Create Command
Volume
-
Inserting data into our table
Volume
-
Select Command
Volume
-
SQL Aliases
Volume
-
UPDATE COMMAND
Volume
-
DELETE Command
Volume
-
Inserting data into our tables
6 Parts
Introducing insert command
Volume
-
Multi-Insert
Volume
-
working with null and NOT-NULL
Volume
-
Working with Default values
Volume
-
Auto-increments
Volume
-
Understanding PRIMRY KEYS
Volume
-
Creating Databases and Tables
9 Parts
Creating New Database
Volume
-
Introducing Command line interface
Volume
-
Dropping Database using command Line Interface (CLI)
Volume
-
Understanding Tables
Volume
-
SQL Data Types
Volume
-
Creating tables in our database
Volume
-
Creating tables in our database Continue
Volume
-
Dropping Tables
Volume
-
MySQL comments
Volume
-
Course Roundup
1 Parts
Course Roundup
Volume
-
0
0 Reviews
Content Quality (0)
Instructor Skills (0)
Value for Money (0)
Support Quality (0)
Course Specifications
Sections
11
Lessons
70
Capacity
Unlimited
Duration
7:01 Hours
Students
4
Created Date
21 Nov 2024
Updated Date
22 Feb 2025
Send Course as Gift
Send as a gift to friends
You are viewing
The Complete SQL Database Course from ZERO to HERO using MySQL.
Subscribe to Our Newsletter
Receive expert insights, course updates, and learning resources directly in your inbox and get notified
Additional Links
Login Register Contact Certificate Validation Become Instructor About Terms and PoliciesContact US
© 2025 Rocket Soft. All Rights Reserved. Empowering Learning Worldwide.
Reply to Comment