Databases
Faculty
Pavel Scherbinin
CTO of Mediaprojects at Mail.ru, Lecturer at Technopark@Mail.Ru
Course length
Duration
Total hours
Credits
Language
Course type
Fee for single course
Fee for degree students
Skills you’ll learn
Overview
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.
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.
Learning highlights
- Design database
- Create query
- Create a complicated queries
- Create right indexes
- Optimize queries
- Configure database
- Implement replication
- Use NoSQL
Course outline
4 classes
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
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
Data Manipulation Language (DML). Select
• SELECT
• JOINS
• Subqueries
• Aggregation
• HAVING, GROUP, ORDER BY UNION
• Priority queues and hash tables
Running a company
• INSERT
• UPDATE
• DELETE
• Recursive queries
• Hierarchical structures in databases
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.
Pavel Scherbinin is a CTO of Mediaprojects with more then 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 Continious Integration using Jenkins and knows how to write a failover applications. Can write assynchronous (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 teachs student at Bauman State Unverisity at Database class.
See full profileApply for this course
Databases
by Pavel Scherbinin
Total hours
45 Hours
Dates
Jun 12 - Jun 30, 2017
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.