OEM Office Elearning Menu

70-464 Developing Microsoft SQL Server 2012 Databases OEM Certkit

Algemene informatie over de cursus

The Training 70-464 Developing Microsoft SQL Server 2012 Databases through a Special Certification Package. 1 Year access to revolutionary E-learning to pass the exam Easily. Get Introduced by Learning through 1 Learning Portal (LMS) with Certified Teachers. Exclusive 24/7 Online Mentor and Challenging Course Testing and View behind the scenes all Tips & Tricks.
Always guaranteed the Official Test Exam and after the Training an Official Certificate of Participation. Optional Livelabs (extra charge).

Delivery time: Within 1 working day
Online access: Standard 12 months
Lesson duration: variable
Study load: Variable because of practical assignments.
Learning methods: Instruction video, Demonstration video, Knowledge Base
Operating systems: Microsoft Windows, Google Chrome OS, Apple MacOS
Included services: Contact with teacher by e-mail and chat, Progress report, 24/7 online access
Supported browsers: Internet Explorer, Edge, Firefox, Safari en Chrome
Certification: Possible for corresponding exam number
Access to teacher: By e-mail and chat
Extra options: Virtual Labs (if available)

Inhoud van de cursus

SQL Server 2012 Developing Databases: Implementing Tables (Update Avail.)
Course: 1 Hour, 48 Minutes

Designing Tables and Data Integrity in SQL Server 20122
Using Data Types in SQL Server 20122
Creating Tables in SQL Server 20121

SQL Server 2012 Developing Databases: Implementing Indexes (Update Avail.)
Course: 1 Hour, 31 Minutes

Designing an Index Strategy in SQL Server 2012
Designing Effective Indexes in SQL Server 2012
Creating Indexes in SQL Server 2012

SQL Server 2012 Developing Databases: Stored Procedures (Update Avail.)
Course: 1 Hour, 30 Minutes

Designing Stored Procedures in SQL Server 2012
Creating Stored Procedures in SQL Server 2012
Using Table Valued Parameters in SQL Server 2012

SQL Server 2012 Developing Databases: CLR Integration (Update Avail.)
Course: 1 Hour, 30 Minutes

Overview of CLR Integration in SQL Server 2012
Implementing CLR Functions and Types in SQL Server 2012
Implementing SQL CLR Stored Procedures and Triggers

SQL Server 2012 Developing Databases: Working with Data (Update Avail.)
Course: 1 Hour, 42 Minutes

Overview of CLR Integration in SQL Server 2012
Implementing CLR Functions and Types in SQL Server 2012
Implementing SQL CLR Stored Procedures and Triggers

SQL Server 2012 Developing Databases: Working with XML Data (Update Avail.)
Course: 1 Hour, 49 Minutes

XML Schemas and Namespaces in SQL Server 2012
Using XML Data Types and Schemas in SQL Server 2012
Implementing XML Indexes in SQL Server 2012

SQL Server 2012 Developing Databases: Optimizing Queries (Update Avail.)
Course: 1 Hour, 30 Minutes

Analyze Queries using SQL Server Profiler and DTA
Using Execution Plans to Optimize Queries
Identifying and Resolving Locks in SQL Server 2012
Using Extended Events in SQL Server 2012
Optimizing and Tuning SQL Server 2012 Queries

SQL Server 2012 Developing Databases: Troubleshooting (Update Avail.)
Course: 1 Hour, 30 Minutes

Managing Databases using Automation in SQL Server 2012
Troubleshooting Server Issues for SQL Server 2012

Microsoft SQL Server 2014 - Developing Databases: New Features
Course: 2 Hours, 6 Minutes

Course Introduction
Creating In-Memory OLTP Tables in SQL Server 2014
Troubleshooting In-Memory OLTP in SQL Server 2014

Microsoft SQL Server 2012 Developing Databases: Implementing Tables and Views
Course: 1 Hour, 48 Minutes

Monitoring In-Memory OLTP Resources in SQL Server 2014
Automating Backups using Scripts in SQL Server 20144
Designing Tables and Data Integrity in SQL Server 201223
Using Data Types in SQL Server 2012
Creating Tables in SQL Server 2012

Microsoft SQL Server 2012 Developing Databases: Implementing Indexes
Course: 1 Hour, 31 Minutes

Designing an Index Strategy in SQL Server 2012
Designing Effective Indexes in SQL Server 2012
Creating Indexes in SQL Server 2012

Microsoft SQL Server 2012 Developing Databases: Stored Procedures
Course: 1 Hour, 18 Minutes

Designing Stored Procedures in SQL Server 2012
Creating Stored Procedures in SQL Server 2012
Using Table Valued Parameters in SQL Server 2012

Microsoft SQL Server 2012 Developing Databases: CLR Integration
Course: 1 Hour, 11 Minutes

Overview of CLR Integration in SQL Server 2012
Implementing CLR Functions and Types in SQL Server 2012
Implementing SQL CLR Stored Procedures and Triggers

Microsoft SQL Server 2012 Developing Databases: Working with Data
Course: 1 Hour, 42 Minutes

Using FILESTREAM and FileTables in SQL Server 2012
Using FileTables in SQL Server 2012
Implementing Full-Text Search in SQL Server 2012
Using Full-Text Search in SQL Server 2012
Using Semantic Search in SQL Server 2012

Microsoft SQL Server 2012 Developing Databases: Working with XML Data
Course: 1 Hour, 49 Minutes

XML Schemas and Namespaces in SQL Server 2012
Using XML Data Types and Schemas in SQL Server 2012
Implementing XML Indexes in SQL Server 2012

Microsoft SQL Server 2012 Developing Databases: Tuning and Optimizing Queries
Course: 1 Hour, 30 Minutes

Analyze Queries using SQL Server Profiler and DTA
Using Execution Plans to Optimize Queries
Identifying and Resolving Locks in SQL Server 2012
Using Extended Events in SQL Server 2012
Optimizing and Tuning SQL Server 2012 Queries

Microsoft SQL Server 2012 Developing Databases: Managing and Troubleshooting
Course: 1 Hour, 30 Minutes

Managing Databases using Automation in SQL Server 2012
Troubleshooting Server Issues for SQL Server 2012

Toelatingseisen: wat heb je nodig?

Er is geen specifieke voorkennis vereist.

Duur van de cursus

variable

Bijzonderheden

Award Winning E-learning

Plaatsen / leslocaties

Heel Nederland, E-learning, Online

Gratis informatie aanvragen

Vul hieronder jouw gegevens in, dan krijg je gratis informatie toegestuurd.

  • De ingevoerde (persoons)gegevens worden door de geselecteerde opleidingsaanbieder(s) gebruikt om de gestelde vraag te beantwoorden;
  • Indien gewenst mag de onderwijsinstelling waar ik mijn aanvraag naar stuur mijn gegevens bewaren om mij van advies te voorzien;
  • Ik ben tenminste 16 jaar oud, of heb toestemming van mijn ouders of voogd om deze informatieaanvraag te verzenden;
  • De privacy statement en algemene voorwaarden van Stichting ROC.nl zijn van toepassing.