Microsoft 70-464 Developing Microsoft SQL Server 2012 Da...

Name: Microsoft 70-464 Developing Microsoft SQL Server 2012 Da...
Rating: 3.8 (42 reviews)

Developing Microsoft SQL Server 2012 Databases

Created byStone River eLearning

Last updated 12/2016

English

What you'll learn

This course will prepare you to pass the exam Microsoft 70-464 Developing Microsoft SQL Server 2012 Databases
At the end of this course, you will be able to design and implement stored procedures,Collect performance and system information and other related tasks

Course content

11 sections • 140 lectures • 4h 59m total length

Course Introduction0:29
Course Modules0:48

Introduction to SQL Server 2012 Part10:09
Introduction to SQL Server 2012 Part20:36
SQL Instances4:05
SQL Editions5:31
SQL Server Tools0:19
SQL Server Management Studio6:10
SQL Data Tools0:37
SQL Command1:16
Use the sequel command, a command line interface for sequel server, with an ole db connection to automate object creation via script and access the dedicated administrative connection for troubleshooting.
Utilizing SQL Server Tools Part15:40
Utilizing SQL Server Tools Part26:11
Exam Scenarios Part10:48
Exam Scenarios Part21:54
Module Review0:51

Introduction to Data Types and Tables Part10:15
Introduction to Data Types and Tables Part22:03
Introduction to Data Types and Tables Part31:40
Collations1:22
Unicode Characters0:45
Null Values0:51
Converting Data Types2:27
Introduction to Tables Part10:13
Introduction to Tables Part23:22
Normalization2:22
Temporary Tables1:49
Working with Tables1:41
Schemas1:59
Primary and Foreign Keys Part10:07
Primary and Foreign Keys Part25:37
UNIQUE Constraint/Index0:42
Explore how a unique constraint and a unique index enforce column uniqueness, with a constraint automatically creating an index, and note that a unique constraint allows a single null value.
In Depth Look Part13:55
In Depth Look Part25:54
In Depth Look Part36:04
In Depth Look Part45:51
Exam Scenarios Part10:37
Exam Scenarios Part21:14
Module Review0:40

SQL Server Indexing Part10:10
SQL Server Indexing Part20:45
Introduction to Indexing3:08
Clustered Indexes5:33
Non Clustered Indexes Part12:14
Non Clustered Indexes Part21:49
Non Clustered Indexes Part33:01
Non Clustered Indexes Part41:43
Maintaining Indexes Part10:06
Maintaining Indexes Part21:51
Index Fragmentation4:22
Index Tuning0:51
Creating & Altering Indexes Part16:01
Creating & Altering Indexes Part23:55
Creating & Altering Indexes Part33:57
Exam Scenarios Part10:33
Exam Scenarios Part21:23
Module Review0:31
Explore indexing concepts, including clustered and non-clustered indexes, including properties such as included columns and filtered indexes, and learn how to assess and address index fragmentation through rebuilds or reorganizations.

Common Language Runtime (CLR) Integration Part10:12
Common Language Runtime (CLR) Integration Part22:52
Assemblies1:41
Permissions1:26
Explore the default safe permission set and when to enable external access or sign the assembly. Recognize that unsafe permissions grant unrestricted access and risk SQL Server process stability.
CLR Objects4:55
Integrating the CLR within SQL Server4:17
Exam Scenarios Part11:17
Exam Scenarios Part21:19
Module Review0:47

Views and Functions Part10:10
Views and Functions Part21:00
Types of Views1:35
Working with Views Part14:36
Working with Views Part23:03
Introduction to Functions Part10:11
Introduction to Functions Part21:20
Working with Functions1:49
Working with Views and Functions Part14:41
Working with Views and Functions Part23:47
Working with Views and Functions Part33:06
Exam Scenarios Part11:47
Exam Scenarios Part21:18
Module Review0:36

Stored Procedures and Triggers Part10:12
Stored Procedures and Triggers Part22:26
Working with Stored Procedures1:26
Introduction to Triggers Part10:07
Introduction to Triggers Part22:48
Working with Triggers2:34
Stored Procedures & Triggers Demo Part15:01
Stored Procedures & Triggers Demo Part23:26
Stored Procedures & Triggers Demo Part33:32
Exam Scenarios Part11:08
Exam Scenarios Part21:45
Module Review1:39

Requirements

Basic understanding of Databases

Description

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.

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

We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.

Who this course is for:

IT professionals

Microsoft 70-464 Developing Microsoft SQL Server 2012 Da...

What you'll learn

Explore related topics

Course content

Developing Microsoft SQL Server 2012 Databases2 lectures • 1min

Module 113 lectures • 34min

Module 223 lectures • 52min

Module 318 lectures • 42min

Module 411 lectures • 28min

Module 59 lectures • 19min

Module 612 lectures • 22min

Module 714 lectures • 29min

Module 812 lectures • 26min

Module 914 lectures • 26min

Requirements

Description

Who this course is for: