Databases
Faculty
Anastasia Lubennikova
Postgres Professional, Senior developer
Course length
Duration
Total hours
Credits
Language
Course type
Fee for single course
Fee for degree students
Skills you’ll learn
Overview
In the modern world, databases are an important component of most applications and information systems. Therefore, almost every profession in the computer science field requires knowledge and experience in interacting with such systems. Focusing on RDBMS (Relational Database Management Systems) as the most widespread and multipurpose type of systems, this course covers the essentials of SQL, database design and database administration. It provides a solid foundation for further development as SQL Developer, Data Analyst, Data Architect or Database Administrator.
Learning highlights
- Learn to work with an existing database to retrieve and manage the data. Interact with a database using SQL language and database adapters to query and manipulate data.
- Learn to model and implement a database for real business needs. Understand the concepts of ER data modeling and database normalization and apply them to design a database.
- Learn to tune the database system and optimize queries for better performance. Learn to maintain a database to provide stable operation and durability. Gain practical experience of working with a real-world RDBMS. Understand its capabilities and limitations to use it most efficiently.
Course outline
4 classes
Introduction
Information about course agenda and grading system.
Field overview and motivation. History of databases. DBMS software overview and classification.Getting started with PostgreSQL.
SQL language
Data Definition Language (DDL). Data types. NULL values. Constraints. Database schema changes: migration, backward and forward compatibility.
SQL language continued
Relational algebra. Data Modification Language (DML). CRUD. Select queries. JOINS, subqueries, aggregation, HAVING, GROUP, ORDER BY, UNION, LIMIT.
Complex select queries
JOINS, subqueries, aggregation, HAVING, GROUP, ORDER BY, UNION. Procedural Languages. PL/pgSQL. Stored procedures.
Prerequisites
This course is one of three in a wholistic series.
Students that have already taken MSL-111 and those with prior experience with HTML, CSS, and Javascript building simple web pages will be good candidates for this module.
Anastasia received her B.S. degree in Applied Mathematics and Information Science from NRNU MEPhI, Moscow, Russia. Anastasia has 5 years of experience as a system software developer and speaker. She also worked as a teacher and project manager in a database systems domain. As a PostgreSQL contributor, Anastasia focuses on optimizing indexing, storage, and backup solutions. She enjoys working with both open source community and enterprise projects, as they provide different perspectives on the same product. Contributing to open source allows to improve the system used by millions of users and collaborate with the best professionals in the field all around the world. While working on software custom development and tech support provides constant challenges, not only technical ones and connects the art of system development with real business needs.
See full profileApply for this course
Databases
by Anastasia Lubennikova
Total hours
45 Hours
Dates
Jan 27 - Feb 14, 2020
Fee for single course
€1500
Fee for degree students
€750
How to secure your spot
Complete the form below to kickstart your application
Schedule your Harbour.Space interview
If successful, get ready to join us on campus
FAQ
Will I receive a certificate after completion?
Yes. Upon completion of the course, you will receive a certificate signed by the director of the program your course belonged to.
Do I need a visa?
This depends on your case. Please check with the Spanish or Thai consulate in your country of residence about visa requirements. We will do our part to provide you with the necessary documents, such as the Certificate of Enrollment.
Can I get a discount?
Yes. The easiest way to enroll in a course at a discounted price is to register for multiple courses. Registering for multiple courses will reduce the cost per individual course. Please ask the Admissions Office for more information about the other kinds of discounts we offer and what you can do to receive one.