Description
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
– Online Mentor
– Measure Exam simulation
– Tips & Tricks
– Quiz
Hybrid Learning is een unieke mix van trainingsmateriaal, video’s en oefeningen die de gebruiker zelfstandig kan toepassen op zijn leervraag. U heeft tot 12 maanden lang toegang tot het online trainingsmateriaal. Zo kunt u de geleerde stof meerdere malen doorlezen en oefenen om u optimaal voor te bereiden voor de examens.
Exclusief examens:
– 070-461: Querying SQL Server 2012 – Retired
– 070-462: Administering SQL Server 2012 Databases – Retired
– 070-463: Implementing a Data Warehouse with SQL Server 2012 – Retired
DutchTrain is een officieel geaccrediteerd Test Center voor Pearson Vue Test, Prometric, Kryterion, Castle Worldwide, Certiport & PSI. U bent bij ons van harte welkom voor examens welke via deze Test Centers beschikbaar zijn. Examens kunnen elke dag, binnen kantooruren, worden afgenomen.
Datum:
U kunt ten alle tijden beginnen! Neem hiervoor contact op met een van onze opleidingsadviseurs.
Locaties: Zelfstudie
Leermethodiek: E-Learning
Taal: Engels
Deze training is ook beschikbaar als:
– Klassikaal
– Maatwerktraining, neem hiervoor contact op met een van onze opleidingsadviseurs.
Voor veelgestelde vragen tijdens het bestelproces, bekijk onze F.A.Q. pagina.
