M903 MCSA SQL Server 2012

Polaznici ovog kursa naučiće kako da konfigurišu database servere koji rade na bazi SQL Server 2012 i 2014 platformama.

Ovaj kurs omogućava polaznicima da usvoje znanje u upravljanju, funkcionisanju i održavanju SQL relacionih baza podataka, prikladno je da se koristi u poslovnim mrežama. 

Sertifikacija

Preuzmite aplikaciju ,,Microsoft Certification Guide”

Trening program je dizajniran da pripremi polaznike za polaganje 3 ispita, koji su deo MCSA SQL Server 2012 sertifikacionog puta: 

70-461: Querying Microsoft SQL Server 2012
70-462: Administering Microsoft SQL Server 2012 Databases
70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

Trajanje: 3 nedelje/ 09:00 do 17:00h

Cena: 975 €

Ovaj kurs možete pohađati online(?)     

Sledeći polasci:

Beograd
Kontaktirajte nas
Virtuelna učionica
Kontaktirajte nas
Plan obuke : 

MS20461 Querying Microsoft SQL Server

Module 1: Introduction to Microsoft SQL Server 2014

This module introduces the SQL Server platform and major tools. It discusses editions, versions, tools used to query, documentation sources, and the logical structure of databases.
  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio

Module 2: Introduction to T-SQL Querying

This module introduces Transact SQL as the primary querying language of SQL Server. It discusses the basic structure of T-SQL queries, the logical flow of a SELECT statement, and introduces concepts such as predicates and set-based operations.
  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements

Opširnije...

MS20462 Administering Microsoft SQL Server Databases

Module 1: Introduction to SQL Server 2014 Database Administration

This module introduces the Microsoft SQL Server 2014 platform. It describes the components, editions, and versions of SQL Server 2014, and the tasks that a database administrator commonly performs for a SQL Server instance.
  • Database Administration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques

Module 2: Installing and Configuring SQL Server 2014

This module explains how to assess resource requirements for SQL Server 2014 and how to install it.
  • Planning SQL Server Installation
  • Installing SQL Server 2014
  • Post-Installation Configuration

Opširnije...

MS20463 Implementing a Data Warehouse with Microsoft SQl Server

Module 1: Introduction to Data Warehousing

This module provides an introduction to the key components of a data warehousing solution and the high-level considerations you must take into account when you embark on a data warehousing project.

  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution

Module 2: Planning Data Warehouse Infrastructure

This module discusses considerations for selecting hardware and distributing SQL Server facilities across servers.
  • Considerations for Data Warehouse Infrastructure
  • Planning Data Warehouse Hardware

Opširnije...