Browse Library

SQL for Newcomers - The Full Mastery Course

A course to make you an SQL genius!

Instructed by Sameh Sharaf

19 days left at this price!
$25 $40 38% off
Get single Course Access
$25
It Includes
  • Get access to this course only
  • Lifetime Course Access
  • Play & Pause Videos
  • High Quality Recorded Lectures
  • Learn Online from Mobile/PC/Tablet
  • Download Course for Offline Viewing
  • Inlcudes Real Projects
  • Free Instructor Support
Want to Learn more? Get access to all marketplace courses starting at $19/mo
  • 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

  • Lecture 1 :
  • Lecture 2 :
  • Tools Used in This Course

Section 2 : Setting Up Course Tools

  • 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

  • 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

  • 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

  • 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

  • Lecture 1 :
  • Concatenate Strings with '||' Operator
  • Lecture 2 :
  • Concatenate Strings with Numbers

Section 7 : Tidy Up Your Results: Sorting, Alias Names, Limit Records

  • 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

  • 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

  • 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

  • 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

  • Lecture 1 :
  • Selectception: A Select Query Inside Another Select Query!

Section 12 : Casting & Data Conversion

  • 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

  • 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

  • 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

  • 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)

  • 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

  • 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?

    Once you purchase a course (Single course or Subscription), you will be able to access the courses instantly online by logging into your account. Use the user name & password that you created while signing up. Once logged in, you can go to the "My Courses" section to access your course.
  • 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 certification after completing the course?

    Yes. Once you succesfully complete any course on Learnfly marketplace, you get a certiifcate of course completion emailed to you within 24 hours with your name & the Learnfly badge. You can definately brag about it & share it on your social media or with friends as one of your achievement. Click here to view the sample certificate Click Here
  • For how long can i access my course after the purchase?

    If you buy a single course, that course is accessible to you for a lifetime. If you go for a premium subcription, you can access all the courses on Learnfly marketplace till your subscription is Active.
  • Whats the difference between Single Course Purchase & Go Premium option?

    With Single Course Purchase, you only get an access of one single course. Whereas, with premium monhtly or annual subscription, you can access all the existing or new courses on learnfly marketplace. You can decide what option suits you the best and accordingly you can make your purchase.
  • Is there any free trial?

    Currently, we don't have any free trial but it may be available in near future.
  • What is the refund policy?

    We would hate you to leave us. However, if you are not satisfied, you can ask for a full refund within 30 days & we will be happy to assist you further.

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...
infinite-scroll-project-ajax-mysql-api-php-jquery

Infinite Scroll Project AJAX MySQL ...

By : Laurence Svekis

Lecture 19

learn-to-build-sql-query-ultimate-sql-and-database-concepts

Learn to Build SQL Query Ultimate S...

By : Jazeb Akram

Lecture 24

sql-server-101-microsoft-sql-server-for-absolute-beginners

SQL Server 101 : Microsoft SQL Serv...

By : Rashid Khan

Lecture 44

oracle-apps-r12-general-ledger-course

Oracle Apps R12 General Ledger Cour...

By : koduru sridevi

Lecture 14

Sign up and start learning
By signing up, you agree to our Terms of Use and Privacy Policy
Forget Password