Designing a SQL Server Database & Storage Solution (70-465)
3.9 (14 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.
364 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Designing a SQL Server Database & Storage Solution (70-465) to your Wishlist.

Add to Wishlist

Designing a SQL Server Database & Storage Solution (70-465)

Learn how to design and optimize database solutions while preparing for the Microsoft SQL Server 70-465 Exam
3.9 (14 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.
364 students enrolled
Created by LearnSmart LLC
Last updated 4/2016
English
English
Current price: $10 Original price: $200 Discount: 95% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 8 hours on-demand video
  • 253 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn how to design an infrastructure and the options you have to plan and implement along with what you have to consider when you plan your database server infrastructure.
  • Utilize important tools to help you map the progress of requirements from the business and technical teams to a physical storage and your data and your future database options.
  • Be able to create a logical model of the database. Generalize the database design and how to specialize it in hand with the concept of normalization and denormalization and when to use them.
  • Understand how you can secure servers, meet the statutory obligations, protect the organization’s assets, and maintain the expected confidentiality.
  • Learn how to use SQL Server to set up rules and configuration settings in one server.
  • Use Windows PowerShell and how it can be used to manage SQL Server and make the administrators’ jobs much easier and more efficient.
  • Prove to yourself, and others, that you are ready for Microsoft’s Developing Microsoft SQL Server Databases (70-465) certification exam with our integrated quizzes and finals.
  • Ensure business continuity by using SQL Server features for high availability and disaster recovery solutions as well as Microsoft Azure services and applications.
View Curriculum
Requirements
  • There is not any requirements for this course.
  • A computer with internet.
  • It is helpful to have a basic understanding of and interest in SQL Server 2012.
  • This is the 2nd (out of 2) Courses in our SQL Server 2012 Database Series, first is "Building and Optimizing a SQL Server Database: Microsoft 70-464" Course
  • Please review this course map to see just how we align and partner with Microsoft in providing this training: https://drive.google.com/a/getsmartertraining.com/file/d/0B-bU4vzmt_NySFFFY196ZEZqZkE/view?usp=sharing
Description

Welcome to Designing a SQL Server Database & Storage Solution: Microsoft 70-465 with LearnSmart.

The following lectures will prepare you for Microsoft SQL Server 70-465 exam, which goes toward the Microsoft Certified & Professional (MCP) and MCSE: Data Platform Solutions Expert certification. These lectures teach the principles, techniques, and tools needed to successfully prepare for and pass the “Developing Microsoft SQL Server Databases” exam.

This is the 2nd Course in our 2 Course SQL Server 2012 Database Series including:

  1. Building and Optimizing a SQL Server Database: Microsoft 70-464
  2. Designing a SQL Server Database and Storage Solution: Microsoft 70-465

Course Overview:

This course is designed to prepare the student for the Microsoft SQL Server 2012 Exam 70-465

Students will learn how to best learn how to design and build database solutions in the organization. This course covers a majority of topics that you will find on the exam, including: the creation of plans and designs for database structure, storage, objects, and servers, and how to create the plan for the environment in which the database solution runs. Learn the main exam objectives by learning these key concepts we cover:

  • Design a database structure
  • Design databases and database objects
  • Design database security
  • Design a troubleshooting and optimization solution

Our lectures are paired with a variety of demonstrations and quizzes giving visual example and real world look of the concepts that will be talked about.

Our sections listed below are can be taken in any order, as a review of a particular concept or exam domain. However, if you are just becoming familiar with SQL Server 2012 and it’s database, it is recommended that you view the sections sequentially.

Course Breakdown:

Section 1: Learn how to design an infrastructure and the options you have to plan and implement along with what you have to consider when you plan your database server infrastructure.

Section 2: Be able to create a logical model of the database. Generalize the database design and how to specialize it in hand with the concept of normalization and denormalization and when to use them.

Section 3: Utilize important tools to help you map the progress of requirements from the business and technical teams to a physical storage and your data and your future database options.

Section 4: Discuss factors that could potentially impact performance, how you can use indexes to improve performance, and how to use query plans generated by SQL Server.

Section 5: Covers how you can secure servers, meet the statutory obligations, protect the organization’s assets, and maintain the expected confidentiality.

Section 6: Learn how to use SQL Server to set up rules and configuration settings in one server, then roll them onto every other SQL Server, database, etc.

Section 7: We cover several measures and policies which are used to improve the performance of SQL Server and how the impact changes have to the SQL Server.

Section 8: Utilize Windows PowerShell and how it can be used to manage SQL Server and make the administrators’ jobs much easier and more efficient.

Section 9: We will discuss how replication can help, how you can plan and set up replication, how you may establish security for the replication, and more.

Section 10: Ensure business continuity by using Sql Server features for high availability and disaster recovery solutions as well as Microsoft Azure services and applications.

Recommendations:

Learn from others! Here are some reviews from participants (Click on reviews to see full list of reviews)

  • Great Material - This course is a great reference and way to refresh your skills for the new Net+ exam! I needed a good refresh before taking the exam and this course is clearly laid out and copiously covers the material for the exam. Great course, well worth the money! -- M.B.
  • Perfect Course - Not only do you get great lectures that are pretty much PowerPoints with an instructor teaching you the concepts, there are also Demo lectures that show you how each of the concepts works in real life. This is such valuable information to have when taking the test. I feel very confident that this course is the best Network+ course on Udemy. -- D.R. Jr.
  • A Complete Jumpstart - What has impressed me the most is the depth of the content to this coarse. Each HD video is crystal clear in both the visual and audio, even including quality closed captioning (great for reading along with the lectures). I wasn't interested in the flashcards or the crossword puzzles when I started the program, but I've found them to be very useful in staying engaged in the class when away from home. This is everything you need to get started and have a classroom quality experience from home. Dive in and stay focused! -- P.C.
Who is the target audience?
  • Looking to enhance your skills in the SQL Server 2012 database system?
  • Are you an IT professional, database administrator, support specialist, or database developer? These concepts are key for these kind of professions.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 217 Lectures Collapse All 217 Lectures 08:12:28
+
Course Orientation
1 Lecture 01:42
+
Designing a Database Server Infrastructure
23 Lectures 01:19:42


Database Server Infrastructures for SQL Server 2014
05:51

Planning a Database Server Infrastructure
05:20

Knowledge Check
00:48

Considerations for Database Consolidation
02:41

Options for Database Consolidation
03:54

Planning Database Consolidation
03:29

Knowledge Check
00:45

Chapter 1 and 2 Quiz
4 questions

Planning Hardware
06:11

Planning Storage
05:08

Planning Processors
04:42

Planning Memory
03:29

Planning Connectivity
01:57

Knowledge Check
00:34

Chapter 3 Quiz
3 questions

Using Resource Governor
03:11

SHOW ME Demonstration: Create Resource Pools and Performance Monitor
06:44

Managing Resources Across Multiple Instances
01:23

SHOW ME Demonstration: Managing Multiple Instances
04:14

Managing resources in Virtualized Environments
01:17

SHOW ME Demonstration: Managing Virtual Environments
04:40

Knowledge Check
00:49

Conclusion
01:38

Final: Designing a Database Server Infrastructure
6 questions
+
Designing a Logical Database Schema
36 Lectures 58:42
Course Overview
01:21

Designing a Logical Database Schema
01:12

Normalization
03:58

Knowledge Check
00:25

First Normal Form
01:32

SHOW ME Demonstration: 1NF
02:15

Second Normal Form
00:52

SHOW ME Demonstration: 2NF
01:49

Third Normal Form
00:53

SHOW ME Demonstration: 3NF
02:13

Fourth Normal Form
01:11

SHOW ME Demonstration: 4NF
01:11

Boyce-Codd Normal Form
01:01

SHOW ME Demonstration: BCNF
01:57

Knowledge Check
00:45

Chapter 1 and 2 Quiz
3 questions

Strategic Denormalization
02:59

Denormalization Considerations
01:43

Scenarios for Denormalization
01:37

Generalization and Specialization
01:24

Knowledge Check
00:26

Chapter 3 Quiz
3 questions

Planning Schemas
02:25

Planning Tables
02:00

Planning Data Types
03:13

Options for Creating Columns
02:13

Planning Primary Key Constraints
02:52

Planning Constraints
01:51

Referential Integrity
01:36

Triggers
01:28

Knowledge Check
00:35

LAB: Designing a Logical Database Schema
00:47

SHOW ME Demonstration: Create a Plan for Database Schema
01:41

SHOW ME Demonstration: Create CozyHomeServices Database and Schema
02:15

SHOW ME Demonstration: Create Database Diagram
01:24

SHOW ME Demonstration: Creating Database View
01:23

Knowledge Check
00:56

Conclusion
01:19

Final: Designing a Logical Database Schema
16 questions
+
Designing a Physical Database Implementation
19 Lectures 41:03
Introduction
01:51

Course Overview
01:32

Planning Data Files and Log Files
04:12

Storing Data Files and Log Files in Multiple Files
02:19

Planning File Groups
03:34

File Size and File Growth
01:52

SHOW ME Demonstration: Estimation of Fize Size and File Growth
01:28

Considerations for RAID and Tempdb
04:16

Knowledge Check
00:32

Chapter 1 Quiz
5 questions

Planning Partitioning
02:17

Partition Functions
01:26

SHOW ME Demonstration: Partitioning a Table
03:15

Performing Operations on Partitioned Data
01:21

SHOW ME Demonstration: Implementing Sliding Window Partition
02:47

Partitions and Performance
01:58

Planning Data Compression
02:51

Planning a Compression Strategy
01:22

Knowledge Check
00:29

Conclusion
01:41

Chapter 2 and 3 Quiz
4 questions

Final: Designing a Physical Database Implementation
12 questions
+
Tuning Database Performance
28 Lectures 58:25
Introduction
01:35

Tuning Database Performance
02:51

Knowledge Check
00:35

Indexes
04:35

Index Types
03:09

Improving Index Performance
03:04

Index Statistics
01:43

SHOW ME Demonstration: Assessing Selectivity Column Order
02:11

Indexing Strategy
04:28

Index Pages
04:04

SHOW ME Demonstration: Assessing Index Performance
02:58

Knowledge Check
00:32

Chapter 1 and 2 Quiz
5 questions

Query Plans
03:44

Viewing Query Plans
01:44

Plan Guides
02:15

Knowledge Check
00:27

Performance Monitoring
02:07

Database Engine Tuning Advisor
00:37

SHOW ME Demonstration: Database Engine Tuning Advisor (DTA)
01:41

SQL Server Profiler
00:39

SHOW ME Demonstration: SQL Server Profiler
02:11

Performance Monitor
00:29

SHOW ME Demonstration: Using Performance Monitor
02:43

Activity Monitor
00:26

SHOW ME Demonstration: Using Activity Monitor
02:05

Performance Baselining and Counters
03:10

Knowledge Check
00:26

Conclusion
01:56

Chapter 3 and 4 Quiz
5 questions

Final: Tuning Database Performance
10 questions
+
Designing Database Security
23 Lectures 01:06:04
Introduction to Designing Database Security
01:56

Business Focused Security
03:12

Design Considerations
04:05

Knowledge Check
00:44

SQL Server Services
02:07

Service Accounts
02:53

Security Principles and Securables
05:28

SQL Server Security Planning
03:29

Planning Data Access
03:21

Security PLanning
04:12

SHOW ME Demonstration: Securing Database Resource
06:23

SHOW ME Demonstration: Using Application Role
02:56

SHOW ME Demonstration: Viewing User Connections in a SQL Server Audit
04:05

SHOW ME Demonstration: Viewing User Connections in a SQL Server Audit
04:40

Knowledge Check
00:38

Chapter 1 and 2 Quiz
5 questions

Contained Databases
03:02

SHOW ME Demonstration: Creating a Contained Database
01:00

Knowledge Check
00:37

Transparent Data Encryption
03:41

SHOW ME Demonstration: Implementing Transparent Data Encryption
02:11

Extensible Key Management
01:02

Knowledge Check
00:33

Conclusion
03:49

Chapter 2 and 3 Quiz
5 questions

Final: Designing Database Security
9 questions
+
Policy Based Management
14 Lectures 21:46
Introduction
00:55

Overview
02:03

Benefits
01:00

Key Components
03:48

Knowledge Check
00:36

Planning a Strategy
01:58

SHOW ME Demonstration: Viewing the Best-Practice Policies
01:24

Policies and Conditions
01:34

SHOW ME Demonstration: Create Condition
01:33

SHOW ME Demonstration: Creating a Policy
01:42

SHOW ME Demonstration: Testing Policy Compliance
01:52

Microsoft System Center
01:37

Knowledge Check
00:34

Conclusion
01:10

Chapter 1 and 2 Quiz
5 questions

Final: Policy Based Management
10 questions
+
Monitoring Server Health
18 Lectures 34:34
Introduction
01:15

SQL Server Health Monitoring
02:46

Challenges to SQL Server Health Monitoring
02:35

Options to Monitor Server Health
02:14

Data Collector and Management Data Warehouse
01:03

Data Collector
02:57

Knowledge Check
00:44

SQL Server Utility
01:59

SQL Server Utility Components
02:47

SHOW ME Demonstration: Creating Utility Control Point
02:03

SHOW ME Demonstration: Enroll an Instance
01:39

Considerations in Creating UCP
01:30

SHOW ME Demonstration: Remove the UCP
00:57

Health Policies
04:12

SHOW ME Demonstration: Configure a Health Policy
01:04

Monitoring Server Health
03:21

Knowledge Check
00:34

Conclusion
00:54

Chapter 1 and 2 Quiz
5 questions

Final: Monitoring Server Health
10 questions
+
Managing SQL Server with PowerShell
16 Lectures 27:19
Windows PowerShell
01:01

Overview
02:55

Introduction to Windows PowerShell
02:08

Windows PowerShell Features
02:16

Knowledge Check
00:34

Chapter 1 Quiz
4 questions

Windows PowerShell Cmdlets
02:37

Windows PowerShell Modules
02:25

Using Windows Commands and Utilities
01:35

Knowledge Check
00:34

Windows PowerShell in SQL Server
01:33

SHOW ME Demonstration: Using Windows PowerShell
01:49

Scripting with Windows PowerShell
02:25

SHOW ME Demonstration: PowerShell Commands and PowerShell ISE
02:31

Running PowerShell Scripts in Secured Environment
01:47

Knowledge Check
00:25

Conclusion
00:44

Chapter 2 and 3 Quiz
5 questions

Final: Managing SQL Server with PowerShell
10 questions
+
Replicating Data
23 Lectures 52:55
Course Overview
02:00

System Replication
02:08

Replication Components
02:59

Snapshot Replication
04:03

SHOW ME Demonstration: Configuring Authentication for Replications
02:19

SHOW ME Demonstration: Configure Distribution for Replication
05:43

SHOW ME Demonstration: Replication Monitor
00:54

Transactional Replication
02:16

SHOW ME Demonstration: Configuring Transactional Replication
02:18

SHOW ME Demonstration: Configuring Subscription for Transactional Replication
01:32

SHOW ME Demonstration: Transaction Replication
00:28

Knowledge Check
01:06

Chapter 1 Quiz
5 questions

Peer-to-Peer Transactional Replication
01:57

Merge Replication
02:25

Replication Agents
02:48

Scheduling Replication
01:26

Configuring Agent Profiles and Placement
02:15

Securing Replication
02:13

Data Validation and Monitoring
01:57

Troubleshooting Replication
05:06

Identifying Replication Topologies
02:55

Knowledge Check
00:34

Conclusion
01:33

Final: Replicating Data
7 questions
1 More Section
About the Instructor
LearnSmart LLC
4.2 Average rating
8,790 Reviews
77,467 Students
68 Courses
Smarter Training. Never Open a Textbook.

LearnSmart has served the learning community with high-quality professional skills and IT certification training since 1997. In that time, the company has helped thousands earn career-related certifications from respected vendors, such as Project Management Institute (PMI)®, Cisco, Microsoft, CompTIA, Oracle, and EC-Council. LearnSmart offers over 1,000 courses covering IT, project management, administrative, HR, and workplace safety topics. With a rapidly growing clientele of individuals and corporations, LearnSmart serves a broad range of Fortune 500 companies to universities, as well as government institutions and the armed forces.

LearnSmart is able to meet diverse career and learning needs through its extensive selection of training. LearnSmart uses industry experts to give learners the most up-to-date content in a video format as well as training resources including; reference tools, pretests, study guides and labs. For more information about how we can help pinpoint and solve your individual or multi-user training challenges.

PMI is a registered trademark of the Project Management Institute, Inc.