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

Course Name : PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours
Students : 30,493
Duration : 67 hrs & 31 downloadable resources
Avg Rating : 4.5 (3,826 ratings)
Original Price : $119.99
Discount Price : $15
Instructor / Provider : Udemy
Course Type : Self Paced Online Course. Lifetime Access
Coupon : Click on ENROLL NOW to apply discount code

Key Topics Covered

1. Foundations of SQL and PostgreSQL:
   • Database creation and table design.
   • Data types, including user-defined types.
   • Table constraints and sequences.
   • Data type conversions with CAST and conversion functions.
2. Querying and Analyzing Data:
   • Query data with filters, logical operators, and ORDER BY.
   • Aggregate, string, and date/time functions.
   • GROUP BY, HAVING, and advanced JOIN techniques.
   • Combine queries using UNION, INTERSECT, and EXCEPT.
3. Advanced PostgreSQL Features:
   • Work with JSON/JSONB objects and indexed queries.
   • Array functions, conditional filters, and ranges.
   • Create materialized views and optimize query performance.
   • Explore schemas, privileges, and security settings.
4. Advanced Query Techniques:
   • Subqueries and advanced Common Table Expressions (CTEs).
   • Window functions and grouping sets.
   • Crosstab reports and text pattern searches with regular expressions.
5. PostgreSQL Development:
   • Write server-side functions using SQL and PL/pgSQL.
   • Create stored procedures, triggers, and custom aggregate functions.
   • Use partitioning techniques for large datasets.
6. PostgreSQL Utilities and Internals:
   • Manage data with transactions, savepoints, and psql commands.
   • Understand PostgreSQL internals, including how data is stored and indexed.
7. Sample Projects and Applications:
   • Work with real-world databases like HR, Northwind, Stock Markets, and Global Trade datasets.
   • Execute hundreds of queries to analyze data and solve business problems.

You’ll Learn How to

• Master SQL with 60+ Hours of Hands-On Exercises: Develop confidence with practical step-by-step exercises from basic to advanced SQL queries.
• Build and Manage Databases from Scratch: Learn how to create databases, design tables, and manage data efficiently.
• Work with Advanced SQL Features: Master subqueries, Common Table Expressions (CTEs), recursive CTEs, triggers, cursors, partitions, and more.
• Optimize Query Performance: Leverage indexes, analyze query plans, and enhance performance with advanced optimization techniques.
• Handle Complex Data: Explore PostgreSQL-specific features like JSON/JSONB, arrays, and range queries.
• Create Powerful SQL Reports: Use advanced tools like crosstab reports, window functions, and grouping sets for professional data analysis.
• Extend Your SQL Skills: Dive into server-side programming with SQL and PL/pgSQL, stored procedures, and triggers.
• Enhance Security and Integrity: Manage schemas, privileges, transactions, savepoints, and data integrity operations.
• Internationalization: Build databases that support global languages and time zones.
• Master PostgreSQL Internals: Understand how PostgreSQL stores and processes data for better optimization.
• Confidently Add SQL to Your Resume: Gain expertise to tackle real-world challenges and showcase PostgreSQL proficiency.

FAQs on Udemy Coupon