Toll Free: 1.877.290.9507 | Direct:708.689.0131

Developing Microsoft SQL Server Databases (MS-20464)

Developing Microsoft SQL Server Databases

Microsoft SQL Server 5-Day Training

This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014.  It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform. 

Total Price: $-,---

Click to Show Course Pricing

Information about this course:

This course is offered as:

  • Classroom Instructor-led Boot Camp
  • Live Online Instructor-led Boot Camp
  • Mentored Self-Paced Online
  • Streaming-Only Self-Paced Online

Course Highlights
  • 93% Pass Rate
  • Hands-on training with latest technologies
  • Complex sims & exercises, gives you practical hands-on experience
award-winning-training
At Course Completion:
After Completing this course, students will be able to:
  • Introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts.
  • Determine appropriate data types to be used when designing tables, convert data between data types, and create alias data types.
  • Be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL. (Note: partitioned tables are not covered).
  • Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints.
  • Determine appropriate single column and composite indexes strategies.
  • Create tables as heaps and tables with clustered indexes. Also consider the design of a table and suggest an appropriate structure.
  • Read and interpret details of common elements from execution plans.
  • Design effective non-clustered indexes.
  • Design and implement views
  • Design and implement stored procedures.
  • Work with table types, table valued parameters and use the MERGE statement to create stored procedures that update data warehouses.
  • Design and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues).
  • Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency.
  • Use both traditional T-SQL error handling code and structured exception handling.
  • Design and implement DML triggers
  • Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server.
  • Store XML data and schemas in SQL Server.
  • Perform basic queries on XML data in SQL Server.
  • Work with the GEOGRAPHY and GEOMETRY data types
  • Implement and query a full-text index.
Who Should Attend:

The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2014 product features and technologies for implementing a database.

What's Included:

Only Intense School’s Boot Camp offers you the following benefits:

  • 5 full days of intense instruction with no outside distractions
  • Exam Vouchers for exams
  • Microsoft Press E-Reference Library, including all Training Kits, Exam References, and Rapid Review books
  • 2nd shot vouchers - in case you do not pass an exam
  • Pre-Class Prep Materials
  • In-person access to the top experts in the industry
  • Lunch and snacks provided on each day of class

FREE MICROSOFT TRAINING!

Redeem Microsoft SATV Training Vouchers HERE

Click here to get more information about this class!

Instantly View Course Syllabus and price

View Course Calendar

Unfortuantely, no public enrollment courses currently match your criteria. Contact Us Here to find out other options with this class.





Select the type of training that best fits your schedule and learning style!

Live, Online, Self-Paced, Classroom - contact us for details on each.

Self-Paced

Streaming Only

Base option for limited budgets

  • Easy Online Access
  • Expert Microsoft Instructor
  • Exam Review
  • Highest Quality Content - 90% Pass
  • Self-Paced Training
Self-Paced

Mentored Online

Most popular self-paced option.

  • Online & Offline Playback (DVD,mobile)
  • Expert Microsoft Instructor
  • Intense Proprietary Exam Prep
  • Highest Quality Content - 90% Pass
  • Hands-On Lab Exercises
  • Self-Paced Mentored Training
  • Mentor & Live Instructor Support
  • Text books, Pre-Study, and Lab books
  • Complex Sims and Exercise Files
Classroom

Instructor-Led

Our top rated training experience

  • Live Classroom
  • Expert Microsoft Instructor
  • Intense Proprietary Exam Prep
  • Highest Quality Content - 90% Pass
  • Microsoft Certification Library
  • Hands-On Lab Exercises
  • Lunch, Snacks
  • Train In-Person at Training Facility
  • Exam Vouchers
  • 2nd Shot Exam Voucher
  • Pre-Shipment of Pre-Study Books
  • Text books, Pre-Study, and Lab books
  • Complex Sims and Exercise Files
Classroom

Live Online

Live experience from home or work

  • Live Online Classroom
  • Expert Microsoft Instructor
  • Intense Proprietary Exam Prep
  • Highest Quality Content - 90% Pass
  • Microsoft Certification Library
  • Hands-On Lab Exercises
  • Exam Vouchers
  • 2nd Shot Exam Voucher
  • Pre-Shipment of Pre-Study Books
  • Text books, Pre-Study, and Lab books
  • Complex Sims and Exercise Files

Course Outline

Module 1: Introduction to Database Development
This module introduces database development and the key tasks that a database developer would typically perform.
Lessons

