Postgraduate Database Studies

Driven by experience and knowledge of market needs, we decided to create something more than just one more postgraduate course. Therefore, in addition to classes, we offer a number of additional benefits. This is possible thanks to the selection of lecturers from among those professionally involved in selected topics. Many of us conduct commercial trainings which, in order to meet the market requirements, are conducted at a high level, and require from the teachers constantly updated professional knowledge supported by practice. Our lecturers regularly participate in various implementations, technical assistance or IT system maintenance services. This is what distinguishes us. We are the only one of the few postgraduate studies on the market that employs certified Microsoft trainers (MCT). On the other hand, we are proud to cooperate with lecturers professionally dealing with Oracle technologies. Our studies are the first step towards obtaining MCTS, MCITP, OCA, OCP certificates. Of course, in our studies, people who hold these titles teach and can provide you with additional information on this topic.

Attractive tuition fees

We offer valuable knowledge at a competitive price; for comparison, the catalog prices of certified Microsoft or Oracle training courses are in the range of PLN 3,500 – PLN 7,700 (plus 23% VAT) per person. As part of our studies, we offer a range of material related to database programming and administration, discussed in 5 standard certified training courses, and we also present other issues. Tuition, which can be paid in two installments, is competitive not only in relation to certified training but also to other studies of a similar profile.

Lecturers’ competences

The staff of lecturers consists of specialists with extensive knowledge supported by passed exams, numerous certificates and engineering titles from Microsoft, Oracle and others. Selected classes will be conducted by certified Microsoft lecturers with extensive experience in transferring knowledge during numerous trainings, consultations and workshops.

Remote control

All teaching materials are available around the clock through our learning platform. Additionally, our students, in the case of selected subjects, have remote access to laboratory environments. In this way, people who want to repeat the tasks performed in the classroom can do it virtually at any time.

Oracle diplomas

Graduating students will receive Oracle diplomas concerning the realized scope of the material; they are evidence that the learner has successfully completed the training process.

Microsoft diplomas

Graduating students will receive Microsoft diplomas concerning the realized scope of the material; they prove that the learner has successfully completed the training process.

Free software

During their studies, our students will have access to and will be able to download original and completely legal copies of Microsoft software for use under the MSDNAA license.

Convenient class dates

We are aware that most of our students are professionally active; In order to make our classes as less troublesome as possible, they will be held entirely on Saturdays and Sundays, every 2-3 weeks. Seven weekend meetings are planned each semester.

Teaching modern technologies

the curriculum includes teaching modern technologies that are currently used in even the largest institutions and companies;

Graduation certificate

After successful graduation and payment of all fees, each student will receive a certificate of completion of Postgraduate Database Studies according to the formula of the Minister of Science and Higher Education.

Study program

The study program is selected so that both beginners and advanced people can participate in them.

Our lecturers deal professionally with the subject of studies and classes. Their knowledge and competences are supported by numerous certificates. We do not place on our website the courses attended by our lecturers because they conduct such courses. Our studies are the first step in preparation for MTA, MCSA and MCSE exams. Our lecturers, holding these certificates, can guide and provide tips and additional information on them.

Certificates:
Microsoft Certified Trainer ( MCT )

Microsoft Certified Professional ( MCP )

Microsoft Certified Technology Specialist ( MCTS ):

• SQL Server, Implementation and Maintenance
• MS Project Server, Managing Projects
• MS Exchange Server, Configuration
• Windows Vista, Configuration
• Windows 7 and Office 2010, Deployment
• MS System Center Operations Manager, Config
• Windows Server Virtualization, Configuration
• MS Business Server, Configuration
• MS Sharepoint Server, Configuration
• Windows Sharepoint Services, Configuration

Microsoft Certified IT Professional ( MCITP ):

• Database Administrator SQL Server
• Enterprise Project management with Project Server
• Enterprise Messaging Administration on MS Exchange
• Enterprise Support Technician on Windows
• Server Administrator on Windows Servers

Microsoft Certified Solution Associate ( MCSA ):

• SQL Server
• Windows NT, 7, 8, Vists
• Windows Server

Microsoft Certified System Engineer ( MCSE ):

