Microsoft Certified Solutions Associate (MCSA) SQL Server 2012

  • E-COURSE
    E-Learning
    BUNDLE
  • 424
  • 18:28:50
Microsoft Certified Solutions Associate (MCSA) SQL Server 2012
Test scorm
Enquire Now
  • E-COURSE
  • 100
  • 04:36:55

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around implementing a Data Warehouse with Microsoft SQL Server 2012.

This course is preparation for the 70-463 exam and describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. A data warehouse collects needed data and organizes the data in a form that solves the complexities and performance issues that line-of-business applications present.

After completing this course participants will be able to:

  • Design and implement a data warehouse
  • Implement an ETL solution that supports incremental data extraction
  • Describe...read more

  • E-COURSE
  • 128
  • 06:57:14

Microsoft 70-462: Administering SQL Server 2012 Databases

This training course was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function.

The 70-462: Administering Microsoft SQL Server 2012 online training 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.

Skills Learned 

  • Installation Planning
  • Installing SQL Server and related services
  • Implementation of a migration strategy
  • How to configure additional SQL Server components
  • Managing the SQL Server Agent
  • Database management and configuration
  • How to configure SQL Server instances
  • Implementing a SQL Server clustered instance
  • SQL Server instances...read more

  • E-COURSE
  • 196
  • 06:54:41

Microsoft 70-461: Querying SQL Server 2012

This course is intended for SQL Server database administrators, implementers, system engineers, and developers. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries.

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 and is the foundation for all SQL Server-related disciplines namely, Database Administration, Database Development and Business Intelligence. The ability to work with Transact-SQL and understand the specifics of querying Microsoft SQL server is a fundamental skill. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries.

Skills Learned

  • Work with Data
  • Query data by using SELECT statements
  • Create Database Objects
  • Create and alter tables using T-SQL syntax (simple statements)
  • Create and...read more