Description
Complete Intro to SQL & PostgreSQL, the comprehensive SQL and PostgreSQL training course is published by Frontend Masters Academy. SQL is a timeless skill and you will find it in almost every modern application. Using the popular PostgreSQL database, you can learn to set up, model, and query your data through real projects. You will also learn how to model complex relationships in your data and query data from large datasets. The course instructor provides tips on the course website and explains how the course is designed for developers who want to learn how to use SQL and PostgreSQL.
What you will learn
- Databases and tables
- SQL commands
- Joins and Constraints
- JSONB
- aggregation
- Activities and Procedures
- Movie database
- Quiz performance
- Transactions Window and Self Join functions
Details of the Complete Intro to SQL & PostgreSQL course
- Publisher: Frontend Masters
- teacher : Brian Holt
- English language
- Education level: all levels
- Number of courses: 53
- Training duration: 7 hours and 20 minutes
The chapters of the Complete Intro to SQL & PostgreSQL course
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
Pictures
Sample video
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 1440p
download link
File(s) password: www.downloadly.ir
Size
2.95 GB