Program Overview

Program Overview

The PDA-DB course is a module of the professional retraining program in Data Analysis using Python. This course introduces students to the basics of databases and database management systems (DBMS), including relational models, normalization, and CRUD operations.

Course Details

• Duration: 32 academic hours, 8 sessions of 4 academic hours each.
• Level of Complexity: The course is designed to be accessible, with no prior knowledge of databases or programming required.
• Prerequisites:
  • Basic computer literacy (working with files, programs, and operating system interfaces).
  • Experience with tabular data (Excel or similar) is beneficial.
  • Understanding of logic and algorithms (conditions, cycles, variables) is helpful.
  • Familiarity with programming basics is desirable but not mandatory.

Course Content

The course covers the following topics:

Introduction to Databases and DBMS

• Concept of databases and DBMS.
• Principles of database organization.
• Main functions of DBMS.
• Database classification.
• Advantages and disadvantages of databases.
• Basic data operations (CRUD).
• Basic terms and definitions.
• Requirements for the relational database model.
• Normalization.
• Working with relational databases.
• Connection to the database.
• Naming rules.

Basics of SQL Language

• SQL language basics.
• Basic syntax of SQL.
• Main operators of the SQL language.
• Syntax of the SELECT operator.
• Logical order of query execution.
• Sorting the result set.
• Removing duplicate rows.

Practical Sessions

• Setting up a connection to the PostgreSQL DBMS.
• Familiarization with the database and development environment.
• Writing simple queries.

Advanced Topics

• Window Functions: Introduction to window functions, their types, and usage peculiarities.
• Subqueries and SET Operators: Using subqueries and SET operators (union, intersection, difference) to combine result sets.
• Data Analysis with SQL: Preparing data for analysis using SQL, writing analytical queries.

Learning Outcomes

Upon completion of the course, students will be able to:

• Interact with databases using SQL.
• Write database queries.
• Use subqueries to implement complex tasks.
• Use aggregate and window functions for data analysis.
• Know the basics of databases and DBMS, principles of database organization, main DBMS functions, and more.
• Possess skills in preparing data for analysis using SQL and writing analytical queries.

Tuition Fees

• For Individuals: 23,900 .
• For Legal Entities: 23,900 , with potential discounts based on the number of participants, contract sum, and other conditions negotiated with the client.

Discount Policy

Discounts are provided based on the number of listeners, the sum of the contract, and other conditions. The actual discount size may slightly differ due to rounding.

Additional Information

The course is part of the "Data Analysis using Python" professional retraining program. It is designed to provide a comprehensive introduction to databases and SQL, ensuring that participants gain practical skills in data analysis.