Premium

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

Online

$ 301 + IVA

*Precio estimado

Importe original en GBP:

£ 229

  • Tipología

    Curso

  • Nivel

    Intermediate

  • Metodología

    Online

  • Inicio

    Fechas a escoger

  • Campus online

  • Envío de materiales de aprendizaje

  • Servicio de consultas

  • Clases virtuales

Descripción

"This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around Developing Microsoft SQL Server 2012 Databases.

This course is designed for Database developers who build and implement databases across the organization, while ensuring high levels of data availability. They perform tasks including creating database files, create data types, tables, plan create and optimize indexes, implement data integrity, implement views, stored procedures and functions, manage transactions and locks. Primary responsibilities may include:

Optimizing and tuning queries.
Creating and altering indexes and stored procedures.
Maintaining database integrity.
Optimizing indexing strategies.
Creating and altering tables.
Maintaining indexes.
Creating and modifying constraints."

Información importante

¿Qué objetivos tiene esta formación?: This training course on developing Microsoft SQL Server 2012 Databases prepares participants for the Microsoft Exam 70-464.

This course will provide all the skills and knowledge for the following areas:

Creating and altering tables (complex statements)
Designing, implementing, and troubleshooting security
Designing the locking granularity level
Maintaining indexes
Implementing data types
Creating and modifying constraints (complex statements)
Working with XML Data
Writing automation scripts
Designing and implementing stored procedures
Designing T-SQL table-valued and scalar functions
Creating, using, and altering user-defined functions (UDFs)
Creating and altering views (complex statements)
Designing tables
Designing for concurrency
Creating and altering indexes
Designing data integrity
Designing for implicit and explicit transactions
Optimizing and tuning queries
Troubleshooting and resolving performance problems
Optimizing indexing strategies
Capturing and analyzing execution plans
Collecting performance and system information

Instalaciones y fechas

Ubicación

comienzo

Online

comienzo

Fechas a escoger Matrícula abierta

¿Qué aprendes en este curso?

  • Networking
  • Transactions
  • Windows
  • Server
  • Office IT
  • Database
  • SQL
  • Database training
  • DNS
  • Proxy
  • Active Directory
  • Rights Management
  • Pilot
  • Ms Office
  • Install

Temario

Syllabus:

Module 1
  • Introduction to SQL Server 2012
  • SQL Instances
  • SQL Editions
  • SQL Server Tools
  • SQL Server Management Studio
  • SQL Data Tools
  • SQL Command
  • Utilizing SQL Server Tools
  • Exam Scenarios
  • Module Review
Module 2
  • Introduction to Data Types and Tables
  • Collations
  • Unicode Characters
  • Null Values
  • Converting Data Types
  • Introduction to Tables
  • Normalization
  • Temporary Tables
  • Working with Tables
  • Schemas
  • Primary and Foreign Keys
  • UNIQUE Constraint/Index
  • In Depth Look
  • Exam Scenarios
  • Module Review
Module 3
  • SQL Server Indexing
  • Introduction to Indexing
  • Clustered Indexes
  • Non Clustered Indexes
  • Maintaining Indexes
  • Index Fragmentation
  • Index Tuning
  • Creating and Altering Indexes
  • Exam Scenarios
  • Module Review
Module 4
  • Query Performance
  • Execution Plans
  • Reading Execution Plans
  • Execution Plan Operators
  • Plan Reuse
  • Query Performance
  • Exam Scenarios
  • Module Review
Module 5
  • Common Language Runtime (CLR) Integration
  • Assemblies
  • Permissions
  • CLR Objects
  • Integrating the CLR within SQL Server
  • Exam Scenarios
  • Module Review
Module 6
  • Transact-SQL (T-SQL) Error Handling
  • Error Severity
  • TRY CATCH Error Handling
  • TRY PARSE and TRY CONVERT
  • @@ ERROR
  • Alerts
  • Error Handling in T-SQL
  • Exam Scenarios
  • Module Review
Module 7
  • Views and Functions
  • Types of Views
  • Working with Views
  • Introduction to Functions
  • Working with Functions
  • Working with Views and Functions
  • Exam Scenarios
  • Module Review
Module 8
  • Stored Procedures and Triggers
  • Working with Stored Procedures
  • Introduction to Triggers
  • Working with Triggers
  • Stored Procedures and Triggers Demo
  • Exam Scenarios
  • Module Review
Module 9
  • Working with XML
  • XML Concepts
  • Schemas and Schema Collections
  • FOR XML Clause
  • FLOWR Queries
  • Working with XML in SQL Server
  • Exam Scenarios
  • Module Review
Module 10
  • Transactions
  • Implicit Transactions
  • Explicit Transactions
  • Locking
  • Working with Transactions and Locking within SQL
  • Exam Scenarios
  • Module Review 
$ 301 + IVA

*Precio estimado

Importe original en GBP:

£ 229