SQLPTSMTMaster ClassMT-SQLPTS2.3<p>Knowledge in the following areas is desirable:</p> <ul> <li>Knowledge of MS SQL Server administration</li><li>Knowledge of relational databases</li><li>Knowledge of TSQL language</li></ul><p>Knowledge in the following areas is desirable:</p> <ul> <li>Knowledge of MS SQL Server administration</li><li>Knowledge of relational databases</li><li>Knowledge of TSQL language</li><li><span class="cms-link-marked"><a class="fl-href-prod" href="/swisscom/fr/course/innovator-sqlscomp"><svg role="img" aria-hidden="true" focusable="false" data-nosnippet class="cms-linkmark"><use xlink:href="/css/img/icnset-linkmarks.svg#linkmark"></use></svg>Microsoft SQL Server Administrator Compact <span class="fl-prod-pcode">(SQLSCOMP)</span></a></span></li></ul><p>The target groups are database administrators who already have knowledge of installing and managing MS SQL Server and want to build on their expertise in the areas of configuration, optimization, and troubleshooting.</p> <p>Also, developers who want to learn, monitor, and optimize advanced SQL functionalities such as stored procedures, transaction programming, and locking behavior.</p><h5>Architecture of the MS SQL Server</h5><ul> <li>connection logs</li><li>Layer of the database engine</li><li>Life Circle query</li></ul><h5>Configuring the SQL Server</h5><ul> <li>Configuring database services</li><li>Storage concepts</li><li>Memory configuration</li><li>processor configuration</li><li>Additional server configurations</li><li>Surface Configuration Manager</li><li>Configuring TempDB</li></ul><h5>database architecture</h5><ul> <li>Database components (data and log files, file groups, extents, pages)</li><li>Page structure and page types</li><li>Working with database files (file configuration, shrink file, etc.)</li></ul><h5>Indices and statistics</h5><ul> <li>Types of indexes</li><li>Advantages and disadvantages of indices</li><li>Column Stored Index</li><li>Statistics and filtered statistics</li></ul><h5>safety</h5><ul> <li>Authorization concepts in SQL Server</li><li>Creating logins, users, roles, and schemas</li><li>Transferring logins</li><li>Working with instances</li><li>Always Encrypted</li><li>Code and data encryption</li><li>Dynamic Data Masking</li><li>Server and database auditing</li><li>Password protection and encryption of backups</li><li>SQL Injection</li><li>Security for SSRS and SSAS</li></ul><h5>Maintenance of the SQL Server</h5><ul> <li>Maintenance strategies for indexes, statistics, and databases</li><li>Automation of maintenance jobs</li><li>SSIS DB as storage location for maintenance jobs</li></ul><h5>Identifying performance bottlenecks</h5><ul> <li>Reasons for performance bottlenecks</li><li>Strategies for identifying performance bottlenecks</li><li>Using Perfmon to analyze performance parameters</li><li>Overview of the most important performance parameters</li><li>Monitoring events with the Profiler and Extended Events tools</li><li>Monitoring with DMVs and DBCC statements</li><li>Data Collector</li></ul><h5>Queries and execution plans</h5><ul> <li>Query processing architecture</li><li>Understanding and interpreting implementation plans</li><li>Using the Database Optimization Advisor to Improve Query Performance</li><li>Benefits of the query store</li><li>Auto Tuning</li></ul><h5>Optimizing SQL</h5><ul> <li>10 tips for high-performance SQL</li><li>Blocking behavior of queries</li><li>Transactions and isolation levels</li><li>Identifying deadlocks</li><li>Influencing execution plans with hints</li><li>Procedures and materialized views</li><li>Use of CLRs</li></ul><h5>In-memory OLTP databases and table compression</h5>Knowledge in the following areas is desirable: - Knowledge of MS SQL Server administration - Knowledge of relational databases - Knowledge of TSQL languageKnowledge in the following areas is desirable: - Knowledge of MS SQL Server administration - Knowledge of relational databases - Knowledge of TSQL language - Microsoft SQL Server Administrator Compact (SQLSCOMP)The target groups are database administrators who already have knowledge of installing and managing MS SQL Server and want to build on their expertise in the areas of configuration, optimization, and troubleshooting. Also, developers who want to learn, monitor, and optimize advanced SQL functionalities such as stored procedures, transaction programming, and locking behavior.Architecture of the MS SQL Server - connection logs - Layer of the database engine - Life Circle query Configuring the SQL Server - Configuring database services - Storage concepts - Memory configuration - processor configuration - Additional server configurations - Surface Configuration Manager - Configuring TempDB database architecture - Database components (data and log files, file groups, extents, pages) - Page structure and page types - Working with database files (file configuration, shrink file, etc.) Indices and statistics - Types of indexes - Advantages and disadvantages of indices - Column Stored Index - Statistics and filtered statistics safety - Authorization concepts in SQL Server - Creating logins, users, roles, and schemas - Transferring logins - Working with instances - Always Encrypted - Code and data encryption - Dynamic Data Masking - Server and database auditing - Password protection and encryption of backups - SQL Injection - Security for SSRS and SSAS Maintenance of the SQL Server - Maintenance strategies for indexes, statistics, and databases - Automation of maintenance jobs - SSIS DB as storage location for maintenance jobs Identifying performance bottlenecks - Reasons for performance bottlenecks - Strategies for identifying performance bottlenecks - Using Perfmon to analyze performance parameters - Overview of the most important performance parameters - Monitoring events with the Profiler and Extended Events tools - Monitoring with DMVs and DBCC statements - Data Collector Queries and execution plans - Query processing architecture - Understanding and interpreting implementation plans - Using the Database Optimization Advisor to Improve Query Performance - Benefits of the query store - Auto Tuning Optimizing SQL - 10 tips for high-performance SQL - Blocking behavior of queries - Transactions and isolation levels - Identifying deadlocks - Influencing execution plans with hints - Procedures and materialized views - Use of CLRs In-memory OLTP databases and table compression5 jours4995.004995.004995.004995.00