Udemy: PostgreSQL Bootcamp : Go From Beginner to Advanced

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

  • 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


Apply for this course