Microsoft 20464 – Developing Microsoft SQL Server Databases

In this course you will learn about SQL Server, logical table design, indexing, query plans and data and domain integiryt. You will also discuss about creating database objects, including views, stored procedures, parameters and functions. Other topics discussed in this course include procedure coding like indexes, concurrency, error handling, triggers and SQL Common Language Runtime.

Cui i se adresează?

This course is aimed at IT professionals that want to learn more about SQL Server 2014 product features and technologies for implementing a database.

Ce veți învăța?

Upon completion you will know how to:

  • SQL Server platform tools including editions, versions, basics of network listeners, and concepts of services and service accounts
  • Appropriate data types used when designing tables, convert data between data types, and create alias data types
  • Design practices regarding SQL Server tables and create tables using T-SQL (partitioned tables not covered in this course)
  • Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK, and UNIQUE constraints
  • Investigate cascading FOREIGN KEY constraints
  • Appropriate single column and composite index strategies
  • Create tables as heaps, tables with clustered indexes, and appropriate structure for table designs
  • Common elements from execution plans
  • Design effective non-clustered indexes
  • Design and implement views and stored procedures
  • Work with table types and table-valued parameters
  • Use MERGE to create stored procedures that update data warehouses
  • Design and implement scalar and table-valued functions
  • Investigate deadlock situation and how transaction isolation levels affect application concurrency
  • T-SQL error handling code and structured exception handling
  • Design and implement data manipulation language (DML) triggers
  • SQL CLR integration and implement existing .NET assembly within SQL Server
  • Store Extensible Markup Language (XML) data and schemas in SQL Server
  • Basic queries on XML data in SQL Server
  • GEOGRAPHY and GEOMETRY data types
  • Implement and query a full-text index
Cerințe preliminare:

Students need to have:

  • Knowledge of writing T-SQL queries
  • Knowledge of basic relational database concepts
Agenda cursului:

Materialele de curs sunt în limba Engleză. Predarea se face în limba Română.

Este recomandat să continui cu:

Implementing a Data Warehouse with Microsoft SQL Server (M20463)
Designing a Data Solution with Microsoft SQL Server (M20465)
Implementing Data Models and Reports with Microsoft SQL Server (M20466)

Programe de certificare

MCSE: Data Platform

Detalii curs

Durată
5
zile

Preț
800
EUR

Modalități de livrare
Predare în clasă, Clasă hibridă, Clasă virtuală
Nivel de specializare
3. Professional
Într-o economie bazată pe cunoaștere, educarea și instruirea angajaților reprezintă o investiție în vederea obținerii unei performanțe îmbunătățite pe termen scurt, precum și a succesului pe termen lung al organizației.
DORESC SĂ MĂ ÎNSCRIU LA CURS

Vă rog să mă contactați:

Meniu