Quality Seal Emagister EMAGISTER CUM LAUDE

Developing MS SQL Server 2012 Database

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

S

17/03/2014
What I would highlight Good training; well organized and executed by Simplilearn.

Would you recommend this course? Yes.
G

12/03/2014
What I would highlight Training was very nicely conducted and managed. Kudos to the trainer who was able to complete the course well within 2days.

Would you recommend this course? Yes.
G

12/03/2014
What I would highlight Excellent information shared; the training will be help me deal my current and future project execution in an effective and efficient manner.

Would you recommend this course? Yes.

What you'll learn on the course

Database
Server
SQL

Course programme

Course Preview
  • Microsoft SQL Server 2012 Development (Exam 70-464)
    • Module 01 - Introduction
      • 1.1 Welcome
      • 1.2 Course Overview
      • 1.3 Understanding QL
      • 1.4 Understanding TSQL
      • 1.5 SQL Server History
      • 1.6 Microsoft SQL Server Certifications
      • 1.7 Programmability Enhancements for 2012
    • 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
      • 3.1 Getting Your Hands on SQL Server 2012
      • 3.2 Installing SQL Server 2012
      • 3.3 Validate a SQL Server Installation pt. 1
      • 3.4 Validate a SQL Server Installation pt. 2
      • 3.5 Uninstalling SQL Server 2012
      • 3.6 SQL Books Online Goes Online
    • Module 04 - SQL Server Basics
      • 4.1 SQL Server Instances
      • 4.2 SQL Server Configuration Manager
      • 4.3 SQL Server Management Studio
      • 4.4 Understanding Databases
      • 4.5 Table Basics
      • 4.6 Understanding Primary Keys
      • 4.7 Understanding Data Types
      • 4.8 Understanding Normalization
      • 4.9 Understanding Foreign Keys
      • 4.10 Creating a Database
      • 4.11 Database Types
      • 4.12 Understanding Transaction Logs
      • 4.13 Refreshing Intellisense
      • 4.14 Understanding Schemas
      • 4.15 Four Part Naming
      • 4.16 Understanding Synonyms pt. 1
      • 4.17 Understanding Synonyms pt. 2
    • Module 05 - Working with Tables
      • 5.1 Attaching Adventureworks Sample DB
      • 5.2 Database Diagrams
      • 5.3 Working with Diagrams
      • 5.4 Table Design Basics
      • 5.5 Creating Tables Graphically
      • 5.6 Creating Tables with TSQL
      • 5.7 Altering Tables
      • 5.8 Understanding Temporary Tables
      • 5.9 Understanding Table Variables
      • 5.10 Temp Table vs. Table Variable
      • 5.11 GUIDs and SQL Server pt. 1
      • 5.12 GUIDs and SQL Server pt. 2
      • 5.13 NEWID() and NEWSEQUENTIALID()
      • 5.14 Understanding Table Partitioning
      • 5.15 Database Files
      • 5.16 Understanding Filegroups
      • 5.17 Working with BLOBs
      • 5.18 FILESTREAM Basics
      • 5.19 Using FILESTREAM
      • 5.20 FileTable Basics
      • 5.21 Understanding Constraints
      • 5.22 Creating Constraints
    • Module 06 - Indexes
      • 6.1 Index Basics
      • 6.2 Clustered Indexes
      • 6.3 Nonclustered Indexes
      • 6.4 Pages and Extents
      • 6.5 Understanding Fill Factor
      • 6.6 Creating Indexes Graphically
      • 6.7 Creating Indexes with TSQL
      • 6.8 Optimizing Indexes
      • 6.9 Reorganizing and Rebuilding Indexes
      • 6.10 Checking Index Fragmentation
    • Module 07 - Programming Objects
      • 7.1 Understanding Stored Procedures
      • 7.2 Creating Stored Procedures
      • 7.3 Using Parameters with SPs
      • 7.4 Using Temp Tables with SPs
      • 7.5 Types of Stored Procedures
      • 7.6 Understanding Transactions
      • 7.7 Explicit and Implicit Transactions
      • 7.8 Using Explicit Transactions
      • 7.9 Transactions and Locking
      • 7.10 Creating Views
      • 7.11 Partitioned Views
      • 7.12 Common Partitioned View Usage
      • 7.13 View Options
      • 7.14 Understanding Functions
      • 7.15 Scalar Function Example
    • Module 08 - Concurrency and Locking
      • 8.1 Understanding Concurrency
      • 8.2 Normalization and Concurrency
      • 8.3 Transaction Isolation Levels
      • 8.4 Monitoring and Managing Locking
    • Module 09 - Optimization
      • 9.1 SQL Server Profiler
      • 9.2 Creating a Trace pt. 1
      • 9.3 Creating a Trace pt. 2
      • 9.4 Querying a Trace Table
      • 9.5 Database Engine Tuning Advisor
      • 9.6 Query Execution Plans
      • 9.7 Understanding Query Hints
      • 9.8 Using System Views
      • 9.9 Using Performance Monitor
    • Module 10 - Working with XML Data
      • 10.1 XML Basics
      • 10.2 Relational vs. XML Data
      • 10.3 Retrieving XML from Relational Data
    • Module 11 - Conclusion
      • 11.1 Course Wrap Up
    • Module 12 - Credits
      • 12.1 About the Author

Additional information

  • What is the course all about?

    Developing Microsoft SQL Server 2012 Databases training prepares Database developers to build their skills in developing and implementing databases, while ensuring high level of data availability. Simplilearn offers Developing Microsoft SQL Server 2012 Databases online training which provides all the required knowledge on creating database files, custom data types, working with indexes, and transaction management

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

    • Globally recognized professional certification
    • Equip you with skills to design and implement SQL databases

  • Who should do this course?

    IT professionals with prior knowledge of writing T-SQL queries and basic database concepts can appear for the training. This training impart skills on SQL Server 2012 product features and technologies for implementing a database.

  • What is the course agenda?

    Module 1 - Introduction to SQL Server 2012
    Module 2 - Introduction to Data Types and Tables
    Module 3 - SQL Server Indexing
    Module 4 - Query Performance
    Module 5 - Common Language Runtime (CLR) Integration
    Module 6 - Transact-SQL (T-SQL) Error Handling
    Module 7 - Views and Functions
    Module 8 - Stored Procedures and Triggers
    Module 9 - Working with XML
    Module 10 - Transactions


Compare this course with other similar courses
See all