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

Published on: 2024-12-09 16:58:08

Categories: 28

Descriptions

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

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

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

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

Sample Clip

Video Player

00:00

Use Up/Down Arrow keys to increase or decrease volume.

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.