Name: Developing MS SQL Server 2012 Database
Brand: simplilearn
Rating: 8.75 (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.4

fantastic

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

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

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

Contact us

Developing MS SQL Server 2012 Database

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.

Developing MS SQL Server 2012 Database

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.