Skillsoft
Skillsoft Logo

Microsoft Certified Solutions Associate - MCSA SQL Server 2012/2014 

  • Offered bySkillsoft

Microsoft Certified Solutions Associate - MCSA SQL Server 2012/2014
 at 
Skillsoft 
Overview

Duration

51 hours

Total fee

37,220

Mode of learning

Online

Difficulty level

Intermediate

Credential

Certificate

Microsoft Certified Solutions Associate - MCSA SQL Server 2012/2014
 at 
Skillsoft 
Highlights

  • Unlimited Mentor Support- Chat & Email, Unlimited Mock Exam attempts
  • 400mn+ users & used by Professionals in 70% of Fortune 500 companies
Details Icon

Microsoft Certified Solutions Associate - MCSA SQL Server 2012/2014
 at 
Skillsoft 
Course details

Who should do this course?
  • Anyone interested in earning Microsoft certified solution associate has various options like desktop infrastructure, business intelligence, server infrastructure, private cloud and sharepoint.
What are the course deliverables?
  • Unlimited Access to Online Content for six months
  • Course Completion certificate - renowned globally
  • 400mn+ users, World's No 1 & trained 70% of Fortune 500 companies
  • Career boost for students and professionals
  • Content aligned with Microsoft
  • Unlimited Mentor Support via chat and E-mail
  • Unlimited mock test attempts
More about this course
  • SQL server is a robust system that offers an array of objects to store and view data. You can enrich your knowledge and expertise in designing, maintaining and building the database and information solutions. To meet business needs, administrators and developers must know how to create, design and configure the database objects. These include views to enable access to the data in specific tables, storing data in the database and indexes to optimize the performance of the database. The course classifies each of these database objects and shows the steps needed to create them using transact SQL statements. This would be of value to IT experts and organizations.

Microsoft Certified Solutions Associate - MCSA SQL Server 2012/2014
 at 
Skillsoft 
Curriculum

Querying Microsoft SQL Server 2012

Microsoft SQL Server 2012: Creating Database Objects

Microsoft SQL Server 2012: Querying Basics and Modifying Data

Microsoft SQL Server 2012: Manipulate Data Using Operators and Functions

Microsoft SQL Server 2012: Creating Functions and Triggers

Microsoft SQL Server 2012: Creating Programming Objects and Optimizing Queries

Microsoft SQL Server 2012: Managing XML Data

Administering Microsoft SQL Server 2012 Databases

Microsoft SQL Server 2012: Installation and Upgrade

Microsoft SQL Server 2012: Instance Configuration and Database Creation

Microsoft SQL Server 2012: Managing Databases and Automating Tasks

Microsoft SQL Server 2012: Security Management

Microsoft SQL Server 2012: Managing Database Data

Microsoft SQL Server 2012: Managing Indexes, Full-Text Search and Partitions

Microsoft SQL Server 2012: Backing Up and Restoring Databases

Microsoft SQL Server 2012: Database Monitoring and Performance Tuning

Microsoft SQL Server 2012: Configuring High Availability

Implementing a Data Warehouse with Microsoft SQL Server 2012

Microsoft SQL Server 2012: Implementing a Data Warehouse: Design and Deployment

Microsoft SQL Server 2012: Implementing a Data Warehouse: Create Basic Packages

Microsoft SQL Server 2012: Implementing a Data Warehouse: ETL Solutions

Microsoft SQL Server 2012: Implementing a Data Warehouse: Enhancing Packages

Microsoft SQL Server 2012: Implementing a Data Warehouse: Custom Components

Microsoft SQL Server 2012: Implementing a Data Warehouse: Installing SSIS

Microsoft SQL Server 2012: Implementing a Data Warehouse: Troubleshooting

Microsoft SQL Server 2012: implementing a Data Warehouse: DQS and MDS Solutions

Other courses offered by Skillsoft

5.03 K
6 hours
Intermediate
6.01 K
3 hours
Intermediate
6.01 K
3 hours
Intermediate
11.83 K
1 hours
Intermediate
View Other 249 CoursesRight Arrow Icon
qna

Microsoft Certified Solutions Associate - MCSA SQL Server 2012/2014
 at 
Skillsoft 

Student Forum

chatAnything you would want to ask experts?
Write here...