Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
Get Unlimited Learning Access
$29
6 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
6 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
$29
What you'll learn?
- 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.
Course Overview
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.
Pre-requisites
- Have a PC or laptop to work on. Your old clunky notebook will do.
Target Audience
- Junior data analysts and scientists.
- Junior developers who need to work on relational databases.
- Undergraduate students who study relational databases in their curriculum.
Curriculum 123 Lectures 11:03:36
-
Section 1 : Introduction
- Lecture 2 :
- Tools Used in This Course
- Lecture 3 :
- Resources- SQL Practice(Please remove ".txt" suffix to restore the original form
-
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
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?
Instructor
0 Course Views
Courses
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...
