All in One Offer! | Access Unlimited Courses in any category starting at just $29. Signup today. Offer Ends in: 6 Days!

Browse Library

Get Unlimited Learning Access
$29
6 days left at this price!
30-Day Money-Back Guarantee

It Includes

  • Get Full Access to the platform
  • Access to 16000+ online courses
  • Play & Pause Course Viewing
  • Attend weekly live webinar
  • High Quality Recorded Lectures
  • Learn Online from Mobile/PC/Tablet
  • Assignments & Projects
  • Online iLab Access
  • Certificate of Completion
  • Download for offline viewing
  • Cancel Anytime
$29
  • Select & filter data for useful reports based on different requirements.
  • Manipulate data by adding new records & modifying or deleting existing ones.
  • Create & modify tables with setting constraints to columns.
  • Learn some of the most useful built-in functions in SQL, as well as data type conversion.
  • Join tables using different join types SQL provides.

Hi!

I'm Sameh Sharaf. I am a data engineer. I have worked on data since 2010 so I guess I can say I'm experienced enough.

This course will teach you how to use SQL (Structured Query Language), a language so prominent for relational databases, databases such as MySQL, PostgreSQL, SQLlite and more.

SQL now is a great skill to have if you want to work as a data analyst, data scientist, BI developer, data engineer, database administrator or even a software developer/engineer, since all these jobs need to use databases and data in a daily basis.

I'm a beginner, is this course for me?

Sure! This course was done for beginners. Even students with experience in SQL may find it useful too to memorize some keywords and functions, as well as learning more about the bits they may miss.

Is there any prerequisites to attend this course?

The only thing you need is a PC or laptop with average performance and any operating system installed on. We'll be using Windows 10 for this course but the OS does not matter since the tech we'll be using is cross-platform and can work on Linux and Mac.

  • Have a PC or laptop to work on. Your old clunky notebook will do.
  • Junior data analysts and scientists.
  • Junior developers who need to work on relational databases.
  • Undergraduate students who study relational databases in their curriculum.
