SQL For Beginners Tutorial | Learn SQL in 4.2 Hours | 2021

SQL is one of the most easy yet powerful programming languages. In SQL tutorial you will learn SQL in 4 hours and cover important SQL concepts. In this tutorial you will will learn about PostgreSQL and everything you need to know to get you started with databases.

Full SQL and Database Courses can be found below

⭐ Table Of Contents ⭐
00:00 - Intro
02:30 - Quick Word Before we begin
03:25 - What is Database
07:18 - What is SQL
08:48 - SQL Example
12:33 - Postgres
15:05 - Install Postgres (MAC OS)
18:43 - Setup Postgres (MAC OS)
22:31 - Install Postgres (Windows
25:51 - PSQL (Windows)
30:55 - Learn SQL the right way
32:18 - Create Database
35:46 - Connecting to Databases
40:24 - Create Table Syntax + Datatypes
44:36 - Create Table Without Constraints
48:12 - Create Table With Constraints
54:56 - Insert Data
58:16 - Insert Into
1:01:47 - SELECT FROM
1:04:38 - Adding Data
1:14:39 - Sorting
1:19:22 - Removing Duplicates
1:21:30 - WHERE clause
1:25:00 - Comparison Operators
1:29:06 - LIMIT OFFSET and FETCH
1:32:24 - IN
1:35:28 - BETWEEN
1:37:30 - LIKE
1:42:55 - GROUP BY
1:46:30 - HAVING
1:52:04 - Car Table
1:55:45 - MIN MAX & AVG
1:59:53 - SUM
2:02:03 - Arithmetic Operators
2:06:14 - Working with Arithmetic Operators
2:10:01 - Alias
2:12:48 - Coalesce
2:16:34 - NULLIF
2:20:39 - Timestamps & Dates
2:20:39 - Adding & Subtracting Dates
2:26:36 - Extracting Fields From Dates
2:28:27 - Age Function
2:30:11 - Primary Keys
2:32:16 - Primary Keys (Part 2)
2:37:30 - Adding Primary Keys Constraints
2:41:58 - Unique Constraints
2:30:11 - Primary Keys
2:50:00 - Check Constraints
2:55:30 - Deleting Records
3:02:25 - Updating Records
3:06:44 - On Conflict Do Nothing
3:11:57 - On Conflict Do Update
3:17:29 - Foreign Keys & Relationships
3:20:45 - Adding Foreign Keys
3:25:59 - Updating Foreign Keys
3:30:26 - Inner Joins
3:36:04 - Left Joins
3:41:49 - Deleting Foreign Keys
3:48:37 - Sequences
3:55:19 - Extensions
3:57:42 - UUID
4:04:12 - UUID in Action
4:14:47 - Exporting to CSV
4:18:02 - Next steps
4:20:00 - Database Design Course

🙊 Here are the goods for all my videos video:

► Recommended Books

Clean Code

HTTP: The Definitive Guide

Clean Architecture

► Computer and Monitor

New Apple MacBook Pro

Dell 27 INCH Ultrasharp U2719D Monitor

Double Arm Stand Desk Mount

USB C Hub Multiport Adapter

► Camera Gear

Sony ILCE7M3B Full Frame Mirrorless Camera

Sigma 16 mm F1.4 DC DN

Sigma 33B965 30 mm F1.4 DC DC

Awesome Screen Saver

IDE I use for coding
- Iterm
- VsCode
- GoLand
- IntelliJ
- Sublime

💯 You can also follow me here:

❤️ Thanks for watching

[amigoscode]

Full SQL and Database Courses can be found below

[hameedferoz]

32:00 SOLUTION: He is using Command Prompt, not SQL Shell. So, follow these steps before continuing the video. First, Open Command Prompt in your Windows, Change Disk using this command: cd C:\Program Files\PostgreSQL\15\bin (Note: This is the location where you installed Postgres. 15 is the version, can be different for you) Second Step: type: psql. It will ask for password. If the username is not Postrges, then you will get error. So, type: psql -U postgres (This will change the user to Postgres) NOw you can type: psql again and enter the password you have set while installing postgres. Please PIN this message so that others can also benefit from it.

[Harry-xrlu]

Honestly the most detailed courses out there on Youtube and with the timestamps it's a million times better because it's easier to track progress and navigate. Jazakallah khair Nelson!

[omardiop]

Hey Bro Thanks fo this detailed course. Just a little precision I would like to share. When creating person table with constraints, you did not need to add NOT NULL to the primary key column. A primary key column by definition can't be null. I have tested myself with just this syntaxe : "id BIGSERIAL PRIMARY KEY" and it's enough to make the field not nullable. Thanks Again :)

[vijaynayak]

1:21:20 DISTINCT is not removing the duplicate values, its just not showing the duplicates while using SELECT. But all the values will be present as it is in original table.

[macks]

After not using SQL and relational databases for a while, I needed a refresher. This tutorial was fantastic! Looking forward to checking out your other videos, your presentation and style really clicks with me!

[ikechukwuanene]

Thank you Nelson! Your Java for beginners and Functional Interfaces tutorials have led me this far. May Allah bless your efforts, Amen.

[worldfact-yk]

Lovely need to rewatch tomorrow thank you, may Allah bless you my friend 🙏

[katemorse]

I have done 60% of this course and everything is fantastic.

[SA_CrimeWatch]

been looking for a black dude for the entire day😭 bless you

[abubakeralsideig]

نيلسون بارك الله فيك وعظم الله اجرك و حفظك الله

[successhycenth]

how i so love coding.. I have read a lot of programming books, and I have watched a lot of your couses on youtube but no sponsor so push this my big dreams... life of a Nigerian.

[matari_ganan]

@Amigoscode, thank you for this course! just a heads up: at 2h4m33s regarding factorial, the exclamation point is no longer used. it should now be written as `select factorial(5);`

[TheBlackFemaleEngineer]

Thanks for sharing this is such a great breakdown!😁

[vitonkanne]

at 1:53:08, where MOCKaroo interface is showed. In todays time the data type 'money' used for price comes with currency symbol "$" etc. When the CREATE table query is generated and if you look at the .sql after download it is shown as VARCHAR datatype.
The reason behind mentioning all of the above is, when you do the AVG function on price at 1:57:28, since it is stored as VARCHAR along with currency symbols '$', the function fails. Therefore I had to use this query to perform the AVG function.

SELECT make, ROUND(AVG(CAST (SUBSTR(price, 2) AS NUMERIC))) FROM car GROUP BY make;

[mikhailwiseman]

if there was a mistake when typing u can "GO AHEAD" and use \edit to fix it in the editor

[anupamahalder]

Awesome videos I have learnt SQL thank you.

[BahawalTV]

Well done! I have created SQL refresher course for my mates to refresh their concepts from time to time.

[qbeetrader]

Assalamualaikum. Glad to watch your youtube SQL for beginer video. Waiting for advanced SQL/ PostgreSQL video ... :)

[sajid_qamar]

Thank you so muchh, now I don't fear command line and Sql.