PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours
Learn about Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions...
4.55 (4320 reviews)
33,674
students
67.5 hours
content
Oct 2023
last update
$89.99
regular price
What you will learn
Learn with 60+ hours of hands-on practical exercises
Step-by-step walkthrough to perform simple to complex SQL queries
Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions, and much more
How to create a database from scratch
Creating and using various Data types
Creating User-defined data types
Table and Column constraints
Understanding, Using, and creating custom Sequences
String Functions
Aggregate Functions
Date/Time Functions with query analysis
Grouping data with group sets
Schemas creations and privileges
Table Partitioning techniques
Exploring Array Functions
In-depth JSON data types and queries
Subqueries
Common Table Expressions (CTEs)
Recursive Common Table Expressions
Advanced Window Functions
Server Programming
Functions with SQL Language
Functions with PL/pgSQL Language
Exploring Stored Procedures
Indexes and queries performance optimizations
Multiple Data Views types and Security
Using Regular Expressions for Text Patterns
Power Text Searches with special data types and indexes
Crosstab Reports with crosstab extensions
Making our database for global languages - Internationalization
psql Utility Commands
Understanding PostgreSQL Internals
Triggers
Using Cursors
Data integrity with Transactions and Savepoints
Managing PostgreSQL security
Extended PostgreSQL echosystem
Analyze sample HR, Stocks, Northwind, Global Trades databases
Practice with huge number of queries
Use SQL to perform data analysis
Confident putting SQL and PostgreSQL on your resume
Screenshots
Related Topics
3499600
udemy ID
9/14/2020
course created date
1/18/2021
course indexed date
Bot
course submited by