Developing MS SQL Server 2012 Database

simplilearn
4.4
4 opinions
  • The training was simple and easy to understand, the course content was excellent.
    ← | →
  • Good training; well organized and executed by Simplilearn.
    ← | →
  • Training was very nicely conducted and managed. Kudos to the trainer who was able to complete the course well within 2days.
    ← | →

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.4
fantastic
  • The training was simple and easy to understand, the course content was excellent.
    ← | →
  • Good training; well organized and executed by Simplilearn.
    ← | →
  • Training was very nicely conducted and managed. Kudos to the trainer who was able to complete the course well within 2days.
    ← | →
100%
4.5
excellent

Course rating

Recommended

Centre rating

Saugata Guharoy

5.0
14/03/2017
What I would highlight: The training was simple and easy to understand, the course content was excellent.
Would you recommend this course?: Yes

Sourabh Jain

4.0
17/03/2014
What I would highlight: Good training; well organized and executed by Simplilearn.
Would you recommend this course?: Yes

Ganapathy Hariharan

4.5
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

Gadibavi Venkata Mohan Reddy

4.0
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
*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

  • 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

See related categories

Developing MS SQL Server 2012 Database

Price on request

The best SQL Server courses

See all

See all