• Security on Windows Servers
• Windows Server
• Oracle Database Administrator Certified Associate
• Oracle Cloud Platform Identity and Security Management 2018 Certified Associate
• Oracle Database Administrator Certified Proferssional

IBM eServer Certified Specialist – pSeries AIX System SupportIBM Certified Database Associate – DB2 Universal Database V8.1 Family

IBM Certified Associate – Notes and Domino

IBM Notes and Domino Sales Professional v3

OpenVMS System Administrator

The study program includes knowledge of the construction, design, programming and administration of relational databases.

In our studies, we focused on teaching the most popular database systems in the world: Oracle and SQL Server. Database systems are the core of modern IT systems, deciding to a large extent about the efficiency, possibilities and scalability, and therefore the possibilities of expanding these systems. Specialists in this field are in demand on the labor market.

The curriculum is structured in such a way that both beginners who have no preparation, as well as people who already know the systems taught, but want to organize and expand their knowledge, can participate in the studies.

Description of items.

Below we present a general list of topics covered in individual subjects. We reserve, however, that the list below is indicative and some changes may be made after detailed arrangements between the lecturers. We also try to present the current knowledge, following the changes introduced in new versions of the software: new functionalities, solutions and possibilities.

Introduction to relational databases

1. Database models
2. Elements of relational database theory
3. Basic concepts and functionalities
4. The most popular RDBMS systems

T-SQL database language

T-SQL is the database language as implemented by Microsoft; largely compliant with the SQL standard; a great starting point for learning to work with relational databases in general, not only with Microsoft products.

1. SQL Server Management Studio and SQLCMD environment
2. Basics and syntax of the SQL language
3. Simple query, formatting of results
4. Filtering data
5. Queries from multiple tables
6. Grouping and summarizing data
7. Subqueries
8. Modifying data
9. Database objects
10. Transaction management

SQL Server I and II administration

This subject covers all the most important administrative activities of this most popular relational database management system under Windows; Due to its friendly environment and ease of use, and at the same time great possibilities, it is perfect to start learning and learn about relational database management on its example.

1. Installation and configuration of SQL Server
2. Database creation
3. Creating a logical and physical database structure
4. Creation and management of database objects
5. Organization of data
6. Safety management
7. Backup, database recovery
8. High availability techniques
9. Database and server monitoring
10. Replication

PL / SQL language

The PL / SQL language is an extension of the SQL language in the Oracle implementation; enables the creation of procedures and functions in Oracle databases. We start the classes by discussing the differences in relation to the language implemented in SQL Server and specific Oracle functions.

1. Oracle SQL (differences and specific functions)
2. Introduction to PL / SQL
3. Modules and packages
4. Create named modules and functions
5. Create and manage triggers

Oracle I and II administration

Oracle is the most popular database systems in the world, used in many institutions, wherever large and efficient databases are needed; Due to the extensive possibilities and high functionality, specialists in this field are extremely valued and sought after.

1. Logical and physical structure of Oracle databases
2. Creation and management of database objects
3. Using PL / SQL to support management
4. Managing the physical structure of the database
5. Backup and recovery
6. Configuring security, permissions, and the use of system resources
7. Use of the RMAN tool

Oracle Application Express

Oracle ApEx is an environment of Rapid Application Development type, so an environment for fast, easy and pleasant creation of database web applications. It does not require advanced knowledge in the field of designing and creating databases. The creator of the application performs most of the activities, such as creating pages / screens or menus, using wizards. The popularity of this environment in the world has exceeded the expectations of Oracle. In addition, there are more and more new users and companies that deploy their applications on the APEX platform. Its possibilities are very large: from managing permissions to creating very effective charts or maps in flash technology. All this without any specialist knowledge.

• Create and manage workspaces, users and permissions
• Create and configure application settings
• Types and properties of pages
• Configure the application menu
• Dynamic elements on pages
• Working with charts and maps
• Create data import wizards
• Application development: shortcuts, help system, etc.
• Moving the application

Business Intelligence (SQL Server)

