Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Data Analysis
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin Mobile App Development SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Personal Development Neuro-Linguistic Programming Personal Transformation Life Purpose Mindfulness Sound Therapy CBT Cognitive Behavioral Therapy Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Leadership
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing Startup YouTube Marketing

DevelopmentDatabase Design & DevelopmentPostgreSQL

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

Learn about Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions...
Bestseller
Rating: 4.5 out of 54.5 (997 ratings)
8,753 students
Created by Adnan Waheed
Last updated 3/2022
English
English [Auto]

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

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

Description

Subqueries? Yes, Recursive CTEs? Yes, Server programming with SQL and PL/pgSQL, Stored Procedures? Yes, Window Functions? Yes indeed and much more...

I've design this course from step-by-step move from basic to advanced topics. Here is a partial list of some of the topics that are covered in 50+ sections and 60+ hours of this course:

  • Apply powerful SQL commands to store, update and retrieve information

  • Step-by-step walkthrough to perform simple to complex SQL queries

  • How to create a database from the scratch, Creating and modifying tables

  • Using UPSERT for INSERT and UPDATE at the same time

  • Query data with ORDER BY, Logical operators, and filters

  • Understand PostgreSQL various data types with examples

  • Data type conversions with CAST, and conversion functions

  • Create your own user-defined data types

  • Explore table and column constraints, create multiple composite constraints, see data integrity operations

  • Create your own custom sequences

  • Parsing data with queries using string functions

  • Aggregate data with aggregate functions

  • Date/Time data types, Intervals, and handling timezones

  • Grouping Data with GROUP BY, conditional filter with HAVING

  • Joining Multiple Tables with various joins techniques

  • Combining Queries together with UNION, INTERSECT, and EXCEPT

  • Understand and create PostgreSQL Schemas, ownership, security privileges

  • Constructing arrays and ranges, query array data with conditional filters

  • Storing data with JSONB objects and Indexing

  • Query performance optimization with indexes, understanding indexes nodes and outputs

  • Create and update regular and materialize views

  • Simple to advances step-by-step Subqueries

  • Creating Common Table Expressions (CTEs), and recursive CTEs queries

  • Making data into group sets

  • Simple to advanced Windows Functions

  • Using regular expressions for text patterns

  • Powerful text searches in PostgreSQL

  • Create and exploring table partitioning techniques

  • Server programming with SQL and PL/pqSQL

  • Creating Stores Procedures

  • Extending PostgreSQL echosystem with custom indexes, and aggregate functions

  • Creating, and executing Triggers

  • Using Cursors

  • pqsql Utility Commands

  • Creating Crosstab reports

  • Making our database for storing global language data - Internationalization

  • Running queries with PostgreSQL transactions

  • Crating, and Managing PostgreSQL Security

  • All about PostgreSQL internals on how data gets stored and much more

  • Running hundreds of queries on sample databases like HR, Northwind, Stock Markets, Word Trades database

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. Sign up today and master PostgreSQL!

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

Instructor

Adnan Waheed
Founder KlickAnalytics and ex-Bloomberg employee
Adnan Waheed
  • 4.6 Instructor Rating
  • 1,070 Reviews
  • 9,714 Students
  • 3 Courses

Hello Everyone,

I am an entrepreneur, a deliverer, a dreamer, a believer, a darer and a doer.

I had worked in Bloomberg for 17 years, and build, manage, and lead several projects and team on global basis. After Bloomberg, had build my own companies like KlickAnalytics, ClickAPIs, ZoomMarkets providing global financial markets analytics with tera bytes data on cloud servers.

I've worked extensively with PHP, Python, Angular, Rest APIs, Cloud systems, time series database, financial data analytics, UNIX systems, MongoDB, PostgreSQL, and advanced system architecture design and more.

My utmost passion is the invention, innovation, changing paradigms, game-changing disruptions, people, personal development and the true adventures of life. Master the getting the job done well.


My Motto: Change the Game!

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.