Главная
Study mode:
on
1
Introduction
2
Installing Postgres
3
Connecting to Postgres
4
Creating a new database
5
Running the query
6
Creating a table
7
Constraints
8
Alter Table
9
Null Columns
10
Update
11
Create another table
12
Insert data
13
Add second post
14
Add third post
15
Where clause
16
Join multiple tables
17
Favorites
Description:
Learn SQL by designing a database schema for a social media website using PostgreSQL. Master essential SQL concepts while gaining practical skills to create databases for personal projects. Follow along as the tutorial covers installation, database creation, table design, constraints, data manipulation, and complex queries. Explore topics like altering tables, handling null columns, inserting and updating data, using WHERE clauses, and joining multiple tables. Access provided code and additional resources to enhance your learning experience and apply newfound knowledge to real-world scenarios.

SQL Tutorial for Beginners

Ben Awad
Add to list