28

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-364Vezi Calendar

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-761Vezi Calendar
20762Developing SQL Databases 40 ore750 EURO70-762Vezi Calendar

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-764Vezi Calendar
20765Provisioning SQL Databases 24 ore 550 EURO70-765Vezi Calendar

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-767Vezi Calendar
20768Developing SQL Data Models 24 ore 550 EURO70-768Vezi Calendar

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-461Vezi Calendar
20462Administering Microsoft SQL Server® 2014 Databases40 ore750 EURO70-462Vezi Calendar
20463Implementing a Data Warehouse with Microsoft SQL Server40 ore750 EURO70-463Vezi Calendar
20464DDeveloping Microsoft SQL Server Databases40 ore750 EURON/AVezi Calendar

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/AVezi Calendar

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

Aplica pentru acest curs

Te rugam sa completezi formularul pentru a rezerva un loc la acest curs:

Invalid Input
Invalid Input
Invalid Input
Invalid Input
Invalid Input
Invalid Input
Invalid Input
Invalid Input