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.
Návrh Školení
Introduction to Relational Databases and PostgreSQL
- What is a relational database
- Overview of PostgreSQL and its ecosystem
- Use cases and advantages of PostgreSQL
Installing and Configuring PostgreSQL and PGAdmin
- Installing PostgreSQL on Windows/Linux
- Installing and using PGAdmin for GUI access
- Creating connections and managing users
Understanding PostgreSQL Architecture
- PostgreSQL server components and memory usage
- Database cluster structure and file layout
- Processes and services
Creating and Structuring Databases
- Creating databases and tables
- Understanding data types
- Using PGAdmin to manage database objects
Writing Basic SQL Queries
- Using SELECT, WHERE, ORDER BY, LIKE, BETWEEN, and NULL
- Sorting and filtering query results
Using GROUP BY and HAVING
- Grouping rows and calculating aggregates
- Filtering groups with HAVING
Working with Complex Conditions
- Using EXISTS, IN, ANY, ALL
- Nesting subqueries
JOIN Operations in PostgreSQL
- INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
- SELF JOIN and use cases
Using Built-in SQL Functions
- Mathematical functions
- String manipulation functions
- Date and time operations
Data Manipulation Statements
- INSERT: inserting new rows
- UPDATE: modifying existing data
- DELETE: removing rows from tables
Working with Views
- Creating and querying simple views
- Views with subselects
- Benefits and limitations of views
Introduction to the Timescale Extension
- What is TimescaleDB and when to use it
- Installing and enabling Timescale extension
- Creating hypertables and inserting time-series data
Summary and Next Steps
Požadavky
- Pochopení základních IT a datových pojmů
- Není vyžadován žádný předchozí zkušenost s SQL nebo databázemi
- Známost používání software na Windows/Linux je užitečná
Cílová skupina
- Žáci a analytici Database
- Vývojáři začínající s PostgreSQL
- Odborníci spravující nebo zkoumající relační databáze
14 hodiny
Reference (5)
Do konce prvního dne navrhl jedna účastnice více interakce v praktických cvičeních a přednosta tento návrh zahrnil do druhého dne kurzu.
Daniela - Unit4
Kurz - PostgreSQL 16 for Developers and Administrators
Machine Translated
Faktický a praktický přístup k tématu. Příjemná atmosféra, která podporuje zadávání otázek.
Marcin - Santander Bank Polska S.A.
Kurz - Implementing High Availability in PostgreSQL
Machine Translated
Andres důsledně zajišťuje, že odpovídá na všechny otázky účastníků a snaží se zajistit, aby každý pochopil jeho učení. Obdivuji jeho odbornost a zručnost v dané problematice
Ryan - Questronix Corporation
Kurz - PostgreSQL for Administrators - 3 Days
Machine Translated
Ahmed has been very cooperative and knowledgeable about the subject and throughout been a good and productive training session covering some basic and important topics on Postgres.
Imran Sadiq Bhat
Kurz - PostgreSQL Essentials
It was clearly tailored to be very appropriate to our purpose which made it extra helpful. I really liked the zoom format as it helped me focus with the material right in front of you all the time and the trainer able to add illustrations and markings on to it as he explained. The trainer answered all our questions in a very satisfying way and I felt surprised at how much I was able to learn in one day. Usually i get tired of training by the afternoon but this was very engaging right through to the end. Pace was perfect and detail went into the right areas.
