Frontend Masters – Complete Intro to SQL & PostgreSQL 2023-1

Frontend Masters – Complete Intro to SQL & PostgreSQL 2023-1 Downloadly IRSpace

Apr 17, 2025 - 11:28 Updated: Apr 20, 2025 - 21:31

0 0

Frontend Masters – Complete Intro to SQL & PostgreSQL 2023-1

Complete Intro to SQL & PostgreSQL, SQL is a timeless skillset you’ll find in nearly every modern application! Using the popular PostgreSQL database, you’ll learn to set up, model, and query your data through real-world projects. You’ll also understand how to model complex relationships in your data and query data from large datasets. teacher walks through the course website and explains how this course is designed for developers who want to know how to use SQL and PostgreSQL.

What you’ll learn

Databases and Tables
SQL Commands
Joins and Constraints
Query Performance
Transactions, Window Functions, and Self Join

Specificatoin of Complete Intro to SQL & PostgreSQL

Publisher : Frontend Masters
Teacher : Brian Holt
Language : English
Level : All Levels
Number of Course : 53
Duration : 7 hours and 20 minutes

Content of Complete Intro to SQL & PostgreSQL

1. Introduction
2. Databases and Tables
3. SQL Commands
4. Joins and Constraints
5. JSONB
6. Aggregation
7. Functions Triggers and Procedures
8. The Movie Database
9. Query Performance
10. Views, Subqueries & Arrays
11. Transactions, Window Functions, and Self Join
12. Wrapping Up