Name: Designing Database Solutions for MS SQL Server 2012
Brand: simplilearn
Rating: 9 (4 reviews)

Description

Type

Course

Methodology

Online

Simplilearn is the World’s Largest Certification Training Provider, with over 400,000+ professionals trained globally
Trusted by the Fortune 500 companies as their learning provider for career growth and training
2000+ certified and experienced trainers conduct trainings for various courses across the globe
All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

All
Students
Centre

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.5

excellent

100%

4.5

excellent

Course rating

Recommended

Centre rating

Subhabrata

4.0

14/03/2018

What I would highlight: Excellent explanation of concepts through real life examples . Course content was helpful.

Would you recommend this course?: Yes

Kumaragunbaran Rajamani

4.5

17/03/2014

What I would highlight: The training was to the point & well attained for the course with relevant supporting study materials.

Would you recommend this course?: Yes

Sushant Sinha

5.0

12/03/2014

What I would highlight: The training was very detailed & helped in enriching knowledge.

Would you recommend this course?: Yes

Ashish Chandak

4.5

12/03/2014

What I would highlight: Crisp and concise course, well-packed in two days time.

Would you recommend this course?: Yes

*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2017

2016

How do you get the CUM LAUDE seal?

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

SQL
Designing
Server
Database

Course programme

Course Preview

Designing Database Solutions for Microsoft SQL Server 2012 (Exam 70-465)
- Module 01 - Welcome
  - 1.1 Introduction
  - 1.2 Course Overview
  - 1.3 Understanding SQL
  - 1.4 Understanding TSQL
  - 1.5 SQL Server History
  - 1.6 SQL Server Certifications
  - 1.7 The 70-465 Exam
- Module 02 - SQL Server 2012 Essentials
  - 2.1 SQL Server 2012 Editions
  - 2.2 Hardware Requirements
  - 2.3 Software Requirements
- Module 03 - Installing SQL Server 2012
  - 3.1 Getting a Copy of SQL Server 2012
  - 3.2 Understanding Instances
  - 3.3 Installing SQL Server 2012 pt. 1
  - 3.4 Installing SQL Server 2012 pt. 2
  - 3.5 SQL Books Online Goes Online
  - 3.6 Downloading Books Online
  - 3.7 SSMS Tour
- Module 04 - Designing Database Structure
  - 4.1 Determining Business Requirements
  - 4.2 Database Types
  - 4.3 The Relational Model
  - 4.4 Normalization Basics
  - 4.5 Basic Architectural Decisions
  - 4.6 Understanding File Groups
  - 4.7 Understanding Partitioning
  - 4.8 Authentication Modes
  - 4.9 Windows Authentication
  - 4.10 SQL Server Authentication
  - 4.11 The SA Account
- Module 05 - Database Object Design
  - 5.1 Logical Database Design
  - 5.2 Physical Design Implications
  - 5.3 Understanding Collation
  - 5.4 Linked Servers
  - 5.5 Understanding NULLs
  - 5.6 ANSI NULLs
  - 5.7 Handling Database Growth
  - 5.8 Linked Servers or Openrowset
  - 5.9 CPU Affinity
  - 5.10 Memory Allocation
  - 5.11 Managing SQL Server Memory
- Module 06 - Designing Tables
  - 6.1 Table Basics
  - 6.2 Temp Tables
  - 6.3 Table Variables
  - 6.4 Common Table Expressions
  - 6.5 Transaction Basics
  - 6.6 Explicit and Implicit Transactions
  - 6.7 Transaction Impact on Performance
  - 6.8 Planning with Concurrency in Mind
  - 6.9 Locking Basics
  - 6.10 Lock Types and Escalation
  - 6.11 Schema Basics
  - 6.12 Creating Schemas
- Module 07 - Indexing
  - 7.1 Understanding Indexes
  - 7.2 Understanding Data Distribution
  - 7.3 Clustered Indexes
  - 7.4 Non-Clustered Indexes
  - 7.5 Indexing Best Practices
  - 7.6 Reorganizing and Rebuilding Indexes
  - 7.7 Which Should I Use?
  - 7.8 Understanding Index Fragmentation
  - 7.9 Understanding Index Internals pt. 1
  - 7.10 Understanding Index Internals pt. 2
  - 7.11 Understanding Fillfactor
- Module 08 - Programming Objects
  - 8.1 Stored Procedure Basics
  - 8.2 Advantages of Stored Procedures
  - 8.3 Stored Procedure Best Practices
  - 8.4 Understanding Views
  - 8.5 Understanding Indexed Views
- Module 09 - Database Server Maintenance
  - 9.1 SQL Server Agent
  - 9.2 Understanding Jobs
  - 9.3 Understanding Alerts
  - 9.4 Understanding Operators
  - 9.5 Understanding Schedules
  - 9.6 Creating a Job
  - 9.7 Database Maintenance Plans
  - 9.8 Creating a Maintenance Plan
  - 9.9 Maintenance Plan Design Surface
  - 9.10 Multiserver Administration
  - 9.11 Ensuring Good Database Health
  - 9.12 DMVs
  - 9.13 SQL Server 2012 DMVs
  - 9.14 Getting to Know Your DMVs
- Module 10 - Monitoring Performance
  - 10.1 Performance Monitoring Basics
  - 10.2 Performance Monitor
  - 10.3 Counters To Watch
  - 10.4 Monitoring Locks
  - 10.5 SQL Server Profiler pt. 1
  - 10.6 SQL Server Profiler pt. 2
- Module 11 - Designing Backup Recovery
  - 11.1 Backup and Recovery Planning
  - 11.2 Transaction Log Basics
  - 11.3 Understanding Recovery Models
  - 11.4 Setting the Recovery Model
  - 11.5 Understanding Database Snapshots
  - 11.6 Using Database Snapshots
  - 11.7 High Availability Options
- Module 12 - Conclusion
  - 12.1 Course Wrap Up
- Module 13 - Credits
  - 13.1 About the Author

Additional information

What is the course all about?
This course describes how to design and monitor high performance, highly available data solutions with SQL Server 2012. Simplilearns offers Designing Database Solutions for Microsoft SQL Server 2012 Online certification training which focuses on creating plans and designs for database structure, storage, objects, and servers.
What learning benefits do you get from Simplilearn’s training?
- Globally recognized certification
- Prepares you for Microsoft Exam 70-465
- Build your skills on planning and designing for database structure, storage, objects, and servers.
Who should do this course?
Professionals who plan and design database solutions for organizations and have experience with database development and administering SQL Server databases.

What is the course agenda?

Module 1 - Course Introduction

Module 2 - Introduction to Databases

Module 3 - Introduction to Data Types and Tables

Module 4 - SQL Server Indexing

Module 5 - Performance Considerations

Module 6 - Backup and Restore

Module 7 - Views and Functions

Module 8 - Stored Procedures and Triggers

Module 9 - SQL Server Security

Module 10 - Installing and Upgrading SQL

See related categories

Contact us

Designing Database Solutions for MS SQL Server 2012

Questions & Answers

Reviews

Reviews on other courses at this centre

This centre's achievements

Subjects

Course programme

What is the course all about?

What learning benefits do you get from Simplilearn’s training?

Who should do this course?

What is the course agenda?

Add similar courses
and compare them to help you choose.

Designing Database Solutions for MS SQL Server 2012

Questions & Answers

Reviews

Reviews on other courses at this centre

This centre's achievements

Subjects

Course programme

What is the course all about?

What learning benefits do you get from Simplilearn’s training?

Who should do this course?

What is the course agenda?

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.