PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours

PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

What you’ll learn
Learn with 60+ hours of hands-on practical exercises
Step-by-step walkthrough to perform simple to complex SQL queries
How to create a database from scratch
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
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

Requirements
No pre-knowledge is required: I’ll teach you absolutely everything you need to know!
A computer is required, but any will do. A desktop or a laptop running Mac, Windows, or Linux
All the software used in the course is free, and I’ll personally walk you through setting it all up

Description
Who this course is for:
Complete beginners to database world, Anyone wanting to learn SQL or PostgreSQL, Anyone wanting to learn advanced query expressions, Application engineers seeking to expand their backend skillset, Anyone wants to learn from basic to advanced functionality of PostgreSQL

For More Courses Visit & Bookmark Your Preferred Language Blog