Microsoft MCSA SQL Server 2012 Training
sql server performance Online Training
By Skill Enhance Virtual Training PVT LTD
Date and time
June 14, 2020 · 6:30am - June 14, 2030 · 9:30am PDT
Location
Online
Refund Policy
Contact the organizer to request a refund.
About this event
- 3652 days 3 hours
Microsoft MCSA SQL Server 2012 Training
The Server 2012 Training delivers the technical skills to handle Microsoft database. It covers the installation, administration, maintenance and troubleshooting of the database. The candidates will learn about data warehousing in detail in this training. The comprehensive knowledge and practical exposure of the database concept builds the proficiency of the professionals to serve the organizations of any size.
- Course 10774A: Querying Microsoft SQL Server 2012
- Course 10775A: Administering Microsoft SQL Server 2012 Databases
- Course 10777A: Execute a Data Warehouse with Microsoft SQL Server 2012
Course 10774A: Querying Microsoft SQL Server 2012
- Introduction to Microsoft SQL Server 2012
- Getting Started with SQL Azure
- Introduction to T-SQL Querying
- Writing SELECT Queries
- Querying Multiple Tables
- Sorting and Filtering data
- Working with SQL Server 2012 Data types
- Using Built-In functions
- Grouping and Aggregating
- Using Subqueries
- Using Table Expressions
- Using Set Operators
- Using Window Ranking, Offset and Aggregate Functions
- Pivoting and Grouping Sets
- Querying SQL Server Metadata
- Executing Stored Procedures
- Programming with T-SQL
- Execute Error Handling
- Execute Transactions
- Improving Query Performance
Course 10775A: Administering Microsoft SQL Server 2012 Databases
- Introduction to SQL Server 2012 and its Toolset
- Preparing Systems for SQL Server 2012
- Installing and Configuring SQL Server 2012
- Working with Databases
- Understanding SQL Server 2012 Recovery Models
- Backup of SQL Server 2012 Databases
- Restoring SQL Server 2012 Databases-
- Importing and Exporting Data
- Authenticating and Authorizing Users
- Assigning Server and Database Roles
- Authorizing Users to Access Resources
- Auditing SQL Server Environments
- Automating SQL Server 2012 Management
- Configuring Security for SQL Server Agent
- Monitoring SQL Server 2012 with Alerts and Notifications
- Performing Ongoing Database Maintenance
- Tracing Access to SQL Server 2012
- Monitoring SQL Server 2012
- Managing Multiple Servers
- Troubleshooting Common SQL Server 2012 Administrative Issues
Course 10777A: Execute a Data Warehouse with Microsoft SQL Server 2012
- Introduction to Data Warehousing
- Data Warehouse Hardware
- Designing and Execute a Data Warehouse
- Creating an ETL Solution with SSIS
- Execute Control Flow in an SSIS Package
- Debugging and Troubleshooting SSIS Packages
- Execute an Incremental ETL Process
- Integrate Data from the Cloud into a Data Warehouse
- Enforcing Data Quality
- Using Master Data Services
- Extending SQL Server Integration Services
- Deploying and Configuring SSIS Packages
- Consuming Data in a Data Warehouse