Главная
Study mode:
on
1
- Intro
2
- Quick Word Before we begin
3
- What is Database
4
- What is SQL
5
- SQL Example
6
- Postgres
7
- Install Postgres (MAC OS)
8
- Setup Postgres (MAC OS)
9
- Install Postgres (Windows
10
- PSQL (Windows)
11
- Learn SQL the right way
12
- Create Database
13
- Connecting to Databases
14
- Create Table Syntax + Datatypes
15
- Create Table Without Constraints
16
- Create Table With Constraints
17
- Insert Data
18
- Insert Into
19
- SELECT FROM
20
- Adding Data
21
- Sorting
22
- Removing Duplicates
23
- WHERE clause
24
- Comparison Operators
25
- LIMIT OFFSET and FETCH
26
- IN
27
- BETWEEN
28
- LIKE
29
- GROUP BY
30
- HAVING
31
- Car Table
32
- MIN MAX & AVG
33
- SUM
34
- Arithmetic Operators
35
- Working with Arithmetic Operators
36
- Alias
37
- Coalesce
38
- NULLIF
39
- Timestamps & Dates
40
- Adding & Subtracting Dates
41
- Extracting Fields From Dates
42
- Age Function
43
- Primary Keys
44
- Primary Keys (Part 2)
45
- Adding Primary Keys Constraints
46
- Unique Constraints
47
- Primary Keys
48
- Check Constraints
49
- Deleting Records
50
- Updating Records
51
- On Conflict Do Nothing
52
- On Conflict Do Update
53
- Foreign Keys & Relationships
54
- Adding Foreign Keys
55
- Updating Foreign Keys
56
- Inner Joins
57
- Left Joins
58
- Deleting Foreign Keys
59
- Sequences
60
- Extensions
61
- UUID
62
- UUID in Action
63
- Exporting to CSV
64
- Next steps
65
- Database Design Course
Description:
Embark on a comprehensive 4-hour SQL tutorial designed for beginners, covering essential concepts to jumpstart your journey with databases. Learn PostgreSQL fundamentals, from creating and connecting to databases to advanced topics like foreign keys and UUID implementation. Master SQL syntax, table creation, data manipulation, querying techniques, and database constraints. Explore practical examples, including working with timestamps, arithmetic operations, and joining tables. Gain hands-on experience with installation and setup processes for both Mac and Windows environments. By the end of this tutorial, you'll have a solid foundation in SQL and database management, preparing you for more advanced database design concepts.

SQL for Beginners Tutorial - Learn SQL in 4.2 Hours

Amigoscode
Add to list
#Programming #Domain-Specific Languages (DSL) #SQL #Data Science #Data Analysis #Databases #Relational Databases #PostgreSQL #Database Design #Data Manipulation #Computer Science #Database Management
0:00 / 0:00
1 of 65

- Intro