SQL for Newcomers - A Crash Course

Name: SQL for Newcomers - A Crash Course
Rating: 4.2 (633 reviews)

A course optimized to master SQL quickly

Created bySameh Sharaf

Last updated 8/2022

English

What you'll learn

Prepare your machine to run SQL
Able to select & filter data
Sort and group data preparing for reports
Learn about functions in SQL

Course content

6 sections • 31 lectures • 1h 57m total length

Introduction1:15
Tools Used in this Course1:00

Download PostgreSQL2:07
Install PostgreSQL2:33
Install PostgreSQL on your local machine by accepting the default directory and data folder, set a strong superuser password, note port 5432, uncheck stack builder, and finish installation.
Download SQLectron1:31
Install SQLectron0:33
Install SQLectron, launch the downloaded tool, and wait for the installation to finish. Then learn how to connect to the database.
Connect to PostgreSQL - Credentials1:18
Connect to PostgreSQL Using SQLectron1:33
Connect to PostgreSQL using SQLectron by configuring a new connection with localhost and port 5432, a superuser, and the installed password, then test and save to start the course.
Import Course Data Using SQLectron2:20
Import course data using SQLectron by downloading the data file and running scripts to build the database, tables, and seed data. Refresh the public schema to reveal departments and employees.
FOR WINDOWS 32-BIT USERS: SQL Alternative - DBeaver0:30
FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data7:51
For Windows 32-bit users, download and install The Beaver community edition, configure the PostgreSQL connection, download the sample dataset, and run queries like select star from employees to verify data.

Check Imported Data5:42
So.. What is a Database?1:20
Understand what a database is and how tables organize data, including relational and tabular structures. See how sql enables access, updates, and querying within an rdbms.
SQL Data Types1:46
Finally Some Fun! Extracting Data Based on Requirements0:51
Filtering Data Using WHERE Keyword8:28
Learn to filter the employees table with the where clause. Filter on base_salary using greater than, greater than or equal to, not equal to, and less than.
Filter Data by Range Using BETWEEN2:42
Filter Data by Set of Values Using IN3:15
learn how to filter data by a set of values using the in keyword in SQL, applying to base salary values like 1600, 2700, and 4200.
Filter Data by Strings (Names, addresses, ...)4:15

Give Your Report Fields A Cool Name4:10
Order Records by Column6:22
Learn to order query results with the order by clause, sorting by any column or expression in ascending or descending order, and handle aliases with spaces using quotes or brackets.
Order Records by Multiple Columns12:07
Learn how to sort query results by multiple columns in SQL, using ascending and descending orders, with examples on job title, full name, salary, and hire date.
LIMIT Record Count Fetched by Your Query7:56

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

"Wow! I really regret learning SQL"

- No one ever

Hi!

I'm Sameh Sharaf. I am a data engineer. I work 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, 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?

Of course! This course was done for beginners. Even students with some experience in SQL may find it useful as well, 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.

This course was great, but I want to learn more. What should I do?

Fret not! I have the full SQL course ready for you. It has over 11 HOURS of goodies. Look for: "SQL for newcomers: The Mastery Course"

Psst.. Can I get a discount for your awesome Mastery course??

Send me a message and I will give you a $9.99 coupon! How cool is that!

Enjoy the course and happy learning!

Who this course is for:

Students aspiring to become data analysts, scientists or engineers
Junior developers who need to work on relational databases.
Junior data analysts and scientists.
Undergraduate students who study relational databases in their curriculum.
Anyone who's interested to learn SQL and add it to their resume.

SQL for Newcomers - A Crash Course

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 2min

Setting Up Course Tools9 lectures • 20min

Browsing & Filtering Data8 lectures • 28min

Tidy Up Your Results: Sorting, Alias Names, Limit Records4 lectures • 31min

NULL & DISTINCT7 lectures • 35min

Epilogue1 lecture • 1min

Requirements

Description

Who this course is for: