MCSE: SQL Server 2012 Bundle
- Offered byXLNC
MCSE: SQL Server 2012 Bundle at XLNC Overview
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
MCSE: SQL Server 2012 Bundle at XLNC Course details
- For IT Professionals wanting to learn the new SQL 2012 technologies and prepare for the relevant Microsoft SQL exams
- 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