SQL & PostgreSQL for Beginners

Learn about Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions...

Created by: Adnan Waheed
Founder KlickAnalytics and ex-Bloomberg employee

What Will I 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

Target audience

• 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