Quality Seal Emagister EMAGISTER CUM LAUDE

Designing Database Solutions for MS SQL Server 2012

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Online
Description

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.

Important information

Opinions

K

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

12/03/2014
What I would highlight The training was very detailed & helped in enriching knowledge.

Would you recommend this course? Yes.
A

12/03/2014
What I would highlight Crisp and concise course, well-packed in two days time.

Would you recommend this course? Yes.

What you'll learn on the course

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


Compare this course with other similar courses
See all