View More...
  • Section 1 : Introduction 2 Lectures 00:02:17

    • Lecture 1 :
    • Lecture 2 :
    • Tools Used in This Course
  • Section 2 : Setting Up Course Tools 8 Lectures 00:19:54

    • Lecture 1 :
    • Download PostgreSQL
    • Lecture 2 :
    • Install PostgreSQL
    • Lecture 3 :
    • Download SQLectron
    • Lecture 4 :
    • Install SQLectron
    • Lecture 5 :
    • Connect to PostgreSQL - Credentials
    • Lecture 6 :
    • Connect to PostgreSQL using SQLectron
    • Lecture 7 :
    • Import Course Data Using SQLectron
    • Lecture 8 :
    • FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data
  • Section 3 : Browsing & Filtering Data 15 Lectures 00:58:08

    • Lecture 1 :
    • Check imported data
    • Lecture 2 :
    • So.. What is a Database?
    • Lecture 3 :
    • SQL Data Types
    • Lecture 4 :
    • Finally Some Fun! Extracting Data Based on Requirements
    • Lecture 5 :
    • Filtering Data using WHERE Keyword
    • Lecture 6 :
    • Filter Data by Range Using BETWEEN
    • Lecture 7 :
    • Filter Data by Set of Values Using IN
    • Lecture 8 :
    • Filter Data by Date
    • Lecture 9 :
    • More Filtering by Date
    • Lecture 10 :
    • Another Query Filtering by Date
    • Lecture 11 :
    • Filter Data by Strings (Names, Addresses, ...)
    • Lecture 12 :
    • More Filtering by Strings
    • Lecture 13 :
    • More Filtering by Strings 2
    • Lecture 14 :
    • More Filtering by Strings 3
    • Lecture 15 :
    • How to Ignore Caps when Filtering by String
  • Section 4 : Filter Data with AND, OR, NOT Operators 4 Lectures 00:38:12

    • Lecture 1 :
    • AND Operator
    • Lecture 2 :
    • OR Operator
    • Lecture 3 :
    • NOT Operator
    • Lecture 4 :
    • AND, OR & NOT Operators: Which Has The Highest Priority?
  • Section 5 : Math Operations 4 Lectures 00:19:03

    • Lecture 1 :
    • Basic Math Operations
    • Lecture 2 :
    • Modulo Operator
    • Lecture 3 :
    • It's Payday! Calculate The Net Salary for Employees
    • Lecture 4 :
    • Filter Data with Math Equations
  • Section 6 : String Concatenation 2 Lectures 00:07:49

    • Lecture 1 :
    • Concatenate Strings with '||' Operator
    • Lecture 2 :
    • Concatenate Strings with Numbers
  • Section 7 : Tidy Up Your Results: Sorting, Alias Names, Limit Records 6 Lectures 00:39:42

    • Lecture 1 :
    • Give Your Report Fields A Cool Name
    • Lecture 2 :
    • A Report for Payroll
    • Lecture 3 :
    • Order Records by Column
    • Lecture 4 :
    • Order Records by Multiple Columns
    • Lecture 5 :
    • How Alias Names Cannot Be Used with WHERE
    • Lecture 6 :
    • LIMIT Record Count Fetched by Your Query
  • Section 8 : NULL, DISTINCT & CASE Statements 5 Lectures 00:32:51

    • Lecture 1 :
    • Fetch A Field's Unique Values Using DISTINCT
    • Lecture 2 :
    • Using DISTINCT Keyword with Multiple Columns
    • Lecture 3 :
    • What is a NULL Value Anyway?
    • Lecture 4 :
    • Build More Sophisticated Queries with CASE Statements
    • Lecture 5 :
    • Your Knowledge So Far Under A Great Test
  • Section 9 : Functions in SQL: Multiple-Row Functions 10 Lectures 00:54:37

    • Lecture 1 :
    • Let Me Introduce You to Functions
    • Lecture 2 :
    • SUM Function
    • Lecture 3 :
    • AVG (Average) Function
    • Lecture 4 :
    • COUNT Function
    • Lecture 5 :
    • MIN & MAX Functions
    • Lecture 6 :
    • How To Count Your Field's Unique Values
    • Lecture 7 :
    • GROUP BY Clause: Use Functions with Dimensions
    • Lecture 8 :
    • GROUP BY More Than One Dimension
    • Lecture 9 :
    • Now For Some Tough Workout
    • Lecture 10 :
    • Filter By Aggregate Functions with HAVING Clause
  • Section 10 : Functions in SQL: Single-Row Functions 8 Lectures 01:12:25

    • Lecture 1 :
    • Character Functions - UPPER, LOWER & INITCAP
    • Lecture 2 :
    • Character Functions - CONCAT & LENGTH
    • Lecture 3 :
    • Character Functions - LPAD & RPAD
    • Lecture 4 :
    • Character Functions - TRIM
    • Lecture 5 :
    • Character Functions - REPLACE
    • Lecture 6 :
    • Character Functions - SUBSTR
    • Lecture 7 :
    • Number Functions - MOD & ROUND
    • Lecture 8 :
    • Number Functions - TRUNC
  • Section 11 : Nested Queries 1 Lectures 00:06:15

    • Lecture 1 :
    • Selectception: A Select Query Inside Another Select Query!
  • Section 12 : Casting & Data Conversion 6 Lectures 00:53:15

    • Lecture 1 :
    • Auto Data Conversion in SQL
    • Lecture 2 :
    • Cast Date to Character
    • Lecture 3 :
    • Cast Number to Character
    • Lecture 4 :
    • Cast Timestamp to Character
    • Lecture 5 :
    • Cast Character to Number
    • Lecture 6 :
    • Cast Character to Date & Timestamp
  • Section 13 : Combination Relationships 5 Lectures 00:09:30

    • Lecture 1 :
    • UNION
    • Lecture 2 :
    • UNION ALL
    • Lecture 3 :
    • Important Note about Combining Queries
    • Lecture 4 :
    • INTERSECT
    • Lecture 5 :
    • EXCEPT
  • Section 14 : Joins in SQL 8 Lectures 00:53:11

    • Lecture 1 :
    • Employees & Departments Tables Revised
    • Lecture 2 :
    • Entity Relationship Diagram (ERD)
    • Lecture 3 :
    • Cartesian Join
    • Lecture 4 :
    • Table Aliases with Joins
    • Lecture 5 :
    • Why I Don't Recommend Cartesian Joins
    • Lecture 6 :
    • Inner Join
    • Lecture 7 :
    • In-Depth Look into Join Types in SQL
    • Lecture 8 :
    • Outer Join - Right, Left & Full
  • Section 15 : Data Manipulation in SQL 9 Lectures 01:00:26

    • Lecture 1 :
    • INSERT a New Record to a Table
    • Lecture 2 :
    • Insert Without Specifying Column Names
    • Lecture 3 :
    • UPDATE a Record's Field Values
    • Lecture 4 :
    • CAUTION! How an UPDATE Query Can Go Wrong
    • Lecture 5 :
    • Update a Record Using Single-Row Functions
    • Lecture 6 :
    • A Good Exercise: Extract Employee's Email Address
    • Lecture 7 :
    • Solution: Extract Employee's Email Address
    • Lecture 8 :
    • DELETE a Table's Record
    • Lecture 9 :
    • Insert Records with Nested Select Queries
  • Section 16 : SQL Data Definition Language (DDL) 23 Lectures 01:59:40

    • Lecture 1 :
    • SQL Data Types Revised
    • Lecture 2 :
    • Bookstore Data Set: Let's Move It to Database
    • Lecture 3 :
    • Create Your First Table!
    • Lecture 4 :
    • Insert Data to Your New Table
    • Lecture 5 :
    • Change Column Data Type
    • Lecture 6 :
    • Rename Column
    • Lecture 7 :
    • Add a New Column to Table
    • Lecture 8 :
    • Constraints in SQL
    • Lecture 9 :
    • Primary Keys
    • Lecture 10 :
    • NOT NULL Constraint
    • Lecture 11 :
    • UNIQUE Constraint
    • Lecture 12 :
    • DEFAULT Constraint
    • Lecture 13 :
    • Foreign Keys
    • Lecture 14 :
    • Use Foreign Keys with Joins - Books & Publishers
    • Lecture 15 :
    • Foreign Keys - Properties
    • Lecture 16 :
    • Drop Column
    • Lecture 17 :
    • DROP Table
    • Lecture 18 :
    • Create a New Table with Select Statement
    • Lecture 19 :
    • A Trick to Create an Empty Table with Select Statement
    • Lecture 20 :
    • Insert New Records Using Select Statement
    • Lecture 21 :
    • Views
    • Lecture 22 :
    • Schemas
    • Lecture 23 :
    • Create & Use Schemas
  • Section 17 : Access Control 6 Lectures 00:16:21

    • Lecture 1 :
    • Introduction to Access Control
    • Lecture 2 :
    • Create User
    • Lecture 3 :
    • Grant SELECT to User
    • Lecture 4 :
    • Grant Insert & Update to User
    • Lecture 5 :
    • Revoke Privilege from User
    • Lecture 6 :
    • User Groups
  • 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?

Sameh Sharaf,

A data engineer, working with data for 8 years and counting. Passionate for teaching as for learning. I'm a certified AWS Solution Architect - Associate and Google Cloud Data Engineer Professional.
View More...
  • managing-sql-business-intelligence-operations

    Managing SQL Business Intelligence ...

    By : Microsoft

    Lecture 7 Intermediate Level 0:0:0
  • infinite-scroll-project-ajax-mysql-api-php-jquery

    Infinite Scroll Project AJAX MySQL ...

    By : Laurence Svekis

    Lecture 19 Beginner Level 1:26:34
  • learn-to-build-sql-query-ultimate-sql-and-database-concepts

    Learn to Build SQL Query Ultimate S...

    By : Jazeb Akram

    Lecture 24 Beginner Level 2:11:45
  • sql-server-101-microsoft-sql-server-for-absolute-beginners

    SQL Server 101 : Microsoft SQL Serv...

    By : Rashid Khan

    Lecture 44 Beginner Level 3:47:42
Signup & Continue Checkout
By signing up, you agree to our Terms of Use and Privacy Policy
Create New Password
Enter your email address and we'll send you a link to reset your password.