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

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/

Hau Van Vo
Hau Van Vo
freetutsdownload.com

Hello everyone, my name is Hau Vu, my nickname is Hau Van Vo. I created this blog to share with everyone the courses on different platforms My motto is "No pain, no gain"

Related Posts
4 Comments
Becky

Can you make also make it available for us on Google drive because Google drive allows conversion.. Thanks

Zenith

Create a Mega account and import the files there. It’s very easy to download from your account that way.

Some1

Hello
Mega link is down
Please update
Thanks

Comments are closed.