Microsoft 70-465: Designing Database Solutions for Micros...
4.5 (5 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.
95 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft 70-465: Designing Database Solutions for Micros... to your Wishlist.

Add to Wishlist

Microsoft 70-465: Designing Database Solutions for Micros...

Designing Database Solutions for Microsoft SQL Server 2012
4.5 (5 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.
95 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:
  • 6 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-465 Designing Database Solutions for Microsoft SQL Server 2012
  • Passing this exam validates a candidate’s ability to create and alter tables,design, implement, and troubleshoot security, collect performance and system information and realted activities.
View Curriculum
Requirements
  • Database professionals having basic understaning of designing and building database solutions
Description

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


This course is designed for Database professionals who design and build database solutions. These Database professionals are responsible for the creation of plans and designs for Database structure, storage, objects, and servers, as well as creating the plan for the environment in which the database solution runs. Primary responsibilities may include but are not limited to designing:

  • Data compression strategies
  • Database models
  • Full-Text Search strategies
  • High-availability solutions
  • Maintenance strategy for database servers
  • Management automation strategies
  • Migration, consolidation, and upgrade strategies
  • Database, schema, and object security parameters

This training course on designing database solutions for Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-465:

  • 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
  • Anyone aspiring to be Microsoft certification
Students Who Viewed This Course Also Viewed
Curriculum For This Course
186 Lectures
05:55:50
+
Designing Database Solutions for Microsoft SQL Server 2012
2 Lectures 01:43

Course Modules
00:40
+
Introduction to SQL Server 2012
16 Lectures 42:41
Introduction Part1
00:08

Introduction Part2
00:54

SQL Server Instances
05:50

SQL Server Editions and Licensing
03:18

SQL Server Objects
01:19

System Databases
03:26

SQL Server Management Studio
01:25

SSMS Components Part1
04:58

SSMS Components Part2
02:14

SQL Server Data Tools
01:00

SQLCMD
03:28

Working with SSMS Part1
04:18

Working with SSMS Part2
01:44

Working with SQLCMD
03:35

Exam Scenarios
03:56

Module Review
01:08
+
Introduction to Databases
19 Lectures 42:17
Introduction Part1
00:08

Introduction Part2
02:39

Database Files Part1
01:33

Database Files Part2
01:52

Temp db
01:44

Working with Databases
03:49

Introduction to Filegroups and Files Part1
00:04

Introduction to Filegroups and Files Part2
02:44

Introduction to Log Files
02:17

Transactions
02:24

Moving Databases
01:32

Detaching and Attaching Databases
01:55

Backing Up and Restoring Databases
01:23


Database Catalog View
02:22

Creating and Configuring Databases Part1
05:51

Creating and Configuring Databases Part2
04:57

Exam Scenarios
02:25

Module Review
01:22
+
Introduction to Data Types and Tables
24 Lectures 51:21
Introduction Part1
00:07

Introduction Part2
00:13

Supported Data Types
06:49

Collations and Unicode Characters Part1
01:33

Collations and Unicode Characters Part2
01:00

Introduction to NULLS
00:57

Converting Data Types
01:58

Introduction to Tables Part1
00:10

Introduction to Tables Part2
03:30

Normalization
03:20

Temporary Tables
02:09

Working with Tables
01:49

Schemas
02:08

Primary and Foreign Keys Part1
01:11

Primary and Foreign Keys Part2
02:19

Primary and Foreign Keys Part3
01:01

UNIQUE Constraint/Index
01:07


Data Types in SQL Server Demonstration Part2
02:17

Working with Tables Demonstration Part1
05:12

Working with Tables Demonstration Part2
02:58

Exam Scenarios Part1
01:12

Exam Scenarios Part2
01:11

Module Review
01:33
+
SQL Server Indexing
20 Lectures 43:01
Introduction Part1
00:07

Introduction Part2
01:10

Introduction to Indexing
01:47

Heaps
01:01

Clustered Indexes
04:38

Non-Clustered Indexes Part1
02:10

Non-Clustered Indexes Part2
02:42

Non-Clustered Indexes Part3
02:07

Maintaining Indexes Part1
00:06

Maintaining Indexes Part2
02:55

Index Fragmentation
02:56

SQL Server Profiler
01:22

Index Tuning
00:44

Working with Indexes Demonstration Part1
04:40

Working with Indexes Demonstration Part2
02:08

Working with Indexes Demonstration Part3
03:16

SQL Server Tuning Advisor Demonstration Part1
04:58

SQL Server Tuning Advisor Demonstration Part2
01:09


Module Review
01:06
+
Performance Considerations
13 Lectures 26:13
Introduction Part1
00:08

Introduction Part2
00:44

Partitioning Function
00:54

Partition Scheme
00:17

Partitioned Table or Index
01:46

Introduction to Transaction
01:18

Implicit and Explicit Transactions
02:53

Locking
03:45

Working with Partition Tables, Transaction & Locks Part1
05:19

Working with Partition Tables, Transaction & Locks Part2
02:26

Working with Partition Tables, Transaction & Locks Part3
03:48

Exam Scenarios
02:18

Module Review
00:37
+
Backup and Restore
27 Lectures 38:12
Introduction Part1
00:09

Introduction Part2
00:27

Database Data and Log Files Part1
01:11

Database Data and Log Files Part2
00:40

Recovery Model
02:23

Database Backups Types Part1
01:02

Database Backups Types Part2
00:59

Database Backups Types Part3
01:27

Database Backups Types Part4
00:51

Database Backups Types Part5
01:05

Backup Compression and Mirrored Media Sets
00:57

Verifying Backups
00:46

Restoration Process
00:49

Restoring Backup Types Part1
01:27

Restoring Backup Types Part2
00:44

Restoring Backup Types Part3
00:19

Restoring to a Point in Time
01:10


Restoring a Database
00:40

Restoring System Databases
01:44

Restoring the Master Database
00:20


Backing Up and Restoring SQL Server Part2
02:59

Backing Up and Restoring SQL Server Part3
03:00

Backing Up and Restoring SQL Server Part4
02:46

Exam Scenarios
03:26

Module Review
00:59
+
Views and Functions
15 Lectures 32:54
Introduction Part1
00:09

Introduction Part2
00:09

Introduction Part3
00:43

Types Of Views
01:21

Creating and Altering Views
03:50

Updatable and Indexed Views
03:43

Partitioned Views
01:12

Introduction to Functions
00:30

Function Types
01:01

Scalar and Table Valued Functions
02:29

Working with Views and Functions Part1
06:06

Working with Views and Functions Part2
03:51

Working with Views and Functions Part3
03:09

Exam Scenarios
03:20

Module Review
01:21
+
Stored Procedures and Triggers
17 Lectures 28:05
Introduction Part1
00:08

Introduction Part2
00:14

Introduction Part3
00:41

Types of Stored Procedures
01:11

Parameters
01:02


Execution Context Part1
01:31

Execution Context Part2
00:38

Introduction to Triggers Part1
00:07

Introduction to Triggers Part2
01:12

Types of Triggers
02:10

Nested and Recursive Triggers
00:51

Trigger Firing Order
00:44

Working with Stored Procedures & Triggers Part1
05:27

Working with Stored Procedures & Triggers Part2
05:52

Exam Scenarios
02:37

Module Review
01:04
+
SQL Server Security
16 Lectures 30:17
Introduction Part1
00:06

Introduction Part2
01:42

SQL Authentication
00:59

SQL Logins
01:01

Accessing a Database
01:28

Authorization Across Servers
01:47

Server Roles
02:24

Database Roles
01:11

Application Roles
00:37

Authorizing Access Part1
03:12

Authorizing Access Part2
03:13


Working with SQL Security Part1
03:53

Working with SQL Security Part2
03:44

Exam Scenarios
02:35

Module Review
01:03
1 More Section
About the Instructor
iCollege Certifications
4.1 Average rating
1,676 Reviews
11,257 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,628 Reviews
274,817 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.