Sun, 14 Jun, 2020 at 07:00 pm - Fri, 14 Jun, 2030 at 10:00 pm
Google Calendar
Outlook Calendar
iCal Calendar
Yahoo Calendar
Online
About the event
Microsoft MCSA SQL Server 2012 Training
sql server performance Online Training
About this Event
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
