Udemy – PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours 2023-10

I’ve design this course from step-by-step move from basic to advanced topics. 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

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

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

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

• Publisher : Udemy
• Teacher : Adnan Waheed
• Language : English
• Level : All levels
• Number of Course : 629
• Duration : 67 hours and 20 minutes

Content

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

Pictures

Sample Clip

Installation Guide

Extract the files and watch with your favorite player

Subtitle : English

Quality: 720p

The 2023/10 version has increased the number of lessons by 2 and the duration by 2 minutes compared to the 2022/3 version.

Download Links

Download Part 1 – 3 GB

Download Part 2 – 3 GB

Download Part 3 – 3 GB

Download Part 4 – 1.14 GB

File size

10.1 GB