SQL for Newcomers - A Crash Course
- Have a PC or laptop to work on. Your old clunky notebook will do.
- Can work on any operating system (Windows, Linux & MacOS).
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.
- Junior data analysts and scientists.
- Junior developers who need to work on relational databases.
- Undergraduate students who study relational databases in their curriculum.
- Anyone who's interested to learn SQL and add it to their resume.
- Tools Used in this Course01:00
- Download PostgreSQL02:07
- Install PostgreSQL02:33
- Download SQLectron01:31
- Install SQLectron00:33
- Connect to PostgreSQL - Credentials01:18
- Connect to PostgreSQL Using SQLectron01:33
- Import Course Data Using SQLectron02:20
- FOR WINDOWS 32-BIT USERS: SQL Alternative - DBeaver00:30
- FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data07:51
- Check Imported Data05:42
- So.. What is a Database?01:20
- SQL Data Types01:46
- Finally Some Fun! Extracting Data Based on Requirements00:51
- Filtering Data Using WHERE Keyword08:28
- Filter Data by Range Using BETWEEN02:42
- Filter Data by Set of Values Using IN03:15
- Filter Data by Date05:24
- More Filtering by Date03:09
- Another Query Filtering by Date00:59
- Filter Data by Strings (Names, addresses, ...)04:15
- Give Your Report Fields A Cool Name04:10
- Order Records by Column06:22
- Order Records by Multiple Columns12:07
- LIMIT Record Count Fetched by Your Query07:56
- Fetch A Field's Unique Values Using DISTINCT02:42
- What Is A NULL Value Anyway?05:01
- Let Me Introduce You to Functions04:11
- SUM Function04:12
- AVG (Average) Function04:09
- COUNT Function06:32
- GROUP BY Clause: Use Functions with Dimensions05:53
- GROUP BY More Than One Dimension04:52
- Character Functions - UPPER, LOWER & INITCAP07:49
- Character Functions - CONCAT & LENGTH10:24
- Number Functions - MOD & ROUND11:13
- Employees & Departments Tables Revised02:40
- Entity Relationship Diagram (ERD)09:13
- Cartesian Join09:27
- Table Aliases with Joins06:43
- INSERT a New Record to a Table08:44
- Insert Without Specifying Column Names09:10
- UPDATE a Record's Field Values07:12
- DELETE a Table's Record06:08
- SQL Data Types Revised12:34
- Bookstore Data Set: Let's Move It to Database03:51
- Create Your First Table!08:19
- Insert Data to Your New Table07:31
- Change Column Data Type07:11
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.