The subjects teach three applications delivered with SQL Server.
Analysis Services – an environment for creating and managing data warehouses; has implemented a number of Data Mining algorithms, such as neural networks, decision trees, etc., so you can use these technologies in a convenient and effective way during data analysis.
Reporting Services – an environment for designing, creating, managing, sharing and distributing reports; allows you to conveniently and efficiently create extremely effective reports presenting data visualizations.
Integration Services – an environment supporting ETL data transfer processes (ang: Extract – Transform – Load ). It allows you to define transfer directions, dependencies between tasks, transformations, error handling, and also allows you to monitor and define permissions; Due to the growing number of a variety of highly specialized IT systems, there is an increasing need for data exchange between different environments and institutions; The solutions discussed during the studies allow for the automation and full control of such processes.
The laboratories are planned in such a way that the students learn from the practical side to combine and ensure cooperation between individual applications.

1. Introduction to Data Warehouse (Analysis Services)
2. Basics of data warehouse architecture
3. Creating a data warehouse
4. Configuring and managing ETL techniques
5. Data warehouse management
6. Use of data mining
7. Installing and configuring reporting services
8. Creation of reports and their configuration

XML

XML (English: Extensible Markup Language ) is a standard for structured data. Allows separate definition of data, format and structure; now, a standard and basic way of data exchange between different systems; more and more data banks and institutions provide data in this format.

GIS

GIS (English: Geographic Information System ) technology for input, storage and visualization of spatial data, including geographic data; allows you to work effectively with this type of data, checking the interrelationship between points, routes and areas; due to the popularization of GPS technology and digital maps in recent years, it is extremely popular and intensively developed.

Formal requirements

Students of studies may be people who have completed higher education and have a bachelor’s, engineer’s, master’s or master’s degree in engineering. The studios have 38 places. Classes are payable and last for 2 semesters. Classes are held on an extramural basis, i.e. on Saturdays and Sundays.

Fees and deadlines

There is a possibility of paying the amount for the entire studies once or spreading the fee into two installments.

Entry fee:
PLN 400 – fee required when submitting documents

One-time fee:
5000 PLN – paid by the day the first semester starts

Payment in installments (two semester payments):
PLN 2,700 – paid by the day the first semester begins
PLN 2,700 – paid by the day of the commencement of classes in the second semester

Confirmation of payment of the entry fee should be provided during the recruitment. In the case of a one-time payment for the entire course, the confirmation should be delivered (by e-mail or in person) to the Study Secretariat before the start of the first classes. In the case of two semester fees, confirmation of the payment of each installment must be provided (by e-mail or in person) before the beginning of each semester.

Invoices will be issued only upon the student’s written request, submitted through us to the WULS-SGGW Bureau within three months from the end of the month in which the payment was made.

Bank transfer details

SGGW in Warsaw
Ul. Nowoursynowska 166
02-787 Warsaw, Poland

Bank account number:
71 1240 6003 1111 0000 4943 8060

title: 507-10-130100-S00184-99 Name and surname of the participant

Required documents

• Application for admission to studies – download: doc pdf

• Personal questionnaire – download: doc pdf

• A transcript or a copy of the university diploma certified by the university. In the case of graduating from a university abroad, the candidate submits the original of the diploma and its translation into Polish certified by an authorized institution, as well as a document confirming the recognition of the diploma or a certificate of exemption from the nostrification procedure

• Proof of payment of the registration fee.

Place for submitting documents

Documents can be sent to us by mail

From July 20, 2020, documents can be submitted in person (from 9:30 to 14:00) in the secretariat of studies. It is also possible to deliver documents outside the office hours – in this case, please contact us by phone in advance.

To reserve a place for studies, before delivering the complete set of documents, please send us a proof of payment of the registration fee to the e-mail address: baza@sggw.pl

Postgraduate Database Studies
Ul. Nowoursynowska 159
building 34, room 3 / 29A
02-776 Warsaw, Poland

If you are interested in detailed information about the studies, please contact us.
(tel: 22-59-37-350, mobile: 695-79-79-13; 601-24-31-77)

Co-financing

There is a possibility of co-financing studies for the unemployed. Co-financing can be up to 100% of the cost of studies. Detailed information and terms of funding can be found here .