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
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
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
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
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.