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. Overview of Relational Databases
- Defining the concept of a relational database.
- Examining PostgreSQL’s architecture and key components.
- Introduction to PgAdmin and psql utilities.
- Establishing database connections and comprehending schema structures.
2. Core SQL Concepts
- Exploring database objects: tables, columns, and constraints.
- Understanding data types and the handling of NULL values.
- Constructing basic SELECT queries.
- Applying filters using WHERE clauses, pattern matching, and logical operators.
- Ordering and restricting query outcomes.
3. Utilizing Functions and Expressions
- Working with arithmetic and string manipulation functions.
- Implementing conditional logic and case statements.
- Managing NULL values and performing data type conversions.
4. Data Combination and Filtering Techniques
- Utilizing inner and outer joins, self-joins, and cross joins.
- Applying set operations: UNION, INTERSECT, and EXCEPT.
- Employing subqueries: scalar, correlated, and table-based.
- Using Common Table Expressions (CTEs) and recursive queries.
5. Data Aggregation and Grouping
- Leveraging aggregate functions: SUM, AVG, COUNT, MIN, MAX.
- Structuring data with GROUP BY and HAVING clauses.
- Applying window and ranking functions.
6. Data Modification
- Performing record insertion, updates, and deletions.
- Managing transactions and utilizing rollback mechanisms.
- Grasping ACID principles for data integrity.
- Adopting best practices for safe data manipulation.
7. Database Objects and Logical Organization
- Building and maintaining schemas and tables.
- Defining primary keys, foreign keys, and unique constraints.
- Creating and managing standard and materialized views.
- Introduction to indexing and its impact on performance.
Requirements
- A fundamental grasp of general IT and data concepts.
- No previous experience with SQL or database management is necessary.
- Basic familiarity with software tools on Windows or Linux platforms is advantageous.
Target Audience
- Individuals new to database technology and data analysts.
- Developers beginning their journey with PostgreSQL.
- Professionals responsible for managing or investigating 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 :)