Course Content
Course Introduction
Course Introduction.
0/7
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
0/9
Creating New Database
04:41
Introducing Command line interface
02:08
Dropping Database using command Line Interface (CLI)
02:05
Understanding Tables
05:59
SQL Data Types
07:29
Creating tables in our database
05:33
Creating tables in our database Continue
02:36
Dropping Tables
01:52
MySQL comments
05:54
Inserting data into our tables
0/6
Introducing insert command
06:24
Multi-Insert
03:51
working with null and NOT-NULL
05:59
Working with Default values
06:22
Auto-increments
04:19
Understanding PRIMRY KEYS
06:52
Basics of CRUD operations
Basics of CRUD operations
0/8
Section Introduction CRUD
04:16
Types of SQL Commands
06:13
Create Command
04:14
Inserting data into our table
01:52
Select Command
04:09
SQL Aliases
03:07
UPDATE COMMAND
07:53
DELETE Command
03:38
SQL String Functions
SQL String Functions
0/7
MySQL string functions
03:34
Loading data and creating new Table
05:21
Concat
06:25
Substring
06:35
Replace
03:10
Upper and Lower
03:32
Reverse, TRIM, LTRIM, RTRIM, RIGHT, LEFT Commands
06:10
Deep Dive into Select Statement
Deep Dive into Select Statement
0/5
Section 6 introduction
01:05
Loading Database and Tables
08:49
Order by and Distinct command
07:36
LIMIT AND OFFSET
06:09
LIKE AND WILCARDS
14:07
Aggregate Functions
Aggregate Functions
0/7
COUNT
05:36
COUNT WITH GRUP BY
04:45
MIN and MAX
01:53
Min and Max with Group By
05:41
Subqueries with Aggregate functions
08:42
SUM and AVG Functions
04:55
Grouping multiple Columns
03:40
Logical Operators and Comparisons
Logical Operators and Comparisons
0/8
NOT EQUAL
05:52
NOT LIKE
03:16
Greater than and less than
06:18
48 Logical and logical or
07:58
Between
04:07
The in Operator
05:56
The Is NULL operator
02:38
Case Operator
08:16
Constraints and Alter Table
Constraints and Alter Table
0/7
Unique Constraint
05:34
Check Constraint
04:32
Named Constraints
04:10
Alter table Adding Columns
03:55
Alter Table Dropping Columns
01:09
Alter table name, and Modifying Columns
04:06
Alter Table Constraints
04:58
Relationships, joins and Views
Relationships, joins and Views
0/8
Introduction to Relationships
07:38
One to one Relationship
12:03
One to Many Relationship
12:01
Many to Many Relationship
12:54
Introduction to joins
03:42
Joins in detail
11:27
Joining Multiple Tables
11:41
Views in detail
05:47
Course Roundup
Course Roundup
0/2
Course Roundup.
02:14
Final words
The Complete SQL Database Course from ZERO to HERO using MySQL.
About Lesson

Welcome to 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

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.

  • In this course, you’ll 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
  • Work with large datasets containing thousands of entries
  • Design and implement complex database schemas

Why Learn MySQL

Consistently ranked the most in-demand skill in recent employer surveys, SQL is a fantastic way to increase your income and boost your professional development. So many companies today use MySQL, including Twitter, Uber, Airbnb, Dropbox, GitHub, Kickstarter, Udemy, Slack, and many others. Unsure about the difference between SQL and MySQL? MySQL is the most popular open source SQL database out there, so it’s a great choice to begin your learning journey. We’ll talk a lot more about the difference between SQL and MySQL in the course, but 95% of what you learn about MySQL in this course will apply to other databases such as Postgres, Oracle, and Microsoft SQL Server.

Who this course is for:

Anyone interested in learning SQL to help with their current job or to find a new role. SQL is one of today’s most in-demand skills

Anyone looking to answer complex business problems and generate reports using data

Business owners, people in sales, or people in marketing roles who are interested in understanding company data better.

Developers who are looking to build applications (e.g. social network, ecommerce site) using MySQL.

Previous
Next
0% Complete