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

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

Subqueries? Yes, Recursive CTEs? Yes, Server programming with SQL and PL/pgSQL, Stored Procedures? Yes, Window Functions? Yes indeed and much more...

I've design this course from step-by-step move from basic to advanced topics. Here is a partial list of some of the topics that are covered in 50+ sections and 60+ hours of this course:

• Apply powerful SQL commands to store, update and retrieve information

• Step-by-step walkthrough to perform simple to complex SQL queries

• How to create a database from the scratch, Creating and modifying tables

• Using UPSERT for INSERT and UPDATE at the same time

• Query data with ORDER BY, Logical operators, and filters

• Understand PostgreSQL various data types with examples

• Data type conversions with CAST, and conversion functions

• Create your own user-defined data types

• Explore table and column constraints, create multiple composite constraints, see data integrity operations

• Create your own custom sequences

• Parsing data with queries using string functions

• Aggregate data with aggregate functions

• Date/Time data types, Intervals, and handling timezones

• Grouping Data with GROUP BY, conditional filter with HAVING

• Joining Multiple Tables with various joins techniques

• Combining Queries together with UNION, INTERSECT, and EXCEPT

• Understand and create PostgreSQL Schemas, ownership, security privileges

• Constructing arrays and ranges, query array data with conditional filters

• Storing data with JSONB objects and Indexing

• Query performance optimization with indexes, understanding indexes nodes and outputs

• Create and update regular and materialize views

• Simple to advances step-by-step Subqueries

• Creating Common Table Expressions (CTEs), and recursive CTEs queries

• Making data into group sets

• Simple to advanced Windows Functions

• Using regular expressions for text patterns

• Powerful text searches in PostgreSQL

• Create and exploring table partitioning techniques

• Server programming with SQL and PL/pqSQL

• Creating Stores Procedures

• Extending PostgreSQL echosystem with custom indexes, and aggregate functions

• Creating, and executing Triggers

• Using Cursors

• pqsql Utility Commands

• Creating Crosstab reports

• Making our database for storing global language data - Internationalization

• Running queries with PostgreSQL transactions

• Crating, and Managing PostgreSQL Security

• All about PostgreSQL internals on how data gets stored and much more

• Running hundreds of queries on sample databases like HR, Northwind, Stock Markets, Word Trades database

This comprehensive course will teach you everything about PostgreSQL to use in your next big project!

Master the PostgreSQL database, and see how to apply it with real world database and queries. Sign up today and master PostgreSQL!

Learn about Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions...

Url: View Details

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

Rating: 4.5197

Level: All Levels

Duration: 67.5 hours

Instructor: Adnan Waheed