Loading Classes
Developing Microsoft SQL Server Databases (20464)
New Age Technologies has been delivering Authorized Training since 1996. We offer Microsoft’s full suite of authorized courses including courses pertaining to Developing Microsoft SQL Server Databases, SharePoint 2013 Business Intelligence, Programming in HTML5 with JavaScript and CSS3, Microsoft Office, Microsoft Exchange Server, and more. If you have any questions or can’t seem to find the Microsoft class that you are interested in, contact one of our Microsoft Training Specialists. Invest in your future today with Microsoft training from New Age Technologies.
✉ Microsoft Training Specialist | ☏ 502.909.0819
Current Promotion
EXCLUSIVE BENEFIT:
This course includes a twelve-month subscription to these exclusive benefits:
- 12 months of anytime access to your course labs and lab environment
- 12 months of 24/7 access to mentoring via chat, email, and phone
- 12 months of on-demand access to indexed, searchable recordings of your Online Live class
- 12 months of unlimited retakes of your class
COURSE INFORMATION
Developing Microsoft SQL Server Databases (20464) Overview:
In the Developing Microsoft SQL Server Databases (20464) course, you will be introduced to SQL Server, logical table design, indexing, query plans, and data and domain integrity.
Developing Microsoft SQL Server Databases (20464) course gives you the skills and knowledge necessary to:
- Create database objects, including:
- Views
- Stored procedures
- Parameters
- Functions
- Procedure coding, such as:
- Indexes
- Concurrency
- Error handling
- Triggers
- SQL Common Language Runtime (CLR)
Who Should Attend:
IT professionals who want to become skilled on SQL Server 2102 & 2014 product features and technologies for implementing a database
Developing Microsoft SQL Server Databases (20464) Prerequisites:
Before attending this course, you must have:
- Knowledge of writing T-SQL queries
- Knowledge of basic relational database concepts
Developing Microsoft SQL Server Databases (20464) Objectives:
After successfully completing this course, you will learn:
- SQL Server platform tools including editions, versions, basics of network listeners, and concepts of services and service accounts
- Appropriate data types used when designing tables, convert data between data types, and create alias data types
- Design practices regarding SQL Server tables and create tables using T-SQL (partitioned tables not covered in this course)
- Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK, and UNIQUE constraints
- Investigate cascading FOREIGN KEY constraints
- Appropriate single column and composite index strategies
- Create tables as heaps, tables with clustered indexes, and appropriate structure for table designs
- Common elements from execution plans
- Design effective non-clustered indexes
- Design and implement views and stored procedures
- Work with table types and table-valued parameters
- Use MERGE to create stored procedures that update data warehouses
- Design and implement scalar and table-valued functions
- Investigate deadlock situation and how transaction isolation levels affect application concurrency
- T-SQL error handling code and structured exception handling
- Design and implement data manipulation language (DML) triggers
- SQL CLR integration and implement existing .NET assembly within SQL Server
- Store Extensible Markup Language (XML) data and schemas in SQL Server
- Basic queries on XML data in SQL Server
- GEOGRAPHY and GEOMETRY data types
- Implement and query a full-text index
Developing Microsoft SQL Server Databases (20464) Outline:
Module 1: Database Development Introduction
- SQL Server Platform
- SQL Server Tools
- Configure SQL Server Services
- Module 1 Labs: Database Development Introduction
- SQL Server Management Studio
Module 2: Design and Implement Tables
- Design Tables
- Work with Schemas
- Create and Alter Tables
- Module 2 Labs: Design and Implement Tables
- Table Designs
- Create a Schema and a Table
Module 3: Ensure Data Integrity through Constraints
- Data Integrity Enforcement
- Implement Domain Integrity
- Implement Entity and Referential Integrity
- Module 3 Labs: Ensure Data Integrity through Constraints
- Design and Test the Constraints
Module 4: Introduction to Indexing
- Core Indexing Concepts
- Single Column and Composite Indexes
- SQL Server Table Structures and Clustered Indexes
- Module 4 Labs: Create Indexes
- Tables with Clustered Indexes
- Performance Improvement through Non-clustered Indexes
Module 5: Advanced Indexing
- Execution Plan Concepts and Elements
- INCLUDE Clause, Padding, Hints, and Statistics
- Design Effective Non-Clustered Indexes
- Performance Monitoring and the Database Engine Tuning Advisor
- Module 5 Labs: Plan for SQL Server 2014 Indexing
- Index Statistics
- Create Covering Indexes
Module 6: Columnstore Indexes
- Clustered and Non-Clustered Columnstore Indexes
- Module 6 Labs: In-Memory Database Capabilities
- Columnstore Indexes
Module 7: Design and Implement Views
- Views
- Creating and Managing Views
- Performance Considerations for Views
- Module 7 Labs: Design and Implement Views
- WebStock, Contacts, and Available Models Views
Module 8: Design and Implement Stored Procedures
- Stored Procedures
- Implement Parameterized Stored Procedures
- Control the Execution Context
- Module 8 Labs: Design and Implement Stored Procedures
- Create Stored and Parameterized Stored Procedures
- Alter the Execution Context of Stored Procedures
Module 9: Design and Implement User-Defined Functions
- Functions
- Design and Implement Scalar Functions and Table-Valued Functions
- Considerations for Implementing Functions
- Alternatives to Functions
- Module 9 Labs: Design and Implement User-Defined Functions
- Format Phone Numbers and Modify Existing Function
- Function-Related Performance Issue Resolutions
Module 10: Respond to Data Manipulation via Triggers
- Design and Implement DML Triggers
- Advanced Trigger Concepts
- Module 10 Labs: Respond to Data Manipulation via Triggers
Module 11: In-Memory Tables
- Memory-Optimized Tables
- Native Stored Procedures
- Module 11 Labs: In-Memory Database Capabilities
- Memory Optimized Tables
- Natively Compiled Stored Procedures
Module 12: Implement Managed Code in SQL Server
- SQL CLR Integration and Implementation
- Import and Configure Assemblies
- Implement Objects created within .NET Assemblies
- Module 12 Labs: Implement Managed Code in SQL Server
- CLR Code
- Implement CLR Assembly
- Implement a CLR User-Defined Aggregate and CLR User-Defined Data Type
Module 13: Store and Query XML Data in SQL Server
- XML and XML Schemas
- Store XML Data and Schemas in SQL Server
- Implement the XML Data Type within SQL Server
- Use the T-SQL for XML Statement
- XQuery Language
- Shred XML to a Relational Form
- Module 13 Labs: Store and Query XML Data in SQL Server
- XML Data Storage in Variables
- Information Retrieval about XML Schema Collections
- Query SQL Server Data as XML
- Write a Stored Procedure Returning XML
Module 14: SQL Server Spatial Data
- Spatial Data Introduction
- SQL Server Spatial Data Types
- Spatial Data in Applications
- Module 14 Labs: SQL Server Spatial Data
- Query the Geometry Data Type
- Add Spatial Data to an Existing Table
/Salary/by_Job/300s.png)
