Learn SQL Using PostgreSQL: From Zero to Hero
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Master PostgreSQL starting with basics to advanced features like triggers, PL/pgSQL functions, Window Functions and CTEDescription
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
Requirements
- Requirements
- Basic computer skills.
- Ability to install software on system.
- Computer that can run PostgreSQL ( I will show you how to install ).
Knowledge
- Perform sophisticated queries
- Join tables together
- Use Group By to answer questions on aggregated date
- Create and modifying tables
- Create indexes to improve search speed
- Put in constraints to keep data clean
- Use pgAdmin tool
- Learn recursive queries
- How views make accessing data simpler
- Subqueries
- Sequences to auto increment fields
- Common Table Expressions
- Conditional Expressions
- Window Functions
- How to handle date and time data
- SQL Functions
- Transactions and Concurrency Control
- PL/pgSQL Functions
- Triggers
- Composite Data Types
- Array Data Types
Will Bunker
4.5 Raiting
Apache Spark 2.0 with Java -Learn Spark from a Big Data Guru
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Learn analyzing large data sets with Apache Spark by 10+ hands-on examples. Take your big data skills to the next level....
Learn SQL Using PostgreSQL: From Zero to Hero
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Master PostgreSQL starting with basics to advanced features like triggers, PL/pgSQL functions, Window Functions and CTE Learning SQL was one of the most valuable skills I learned while building Match....
Mastering Data Analysis in Excel
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Unlock the power of Excel to utilize its analytical tools from Vlookup to Pivot Table - no matter your experience level...
Apache Spark Streaming with Python and PySpark
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Add Spark Streaming to your Data Science and Machine Learning Python Projects What is this course about? What will you learn from this Apache Spark streaming cour?...
