MS SQL Server Developer - free course from Otus, training 5 months, Date: December 1, 2023.

Miscellaneous / by admin / December 04, 2023

click fraud protection

During the course, we will examine in detail the query language and internal DBMS processes that occur at all stages of working with a query. The course will allow you to understand the details of processes and get a clear idea of what this or that code does, where potential problems may arise, and how they can be resolved. We'll take a closer look at code optimization, how to write it if you have billions of data, and we'll tell you about popular rakes so you can bypass them.

This course is intended for:
— developers with experience working with databases at the “I’ve done it and used it, but I don’t know how it works inside” level (for example, through ORM);
— developers with little experience working with databases and a desire to advance further.

After training you will be able to:
— develop in SQL;
— design a database and understand all the nuances;
— analyze and optimize query performance;
— write complex stored procedures, functions and triggers;
- read the query plan.

Graduation project - creation and optimization of your own database (for your company/startup). The teacher will help you choose a topic and tell you how to reduce the scope of work, and you will have the opportunity to get feedback and practice your acquired knowledge on real material.

instagram viewer

Pavel Strekalov

courses

Leading specialist at JSC Greenatom. More than 10 years of professional development experience. Main stack: .NET / C#, Java, MS SQL Server. Full stack development of systems for internal and external customers from requirements analysis to implementation, operation and technical support. Graduated from the Moscow Institute of Electronic Technology (MIET) in 2006 with a degree in Computer Systems, Systems and Networks.

Victor Korobkov

courses

More than 15 years of experience in the IT industry, more than 20 years of teaching experience. Currently: - programmer at the Center for Intelligent Geoinformation Technologies (CIGIT) of the Federal State Budgetary Educational Institution of Higher Education "ASU"; - senior lecturer at the Department of Automated information processing and control systems in the areas of “Programming and fundamentals of algorithmization”, “Databases”, “Artificial intelligence systems”;- co-founder of the small innovative enterprise ForeSays LLC - scientific research in the field of natural and technical sciences, software development provision. Skills: C/C++ programming, Delphi; design and development of databases: DBMS MSVisualFoxPro, MSAccess, MSSQLServer, PostgreSQL. Has 2 patents and 8 certificates of registration of computer programs Teacher

Mikhail Rzhevsky

course

IT specialist, freelancer, certified Dynamics AX and Dynamics CRM developer with more than 5 years of experience (expert level). Total experience in the IT industry is 15 years. Has a wide range of professional skills (MS SQL Server, MySQL, C#, HTML, XML, CSS, Javascript, JQuery, Unit Tests). Participated in the implementation of many projects, worked as Senior Dynamics CRM. Is a Microsoft Certified Trainer. Since 2009, in addition to his main job, he has been engaged in teaching. Author of his own courses and specialized articles on hosting-it.ru. Graduate of MIREA (graduated in 1994).

Using the database
-Topic 1. Basic components and architecture of SQL Server. DZ
-Topic 2. SELECT statement and simple filters, GROUP BY, HAVING. DZ
-Topic 3.Introduction to indexes and query plans
-Topic 4. Subqueries, CTE, temporary tables. DZ
-Topic 5. Operators CROSS APPLY, PIVOT, UNPIVOT. DZ
-Topic 6.Window functions. DZ
-Topic 7. Dynamic SQL. DZ
-Topic 8. Selections from XML and JSON fields. DZ
-Topic 9.Final lesson on SELECT
-Topic 10.Data modification operators. DZ
-Topic 11.Transaction isolation levels
-Topic 12. Stored procedures, functions, triggers, cursors. DZ
-Topic 13.Creating and using the CLR. DZ

Database design
- Topic 14. Database design. DZ
-Topic 15. DDL operators. DZ
-Topic 16. Data types
-Topic 17. Approaches to database design, patterns
-Topic 18.Indices. DZ
- Topic 19. Designing a database for OLTP load. Why is it important to separate OLTP and OLAP
-Topic 20. Design of data warehouses and OLAP systems. DZ
-Topic 21.Using SSIS in ETL
-Topic 22.SQL Server Reporting Services and PowerBI
-Topic 23.Queues in MS SQL Server. DZ
-Topic 24.Seminar on created database projects

Database optimization and administration
-Topic 25.Index maintenance
- Topic 26. Query plans, and now more details
-Topic 27.DMV in SQL Server
-Topic 28.Optimization of database operation
-Topic 29. Popular Hints and tips for the optimizer. DZ
-Topic 30.Seminar: optimization of complex queries
-Topic 31. Partitioning tables. DZ
-Topic 32.Security in SQL Server
-Topic 33.Backup and recovery
-Topic 34. Ensuring fault tolerance, replication
- Topic 35. Discussion of projects. Summing up the course

Tags cloud

Miscellaneous

Rating

Views

Comments