Skip to main content
EnglishEnglish
Digital Skills and Jobs Platform

Harvard Free Course on SQL and Databases

Want to learn how to work with databases or master SQL? On the Prometheus platform, a free CS50’s Introduction to Databases with SQL course from Harvard University is available in Ukrainian.

Up to 12 Hours
Online

Want to learn how to work with databases or master SQL? On the Prometheus platform, a free CS50’s Introduction to Databases with SQL course from Harvard University is available in Ukrainian.

About the course

The course will help you understand the basics of databases and SQL and gradually move to practical work with PostgreSQL and MySQL. The program also has topics for optimizing queries, scaling databases, security and other aspects of working with data.

The training contains practical tasks and a final project, during which participants create their own database. Upon successful completion, a certificate can be obtained.

The course will be useful for programmers, data analysts, BI specialists, QA specialists, entrepreneurs, operational managers and anyone who wants to develop data skills.

What will you learn?

  • SQL Basics: Creating Tables and Writing Basic SQL Queries
  • Working with relational models: building entities and relationships, primary and foreign keys
  • Data Normalization: Avoiding Duplication and Schema Errors
  • Data Joining: JOINs and Sets
  • Schemes and limitations
  • CRUD operations
  • Data Views and ETS: Simplifying Access, Aggregation, Data Protection
  • Data optimization: indices, transactions, locks
  • Scaling & Security: Replication, Sharding, Access Control, SQL Injection Protection

Duration of the event: About 11.5 hours

The course is free of charge and is taught in Ukrainian.

Key dates

Duration
12 Hours

Additional information

Training opportunities
Course
Learning Effort
Part time light
Geographic scope - Country
Ukraine
Target language
English
Target group
High Achievers
Persons with 0-3 years work experience
Persons with 3-10 years work experience
Persons with 10+ years work experience
Low Achievers
Is this course free
Yes

Digital technologies

Skill levels