Designing Database Solutions for MS SQL Server 2012

simplilearn
4.5
4 opinions
  • Excellent explanation of concepts through real life examples . Course content was helpful.
    ← | →
  • The training was to the point & well attained for the course with relevant supporting study materials.
    ← | →
  • The training was very detailed & helped in enriching knowledge.
    ← | →

Course

Online

Price on request

The best SQL Server courses

See all

See all

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?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.5
excellent
  • Excellent explanation of concepts through real life examples . Course content was helpful.
    ← | →
  • The training was to the point & well attained for the course with relevant supporting study materials.
    ← | →
  • The training was very detailed & helped in enriching knowledge.
    ← | →
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

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 8 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

Designing Database Solutions for MS SQL Server 2012

Price on request

The best SQL Server courses

See all

See all