Главная
Study mode:
on
1
- Intro to SQL
2
- Download Postgres
3
- Data Structure
4
- Inserting Data
5
- Selecting Data
6
- Deleting Data
7
- Primary Key Constraint
8
- Filtering Data
9
- AND, OR, NOT
10
- Ordering/Sorting Data
11
- Challenge 1
12
- Relationships
13
- Foreign Keys
14
- Bridge/Join Table
15
- Inner Joins
16
- Right, Left, Outer Joins
17
- Many to Many Joins
18
- Group By
19
- Unions
20
- Challenge 2
21
- Subqueries
22
- Datatypes
23
- Altering a Table
Description:
Dive into a comprehensive 4-hour crash course on raw SQL for beginners. Learn essential database concepts and SQL fundamentals, starting with an introduction to SQL and Postgres installation. Master data structures, CRUD operations, and constraints. Explore advanced topics like data filtering, sorting, and various types of joins. Practice your skills with coding challenges. Delve into relationships, foreign keys, and bridge tables. Understand group by operations, unions, and subqueries. Familiarize yourself with different datatypes and table alterations. Access supplementary resources including a GitHub repository, Postgres download link, and recommended SQL tools like Postico and PopSQL to enhance your learning experience.

SQL Crash Course - Learn Raw SQL for Beginners

Laith Academy
Add to list
0:00 / 0:00