Microsoft 70-464 Developing Microsoft SQL Server 2012 Da...
4.0 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
129 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft 70-464 Developing Microsoft SQL Server 2012 Da... to your Wishlist.

Add to Wishlist

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

Developing Microsoft SQL Server 2012 Databases
4.0 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
129 students enrolled
Last updated 12/2016
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • IT professionals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
140 Lectures
04:59:00
+
Developing Microsoft SQL Server 2012 Databases
2 Lectures 01:17

Course Modules
00:48
+
Module 1
13 Lectures 34:07
Introduction to SQL Server 2012 Part1
00:09

Introduction to SQL Server 2012 Part2
00:36

SQL Instances
04:05

SQL Editions
05:31

SQL Server Tools
00:19


SQL Data Tools
00:37

SQL Command
01:16

Utilizing SQL Server Tools Part1
05:40

Utilizing SQL Server Tools Part2
06:11

Exam Scenarios Part1
00:48

Exam Scenarios Part2
01:54

Module Review
00:51
+
Module 2
23 Lectures 51:30
Introduction to Data Types and Tables Part1
00:15

Introduction to Data Types and Tables Part2
02:03

Introduction to Data Types and Tables Part3
01:40

Collations
01:22

Unicode Characters
00:45

Null Values
00:51

Converting Data Types
02:27

Introduction to Tables Part1
00:13

Introduction to Tables Part2
03:22

Normalization
02:22

Temporary Tables
01:49

Working with Tables
01:41

Schemas
01:59

Primary and Foreign Keys Part1
00:07

Primary and Foreign Keys Part2
05:37

UNIQUE Constraint/Index
00:42

In Depth Look Part1
03:55

In Depth Look Part2
05:54


In Depth Look Part4
05:51

Exam Scenarios Part1
00:37

Exam Scenarios Part2
01:14

Module Review
00:40
+
Module 3
18 Lectures 41:53
SQL Server Indexing Part1
00:10

SQL Server Indexing Part2
00:45

Introduction to Indexing
03:08

Clustered Indexes
05:33

Non Clustered Indexes Part1
02:14

Non Clustered Indexes Part2
01:49

Non Clustered Indexes Part3
03:01

Non Clustered Indexes Part4
01:43

Maintaining Indexes Part1
00:06

Maintaining Indexes Part2
01:51

Index Fragmentation
04:22

Index Tuning
00:51

Creating & Altering Indexes Part1
06:01

Creating & Altering Indexes Part2
03:55

Creating & Altering Indexes Part3
03:57

Exam Scenarios Part1
00:33

Exam Scenarios Part2
01:23

Module Review
00:31
+
Module 4
11 Lectures 27:33
Query Performance Part1
00:14

Query Performance Part2
02:05

Execution Plans
03:08

Reading Execution Plans
01:17

Execution Plan Operators
01:22

Plan Reuse
02:06

Query Performance Part1
04:28

Query Performance Part2
04:25

Query Performance Part3
06:02

Exam Scenarios
01:25

Module Review
01:01
+
Module 5
9 Lectures 18:46
Common Language Runtime (CLR) Integration Part1
00:12

Common Language Runtime (CLR) Integration Part2
02:52

Assemblies
01:41


CLR Objects
04:55

Integrating the CLR within SQL Server
04:17

Exam Scenarios Part1
01:17

Exam Scenarios Part2
01:19

Module Review
00:47
+
Module 6
12 Lectures 21:41
Transact-SQL (T-SQL) Error Handling Part1
00:13

Transact-SQL (T-SQL) Error Handling Part2
02:17

Error Severity
03:20

TRY CATCH Error Handling
01:24

TRY PARSE and TRY CONVERT
00:45

@@ ERROR
00:44

Alerts
01:04

Error Handling in T-SQL Part1
04:02

Error Handling in T-SQL Part2
05:04

Exam Scenarios Part1
00:38

Exam Scenarios Part2
01:23

Module Review
00:47
+
Module 7
14 Lectures 28:59
Views and Functions Part1
00:10

Views and Functions Part2
01:00

Types of Views
01:35

Working with Views Part1
04:36

Working with Views Part2
03:03

Introduction to Functions Part1
00:11

Introduction to Functions Part2
01:20


Working with Views and Functions Part1
04:41

Working with Views and Functions Part2
03:47

Working with Views and Functions Part3
03:06

Exam Scenarios Part1
01:47

Exam Scenarios Part2
01:18

Module Review
00:36
+
Module 8
12 Lectures 26:04
Stored Procedures and Triggers Part1
00:12

Stored Procedures and Triggers Part2
02:26

Working with Stored Procedures
01:26

Introduction to Triggers Part1
00:07

Introduction to Triggers Part2
02:48

Working with Triggers
02:34

Stored Procedures & Triggers Demo Part1
05:01

Stored Procedures & Triggers Demo Part2
03:26

Stored Procedures & Triggers Demo Part3
03:32

Exam Scenarios Part1
01:08

Exam Scenarios Part2
01:45

+
Module 9
14 Lectures 26:04
Working with XML Part1
00:08

Working with XML Part2
00:31

XML Concepts Part1
01:59

XML Concepts Part2
01:20

Schemas & Schema Collections Part1
03:56

Schemas & Schema Collections Part2
01:12

FOR XML Clause Part1
00:05

FOR XML Clause Part2
03:11

FLOWR Queries
01:31

Working with XML in SQL Server Part1
05:17

Working with XML in SQL Server Part2
03:57

Exam Scenarios Part1
01:04

Exam Scenarios Part2
01:13

Module Review
00:40
1 More Section
About the Instructor
iCollege Certifications
4.1 Average rating
1,656 Reviews
11,209 Students
100 Courses
Certification Leader

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

Utilizing state of the art technologies, highly experienced consultants and innovative methodologies, we provide, cutting-edge education products, services and solutions for individuals, corporate organizations, governmental institutions and education providers.

Our collective knowledge and experience in education and training sets the standard for service delivery in learning solutions.

Stone River eLearning
4.2 Average rating
16,571 Reviews
274,362 Students
201 Courses
270,000+ Happy Udemy Students

At Stone River eLearning, technology is all we teach. If you're interested in programming, development or design - we have it covered. 

Check out our huge catalog of courses and join the over 450,000 students currently taking Stone River eLearning courses. We currently offer 100+ different technology training courses on our Stone River eLearning website and are adding new courses on hot and trending topics every month. A subscription option is available for those with a real passion for learning.