Get in Touch
 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.

Number of participants


Price per participant (excl. VAT)

Testimonials (3)

Upcoming Courses

Related Categories