The course “Database Fundamentals” including:

general knowledge about the DBMS;
understanding of client-server communication;
normal forms, denormalization;
references between table-columns;
understanding of the main types of data;
functions;
triggers.

WHY SOFTSERVE ACADEMY?

reality-check: 40% of all SoftServe developers are our graduates

15 years of providing on-demand knowledge verified by real projects

mentors define your learning needs and knowledge gaps to adjust the course and support you all along

small-sized groups to make you get all the answers and attention

1,5 months of experience to list on your CV

practical assignments make up 2/3 of a program

For whom?

The course is oriented at apprentices, that have basic knowledge of database design and work in any database system.
For those who want for mastering RDBMS, that you can`t do without in any project.
For those, who are interested in continuing education at SoftServe Academy in any direction.

COURSE INFORMATION

Course plan

Relational Database Basic
Keys. Relations. SQL Data Types
Accessing Data: simple SELECT statement
Creating simple reports
SELECT Statement: Working with Multiple Tables
Advanced Data Selection: Aggregate Functions
SQL Subqueries
Database Design. Building a Simple Database Structure
Database Objects’ Management
Manipulating Database Data. Specifying Values
Views: Creating, Usage and Deleting
DB Administration. Transactions
Creating the Stored Procedures
Triggers in DB
NoSQL, MongoDB

The outcomes for you

basic SQL language data types; SQL statements for creating database objects; SQL statements for data manipulation; data access tools; SQL tools and constructions for database administration;
design a database for a specific subject area; use a graphical client to work with the database server; create and manage database objects;
add, modify and delete data in the database; build simple and complex database table queries;
manage the work of database users and their roles; use SQL queries to access data from software modules.

FAQs

Is there any kind of pre-selection procedure?

Yes, before the course start, you’ll be interviewed by a tutor to make sure you are ready for the course and that your expectations for it are correct.

General information

duration

7-8 weeks

recurrence

2 times per week Mon, Fri 18:00-20:00

format

Online

Available groups for registration

11.12.2023-26.01.2024

Online

Database Fundamentals

8599 UAH

Registration is open till 11.12.2023

Registration

For those affected by the war in Ukraine, we can offer free seats on this course. In order to study for free, fill out this form, write a motivation letter and pass a technical test. The number of seats is limited. The selection will be made based on the letter and the results of the technical test.

* Service provides LLC SoftServe Technologies, Online

Example of the order-agreement is here