DATE: 27 Jan - 14 Feb, 2020
DURATION: 3 Weeks
LECTURES: 3 Hours per day
LANGUAGE: English
LOCATION: Barcelona, Harbour.Space Campus
COURSE TYPE: Offline
WHAT YOU WILL LEARN
COURSE OUTLINE
BIBLIOGRAPHY
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.
ANASTASIA
LUBENNIKOVA
DATE: 27 Jan – 14 Feb, 2020
DURATION: 3 Weeks
LECTURES: 3 Hours per day
LANGUAGE: English
LOCATION: Barcelona, Harbour.Space Campus
COURSE TYPE: Offline
Session 1
Introduction
Information about course agenda and grading system.
Field overview and motivation. History of databases. DBMS software overview and classification.Getting started with PostgreSQL.
Session 2
SQL language
Data Definition Language (DDL). Data types. NULL values. Constraints. Database schema changes: migration, backward and forward compatibility.
Session 3
SQL language continued
Relational algebra. Data Modification Language (DML). CRUD. Select queries. JOINS, subqueries, aggregation, HAVING, GROUP, ORDER BY, UNION, LIMIT.
Session 4
Complex select queries
JOINS, subqueries, aggregation, HAVING, GROUP, ORDER BY, UNION. Procedural Languages. PL/pgSQL. Stored procedures.
- 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.
All rights reserved. 2017
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.
SKILLS:
- Data Science
- Data Structures
- Mathematics
- Databases
- PostgresSQL
ABOUT ANASTASIA
Database System Concepts by Avi Silberschatz, Henry F. Korth, S. Sudarshan (McGraw-Hill Education, 2010)
Harbour.Space is a university created by entrepreneurs for entrepreneurs. We focus on meeting the demands of the future, while traditional education providers are too often stuck in the past.
We’re one of the only European institutions completely dedicated to technology, design and entrepreneurship, and our interdisciplinary courses are taught by some of today’s leading professionals. Our aim is not only to equip students with the knowledge to take on the real world, but to nurture, create and shape tomorrow’s tech superstars.
ABOUT HARBOUR.SPACE
HARBOUR.SPACE UNIVERSITY