28

CURSURI OFICIALE MICROSOFT SQL SERVER ( MOC )

CURSURI OFICIALE MICROSOFT SQL SERVER ( MOC )

PRETUL INCLUDE SUPORTUL DE CURS OFICIAL MICROSOFT IN FORMAT ELECTRONIC, COFFEE-BREAK, MASA DE PRANZ LA RESTAURANT SI DIPLOMA MICROSOFT RECUNOSCUTA INTERNATIONAL
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 550 EURO 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 750 EURO 70-761 13.05.2019
20762 Developing SQL Databases 40 ore 750 EURO 70-762 27.05.2019

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 750 EURO 70-764 N/A
20765 Provisioning SQL Databases  24 ore  550 EURO 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 750 EURO 70-767 N/A
20768 Developing SQL Data Models  24 ore  550 EURO 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 750 EURO 70-461 N/A
20462 Administering Microsoft SQL Server® 2014 Databases 40 ore 750 EURO 70-462 N/A
20463 Implementing a Data Warehouse with Microsoft SQL Server 40 ore 750 EURO 70-463 N/A
20464D Developing Microsoft SQL Server Databases 40 ore 750 EURO 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 750 EURO 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

Bonus: Un voucher de 10% discount pentru al 2 lea curs achizitionat

Discount de volum:

• 7-8 participanti/ grupa - 5 % discount la pretul de lista

• 9-10 participanti/ grupa - 10 % discount la pretul de lista

• >10 participanti/ grupa - pretul se negociaza

RECOMANDARI DIN PARTEA CLIENTILOR

Microsoft-recomandation
Rec-fundatie-excel
Rec-fundatie
Recomandare-Microsoft
rec-bcr
rec-informatica-feroviara
rec-kaufland
rec-ministerul-justitiei
recomandare-acvatot
recomandare-bcr
recomandare-brd
recomandare-cez
recomandare-ejot
recomandare-hydroelectrica
recomandare-infineon
recomandare-ing
recomandare-radix
recomandare-timex
recomandare-umf
recomandare-voluntari