Lab : Introduction to Database Development After completing this module, you will be able to: Module 2: Designing and Implementing Tables
This module explains how to design, create, and alter tables. Also it focusses on working with schemas.
Lessons Lab : Designing and Implementing Tables After completing this module, you will be able to: Module 3: Ensuring Data Integrity through Constraints
This module explains how to enforce data integrity, and implement domain integrity to maintain high quality data. Also it focusses on implementing Entity and Referential Integrity.
Lessons Lab : Ensuring Data Integrity through Constraints After completing this module, you will be able to: Module 4: Introduction to Indexing 
This module describes the concept of an index and discusses selectivity, density and statistics. It covers appropriate data type choices and choices around composite index structures. 
Lessons Lab : Creating Indexes After completing this module, you will be able to: Module 5: Advanced Indexing 
This module explains covering indexes and the INCLUDE clause as well as the use of padding, hints and statistics. The module also covers the use of the Database Engine Tuning Advisor and index-related dynamic management views to assess indexing strategies. 
Lessons Lab : Planning for SQL Server 2014 Indexing After completing this module, you will be able to: Module 6: Columnstore Indexes 
This module explains columnstore indexes, introduces clustered and nonclustered columnstore indexes, and discusses considerations for using columnstore indexes. 
Lessons Lab : Using In-Memory Database Capabilities After completing this module, you will be able to: Module 7: Designing and Implementing Views 
This module introduces Views, and explains how to create and manage Views. Also it focusses on the performance consideration for Views. 
Lessons Lab : Designing and Implementing Views After completing this module, you will be able to: Module 8: Designing and Implementing Stored Procedures
This module describes the potential advantages of the use of stored procedures along with guidelines on creating them.   Lessons Lab : Designing and Implementing Stored Procedures After completing this module, you will be able to: Module 9: Designing and Implementing User-Defined Functions 
This module explains how to design and implement user-defined functions that enforce business rules or data consistency, and modify and maintain existing functions written by other developers. 
Lessons Lab : Designing and Implementing User-Defined Functions After completing this module, you will be able to: Module 10: Responding to Data Manipulation via Triggers 
This module, explains what DML triggers are and how they enforce data integrity. Also it focusses on the different types of triggers available, and how to define triggers in a database. 
Lessons Lab : Responding to Data Manipulation via Triggers After completing this module, you will be able to: Module 11: Using In-Memory Tables
This module covers the creation of in-memory tables and native stored procedures and discusses the advantages and disadvantages of using in-memory tables.
Lessons Lab : Using In-Memory Database Capabilities After completing this module, you will be able to: Module 12: Implementing Managed Code in SQL Server 
This module explains how to use CLR integrated code to create user-defined database objects that are managed by the .NET Framework. 
Lessons Lab : Implementing Managed Code in SQL Server After completing this module, you will be able to: Module 13: Storing and Querying XML Data in SQL Server 
This module introduces XML and shows how XML data can be stored within SQL Server and then queried, including queries written in a language called XQuery. 
Lessons Lab : Storing and Querying XML Data in SQL Server After completing this module, you will be able to: Module 14: Working with SQL Server Spatial Data
This module introduces Spatial Data, and explains how to work with SQL Server Spatial Data Types.
Lessons Lab : Working with SQL Server Spatial Data After completing this module, you will be able to:

Instructor was very knowledgeable in all subjects of the course and tailored his lessons and labs to the student's weaknesses. Very eager to help students in any way he can.

- Scott Masury
MA Army National Guard

The instructor was very knowledgeable, and was able to explain complicated technologies in a way that was easy to comprehend. I was given everything I needed to learn and complete my course with confidence.

- Travis Drennan

I had an above-average instructor. Not only did he instruct, he mentored us with real-world experience. The knowledge he had of the applications was beyond comprehensible. Outstanding!

- Weston Flowers
Brooke Army Medical Center (CTR)

The instructor did a great job, his guidance on the skills of passing the exams was most valuable.

- George Ballane
Unavailable

He was very knowledgable in the course material and presented it in a very methodical way. The course materials were great and are resources we will use in the future.

- Ralph Polk
Brooke Army Medical Center (CTR)

Instructor did a fantastic job of delivering a large set of very dense course material cogently to the class. She obviously had the material down cold and could easily break down elements of the different knowledge domains in clear explanations.

- Byron Caswell
Scitor

Prerequisites?
Before attending this course, students must have:
  • Knowledge of writing T-SQL queries.
  • Knowledge of basic relational database concepts..
Certifications

...

States