Organization of activities
Classes in the study in the extramural mode are held once or twice a month on Saturdays and Sundays.
The study program covers two semesters (206 hours).
Classes are conducted in Polish.
Conditions for passing
To obtain a postgraduate diploma, you need to pass 5 subjects from the pool of available subjects. Each subject requires passing exercises and passing
an exam. There are no projects and their defenses at the end of the course of study. Minor IT projects are organized as part of the subjects taught.
Study program
- Relational model of databases
- Startup environments for database applications
- Simple SQL queries
- Selecting data from several tables
- Grouping queries
- Sub-questions
- Correlated subquestions
- DML - modification of database content (INSERT, UPDATE and DELETE).
- DDL - defining the database schema
- Declarative cohesion ties
- SQL extensions in specific systems: SQLServer (Transact-SQL), Oracle (PL/SQL)
- Building information systems
- Conducting project work
- MSF Methodology
- Database design - entity relationship diagrams (MS Visio)
- Data modeling
- Database design. Functional relationships. Normalization and normal forms
- CASE Tools. Oracle Designer presentation
- Object-oriented data modeling. Diagrams of types and object-oriented tables
- Object-oriented modeling and design: class diagrams, system use case diagrams, Unified Modeling Language (UML)
- Installation and system architecture
- Physical organization of data on disks
- Server performance, database tuning
- Transaction management
- Server security, permissions
- Database backups (backup)
- Disaster recovery of databases
- Automation of activities in the database
- Server monitoring
- Distributed databases (replication, mirroring, log shipping)
- Administration scripts
- Introduction to Integration Services
- The importance and use of data warehouses
- Fundamentals of data warehouse architecture
- Integration of source data
- Creating a conceptual model of a data warehouse
- Logical models of data warehouses
- Data refresh issues
- Multidimensional data models, OLAP operations
- Supporting data mining tasks
- Data warehouse quality factors and their evaluation
- The use of data warehousing in CRM applications
- .NET Platform
- C# programming language
- Basics of object-oriented programming in C#
- Basics of console application development
- Basics of web and desktop application development
- Communication with the database
- Good programming practices
Meeting with managers of postgraduate programs
No one will tell you more about the studies offered by Centre for Postgraduate Studies than those who created them. We invite you to watch and listen to the interviews with the managers of the postgraduate and MBA programs (including the head of CKP Ms. Marta Godzisz), conducted by Ms. Aleksandra Szyr.
