English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 65 lectures (5h 17m) | 3.38 GB
Learn the most critical parts of postgresql from the ground up.
Unlock the power of PostgreSQL with a course designed by a seasoned CTO for real-world application. Skip the fluff and dive straight into the heart of what matters in day-to-day database operations.
Why This Course?
Curated content based on 15+ years of industry experience
Focus on practical skills used daily in professional settings
Efficient learning path, eliminating unnecessary complexities
What You’ll Learn:
- Robust Query Writing: Master the art of crafting efficient and powerful SQL queries
- Essential PostgreSQL Features: Explore views, triggers, and functions
- Data Manipulation: Become proficient in update, insert, and delete operations
- Database Architecture: Understand schemas and effective database design
Whether you’re a beginner starting from scratch or a professional looking to sharpen your skills, this course will elevate your PostgreSQL proficiency to new heights. Join us to gain practical knowledge that you can implement immediately.
Transform your database skills and boost your career prospects with this laser-focused, industry-driven PostgreSQL course!
Learn from real-world scenarios and hands-on exercises that simulate actual workplace challenges. Gain confidence in your ability to handle complex database tasks efficiently. By the end of this course, you’ll possess the skills that top companies seek in their database professionals, setting you apart in the competitive tech landscape.
Table of Contents
Introduction & Setup
1 Introduction
2 What a Database is & Types of Databases
3 What is SQL
4 Why Postgres
5 Setup Mac
6 Setup Windows
Tables & Data Types
7 What is a Table
8 Common Conventions
9 Data Types
10 Creating Our First Table
11 EXERCISE Creating our first table
12 EXERCISE WALKTHROUGH Creating our first table and nullable columns
Basic Operations
13 Types of Operations CRUD
14 Insert statements
15 Select statements
16 Update statements
17 Delete statements
18 Transactions
Robust Conditions
19 Setup
20 LIKE & ILIKE
21 OR statements and parenthesis
22 Alias
23 ORDER BY
24 Primary Keys and Indexes
25 EXERCISE Robust Queries
26 Data for exercise
27 EXERCISE WALKTHROUGH Robust Queries
Table Relationships
28 Why we need relationships
29 Types of Relationships
30 Entity Relationship Diagrams
31 EXERCISE Designing a Database
32 EXERCISE WALKTHROUGH Designing a Database
33 Foreign Keys
34 Leaf Land DB Setup
35 Join statements
36 Schemas
37 EXERCISE Joins
38 EXERCISE WALKTHROUGH Joins
Advanced Queries
39 Aggregates & Group By
40 Date Trunc
41 Nested Queries
42 CTES WITH Queries
43 EXERCISE Product Revenue
44 EXERCISE WALKTHROUGH Product Revenue
45 EXERCISE User Insights
46 EXERCISE WALKTHROUGH User Insights
47 EXERCISE Monthly Sales
48 EXERCISE WALKTHROUGH Monthly Sales
Advanced UpdatesInserts
49 Creating a shipping schema and table
50 Inserting from query
51 Updating from queries
Views
52 What’s a View
53 Creating a View
54 Materialized Views
Functions & Triggers
55 What is a Function
56 Creating a Discount Function
57 Using Functions
58 Triggers
59 EXERCISE Functions & Triggers
60 EXERCISE WALKTHROUGH Functions & Triggers
Closing & Some More Useful Information
61 JSONB
62 Finding queries with long execution time
63 Database Hosting
64 Datagrip
65 Thank You
Resolve the captcha to access the links!