SQL for Newcomers - A Crash Course

A course optimized to master SQL quickly
Rating: 4.4 out of 5 (458 ratings)
13,225 students
SQL for Newcomers - A Crash Course
Rating: 4.4 out of 5 (458 ratings)
13,225 students
Able to select & filter data using SQL
Manipulate data by adding new records & modifying or deleting existing ones
Create & modify tables
Join tables using different join types SQL provides.

Requirements

  • Have a PC or laptop to work on. Your old clunky notebook will do.
  • Can work on any operating system (Windows, Linux & MacOS).
Description

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.

Who this course is for:
  • 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.
Course content
11 sections • 51 lectures • 4h 17m total length
  • Introduction
    01:15
  • Tools Used in this Course
    01:00
  • Download PostgreSQL
    02:07
  • Install PostgreSQL
    02:33
  • Download SQLectron
    01:31
  • Install SQLectron
    00:33
  • Connect to PostgreSQL - Credentials
    01:18
  • Connect to PostgreSQL Using SQLectron
    01:33
  • Import Course Data Using SQLectron
    02:20
  • FOR WINDOWS 32-BIT USERS: SQL Alternative - DBeaver
    00:30
  • FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data
    07:51
  • Check Imported Data
    05:42
  • So.. What is a Database?
    01:20
  • SQL Data Types
    01:46
  • Finally Some Fun! Extracting Data Based on Requirements
    00:51
  • Filtering Data Using WHERE Keyword
    08:28
  • Filter Data by Range Using BETWEEN
    02:42
  • Filter Data by Set of Values Using IN
    03:15
  • Filter Data by Date
    05:24
  • More Filtering by Date
    03:09
  • Another Query Filtering by Date
    00:59
  • Filter Data by Strings (Names, addresses, ...)
    04:15
  • Give Your Report Fields A Cool Name
    04:10
  • Order Records by Column
    06:22
  • Order Records by Multiple Columns
    12:07
  • LIMIT Record Count Fetched by Your Query
    07:56
  • Fetch A Field's Unique Values Using DISTINCT
    02:42
  • What Is A NULL Value Anyway?
    05:01
  • Let Me Introduce You to Functions
    04:11
  • SUM Function
    04:12
  • AVG (Average) Function
    04:09
  • COUNT Function
    06:32
  • GROUP BY Clause: Use Functions with Dimensions
    05:53
  • GROUP BY More Than One Dimension
    04:52
  • Character Functions - UPPER, LOWER & INITCAP
    07:49
  • Character Functions - CONCAT & LENGTH
    10:24
  • Number Functions - MOD & ROUND
    11:13
  • Employees & Departments Tables Revised
    02:40
  • Entity Relationship Diagram (ERD)
    09:13
  • Cartesian Join
    09:27
  • Table Aliases with Joins
    06:43
  • INSERT a New Record to a Table
    08:44
  • Insert Without Specifying Column Names
    09:10
  • UPDATE a Record's Field Values
    07:12
  • DELETE a Table's Record
    06:08
  • SQL Data Types Revised
    12:34
  • Bookstore Data Set: Let's Move It to Database
    03:51
  • Create Your First Table!
    08:19
  • Insert Data to Your New Table
    07:31
  • Change Column Data Type
    07:11

Instructor
Data Engineer
Sameh Sharaf
  • 4.4 Instructor Rating
  • 876 Reviews
  • 23,135 Students
  • 3 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.