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
Program
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
FAQ
1
The course is designed for developers, data analysts, testers and business analysts. You will learn the SQL programming language for accessing, creating, and manipulating information in relational databases. In practice, you will learn how to write queries, normalize data, and work with triggers and functions.
2
You will learn how to set up a MySQL server, connect through Workbench, and write queries with SELECT, JOIN, GROUP BY, and subqueries. The program covers using aggregate functions, working with dates, normalizing data, and writing DDL/DML commands (INSERT, UPDATE, DELETE) and stored procedures.
3
The duration of the course is 4 weeks, during which 8 online classes are held. After each lecture, you will complete homework and receive feedback from the trainer. All videos and learning materials will be conveniently collected for you in Google Classroom.
4
The cost of online training is UAH 10,000, and the recording format costs UAH 6,000. There is a special loyalty program for participants, and there is also an opportunity to attend a trial class. To join the course, simply click the "Apply" button on this page.
Course
4 weeks
8 lessons
Online
10000 грн
У записі
6000 грн
- Діє програма лояльності
- We offer a trial lesson
Education provides
Dmitry Popov
Expert in retail customer experience management
Reviews
I am very glad that I was lucky enough to become a SkillsUp student =) First, I got into the course "SQL Fundamentals", then "Java from scratch" and now I have "Java-practice" ahead of me and this is not the end =) A huge thank you to Denis and Lyosha for their patience and sensitivity) The information is provided easily and accessible, but the most important thing is that you start to love what you learn =) And you can only learn well because you love)))
I graduated from the SQL Fundamentals course in February 2016. I am very satisfied with the quality of the knowledge I received and the teaching method. The course was taught by Denys Skalenko, a very responsible and energetic person who explained the material very succinctly and simply, answered all questions, and paid attention to everyone. If there were problems with mastering the material, he explained with examples until everyone understands and understands the new information. SkillsUp is a place of friendly, young, active and purposeful people. As soon as you enter the walls of SkillsUp, the head of the training center, Misha Chokan, surrounds you with attention and is eager to help in solving all kinds of issues. Candy and coffee with tea before class is a nice compliment for all SkillsUp students ))))) Thanks to the SkillsUp team for the knowledge gained!! I recommend it to everyone!!!!!!
I study at SkillsUp regularly. My first course was "SQL Fundamentals" - learned some new knowledge, despite the fact that I had a base. I also tried the "Automation of software testing" courses, unfortunately, I was unable to successfully complete them due to weak technical training. Teachers try to understand the material and work with each student. SkillsUp has democratic prices, a flexible system of discounts and an individual approach to each client. SkillsUp is located in a convenient location, on the territory of the "Kyiv National University of Culture and Arts" - it is easy to get to. Among the shortcomings, only the temperature problems of the university itself can be noted - it is cool in winter (the university does not heat in winter, and stationary heaters sometimes do not cope with the volume of the room), and in summer it is hot until 19:00, despite the windows and doors being open.
I finished SQL and Project Management courses at SkillsUp. Excellent courses for everyone who wants to master these directions in the IT field. Classes at SkillsUp are rich, informative and interesting. Teachers inspire during the learning process, the material is presented in an accessible way and with examples. Lots of homework and practice — all this helped me systematize my knowledge and gain new ones. She has never once regretted connecting her life with SkillsUp. I recommend these courses to those who care about their professional future.
I am very glad that I was lucky enough to become a SkillsUp student =) First, I got into the course "SQL Fundamentals", then "Java from scratch" and now I have "Java-practice" ahead of me and this is not the end =) A huge thank you to Denis and Lyosha for their patience and sensitivity) The information is provided easily and accessible, but the most important thing is that you start to love what you learn =) And you can only learn well because you love)))
I graduated from the SQL Fundamentals course in February 2016. I am very satisfied with the quality of the knowledge I received and the teaching method. The course was taught by Denys Skalenko, a very responsible and energetic person who explained the material very succinctly and simply, answered all questions, and paid attention to everyone. If there were problems with mastering the material, he explained with examples until everyone understands and understands the new information. SkillsUp is a place of friendly, young, active and purposeful people. As soon as you enter the walls of SkillsUp, the head of the training center, Misha Chokan, surrounds you with attention and is eager to help in solving all kinds of issues. Candy and coffee with tea before class is a nice compliment for all SkillsUp students ))))) Thanks to the SkillsUp team for the knowledge gained!! I recommend it to everyone!!!!!!
I study at SkillsUp regularly. My first course was "SQL Fundamentals" - learned some new knowledge, despite the fact that I had a base. I also tried the "Automation of software testing" courses, unfortunately, I was unable to successfully complete them due to weak technical training. Teachers try to understand the material and work with each student. SkillsUp has democratic prices, a flexible system of discounts and an individual approach to each client. SkillsUp is located in a convenient location, on the territory of the "Kyiv National University of Culture and Arts" - it is easy to get to. Among the shortcomings, only the temperature problems of the university itself can be noted - it is cool in winter (the university does not heat in winter, and stationary heaters sometimes do not cope with the volume of the room), and in summer it is hot until 19:00, despite the windows and doors being open.
I finished SQL and Project Management courses at SkillsUp. Excellent courses for everyone who wants to master these directions in the IT field. Classes at SkillsUp are rich, informative and interesting. Teachers inspire during the learning process, the material is presented in an accessible way and with examples. Lots of homework and practice — all this helped me systematize my knowledge and gain new ones. She has never once regretted connecting her life with SkillsUp. I recommend these courses to those who care about their professional future.