Tech Heart
Harbour.Space University

RESERVE MY SPOT

Pavel Scherbinin is a CTO of Mediaprojects with more than 10 years experience, including Perl, MySQL, JavaScript, Nginx, PSGI, Sphinx and other things. He is an proponent of Modern Perl, uses Mojolicious, Moo, Test::More. Creates a highload and high-avaliable project with NGINX and UWSGI. Pavel can implement Continuous Integration using Jenkins and knows how to write a failover applications. Can write asynchronous (AnyEvent, Coro) and parallel (fork, threads) code.
Besides, Pavel has a good experience at design database schemas, writing difficult SQL queries and index optimisation. He teaches student at Bauman State University at Database class.
In his free time, Pavel currently works on an app that will help people to find a best place for eat, by their interest and mood.

• Design database

• Create query

• Create a complicated queries

• Create right indexes

• Optimize queries

• Configure database

• Implement replication

• Use NoSQL

SKILLS:

- Web Development

Databases

Computer Science

- Perl

- MYSQL

- JavaScript

- Nginx

- PSGI

- Sphinx

- Teaching

DATE: 12 - 30 June, 2017

DURATION: 3 Weeks

LECTURES: 3 Hours per day

LANGUAGE: English

LOCATION: Barcelona, Harbour.Space Campus

COURSE TYPE: Offline

WHAT YOU WILL LEARN
COURSE OUTLINE
ABOUT PAVEL
BIBLIOGRAPHY
HARBOUR.SPACE 

DATABASES

This course covers database design and the use of databases in applications, with a short introduction to the internals of relational database engines. It includes extensive coverage of the relational model, relational algebra, and SQL. The course also features database design and relational design principles based on dependencies and normal forms.

PAVEL SCHERBININ
RESERVE MY SPOT

We offer innovative university degrees taught in English by industry leaders from around the world, aimed at giving our students meaningful and creatively satisfying top-level professional futures. We think the future is bright if you make it so.

HARBOUR.SPACE UNIVERSITY

DATE: 12 – 30 June, 2017

DURATION:  3 Weeks

LECTURES: 3 Hours per day

LANGUAGE: English

LOCATION: Barcelona, Harbour.Space Campus

COURSE TYPE: Offline

DATABASES

Session 1

Introduction and design basics 

• A brief introduction to the history of the database.
• Why and where are databases used?
• What types of databases exist?
• Introduction to Relational Database
• The terms of relational databases
• Relational Algebra

Session 2

Design and Data Definition Language (DDL)

• Introduction to database design
• Why database design can be bad
• Normalization and normal forms
• Primary keys
• Data types
• Migration between scheme versions

Session 3

Data Manipulation Language (DML). Select

• SELECT
• JOINS
• Subqueries
• Aggregation
• HAVING, GROUP, ORDER BY UNION
• Priority queues and hash tables

SHOW MORE

Session 4

Running a company

• INSERT
• UPDATE
• DELETE
• Recursive queries
• Hierarchical structures in databases

Many additional key database topics from the design and application-building perspective are also covered, including indexes, views, transactions, and integrity constraints. Big part of this course about high performance optimization, how to do your database faster, improving your queries, optimizing indexes, configuring. NoSQL systems like documentary and key-value stores will also be covered.