XLNC
XLNC Logo

MCSE: SQL Server 2012 Bundle 

  • Offered byXLNC

MCSE: SQL Server 2012 Bundle
 at 
XLNC 
Overview

In high-growth industries, entry-level employees with a Microsoft Certified Solutions Associate (MCSA) certification can annually earn up to $16,000 more than their non-certified peers

Total fee

1,999

Mode of learning

Online

Credential

Certificate

MCSE: SQL Server 2012 Bundle
 at 
XLNC 
Highlights

  • Earn a certificate of completion from XLNC
Details Icon

MCSE: SQL Server 2012 Bundle
 at 
XLNC 
Course details

Skills you will learn
Who should do this course?
  • For IT Professionals wanting to learn the new SQL 2012 technologies and prepare for the relevant Microsoft SQL exams
More about this course
  • Obtaining an MCSE: SQL Server 2012 certification will qualify you for such jobs as database analyst and database designer
  • It demonstrates broad skill sets in building and administrating enterprise-scale data solutions both on-premises and in cloud environments

MCSE: SQL Server 2012 Bundle
 at 
XLNC 
Curriculum

Mcse : SQL server 2012 bundle (exam 70-461)

Introduction

Getting set up

Sql server 2012 management studio

Creating database objects

Basic select queries

More advanced select statements

Sql server 2012 data types

Using joins

Querying metadata

Inserts / updates / deletes

Subqueries

Table expressions

Stored procedures

Functions

Transactions

Conclusion

Credits

Mcse : sql server 2012 bundle (exam 70-462)

Introduction

Improvements in 2012

Sql server 2012 essentials

Installing sql server 2012

Sql server basics

Managing sql server 2012

Automating sql server 2012

Indexes

Performance and monitoring

Sql server security

Backup / recovery / availability

Scripting sql server 2012

Conclusion

Credits

Mcse : sql server 2012 bundle (exam 70-463)

Welcome

Getting set up

Data warehouse basics

Creating a data warehouse

Data flow using ssis

Design and implement data flow

Advanced control flow

Data services

Custom code in ssis

Deploying packages

Conclusion

Credits

Mcse : sql server 2012 bundle (exam 70-464)

Introduction

Sql server 2012 essentials

Installing sql server

Sql server basics

Working with tables

Indexes

Programming objects

Concurrency and locking

Optimization

Working with xml data

Conclusion

Credits

Mcse : sql server 2012 bundle (exam 70-465)

Welcome

Sql server 2012 essentials

Installing sql server 2012

Designing database structure

Database object design

Designing tables

Indexing

Programming objects

Database server maintenance

Monitoring performance

Designing backup & recovery

Conclusion

Credits

Other courses offered by XLNC

1.5 K
6 months
– / –
1.5 K
6 months
– / –
1.5 K
6 months
– / –
2 K
6 months
– / –
View Other 67 CoursesRight Arrow Icon
qna

MCSE: SQL Server 2012 Bundle
 at 
XLNC 

Student Forum

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