The Complete SQL Course 2021: Become a MYSQL Master
This Complete SQL Bootcamp will Take you From Beginner to Master
Updated on Sep, 2023
Language - English
Course 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 :)
Goals
What will you learn in this course:
- Learn how to create and deal with databases
- Grasp the concept of SQL clauses, functions, data types
- How to write simple to complex SQL queries
Prerequisites
What are the prerequisites for this course?
- Just a computer
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
2 Lectures
-
Introduction
08:34
08:34
-
Installing Xampp
05:26
05:26
Getting Started With Databases
7 Lectures
Constraints
4 Lectures
SQL Functions
2 Lectures
SQL Clauses
5 Lectures
Alters
3 Lectures
All About Joins and SQL Relations
4 Lectures
Wild Cards
2 Lectures
More Advanced Areas of SQL
3 Lectures
Instructor Details
Web Coding
Developer || Instructor || BloggerMohamed Hassan is an aspiring developer. Years ago when started learning to code, he immediately fell in love with it and it's like this is all I want to do all my life. He then started building websites and apps for fun, got his internship a few months later, but he knew all along, how he always loved teaching people from a young age, and now he is dedicated to getting you the finest, most robust, informative, and engaging content and learning experience that he can get you.
He has experience with various both back-end and front-end technologies, from PHP to Python to Javascript and so much more.He explains everything with ease and clarity with practical real-world examples and mind-tackling quizzes and he is all ready to answer your questions :)
Course Certificate
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now