The Complete SQL Course 2020: Become a MYSQL Master
What you'll learn
- Learn how to create and deal with databases
- Learn CRUD operations and how to use them to make use out of your database
- Grasp the concept of SQL clauses, functions, data types
- How to write simple to complex SQL queries
Course content
Introduction2 lectures • 14min
- IntroductionPreview08:34
- 2-Xampp (PHPmyadmin)installation05:26
Getting Started With Databases7 lectures • 20min
Constraints4 lectures • 18min
SQL Functions2 lectures • 6min
SQL Clauses5 lectures • 23min
Alters3 lectures • 14min
All About Joins and SQL Relations4 lectures • 23min
Wild Cards2 lectures • 11min
More Advanced Areas of SQL3 lectures • 25min
Requirements
- Just a computer
Description
You will learn to write SQL queries like a pro by building a real-world blog database
Here is a list of some of the things you will get after this course:
How to create your first database
How to create and delete your tables
How to perform CRUD operations
How to use SQL complex constraints
Running your first query
learn how to use Alters to tweak your columns and tables
learn and perform functions
create and understand complicated joins and unions and more..
More Specifically :
1-create database
2-create and deleting tables
3-insert
4-update and delete
5-data types
6-Conditional & comparison operators
7-basic queries
8-constraints (primary key, foreign key, and indexes)
9-functions (SUM-MIN-AVG-MAX-COUNT)
10-clauses (WHERE, ORDER by, DISTRICT, IN, GROUP By,)
11-alters
12-aliases
13-joins (INNER-RIGHT-LEFT)
14-UNIONS
15-wild cards
16-views
17-creating functions
18-triggers
Pretty cool huh? I hope you are ready for this journey :)
Who this course is for:
- Anyone interested in learning SQL, MYSQL for software engineering, data analysis or big data
Instructor
![Web Coding](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.9 Instructor Rating
- 506 Reviews
- 58,937 Students
- 1 Course
I am Mohamed Hassan. I am a full stack developer mostly focused on PHP, Python and Javascript. I like to help students and newcomers in the world of programming. When I first started off with coding 4 years ago, I made a lot of mistakes and I want you to avoid them. If you have any questions, reach out to me on my social media :)