“PostrgreSQL Training - basic course” will allow you to understand the role of SQL language in operating databases. During the course, you will learn to formulate precise queries so that you will be able to extract exactly the information you need. Want to learn data analysis from scratch? Sign up for our course!
After completing the training, the participant will acquire knowledge about the principles of functioning of a relational database, its components and the correlations between them. They will understand the role of the SQL language in users' interaction with the database, especially in extracting the desired information from the repository. Furthermore, through practical exercises, the user will gain the ability to formulate various types of queries of varying complexity and apply them appropriately to a specific situation. They will be able to edit data in the database and use transactions to process the data safely and consolidate the results.
After the course, the participant will be able to:
The training is designed for people who use databases as a source of information when constructing a variety of reports, analyzing data and developing applications.
The participants of the training are required to have basic knowledge of MS Windows environment.
2 days, 16 training hours
The training is conducted in the form of consecutive training sessions divided into modules. Within a training module there is a theoretical part explaining a given issue, collectively and independently solved by the participant exercise and a block of questions and answers.
Presentation of the objectives and scope of the training
Licensing principles - open source
Features distinguishing PostgreSQL from other database servers
Basics of the relational model of data organization
Concept of a database server
SQL language - selecting the data
Overlay software for performing queries
Creating simple queries
Using functions in queries
Single line functions
Filtering on aggregation results
Selecting data from multiple tables
Bulk operations on query results
Multiple times nested subqueries
Data Manipulation Language (DML)
DML operations based on query results
Repetition of material on key operations in SQL
Additional questions from participants
He has several years of teaching and training experience, the main area of training specialization is the application and administration of the Oracle database. He also teaches PostreSQL, MySQL and SQL syntax in MS SQL Server databases.
+48 12 687 78 11
+48 608 646 465