Description
PostgreSQL Bootcamp: Go From Beginner to Advanced, 60+hours PostgreSQL Bootcamp: Go From Beginner to Advanced, published by Udemy Academy. I have designed this course step by step from basic topics to advanced topics. This comprehensive course will teach you everything you need to know about PostgreSQL for your next big project. Master the PostgreSQL database and see how to apply your knowledge to real projects.
What you will learn
- Learning with 60 hours of hands-on practice
- Step-by-step practice for performing simple to complex SQL queries
- subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions
- How to create a database from scratch
- Creating and using data types
- Create user-defined data types
- Table and column constraints
- Understand, use and create custom arrangements
- String functions
- Aggregate functions
- Date and time functions with query analysis
- Group data with group sets
- Creating Schemas and privileges
- Table partitioning techniques
- Check array functions
- JSON in-app data types and queries
- Subqueries
- Common table expressions (CTES)
- Common expressions of the recursive table
- Advanced Window functions
- Server programming
- Functions with SQL language
- Functions with PL/pgSQL language
- Check Stored Procedures
- Indexes and query performance optimization
- Multiple data types and security
- Using Regular Expressions for text patterns
- Text search with specific data types and indexes
- Crosstab reports with the Crosstab extension
- Creating a database for international languages
- Psql utility commands
- Getting to know the internals of PostgreSQL
- Triggers
- Using Cursors
- Data integrity with Transactions and save points
- PostgreSQL security management
- Extending the PostgreSQL ecosystem
- Analysis of sample databases of HR, stock market, world trade
- Practice with a large number of queries
- Using SQL to perform data analysis
- Feel free to put SQL and PostgreSQL on your resume
Who is this course suitable for?
- A complete introduction to the database world for beginners
- Anyone who wants to learn SQL or PostgreSQL
- Anyone who wants to learn advanced query expressions
- Software engineers looking to expand their backend skills
- Anyone who wants to learn basic to advanced features of PostgreSQL
PostgreSQL Bootcamp course specifications: Go From Beginner to Advanced, 60+ hours
- Publisher: Udemy
- teacher : Adnan Waheed
- English language
- Education level: all levels
- Number of courses: 627
- Training duration: 67 hours and 18 minutes
At the beginning of the course chapters on 11/2022
Course prerequisites
-
No pre-knowledge is required: I’ll teach you absolutely everything you need to know!
-
A computer is required, but anything 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 video
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
download link
File(s) password: www.downloadly.ir
Size
10 GB
Be the first to comment