MCSA SQL Server 2012 + MCSE Business Intelligence / 70-461, 70-462, 70-463, 70-466, 70-467

Product type
Logo DutchTrain
Provider rating: starstarstarstarstar_border 7.6 DutchTrain has an average rating of 7.6 (out of 53 reviews)

Tip: need more info about the programme or price? Request information for free!

Description

We gaan weer van start met de klassikale trainingen. Daarnaast zijn al onze klassikale trainingen ook beschikbaar in onze Dynamic Virtual Classroom. In onze Dynamic Virtual Classroom zijn zowel de docent als de cursisten zichtbaar met elkaar verbonden en kunnen documenten en beeldschermen met alle deelnemers worden gedeeld. Cursisten hebben de mogelijkheid, net zoals in een klassikale training, om zowel onderling als met de docent te communiceren en opdrachten te maken. Een actieve klassikale training maar dan op afstand.

Daarnaast zijn veel van onze trainingen ook beschikbaar als
E-Learning in onze Education On Demand Omgeving.
Deze E-Learning trainingen kunt u volgen vanaf iedere gewenste locatie, op ieder moment en heeft u 365 dagen toegang tot de online training.

Bij DutchTrain staan wij voor u klaar.

Dutchtrain "Verder niks nodig"

MCSA SQL Server 2012 + MCSE Business Intelligence

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, DELET…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft SQL Server, PL/SQL, MCSE, MCSA, and Microsoft ProClarity.

We gaan weer van start met de klassikale trainingen. Daarnaast zijn al onze klassikale trainingen ook beschikbaar in onze Dynamic Virtual Classroom. In onze Dynamic Virtual Classroom zijn zowel de docent als de cursisten zichtbaar met elkaar verbonden en kunnen documenten en beeldschermen met alle deelnemers worden gedeeld. Cursisten hebben de mogelijkheid, net zoals in een klassikale training, om zowel onderling als met de docent te communiceren en opdrachten te maken. Een actieve klassikale training maar dan op afstand.

Daarnaast zijn veel van onze trainingen ook beschikbaar als
E-Learning in onze Education On Demand Omgeving.
Deze E-Learning trainingen kunt u volgen vanaf iedere gewenste locatie, op ieder moment en heeft u 365 dagen toegang tot de online training.

Bij DutchTrain staan wij voor u klaar.

Dutchtrain "Verder niks nodig"

MCSA SQL Server 2012 + MCSE Business Intelligence

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
---------------------------------------------------------------------------------------------------

70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012 
This course is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around implementing data models and reports with Microsoft SQL Server 2012.

This course is designed for BI Developers who most-likely focus on hands-on work creating the BI solution including implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making

– Designing dimensions and measures
– Implementing and configuring dimensions in a cube
– Designing a schema to support a cube architecture
– Creating measures
– Implementing a cube
– Creating Multidimensional Expressions (MDX) queries
– Implementing custom logic in a data model
– Implementing storage design in a multidimensional model
– Selecting an appropriate model for data analysis
– Analyzing data model performance
– Processing data models
– Troubleshooting data analysis issues
– Deploying SSAS databases
– Installing and maintaining an SSAS instance
– Configuring permissions and roles in a Business Intelligence Semantic Model (BISM)
– Implementing a tabular data model
– Implementing business logic in a tabular data model
– Implementing data access for a tabular data model
– Designing a report
– Implementing a report layout
– Configuring authentication and authorization for a reporting solution
– Implementing interactivity in a report
– Troubleshooting reporting service issues
– Managing a report environment
– Configuring report data sources and datasets
---------------------------------------------------------------------------------------------------

70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012  
This course is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around designing business intelligence solutions with Microsoft SQL Server 2012.

This course is designed for BI Architects, who focus on the overall design of the BI infrastructure, including how it relates to other data systems in use.

– Module 1: Intro To Business Intelligence
– Module 2: Database Essentials
– Module 3: Business Intelligence Development
– Module 4: Business Intelligence Results
– Module 5: Advanced Reporting And Development
– Module 6: SQL Server Integration Services (SSIS)
– Module 7: SQL Server 2014 New Features
– Module 8: Course Review And Exam Prep
---------------------------------------------------------------------------------------------------

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. 

Deze certificering bestaat uit de volgende training

- 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  
- Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
- Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft 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  
- 070-466: Implementing Data Models and Reports with Microsoft SQL Server 2012 
- 070-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012  

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.

Optioneel

- Real Life Practice Labs

Datum

U kunt ten alle tijden beginnen! Neem hiervoor contact op met een van onze opleidingsadviseurs.

Locaties

Zelfstudie

Leermethodiek

E-Learning

Taal

Engels

Meer informatie

Kijk op onze website voor gedetailleerde lesinhoud, examens en meer details van deze training.

Deze traingen zijn ook beschikbaar als

- Klassikaal
- Maatwerktraining, neem hiervoor contact op met een van onze opleidingsadviseurs.

Stay up-to-date on new reviews

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Where should we send the information?

Gender
(optional)
(optional)
(optional)
(optional)
(optional)
We store your personal details, and share them with DutchTrain, in order to help you along via email and potentially via phone. You can find more info in our privacy policy.