Cursuri Oficiale Microsoft SQL Server ( MOC )

Cursuri Oficiale Microsoft SQL Server ( MOC )

*Pretul include suportul de curs oficial Microsoft, coffee-break, masa de pranz la restaurant.
Se acorda discounturi negociabile de volum. Solicita oferta speciala pentru compania ta!
Model Diploma de Absolvire

Entry level: Database

Dupa sustinerea cu succes a unuia dintre aceste examene, ti se acorda certificarea „Microsoft Technology Associate”, recunoscuta international, care atesta expertiza IT-PRO in materie.
Cod Descriere Durata Pret (fara TVA) Examen aferent Data urmatorului curs
40364 Database Administration Fundamentals 24 ore 495 EUR 98-364 N/A
Agenda curs 40364 - Database Administration Fundamentals

Module 1: Understanding Core Database Concepts
Module 2: Creating Database Objects
Module 3: Manipulating Data
Module 4: Understanding Data Storage
Module 5: Administering a Database

Associate level: MCSA: SQL 2016 Database Development

Dupa sustinerea cu succes a unuia dintre aceste examene, ti se acorda certificarea „Microsoft Certified Solutions Associate: SQL Server 2014”, recunoscuta international, care atesta expertiza IT-PRO in materie.
Cod Descriere Durata Pret (fara TVA) Examen aferent Data urmatorului curs
20761 Querying Data with Transact-SQL 40 ore 699 EUR 70-761 20.11.2017
20762 Developing SQL Databases 40 ore 699 EUR 70-762 26.02.2018
Agenda curs 20761 - Querying Data with Transact-SQL

Module 1: Introduction to Microsoft SQL Server 2016
Module 2: Introduction to T-SQL Querying
Module 3: Writing SELECT Queries
Module 4: Querying Multiple Tables
Module 5: Sorting and Filtering Data
Module 6: Working with SQL Server 2016 Data Types
Module 7: Using DML to Modify Data
Module 8: Using Built-In Functions
Module 9: Grouping and Aggregating Data
Module 10: Using Subqueries
Module 11: Using Set Operators

Agenda curs 20762 - Developing SQL Databases

Module 1: Introduction to Database Development
Module 2: Designing and Implementing Tables
Module 3: Advanced Table Designs
Module 4: Ensuring Data Integrity through Constraints
Module 5: Introduction to Indexes
Module 6: Designing Optimized Index Strategies
Module 7: Columnstore Indexes
Module 8: Designing and Implementing Views
Module 9: Designing and Implementing Stored Procedures
Module 10: Designing and Implementing User-Defined Functions
Module 11: Responding to Data Manipulation via Triggers
Module 12: Using In-Memory Tables
Module 13: Implementing Managed Code in SQL Server

Associate level: MCSA: SQL 2016 Database Administration

Cod Descriere Durata Pret (fara TVA) Examen aferent Data urmatorului curs
20764 Administering a SQL Database Infrastructure  40 ore  699 EUR 70-764 30.10.2017
20765 Provisioning SQL Databases  24 ore  495 EUR 70-765 N/A
Agenda curs 20764 - Administering a SQL Database Infrastructure

Module 1: SQL Server Security
Module 2: Assigning Server and Database Roles
Module 3: Authorizing Users to Access Resources
Module 4: Protecting Data with Encryption and Auditing
Module 5: Recovery Models and Backup Strategies
Module 6: Backing Up SQL Server Databases
Module 7: Restoring SQL Server 2016 Databases
Module 8: Automating SQL Server Management
Module 9: Configuring Security for SQL Server Agent
Module 10: Monitoring SQL Server with Alerts and Notifications
Module 11: Introduction to Managing SQL Server by using PowerShell
Module 12: Tracing Access to SQL Server with Extended events
Module 13: Monitoring SQL Server
Module 14: Troubleshooting SQL Server
Module 15: Importing and Exporting Data

Agenda curs 20765 - Provisioning SQL Databases

Module 1: SQL Server 2016 Components
Module 2: Installing SQL Server 2016
Module 3: Upgrading SQL Server to SQL Server 2016
Module 4: Deploying SQL Server on Microsoft Azure
Module 5: Working with Databases
Module 6: Database Storage Options
Module 7: Performing Database Maintenance

Associate level: MCSA: SQL 2016 Business Intelligence Development

Cod Descriere Durata Pret (fara TVA) Examen aferent Data urmatorului curs
20767 Implementing a SQL Data Warehouse  40 ore  699 EUR 70-767 N/A
20768 Developing SQL Data Models  24 ore  495 EUR 70-768 N/A
Agenda curs 20767 - Implementing a SQL Data Warehouse

Module 1: Introduction to Data Warehousing
Module 2: Planning Data Warehouse Infrastructure
Module 3: Designing and Implementing a Data Warehouse
Module 4: Columnstore Indexes
Module 5: Implementing an Azure SQL Data Warehouse
Module 6: Creating an ETL Solution
Module 7: Implementing Control Flow in an SSIS Package
Module 8: Debugging and Troubleshooting SSIS Packages
Module 9: Implementing an Incremental ETL Process
Module 10: Enforcing Data Quality
Module 11: Using Master Data Services
Module 12: Extending SQL Server Integration Services (SSIS)
Module 13: Deploying and Configuring SSIS Packages
Module 14: Consuming Data in a Data Warehouse

Agenda curs 20768 - Developing SQL Data Model

