The SQL Ultimate Course: from Zero to Hero

Unique SQL course - covers everything you need to MASTER SQL and understand how things work behind the scenes in SQL.

Created by : Rated :4 1060 views

Last Updated: 2023-05-08 07:05:19 English Course Type: Self Learning

Obtain one of the most in-demand Skills
Answer company questions using data and SQL.
Have the Ability to Solve any SQL Problem. Gain Theoretical Insights about SQL and Relational Databases.
Understand how SQL queries are processed behind the scene, this helps to be more creative when writing SQL code.
Tons of Best Practices and Tips & Tricks, i've collected from Real Life Projects.
Code along with me to PRACTICE and IMPLEMENT everything you learn.

Having SQL Skills and learn one of employer's most requested skills of 2023! Learning SQL is one of the fastest ways to improve your career prospects.

This is the most comprehensive, yet straight-forward, course for the SQL language on Learnfly!

In this course, I transferred my experience from over a decade of real-world Big Data projects to one learnfly course.

I designed this course to take you from Zero to Hero of SQL, so if you are a beginner, don't worry, I will explain everything from scratch step by step. You are not too old or too young, and SQL is super easy to learn.

Important

All course materials like database script, SQL Cheat Sheet and presentations can be found and downloaded under the first lecture "Course Curriculum Overview"

Each SQL Topic in this course will be explained in 3 steps:

The concept (Theory)
Learn SQL Syntax using simple Tasks.
Learn How SQL Processes the Query behind the scene.

SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today!

You will have exercises during the videos where I present a task and we solve it together. By the end of each section, you will have as well tons of exercises and solutions.

I will provide you with numerous materials:

SQL Course Curriculum (Roadmap) and we will progress it in each lecture.
SQL Cheat Sheet, so you don't have to memorize all SQL syntaxes and you can use it later during development to have quick access.
SQL Database and Data for Training, so you can practice with me.
SQL Presentations and Concepts, all collected in one place to have it as a reference for you.

Topics covered in this course :

SQL Basics: Intro, Why SQL, Database Concepts, Table concepts, SQL Commands, SQL Elements
Download & Install MySQL
Install Database
SQL Coding Style
SELECT statement
DISTINCT
ORDER BY
Filtering Data: Where
Comparison Operators: =, >, <, >=, <=, !=
Logical Operators: AND, OR, NOT
BETWEEN, IN, LIKE
JOINS: Inner, Left, Right, Full
UNION & UNION ALL
Aggregate Functions: MAX, MIN, AVG, COUNT, SUM
String Functions: CONCAT, LOWER, UPPER, TRIM, LENGTH, SUBSTRING
Advanced SQL Topics
GROUP BY
HAVING
Subquery: EXISTS & IN
Modifying Data: INSERT, UPDATE, DELETE
Defining Data: CREATE, ALTER, DROP

No prior experience is required. We will start from the scratch with baby steps.
nothing

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 level up their skills and master a new programming language.
Anyone who wants to work with data.
SQL Developers who are interested in working with Databases.
Data Analysts who are interested in building dashboards and reports.
Data Scientists who are interested in finding answers from data.
People from Business who are interested in understanding company data better.

Section 1 : SQL Basics 7 Lectures 00:28:04
Lecture 1 :
Course Curriculum Overview Preview
Lecture 2 :
Introduction to SQL
Lecture 3 :
Why Learn SQL
Lecture 4 :
The Database Concepts
Lecture 5 :
SQL Tables Concepts
Lecture 6 :
The Main SQL Commands
Lecture 7 :
The Elements of SQL Statements
Section 2 : Prepare The Environment 4 Lectures 00:23:27
Lecture 1 :
Download & Install MySQL
Lecture 2 :
Tour in the Interface of MySQL Workbench
Lecture 3 :
Install the Course Database
Lecture 4 :
Guide to SQL Coding Style
Section 3 : Querying Data 3 Lectures 00:19:59
Lecture 1 :
SELECT Statement
Lecture 2 :
DISTINCT
Lecture 3 :
ORDER BY
Section 4 : Filtering Data 6 Lectures 00:48:19
Lecture 1 :
WHERE
Lecture 2 :
Comparison Operators: =, >, <, >=, <=, !=
Lecture 3 :
Logical Operators: AND, OR, NOT
Lecture 4 :
BETWEEN
Lecture 5 :
IN
Lecture 6 :
LIKE
Section 5 : Joining Data 7 Lectures 00:36:44
Lecture 1 :
JOINS Concept
Lecture 2 :
AS Statement - Aliases
Lecture 3 :
INNER JOIN
Lecture 4 :
LEFT JOIN
Lecture 5 :
FULL JOIN
Lecture 6 :
UNION
Lecture 7 :
RIGHT JOIN
Section 6 : SQL Functions 2 Lectures 00:12:52
Lecture 1 :
Aggregate Functions
Lecture 2 :
String Functions
Section 7 : SQL Advanced Topics 3 Lectures 00:00:00
Lecture 1 :
GROUP BY
Lecture 2 :
HAVING
Lecture 3 :
SubQuery: EXISTS vs IN
Section 8 : Modifying Data 3 Lectures 00:05:53
Lecture 1 :
INSERT
Lecture 2 :
UPDATE
Lecture 3 :
DELETE
Section 9 : Defining Data 3 Lectures 00:01:49
Lecture 1 :
CREATE Table
Lecture 2 :
ALTER Table
Lecture 3 :
DROP Table
Section 10 : Next SQL Course & THANK YOU 1 Lectures 00:00:57
Lecture 1 :
Next SQL Course & THANK YOU

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?