Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
This plan includes
- Limited free courses access
- Play & Pause Course Videos
- Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Email & Chat Support
This plan includes
- Access to 11,000+ Courses
- Ads free experience Courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Direct Support
- Email & Chat Support
- Cancel Anytime
What you'll learn?
- 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.
Course Overview
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
Pre-requisites
- No prior experience is required. We will start from the scratch with baby steps.
- nothing
Target Audience
- 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.
Curriculum 78 Lectures 02:58:04
-
Section 1 : SQL Basics
- 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
- 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
- Lecture 1 :
- SELECT Statement
- Lecture 2 :
- DISTINCT
- Lecture 3 :
- ORDER BY
-
Section 4 : Filtering Data
- 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
- 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
- Lecture 1 :
- Aggregate Functions
- Lecture 2 :
- String Functions
-
Section 7 : SQL Advanced Topics
- Lecture 1 :
- GROUP BY
- Lecture 2 :
- HAVING
- Lecture 3 :
- SubQuery: EXISTS vs IN
-
Section 8 : Modifying Data
- Lecture 1 :
- INSERT
- Lecture 2 :
- UPDATE
- Lecture 3 :
- DELETE
-
Section 9 : Defining Data
- Lecture 1 :
- CREATE Table
- Lecture 2 :
- ALTER Table
- Lecture 3 :
- DROP Table
-
Section 10 : Next SQL Course & THANK YOU
- Lecture 1 :
- Next SQL Course & THANK YOU
Our learners work at
Frequently Asked Questions
-
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?
