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.
CodDescriereDurataPret (fara TVA)Examen aferentData urmatorului curs
40364Database Administration Fundamentals24 ore550 EURO98-364N/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.
CodDescriereDurataPret (fara TVA)Examen aferentData urmatorului curs
20761Querying Data with Transact-SQL40 ore750 EURO70-761N/A
20762Developing SQL Databases40 ore750 EURO70-762N/A
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

CodDescriereDurataPret (fara TVA)Examen aferentData urmatorului curs
20764Administering a SQL Database Infrastructure 40 ore750 EURO70-764N/A
20765Provisioning SQL Databases 24 ore 550 EURO70-765N/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

CodDescriereDurataPret (fara TVA)Examen aferentData urmatorului curs
20767Implementing a SQL Data Warehouse 40 ore750 EURO70-767N/A
20768Developing SQL Data Models 24 ore 550 EURO70-768N/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.
CodDescriereDurataPret (fara TVA)Examen aferentData urmatorului curs
20461Querying Microsoft SQL Server 201440 ore750 EURO70-461N/A
20462Administering Microsoft SQL Server® 2014 Databases40 ore750 EURO70-462N/A
20463Implementing a Data Warehouse with Microsoft SQL Server40 ore750 EURO70-463N/A
20464DDeveloping Microsoft SQL Server Databases40 ore750 EURON/AN/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

CodDescriereDurataPret (fara TVA)Examen aferentData urmatorului curs
MOC 20466DImplementing Data Models and Reports with SQL Server 201440 ore750 EURON/AN/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