Learn SQL Using PostgreSQL: From Zero to Hero
Free Coupon Discount - Master PostgreSQL starting with basics to advanced features like triggers, PL/pgSQL functions, Window Functions and CTE | Created by Will Bunker
Students also bought
Preview this Udemy Course GET COUPON CODE
Description
Learning SQL was one of the most valuable skills I learned while building Match. We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running. The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users.
I want to teach you how to use PostgreSQL. We will walk through
Basic selection statements
Joining multiple tables together
Grouping records to get aggregate data
Inserting, updating and deleting records
Creating tables and indexes
Subqueries to create sophisticated reports
Table constraints to keep data clean
Sequences to create auto incrementing fields
CTE - common table expressions that include recursive queries
Views to simply accessing complex queries
Conditional Expressions for queries
Window functions to combine regular queries with aggregate data
How to work with date, time and intervals
Create SQL Functions to capture complex statements
Create PL/pgSQL Functions that allow programming with if/then and loops
Triggers
Array data types
Composite data types
Transactions and concurrency control
Who this course is for:
Someone wanting to master PostgreSQL and SQL query language
Anyone wanting to learn advanced query expressions
100% Off Udemy Coupon . Free Udemy Courses . Online Classes
Students also bought
- The Complete Python/PostgreSQL Course 2.0
- SQL & PostgreSQL for Beginners: Become an SQL Expert
- The Complete Python & PostgreSQL Developer Course
- Spatial SQL with Postgres : A language for geographers
- Node, SQL, & PostgreSQL - Mastering Backend Web Development
Preview this Udemy Course GET COUPON CODE
Description
Learning SQL was one of the most valuable skills I learned while building Match. We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running. The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users.
I want to teach you how to use PostgreSQL. We will walk through
Basic selection statements
Joining multiple tables together
Grouping records to get aggregate data
Inserting, updating and deleting records
Creating tables and indexes
Subqueries to create sophisticated reports
Table constraints to keep data clean
Sequences to create auto incrementing fields
CTE - common table expressions that include recursive queries
Views to simply accessing complex queries
Conditional Expressions for queries
Window functions to combine regular queries with aggregate data
How to work with date, time and intervals
Create SQL Functions to capture complex statements
Create PL/pgSQL Functions that allow programming with if/then and loops
Triggers
Array data types
Composite data types
Transactions and concurrency control
Who this course is for:
Someone wanting to master PostgreSQL and SQL query language
Anyone wanting to learn advanced query expressions
100% Off Udemy Coupon . Free Udemy Courses . Online Classes
Post a Comment for "Learn SQL Using PostgreSQL: From Zero to Hero"