The Complete SQL Database Course from ZERO to HERO using MySQL.
in Databases
Created by
Ahmed Abditah
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.
Related Courses
Course
Comments (0)
Course Introduction
4 Parts
Course Introduction
-
Downloading MySQL
-
Installing MySQL in our Computer
-
What is a Database?
-
Creating Databases and Tables
9 Parts
Creating New Database
-
Introducing Command line interface
-
Dropping Database using command Line Interface (CLI)
-
Understanding Tables
-
SQL Data Types
-
Creating tables in our database
-
Creating tables in our database Continue
-
Dropping Tables
-
MySQL comments
-
Inserting data into our tables
6 Parts
Introducing insert command
-
Multi-Insert
-
working with null and NOT-NULL
-
Working with Default values
-
Auto-increments
-
Understanding PRIMRY KEYS
-
Basics of CRUD operations
8 Parts
Section Introduction CRUD
-
Types of SQL Commands
-
Create Command
-
Inserting data into our table
-
Select Command
-
SQL Aliases
-
UPDATE COMMAND
-
DELETE Command
-
SQL String Functions
7 Parts
MySQL string functions
-
Loading data and creating new Table
-
Concat
-
Substring
-
Replace
-
Upper and Lower
-
Reverse, TRIM, LTRIM, RTRIM, RIGHT, LEFT Commands
-
Deep Dive into Select Statement
5 Parts
Section 6 introduction
-
Loading Database and Tables
-
Order by and Distinct command
-
LIMIT AND OFFSET
-
LIKE AND WILCARDS
-
Aggregate Functions
7 Parts
COUNT
-
COUNT WITH GRUP BY
-
MIN and MAX
-
Min and Max with Group By
-
Subqueries with Aggregate functions
-
SUM and AVG Functions
-
Grouping multiple Columns
-
Logical Operators and Comparisons
8 Parts
NOT EQUAL
-
NOT LIKE
-
Greater than and less than
-
48 Logical and logical or
-
Between
-
The in Operator
-
The Is NULL operator
-
Case Operator
-
Constraints and Alter Table
7 Parts
Unique Constraint
-
Check Constraint
-
Named Constraints
-
Alter table Adding Columns
-
Alter Table Dropping Columns
-
Alter table name, and Modifying Columns
-
Alter Table Constraints
-
Relationships, joins and Views
8 Parts
Introduction to Relationships
-
One to one Relationship
-
One to Many Relationship
-
Many to Many Relationship
-
Introduction to joins
-
Joins in detail
-
Joining Multiple Tables
-
Views in detail
-
Course Roundup
1 Parts
Course Roundup
-
0
0 Reviews
.png)
