TOP Database courses from the school Specialist

SQL Server is a universal platform for data management, business application development, and business intelligence projects. The purpose of the course is to learn how to develop databases, as well as solve typical tasks and problems that arise when using them. * *the course is taught in partnership with the ARMKYBERSEC Academy

The course provides students with knowledge of how to effectively configure SQL statements, as well as how to write them correctly. Various methods of writing SQL commands will be reviewed, and students will learn which methods are most effective in certain circumstances.

The goal of the course is to learn to use modern databases in general and Microsoft SQL Server 2017 in particular freely and confidently. The course is intended for analysts using Microsoft SQL Server databases, report developers, database application support specialists, database administrators and developers, and applications. * *the course is taught in partnership with the ARMKYBERSEC Academy

The course provides students with basic knowledge of SQL, allowing the developer to write queries against one or more tables, modify table data, and create database objects. The main development tool used in the course is Oracle SQL Developer; SQL Plus is used as an additional one.

The course provides students with the knowledge and skills to administer SQL Server database infrastructure for cloud, local and hybrid relational databases, as well as for relational databases Microsoft PaaS (Platform as service). * *the course is taught in partnership with the ARMKYBERSEC Academy

The course examines modern PL/SQL capabilities for developing and debugging PL/SQL programs that most effectively interact with the database and other applications. The issues of writing optimal code, using external routines written in languages ​​C and Java, using a fine-grained access control mechanism, as well as protecting code from SQL injections. You will learn to use all the functionality of cursors, packages, large objects, collections, and methods of interacting with other applications.

MySQL server is very common and is often used in web technologies. Most websites and solutions on the Internet are based on this server. The course covers basic techniques and methods for working effectively with the MySQL 8 server. This course is intended for developers who plan to use the MySQL server in their practice. The course will be especially interesting for web developers using PHP and Perl.

We invite you to master the professional use of multidimensional databases! You will master all the possibilities provided by multidimensional databases. The most important thing is that you will learn to work with such databases directly, without intermediaries or middleware. * *the course is taught in partnership with the ARMKYBERSEC Academy

In the course, you'll learn how to migrate to three target platforms for SQL-based workloads: Azure Virtual Machines, Azure SQL Databases, and Azure SQL Database Managed Instances. * *the course is taught in partnership with the ARMKYBERSEC Academy

This course covers the fundamentals of the Microsoft Transact-SQL language. Topics include both querying and modifying data in relational databases hosted on Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database. * *the course is taught in partnership with the ARMKYBERSEC Academy

During the course, you will become familiar with the API, learn how to correctly describe data formats, become familiar with XML, and prepare an XSD schema. Compare XML and JSON, understand in which situation which is preferable to use and learn how to prepare a JSON schema.