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 (6 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.
255 students enrolled
$19
$200
90% off
Take This Course
  • Lectures 217
  • Length 8 hours
  • Skill Level All Levels
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2015 English Closed captions available

Course 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.

What are the 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

What am I going to get from this course?

  • 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.

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Course Orientation
Preview
01:42
Section 1: Designing a Database Server Infrastructure
Designing Database Server Infrastructure
Preview
01:18
Planning SQL Server Implementation
Preview
09:39
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
Section 2: Designing a Logical Database Schema
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
Section 3: Designing a Physical Database Implementation
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
Section 4: Tuning Database Performance
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

LearnSmart LLC, Smarter Training. Never Open a Textbook Again.

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.

Ready to start learning?
Take This Course