Laserfiche WebLink
updates., Manage threats by using Advanced Threat Analytics <br />(OMS). <br />and Microsoft Operations Management Suite <br />20761 Querying Data with Transact SQL <br />Description <br />Are you ready to learn how to navigate relational databases like a pro? Transact SQL training from will prepare <br />you to take the next step in your data career. <br />In this course, you will gain a comprehensive understanding of the Transact SQL language, which is used by all <br />SQL Server -related disciplines including database administration, database development and business intelligence. <br />Acquired Skills <br />Describe the key capabilities and components of SQL Server <br />Confidently speak about T-SQL, sets and predicate logic <br />Write single- and multi -table SELECT statements <br />Explain how SQL Server uses data types <br />Manipulate set operators to combine query results <br />Work with and implement views and table -valued functions <br />Write DML statements and queries <br />Transform data by implementing pivot, unpivot, rollup and cube <br />Create and implement stored procedures <br />Add programming constructs such as variables, conditions and loops to T-SQL code <br />20762 Developing SQL Databases <br />Description <br />In the Developing SQL Databases course, you will learn how to use SQL Server 2016 features and tools and gain <br />the knowledge and skills to develop a SQL Server database. <br />Acquired Skills <br />Design and implement tables <br />Confidently speak about advanced table designs <br />Ensure data integrity through constraints <br />Describe indexes, including optimized and column store indexes <br />Work with spatial data <br />Address data manipulation using triggers <br />Execute managed code in SQL Server <br />Store and query XML data, BLOBS and text documents <br />Design and implement views, stored procedures, user -defined functions and in -memory tables <br />20764 Administering a SQL Database Infrastructure <br />Description <br />In this course, you'll learn the ins and outs of database administration and gain hands-on experience <br />automating, backing up, restoring and troubleshooting SQL Server. With expert guidance from' certified <br />instructors, you'll master the modern database techniques companies are desperately seeking out. <br />Acquired Skills <br />Authenticate and authorize users <br />Assign server and database roles <br />Backup and restore SQL Server databases <br />Protect data with encryption and auditing <br />Automate database management <br />Configure security for the SQL Server agent <br />Manage alerts and notifications <br />Administer SQL Server using PowerShell <br />Monitor and troubleshoot a SQL Server infrastructure <br />Import and export data <br />20765 Provisioning SQL Databases <br />Description <br />