The Complete SQL Database Course from ZERO to HERO using MySQL.

Course Content

Course Introduction
Course Introduction.

Welcome to the course
Course Introduction
05:22
Downloading MySQL
02:13
Installing MySQL in our Computer
09:22
What is a Database?
10:07
Course Resources
Student Review Request

Creating Databases and Tables
Creating Databases and Tables

Inserting data into our tables

Basics of CRUD operations
Basics of CRUD operations

SQL String Functions
SQL String Functions

Deep Dive into Select Statement
Deep Dive into Select Statement

Aggregate Functions
Aggregate Functions

Logical Operators and Comparisons
Logical Operators and Comparisons

Constraints and Alter Table
Constraints and Alter Table

Relationships, joins and Views
Relationships, joins and Views

Course Roundup
Course Roundup

About 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.

Understand the fundamental concepts of databases, including data organization, storage, and retrieval.
Learn how to install and set up MySQL on your local machine or a server environment.
Master the CRUD operations (Create, Read, Update, Delete) using SQL commands to interact with MySQL databases.
Practice creating, reading, updating, and deleting records in database tables.
Explore different types of relationships in databases, such as one-to-one, one-to-many, and many-to-many.
Understand how to define and implement these relationships using foreign keys and join operations in MySQL.
Gain proficiency in the basics of SQL language syntax, including SELECT, INSERT, UPDATE, DELETE statements.
Learn how to use SQL clauses such as WHERE, ORDER BY, GROUP BY, and HAVING to filter, sort, and group data.
Dive into the concept of subqueries in SQL and understand how to write subqueries to retrieve data from nested queries.
Learn about database normalization techniques to reduce data redundancy and improve data integrity.

Complete Beginners: Individuals who have no prior experience with databases, SQL, or MySQL
Self-Learners: Individuals interested in self-paced, practical learning to master MySQL from scratch.
Anyone Seeking Database Knowledge: Whether for personal projects, academic pursuits, or professional growth, this course caters to anyone curious about databases and MySQL.
Students: College or university students seeking to enhance their skills in database management.
Career Changers: Individuals looking to pivot their careers into database management or development.

2.00 /5

Ahmed Arnab

2 Courses

Hey there! I'm Ahmed Abdifatah, and I've been deeply immersed in the IT industry for the past four years, honing my skills in database administration and network management. Throughout my…

Student Ratings & Reviews

No Review Yet

Find your desired course

Select Your Favourite Category And Start Learning.

.Popular

Academic Accounting

Accounting

Asaasiyaadka Computer-ka

Branding

Caafimaad

Caafimaadka Guud

CAD

The Complete SQL Database Course from ZERO to HERO using MySQL.

All Levels

7h 1m

74

Course Content

Course Introduction Course Introduction.

Downloading MySQL

Installing MySQL in our Computer

What is a Database?

Course Resources

Student Review Request

Creating Databases and Tables Creating Databases and Tables

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

Introducing insert command

Multi-Insert

working with null and NOT-NULL

Working with Default values

Auto-increments

Understanding PRIMRY KEYS

Basics of CRUD operations Basics of CRUD operations

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 SQL String Functions

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 Deep Dive into Select Statement

Section 6 introduction

Loading Database and Tables

Order by and Distinct command

LIMIT AND OFFSET

LIKE AND WILCARDS

Aggregate Functions Aggregate Functions

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 Logical Operators and Comparisons

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 Constraints and Alter Table

Unique Constraint

Check Constraint

Select Your Favourite
Category And Start Learning.