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

4
36
PostgreSQL Bootcamp Go From Beginner to Advanced, 60+hours

PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours Free Download. Learn about Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions…

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

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

Ignace Aleya – Next Level Editing Expert Masterclass

What you’ll 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

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

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

Mega

Content From: https://www.udemy.com/course/postgresqlmasterclass/

4 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here