+91 – 88617 email@example.com
[vc_row][vc_column][vc_btn title=”Request a demo” color=”success” i_icon_fontawesome=”fa fa-envelope-o” link=”url:http%3A%2F%2Fflexmind.co%2Fcontact%2F%23firstcontentcontainer|title:SQL%20Server%202012%20Administrator%20training|” add_icon=”true”][vc_facebook type=”button_count”][vc_tta_tabs][vc_tta_section title=”10776A” tab_id=”1452107506245-dea10bff-14cb”][vc_column_text]
This course introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focuses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR are also covered in this course.
Module 1: Introduction to SQL Server 2012 and its Toolset
Module 2: Working with Data Types
Module 3: Designing and Implementing Tables
Module 4: Ensuring Data Integrity through Constraints
Module 5: Planning for SQL Server 2012 Indexing
Module 6: Implementing Table Structures in SQL Server 2012
Module 7: Reading SQL Server 2012 Execution Plans
Module 8: Improving Performance through Non-clustered Indexes
Module 9: Designing and Implementing Views
Module 10: Designing and Implementing Stored Procedures
Module 11: Merging Data and Passing Tables
Module 12: Designing and Implementing User-Defined Functions
Module 13: Creating Highly Concurrent SQL Server 2012 Applications
Module 14: Handling Errors in T-SQL Code
Module 15: Responding to Data Manipulation via Triggers
Module 16: Implementing Managed Code in SQL Server 2012
Module 17: Storing XML Data in SQL Server 2012
Module 18: Querying XML Data in SQL Server
Module 19: Working with SQL Server 2012 Spatial Data
Module 20: Working with Full-Text Indexes and Queries
[/vc_column_text][/vc_tta_section][vc_tta_section title=”10775A” tab_id=”1452107506248-4f8d0d1e-84a9″][vc_column_text]
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.
Module 2: Preparing Systems for SQL Server 2012
Module 3: Installing and Configuring SQL Server 2012
Module 4: Working with Databases
Module 5: Understanding SQL Server 2012 Recovery Models
Module 6: Backup of SQL Server 2012 Databases
Module 7: Restoring SQL Server 2012 Databases
Module 8: Importing and Exporting Data
Module 9: Authenticating and Authorizing Users
Module 10: Assigning Server and Database Roles
Module 11: Authorizing Users to Access Resources
Module 12: Auditing SQL Server Environments
Module 13: Automating SQL Server 2012 Management
Module 14: Configuring Security for SQL Server Agent
Module 15: Monitoring SQL Server 2012 with Alerts and Notifications
Module 16: Performing Ongoing Database Maintenance
Module 17: Tracing Access to SQL Server 2012
Module 18: Monitoring SQL Server 2012
Module 19: Managing Multiple Servers
Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues
[/vc_column_text][/vc_tta_section][vc_tta_section title=”20465C” tab_id=”1452107688657-424a6118-0f5f”][vc_column_text]
Module 1: Introduction to Enterprise Data Architecture
Lab : Assessing an Existing Enterprise Data Infrastructure
Module 2: Multi-Server Configuration Management
Lab : Planning and Implementing Policy-Based Management
Module 3: Monitoring SQL Server 2014 Health
This module describes Data Collector and the SQL Server Utility Control Point (UCP), two features of SQL Server 2014 that enable you to perform in-depth health monitoring across the enterprise.Lessons
Lab : Monitoring SQL Server Health
Module 4: Consolidating Database Workloads with SQL Server 2014
This module provides an overview of the benefits of consolidating database workloads by using SQL Server 2014, and describes the different options for implementing a consolidation strategy. It also describes how you can manage a consolidated infrastructure in various scenarios.
Lab : SQL Server Consolidation
Module 5: Introduction to Cloud Data Solutions
Cloud computing has risen to prominence very rapidly within the world of IT, and many organizations have implemented or are planning to implement cloud-based solutions that encompass all or part of their infrastructure. This module describes some of the fundamental concepts of cloud computing and outlines how to include SQL Server 2014 in a private cloud infrastructure.
Lab : Preparing a SQL Server Installation in a Virtual Machine Template
Module 6: Introduction to Microsoft Azure
Cloud computing has risen to prominence very rapidly within the world of IT, and many organizations have implemented or are planning to implement cloud-based solutions that encompass all or part of their infrastructure. This module describes some of the fundamental concepts of cloud computing and outlines some of the important technologies, such as Microsoft Azure services, that organizations can use to build a cloud-based platform for SQL Server 2014.
Lab : Using Microsoft Azure
Module 7: Microsoft Azure SQL Database
Microsoft’s cloud platform includes Microsoft Azure SQL Database, which you can use to use SQL Server to host your databases without having to take on the responsibility of managing SQL Server itself, or the operating system that supports it. This module describes Microsoft Azure SQL Database, including how to provision it, how to implement security, how to manage databases and how to migrate databases to Microsoft Azure SQL Database.
Lab : Using Microsoft Azure SQL Database
Module 8: SQL Server in Microsoft Azure Virtual Machines
Using virtual machines in Microsoft Azure to host SQL Server instances and databases enables you to take advantage of the benefits of the cloud whilst retaining greater control over the infrastructure than you can when using Microsoft Azure SQL Database. This module explains the benefits and considerations for using virtual machines in Microsoft Azure. It also describes how to create and configure virtual machines in Microsoft Azure, and how to work with SQL Server databases in virtual machines in Microsoft Azure.
Lab : Using Microsoft Azure Virtual Machines
Module 9: Introduction to High Availability in SQL Server 2014
Maintaining highly available database services is vital in a 24 hour operating environment. SQL Server 2014 includes many features that can help organizations to deliver the levels of service they require to drive their businesses. This module explains the different ways that you can implement high availability by using SQL Server 2014. It also describes how to use log shipping to promote resilience for individual user databases.
Lab : Using Log Shipping
Module 10: Clustering with Windows Server and SQL Server 2014
SQL Server 2014 is closely integrated with the Windows Server Failover Clustering feature in Windows Server 2012 and Windows Server 2012 R2, enabling you to create enterprise-class clustering solutions that can deliver comprehensive high availability and disaster recovery solutions. This module explains how Windows Server Failover Clustering and SQL Server AlwaysOn Failover Cluster Instances work, and describes how to implement clustering to protect service availability.
Lab : Implementing an AlwaysOn Failover Cluster Instance
Module 11: AlwaysOn Availability Groups
Lab : Implementing and Testing an AlwaysOn Availability Group
Module 12: Planning High Availability and Disaster Recovery
This module describes the planning considerations for high availability and disaster recovery, and provides common implementation scenarios for on-premises, hybrid, and Microsoft Azure environments.Lessons
Lab : Planning High Availability and Disaster Recovery
Module 13: Replicating Data
SQL Server replication enables you to copy and distribute data and database objects to other computers and locations in your enterprise, which can improve availability and scalability. This module provides an overview of SQL Server replication and explains the agents used to implement replication. It also describes some common replication scenarios, how to design an appropriate replication system for your requirements, and how to monitor and troubleshoot replication.
Lab : Planning and Implementing Replication
[/vc_column_text][/vc_tta_section][vc_tta_section title=”20467C” tab_id=”1452107747010-492df508-e735″][vc_column_text]
Module 1: Planning a BI Solution
This modules discusses how to plan the components of a BI solution.
Lab : Planning a BI Solution
Module 2: Planning a BI Infrastructure
This modules explains how to plan an appropriate BI infrastructure for a given set of BI services.
Lab : Planning a BI Infrastructure
Module 3: Designing a Data Warehouse
This module explain how to design a data warehouse for a given set of user requirements.
Lab : Designing a Data Warehouse Physical Schema
Lab : Designing a Data Warehouse Logical Schema
Module 4: Designing an ETL Solution
This module explains how to design an ETL solution for a data warehouse.
Lab : Designing an ETL Solution
Module 5: Designing Analytical Data Models
This module explains how to design analytical data models for specific BI scenarios.Lessons
Lab : Comparing Analytical Data Models
Lab : Designing Data Models
Module 6: Planning a BI Delivery Solution
This module explains how to choose an appropriate delivery solution for a given scenario.
Lab : Planning a BI Delivery Solution
Module 7: Designing a Reporting Services Solution
This module explains how to design a Reporting Services solution.
Lab : Designing a Reporting Services Solution
Module 8: Designing an Excel-Based Reporting Solution
This module explains how to design a reporting solution that uses Excel.
Lab : Designing an Excel Reporting Solution
Module 9: Planning a SharePoint Server BI Solution
This module explains how to design a SharePoint BI solution.Lessons
Lab : Planning a SharePoint Server BI Solution
Module 10: Monitoring and Optimizing a BI Solution
This module explains how to monitor and optimize a BI solution.Lessons
Lab : Monitoring and Optimizing a BI Solution
Module 11: Planning BI Operations
This module explains how to plan management and maintenance operations for a BI solution.
Lab : Planning BI Operations