М20762С: Development of databases on the Microsoft SQL Server platform - course 56,990 rub. from Specialist, training 40 academic hours, date of May 15, 2023.
Miscellaneous / / December 04, 2023
Experienced course teacher Microsoft Azure, certificate holder Microsoft Certified Professional, MCSE:Cloud Platform and Infrastructure, MCSA: Windows Server 2012. Experience in system administration is more than 20 years, in the field of teaching - 5 years. At the moment, Denis Alekseevich has released more than 40 groups on various vendor products Microsoft.
Denis Alekseevich is a graduate of UrFU with a degree in design engineer (gas turbines). Worked as an engineer and system administrator in companies such as Okami-Motors-Vostok, PF SKB Kontur, Softline Trade. During his time at Softline Trade, he was promoted to head of the Microsoft System Center department. His main activities are architecture development, detailed design, development of work schedules and labor cost estimates as a technical expert, product implementation Microsoft System Center (Service Manager, Configuration Manager, Operation Manager, Data Protection Manager), presentations, training for the customer.
Denis Alekseevich is a responsible teacher, aimed at maximum assimilation of the material by students and their understanding of how to apply it in practice. Listeners especially note his creativity and ability to find a personal approach to learning, as well as the value of examples of solving various administrator problems from his personal experience.
Special purpose teacher, holder of prestigious international status Microsoft Certified Master. Graduate of Moscow State Technical University named after N.E. Bauman.
In his classes, Fedor Anatolyevich puts the principle at the forefront “Look to the root!” - it is important not only to study the operation of the mechanism, but also to understand why it works this way and not otherwise.
A generalist in the field of software design and development. He has many years of experience as a development team leader and chief architect. Specializes in enterprise application integration, web portal architecture development, data analysis systems, deployment and support Windows infrastructure.
The combination of engineering and natural science presentation styles allows students to convey the passion and creative approach of the teacher. Fedor Anatolyevich invariably receives the most enthusiastic reviews from his grateful graduates.
Leading teacher of the center for Microsoft Azure and network technologies Microsoft, has statuses MS: MCSA, MCSE, MCDBA and SCNP.
Microsoft Certified Trainer (MCT) with over 20 years of teaching experience. During his time as a teacher, he trained more than 4,000 specialists.
Alexander Vitalievich Candidate of Sciences, majoring in Cybernetics, author of professional articles on systems for processing, transmitting and protecting information, and automated control systems. Has more than 30 technical certifications (Microsoft, CompTIA, SCP, ITIL) and extensive experience in managing technical support for corporate customers.
Alexander Vitalievich worked for more than 14 years in the technical support service of Microsoft Corporation, of which more than 10 years led the group technical support for corporate customers, managing a team of more than 20 technical support managers and providing premium Premier support of more than 100 largest Russian corporations, including Magnit, Lenta, Russian Post, Kaspersky and etc. Alexander Vitalievich took an active part in the introduction of a new type of premium technical support (Microsoft Unified Support) in Russia in 2018-2020, focused on maximizing assistance in the implementation of cloud technologies in organizations.
During the classes, the teacher places the main emphasis on developing practical skills in students. In their reviews, graduates invariably note not only the information richness and structure of the material, but also the especially warm, friendly atmosphere, humor, and abundance of cases and stories from practice.
Module 1. Introduction to database development (2 ac. h.)
Introduction to the SQL Server Platform
Developer Tools and Tasks
Laboratory work
Module 2. Design and creation of tables (2 ac. h.)
Table development
Data types
Using Schemes
Operations on tables
Laboratory work
Module 3. Complex aspects of table development (2 ac. h.)
Module 4. Ensuring data integrity using restrictions (2 ac. h.)
Ensuring data integrity
Domain integrity
Entity and referential integrity
Laboratory work
Module 5. Indices (2 ac. h.)
How indexes work
Data types and indexes
Heap, clustered and non-clustered indexes
Simple and compound indexes
Laboratory work
Module 6. Development of effective indices (2 ac. h.)
Index Development Strategy
Index management
Query Execution Plan
Database Engine Configuration Assistant
Query storage
Laboratory work
Module 7. Column indexes (2 ac. h.)
Introduction to Column Indexes
Creating Column Indexes
Exploiting Column Indexes
Laboratory work
Module 8. Design and creation of representations (2 ac. h.)
Purpose of views
Creating and Managing Views
Impact of views on performance
Laboratory work
Module 9. Design and creation of stored procedures (2 ac. h.)
Introduction to Stored Procedures
Using Stored Procedures
Parameterized procedures
Execution context management
Laboratory work
Module 10. Design and creation of user functions (2 ac. h.)
Feature overview
Scalar functions
Table functions
Creating Functions
Alternative mechanisms
Laboratory work
Module 11. Processing data changes using triggers (2 ak. h.)
Trigger Design
Implementation of triggers
Advanced Trigger Features
Laboratory work
Module 12. Tables placed in memory (3 ac. h.)
In-memory tables
Procedures compiled to binary code
Laboratory work
Module 13. Managed code in a database (2 ac. h.)
Module 14. Storage and processing of XML data (3 ac. h.)
Introduction to XML
Storing data in XML
Creating indexes for XML
Converting data to XML
Running Queries with XQuery
Converting data from XML to a table view
Laboratory work
Module 15. Storage and processing of spatial data (2 ac. h.)
Introduction to Spatial Data
Working with spatial types
Using spatial types in applications
Laboratory work
Module 16. Storage and processing of unstructured data (2 ac. h.)
Introduction to Unstructured Data (BLOB)
Storing unstructured data in separate files
Full text search
Laboratory work
Module 17. Competitive access to data (3 ac. h.)
Concurrent data access and transactions
Locking mechanism
Laboratory work
Module 18. Performance and monitoring (3 ac. h.)
Tracing and Extended Events
Statistics on current requests
Optimizing database file settings
Metrics to measure performance
Laboratory work
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
4,2
cool course in which we will hang out with the basic tools of the universe of data analysis and processing, using the Python programming language 🐍 and the Pandas library 🐼
4
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.
4,2