Please, change device orientation to portrait

Database
Development
Relational Database Development using Microsoft SQL Server tools

What do we suggest?

  • Within the course you will be able to get up-to- date information from real professionals and solidify it while exchanging experience and knowledge with your friends under the expert guidance.
  • Curriculum of the course includes such topics: 
    • Relational database. Database design. Diagrams;
    • Types of tables relationships;
    • Indexes;
    • Stored procedures, functions, triggers writing. Dynamic SQL;
    • Temporary tables. Cursors;
    • Solidifying T-SQL knowledge. Knowledge of the main operators, ability to use skills while working on a project. Aggregation, window functions;
    • Studying main SQL Server Management Studio components;
    • Building data warehouse; Inmon/Kimbal approach;
    • SSIS. Designing a project for uploading data from files to a database. Providing incremental data uploading;
    • Analytics. Reporting using SSRS, TABLEAU;
    • Solidifying theoretical knowledge.

For those, who:

  • Have basic knowledge in DBMS (Databases, widespread DBMS, database objects, data consistency, database normalization);
  • Know SQL Server data types, SQL constraints;
  • Have basic knowledge in T-SQL;
  • Are familiar with business analytics (business analytics tools, ETL, database storage, database denormalization);
  • Have logical thinking, algorithms;
  • Understand “client-server” connection;
  • Level of English is Intermediate+;
  • Are ready to be involved in education process at the IT Academy 6-8 hours every day.

What is the minimum technical knowledge demanded to enter the course and which resources can be used for preparation?

  •   Basic understanding of OLTP and OLAP systems;
  •   Idea of relational database;
  •   Normal forms, denormalization. Necessity of database denormalization;
  •   Connection between tables;
  •   Сonstraints. Primary key, Foreign Key, Default, Check, Unique constraints;
  •   Indexes. Their types and purpose;
  •   Idea of database warehouse. Approaches to database storage creation;
  •   SQL basics;
  •   SELECT, FROM, WHERE ,GROUP BY, HAVING requests;
  •   Tables combination (INNER, OUTER, FULL, CROSS join, self-join, APPLY);
  •   Using CASE, LIKE, IN (NOT IN), ANY, IF EXISTS (IF NOT EXISTS) in requests;
  •   TOP, OFFSET FETCH;
  •   UNION/UNION ALL, EXCEPT/INTERSECT;
  •   Window functions;
  •   Understanding of main data types;
  •   DML – INSERT/UPDATE/DELETE;
  •   DDL – CREATE/DROP/ALTER;
  •   Stored procedure;
  •   Function – scalar, inline, multi statement;
  •   View (purpose of using, ways of data update);
  •   Triggers (essence, their main types);
  •   Dynamic SQL;
  •   Temporary objects (temporary tables, time variables).

 

* What can bring advantages at the interview with an expert?

  • Doing tasks on site sql-ex, learning level;
  • Basic understanding of SSIS (data flow task, main control flow, deploy package components);
  • Hands-on experience in database objects creation: table, view, stored procedure, function, trigger.

* We don`t specify literature for this section and don`t put these questions on the obligatory list. But awareness of something, noted above, will be your advantage at the interview with a technical expert.

What is the procedure of entering courses? Answers to organizational questions

 

     ·       Schedule of courses of the IT Academy: 

o   https://career.softserveinc.com/en-us/schedule 

·       Registration for courses of the IT Academy:

         o  https://career.softserveinc.com/en-us/technology

 

Test assignments

Sample of assignments

Available groups for registration

Currently, there are no courses in this direction that are open for registration.


To learn about the registration opening, complete the following form:

Call
us
Feed
back