SQL Fundamentals

Course Goal

To teach you the SQL programming language, which is a tool for accessing information in relational databases and is also used to create, modify, and manipulate data.

This Course is Designed For

  • Developers
  • Data analysts
  • Database administrators
  • Business analysts
  • Testers and many others

Learning Format

  • Course duration: 8 sessions × 4 weeks
  • Homework after each lecture and personalized feedback from the trainer
  • Access to video recordings and materials in Google Classroom

What does a graduate of the online course receive

🔗 View benefits

Program of the course "SQL Fundamentals"

1
  • You will get acquainted with the concept of a database and the types of DBMS, and you will study the hierarchy of data storage.
  • You will install the MySQL server and learn how to connect to it using Workbench and visualize data.
2
  • You will write your first query using the SELECT operator and retrieve your first dataset from the database.
  • You will learn how to filter information using conditions, sort by columns, and limit the number of returned rows.
3
  • You will learn why databases contain so many tables and the principles behind their structure.
  • You will learn how to independently transform data into a normalized form.
4
  • You will learn how to connect multiple tables and work with normalized data views.
5
  • You will learn how to write nested queries to create dynamic scripts.
  • You will understand the principles of writing subqueries, where they are used, and their limitations.
6
  • You will learn how to merge and read datasets, join tables, and enrich data.
7
  • You will learn how to apply functions to columns such as sum, average, maximum, minimum, count, and length.
8
  • You will learn the basic principles of grouping.
  • You will practice using the GROUP BY command together with aggregate functions and the HAVING clause.
9
  • You will learn what data types exist, when to use them, and how to convert them.
10
  • You will analyze the syntax for writing queries with DDL/DML commands.
  • You will write your first INSERT, UPDATE, and DELETE queries.
11
  • You will learn how to create an entity in the database that allows you to quickly display the results of a stored data selection query.
12
  • You will study functions for proper date processing: adding, subtracting, reformatting, and extracting parts (year, quarter, month, day, etc.).
13
  • You will learn the principles of creating and working with stored procedures and functions.
  • You will study event triggers and write your first trigger.
Course
4 weeks
8 lessons
Online
8000 грн
У записі
4000 грн

Education provides

Recommended Courses

7 weeks | 13 lessons
Data Analyst
Apply

Do you want to get updates about campaigns, discounts and events?