Module 1: Introduction to Business Intelligence and Data Modeling
Module 2: Creating Multidimensional Databases
Module 3: Working with Cubes and Dimensions
Module 4: Working with Measures and Measure Groups
Module 5: Introduction to MDX
Module 6: Customizing Cube Functionality
Module 7: Implementing a Tabular Data Model by Using Analysis Services
Module 8: Introduction to Data Analysis Expression (DAX)
Module 9: Performing Predictive Analysis with Data Mining

Associate level: MCSA: SQL Server 2012/2014

Dupa sustinerea cu succes a unuia dintre aceste examene, ti se acorda certificarea „Microsoft Certified Solutions Associate: SQL Server 2012/2014”, recunoscuta international, care atesta expertiza IT-PRO in materie.
Cod Descriere Durata Pret (fara TVA) Examen aferent Data urmatorului curs
20461 Querying Microsoft SQL Server 2014 40 ore 699 EUR 70-461 N/A
20462 Administering Microsoft SQL Server® 2014 Databases 40 ore 699 EUR 70-462 N/A
20463 Implementing a Data Warehouse with Microsoft SQL Server 40 ore 699 EUR 70-463 N/A
20464D Developing Microsoft SQL Server Databases 40 ore 699 EUR N/A N/A
Agenda curs 20461 - Querying Microsoft SQL Server® 2014

Module 1: Introduction to Microsoft SQL Server 2014
Module 2: Introduction to T-SQL Querying
Module 3: Writing SELECT Queries
Module 4: Querying Multiple Tables
Module 5: Sorting and Filtering Data
Module 6: Working with SQL Server 2014 Data Types
Module 7: Using DML to Modify Data
Module 8: Using Built-In Functions
Module 9: Grouping and Aggregating Data
Module 10: Using Subqueries
Module 11: Using Table Expressions
Module 12: Using Set Operators
Module 13: Using Window Ranking, Offset, and Aggregate Functions
Module 14: Pivoting and Grouping Sets
Module 15: Querying data with Stored Procedures
Module 16: Programming with T-SQL
Module 17: Implementing Error Handling
Module 18: Implementing Transactions
Module 19: Appendix 1: Improving Query Performance
Module 20: Appendix 2: Querying SQL Server Metadata

Agenda curs 20462 - Administering Microsoft® SQL Server® 2014 Databases

Module 1: Introduction to SQL Server 2014 Database Administration
Module 2: Installing and Configuring SQL Server 2014
Module 3: Working with Databases and Storage
Module 4: Planning and Implementing a Backup Strategy
Module 5: Restoring SQL Server 2014 Databases
Module 6: Importing and Exporting Data
Module 7: Monitoring SQL Server 2014
Module 8: Tracing SQL Server Activity
Module 9: Managing SQL Server Security
Module 10: Auditing Data Access and Encrypting Data
Module 11: Performing Ongoing Database Maintenance
Module 12: Automating SQL Server 2014 Management
Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications

Agenda curs 20463 - Implementing a Data Warehouse with Microsoft SQL Server

Module 1: Introduction to Data Warehousing
Module 2: Data Warehouse Hardware Considerations
Module 3: Designing and Implementing a Data Warehouse
Module 4: Creating an ETL Solution with SSIS
Module 5: Implementing Control Flow in an SSIS Package
Module 6: Debugging and Troubleshooting SSIS Packages
Module 7: Implementing an Incremental ETL Process
Module 8: Enforcing Data Quality
Module 9: Using Master Data Services
Module 10: Extending SQL Server Integration Services
Module 11: Deploying and Configuring SSIS Packages
Module 12: Consuming Data in a Data Warehouse

Agenda curs MOC 20464D - Developing Microsoft SQL Server Databases

Module 1: Introduction to Database Development

Module 2: Designing and Implementing Tables

Module 3: Ensuring Data Integrity through Constraints

Module 4: Introduction to Indexing

Module 5: Advanced Indexing

Module 6: Columnstore Indexes

Module 7: Designing and Implementing Views

Module 8: Designing and Implementing Stored Procedures

Module 9: Designing and Implementing User-Defined Functions

Module 10: Responding to Data Manipulation via Triggers

Module 11: Using In-Memory Tables

Module 12: Implementing Managed Code in SQL Server

Module 13: Storing and Querying XML Data in SQL Server

Module 14: Working with SQL Server Spatial Data

SQL Server 2014

Cod Descriere Durata Pret (fara TVA) Examen aferent Data urmatorului curs
MOC 20466D Implementing Data Models and Reports with SQL Server 2014 40 ore 699 EUR N/A N/A
Agenda curs MOC 20466D - Implementing Data Models and Reports with SQL Server 2014

Module 1: Introduction to Business Intelligence and Data Modeling

Module 2: Creating Multidimensional Databases

Module 3: Working with Cubes and Dimensions

Module 4: Working with Measures and Measure Groups

Module 5: Introduction to MDX

Module 6: Customizing Cube Functionality

Module 7: Implementing an Analysis Services Tabular Data Model

Module 8: Introduction to Data Analysis Expression (DAX)

Module 9: Implementing Reports with SQL Server Reporting Services

Module 10: Automating Report Execution and Delivery

Module 11: Delivering BI with SharePoint PerformancePoint Services

Module 12: Performing Predictive Analysis with Data Mining

Verifica data de incepere a cursului dorit si rezerva online un loc sau trimite o cerere de rezervare pentru un curs care nu are stabilita urmatoarea data de incepere.
X