A quick entrance into PostgreSQL – Course in English

The basic seminar introduces you to the world of database queries from the open source programme PostgreSQL. You will learn what a relational database concept is, how to edit data in tables and how to create and modify database objects. Link multiple tables in a query using joins to compile the required data. Control privileges at the object and system level and modify existing schema objects for which you retrieve metadata and create reports using dictionary views. Become familiar with date and other time functions and regular expression support in SQL. We show you the PgAdmin development tool for creating queries and administering databases.

Contents:

• Introduction to PostgreSQL Database
• Retrieving data with the SELECT statement
• Restricting and sorting data (WHERE / ORDER BY)
• Customising output with single row functions
• Conversion functions and conditional expressions
• Reporting with aggregated data using group functions
• Displaying data from multiple tables (JOINS)
• Solving queries with subqueries and CTE (WITH)
• Set operators
• Data manipulation (Data Manipulation Language)
• Creating and managing tables using DDL statements
• Creating additional schema objects
• User access control
• Schema object management
• Object management with data dictionary views
• Handling large amounts of data
• Data management in different time zones
• Data query with sub-queries
• Regular expression support

Target group: Beginners with little or no previous knowledge of T-SQL

Prerequisites: Basic computer skills

Duration: 2 days

Note: The seminar focuses on PostgreSQL concepts. Specific functions and syntax of other SQL dialects are not covered. It is geared towards Microsoft PostgreSQL database.

At the end of the seminar:

After the seminar, you will have developed a solid understanding of PostgreSQL. You will be familiar with the basics, be able to understand and write basic SQL queries and develop simple database applications with PostgreSQL.

How this seminar will help you: Mastering PostgreSQL can prove beneficial in enhancing career opportunities and handling challenging tasks related to database applications with PostgreSQL.

Thank you for your interest in this seminar. We wish you a lot of fun!