MCSA SQL Server 2012 / 70-461, 70-462, 70-463
Beschrijving
MCSA SQL Server 2012
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 the knowledge and understanding for some of these important job functions:
- Apply built-in scalar functions
- Apply ranking functions
- Combine datasets
- Creates and alters
- Design T-SQL stored procedures, views
- Implementing aggregate queries, error handling, sequence generation and data types
- Manage transactions
- Modify data by using INSERT, UPDATE, DELETE and MERGE statements
- Optimi…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
MCSA SQL Server 2012
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 the knowledge and understanding for some of
these important job functions:
- Apply built-in scalar functions
- Apply ranking functions
- Combine datasets
- Creates and alters
- Design T-SQL stored procedures, views
- Implementing aggregate queries, error handling, sequence
generation and data types
- Manage transactions
- Modify data by using INSERT, UPDATE, DELETE and MERGE
statements
- Optimizing queries
- Query data using SELECT statements and Managing XML data
- OUTPUT clause to return data
---------------------------------------------------------------------------------------------------
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. Any participants setting up database
systems and/or responsible for efficient system operation, regular
database back ups stored effectively, and securing data from
unauthorized access is also a candidate for this training course on
SQL 2012.
Below is a partial list of job functions associated to this
training course:
- Audit SQL Server instances
- Back up databases
- Configure additional SQL Server components, Instances and
Services
- Deploying a SQL Server
- Implementing strategies, columnstores and High-Availability and
Disaster Recovery solutions
- Importing/exporting
- Install SQL Server and related services.
- Maintenance
- Management, configuration, permissions, alerts, logins and
roles.
- Optimization
- Installation Planning
- Restoring
- Troubleshooting
---------------------------------------------------------------------------------------------------
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 designed for ETL and Data Warehouse Developers who
most likely focus on hands-on work creating business intelligence
(BI) solutions, including data cleansing, Extract Transform Load
(ETL), and Data Warehouse implementation. Primary responsibilities
may include:
- Mastering data using Master Data Services
- Cleansing data using Data Quality Services
- ETL Package development for data
loading/transfer/transformation
- Data Synchronization
- One-time data or application migration
- Ad-hoc data manipulations, transformations
- Scheduling ETL jobs
- Managing, configuring and deploying SQL Server Integration
Services (SSIS) packages
---------------------------------------------------------------------------------------------------
Package Includes:
- 12 Months Online Access,
Featuring OnDemand Instructor-Led Classroom Sessions
with Full Audio and Video Lectures
- Unique Course Content
- Expert-led Video Courses
- Quizzes
- Navigation & Controls
- Discussion Board
Deze bundel bestaat uit de volgende
trainingen:
- Microsoft 70-461: Querying SQL Server 2012
- Microsoft 70-462: Administering SQL Server 2012
Databases
- Microsoft 70-463: Implementing a Data Warehouse
with SQL Server 2012
Exclusief examens:
- 070-461 Querying SQL
Server 2012
- 070-462 Administering SQL Server 2012
Databases
- 070-463 Implementing a Data Warehouse with SQL
Server 2012
Datum:
U kunt ten alle tijden beginnen! Neem hiervoor
contact op met een van onze opleidingsadviseurs.
Locatie: Zelfstudie
Leermethodiek: E-Learning
Taal: Engels
Optioneel:
- Real Life Practice Labs € 585,00
(Excl. BTW)
- Examens
Deze training is ook beschikbaar als:
- Maatwerktraining, neem hiervoor contact op met een van onze
opleidingsadviseurs.
Dutchtrain "Verder niks nodig"
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.