The Complete SQL/MySQL Masterclass from Beginner to Expert
Learn SQL through lots of practice and many explained exercises!
Programming,Database and Design Development,
Lectures -94
Quizzes -17
Duration -8.5 hours
Lifetime Access

Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Hello,
Getting here means you want to learn programming. You've come to the right place!
Why programming?
Because you earn well, the employment rate in the field is almost 100% or maybe just for fun.
We want to help you build a real experience in the field, not just learn a programming language.
When you are just starting out in IT and want to get a job, the most important thing is to prove to your employer that you are capable of producing for him.
If you bring added value to the employer, everything is fine, and our complete beginner course can help you do just that. You will learn how to read and write complex queries in a database using one of the most sought after skills. - MySQL.
Learning SQL is one of the fastest ways to improve your career prospects, as it is one of the most sought-after technological skills! In this course you will learn quickly and you will receive challenges along the way to improve your understanding!
Success!
Goals
In this course you will learn the basics of SQL without the need for prior knowledge of databases.
You will learn the basics of SQL syntax.
You will learn what databases are, tables, and how to use them.
You will learn how to create databases and tables.
You will learn to manipulate the structure of tables
You will learn to modify existing tables.
You will learn to enter data in tables.
You will learn to read data from tables.
You will learn to modify existing data in tables.
You will learn how to delete data from tables.
You will learn what joins are and how to use them.
You will learn what aggregation functions are and how to use them
You will learn what triggers are and how to use them
You will learn what functions are stored and how they are used
You will learn what stored procedures are and how to use them
Upon completion of this course, you will have the skills to be able to use SQL with confidence, to have a solid understanding of MySQL and to be skilled in designing databases.
Prerequisites
No prior knowledge of databases, SQL or MySQL is required. You will learn everything you need to know
Curriculum
Check out the detailed breakdown of what’s inside the course
Course presentation
1 Lectures
-
What is SQL? 02:58 02:58
SQL Setup
1 Lectures
Databases & Tables
2 Lectures
Data Types in SQL
2 Lectures
Creating Databases and Tables
3 Lectures
Modify the table structure
3 Lectures
Inserting data in Tables
3 Lectures
Unique Identifiers
5 Lectures
Table specific SQL keywords
7 Lectures
Reading Data from tables
3 Lectures
Filtering the table data
15 Lectures
Updating table data
4 Lectures
Deleting the table data
3 Lectures
Pagination & Order
4 Lectures
Foreign Keys
5 Lectures
Joins
8 Lectures
SQL Aggregate Functions
11 Lectures
Triggers
6 Lectures
Stored functions
4 Lectures
Stored Procedures
4 Lectures
Instructor Details
Sharp Academy
Course Certificate
Use your certificate to make a career change or to advance in your current career.
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