Our courses

Pick a skill you'd like to learn

Intro to SQL and Databases

Creating and planning a database is one of the most important skills you need when creating IT solutions. In this course, you will learn by doing!

Every web and mobile application - in fact, every program that operates with data and stores them - needs a database. Knowledge of how to plan a database is one of the most important skills when creating a new IT solution. Most computer programs, websites and mobile apps use databases to safely store data.

In this two-week course, led by experienced SQL ninja, you will learn how to properly design a database plan and use SQL to build that database and manage it.

course session

What will I learn?

  • What databases are, what types of databases exist and why we use them
  • The pros and cons of using a database
  • Define key elements of a business process and recognize tables and data in it
  • Create a database schema and tables relations
  • Plan/design a database
  • Common SQL usage: write, read, join data, update, delete and all other ways to work with data using SQL

Every participant will create plans for 10 different databases during the course and build them using SQL commands. Through these examples, you will learn how to properly plan a database and you will be able to use this knowledge in your IT projects right away!

Program

  1. Introduction to SQL (first SQL commands and your first database plan)
  2. Tables and relationships (one-to-many, many-to-many)
  3. Planning a database, part 1 (simple databases)
  4. Planning a database, part 2 (more complex databases)
  5. Using SQL to build a database and to add data in it
course session

Prior knowledge

The course is suitable for all beginners, so having prior SQL and database knowledge is not necessary. It is also very useful for people who already use databases, but feel their knowledge of planning a database and their understanding of SQL commands is not sufficient.

What do I need with me?

The only thing you need is a laptop, a charger and a big dose of curiosity for SQL and databases

course session

After the course

SQL knowledge opens the door to becoming a database analyst or an expert in the future. But even if you don’t plan to become an analyst, this knowledge is...

  • useful for every programmer because most applications and computer programs use databases to store data
  • good for an overall understanding of the IT world
  • able to provide you with a deeper view into working with data and spreadsheets
  • able to improve your analytical and planning skills, which are also useful outside the IT world

When does the course take place?

The course lasts 2 weeks. Sessions are twice a week (Mondays and Thursdays) between 6:00 pm and 7:30 pm.

Pricing

The Early Bird price will be set to $399. The full price of the course is $799.

If you apply to the waitlist below, you'll be able to get the course at the Early Bird price!


Apply to the waitlist

Apply for our newsletter