Database Querying, Administration and Warehousing on Microsoft SQL Server 2012 Postgraduate Course
Course descriptionBy the conclusion of the specified learning and development activities, delegates will be able to: Demonstrate their ability to analyse collected performance data; Illustrate how they authorise users to access particular objects; Indicate how they would provide authorisation for users to execute a code; Demonstrate their knowledge of database maintenance and how to automate the process; Demonstrate an automation of SQL Server Management; Back up databases and transaction logs. Capture activity using SQL Server Profiler and Extended Events Profiler. Capture and manage performance data. Conduct pre-installation stress testing for SQL Server. Configure credentials. Configure database mail. Configure operators, alerts and notifications. Configure permissions at the schema level; Configure Proxy accounts. Configure SQL Server Services. Construct and execute dynamic SQL with EXEC and sp_executesql. Create and manage transactions with transaction control language statements. Create dynamic packages that include variables and parameters. Create simple inline table-valued functions and write queries against them. Create simple stored procedures which encapsulate a SELECT statement. Create simple views and write queries against them. Create user-defined database roles. Debug an SSIS package. Declare and assign variables and synonyms. Deploy and upgrade Data-Tier Applications. Deploy and upgrade Data-Tier Applications. Describe batches and how they are handled by SQL Server. Describe batches and how they are handled by SQL Server. Describe BI and common BI scenarios. Describe cloud data scenarios. Describe components of well-performing queries. Describe how custom components can be used to extend SSIS. Describe how Data Quality Services can help you manage data quality. Describe how logins are authorized to access databases. Describe how multiple tables may be queried in a SELECT statement using joins. Describe how SQL Server authenticates connections. Describe how you can include custom scripts in an SSIS package. Describe key Master Data Services concepts. Describe numeric data types, type precedence and type conversions. Describe options for virtualizing SQL Server. Describe options for virtualizing SQL Server. Describe SQL Azure. Describe SQL Server's behavior when errors occur in T-SQL code. Describe SSIS deployment. Describe the architecture and editions of SQL Server 2012; Describe the basic features of SQL Azure; Describe the benefits to using window functions; Describe the considerations for implementing an incremental extract, transform, and load (ETL) solution.