Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
1. Introduction to Relational Databases
- Defining Relational Databases
- PostgreSQL architecture and its key components
- Overview of PgAdmin and psql utility tools
- Establishing database connections and understanding schema structures
2. Fundamentals of SQL
- Core database objects: tables, columns, and constraints
- Data types and the handling of NULL values
- Composing basic SELECT queries
- Applying filters using WHERE clauses, pattern matching, and logical operators
- Sorting and limiting query outputs
3. Utilizing Functions and Expressions
- Arithmetic and string manipulation functions
- Conditional logic and case statements
- Managing NULLs and performing data type conversions
4. Data Combination and Filtering Techniques
- Inner and outer joins, self-joins, and cross joins
- Set operations: UNION, INTERSECT, and EXCEPT
- Subqueries: scalar, correlated, and table-based subqueries
- Common Table Expressions (CTEs) and recursive query structures
5. Aggregation and Data Grouping
- Aggregate functions: SUM, AVG, COUNT, MIN, and MAX
- Utilizing GROUP BY and HAVING clauses
- Window functions and ranking methodologies
6. Data Modification
- Inserting, updating, and removing records
- Implementing transactions and rollback mechanisms
- Understanding ACID principles in database management
- Best practices for safe data manipulation
7. Database Objects and Logical Architecture
- Creation and administration of schemas and tables
- Primary keys, foreign keys, and unique constraints
- Development and management of views and materialized views
- Introduction to indexing and its impact on performance
Requirements
- A foundational understanding of basic IT and data principles
- No prior experience with SQL or database systems is necessary
- Basic familiarity with software tools on Windows or Linux platforms is beneficial
Target Audience
- Database beginners and data analysts
- Developers initiating their journey with PostgreSQL
- Professionals responsible for managing or exploring relational database systems
Testimonials (3)
CTE and indexes. Maybe more likely to use partitioning, explain analyze and vacuum on daily-base work
Lorenzo Antonelli - Innova S.P.A
Course - PostgreSQL Fundamentals
Index understanding and usage, improvements on db performances
Matteo Baldini - Innova S.P.A
Course - PostgreSQL Fundamentals
advance topics hands on + discussion like timescaleDB and hypertable , trainer's knowledge on the subject :)
