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! Entry level: DatabaseDupa 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 40364 Database Administration Fundamentals 24 ore 495 EUR 98-364 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 DevelopmentDupa 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 20761 Querying Data with Transact-SQL 24 ore 495 EUR 70-761 20762 Developing SQL Databases 40 ore 699 EUR 70-762 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 Associate level: MCSA: SQL 2016 Database Administration Cod Descriere Durata Pret (fara TVA) Examen aferent 20764 Administering a SQL Database Infrastructure  40 ore  699 EUR 70-764 20765 Provisioning SQL Databases  24 ore  495 EUR 70-765 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 Associate level: MCSA: SQL 2016 Business Intelligence Development Cod Descriere Durata Pret (fara TVA) Examen aferent 20767 Implementing a SQL Data Warehouse  40 ore  699 EUR 70-767 20768 Developing SQL Data Models  24 ore  495 EUR 70-768 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