Developing SQL Databases Training from ICC Teleservices
Duration 40(Hrs)
Buy Now
COURSE OUTLINE
1 - INTRODUCTION TO DATABASE DEVELOPMENT
- Navigate the SQL Server Platform
- Perform SQL Server Database Development Tasks
2 - DESIGNING & IMPLEMENTING TABLES
- Design, Create and Alter Tables
- Understand the Different Data Types
- Create and Manage Schemas
- Lab: Designing and implementing tables
3 - ADVANCED TABLE DESIGNS
- Partition and Compress Data
- Create Temporal Tables
- Lab: Using advanced table designs
4 - ENSURING DATA INTEGRITY THROUGH CONSTRAINTS
- Enforce Data Integrity
- Add and Test Constraints
- Implement Data Domain, Entity and Referential Integrity
- Lab: Using Data Integrity Through Constraints
5 - INTRODUCTION TO INDEXES
- Understand Core Indexing Concepts
- Learn about Data and Index Types – Including Heaps, Clustered, Nonclustered, Single Column and Composite Indexes
- Develop Heaps and Clustered and Covered Indexes
- Lab: Implementing Indexes
6 - DESIGNING OPTIMIZED INDEX STRATEGIES
- Learn About Index Strategies, Managing Indexes and Execution Plans
- Work with the Database Engine Tuning Advisor
- Use the Query Store to Identify and Fix Queries
- Lab: Optimizing Indexes
7 - COLUMNSTORE INDEXES
- Interpret, Create and Work with Columnstore Indexes
- Build a Memory Optimized Columnstore Table
- Lab: Using Columnstore Indexes
8 - DESIGNING AND IMPLEMENTING VIEWS
- Create and Manage Views
- Understand Performance Considerations for Views
- Set up Standard and Updateable Views
- Lab: Designing and Implementing Views
9 - DESIGNING AND IMPLEMENTING STORED PROCEDURES
- Create and Work with Stored Procedures
- Build and Implement Parameterized Stored Procedures
- Control Execution Context
- Lab: Designing and Implementing Stored Procedures
10 - DESIGNING AND IMPLEMENTING USER-DEFINED FUNCTIONS
- Understand the Types of Functions, Alternatives and Key Considerations for Implementation
- Design and Implement Scalar and Table-Valued Functions
- Lab: Designing and Implementing User-Defined Functions
11 - RESPONDING TO DATA MANIPULATION VIA TRIGGERS
- Design and Implement DML Triggers
- Learn about Advanced Trigger Concepts
- Create, Test and Improve Audit Triggers
- Lab: Responding to Data Manipulation by Using Triggers
12 - USING IN-MEMORY TABLES
- Work With Memory-Optimized Tables
- Establish Natively Compiled Stored Procedures
- Lab: Using In-Memory Database Capabilities
13 - IMPLEMENTING MANAGED CODE IN SQL SERVER
- Learn about CLR Integration in SQL Server
- Implement and Publish CLR Assemblies
- Lab: Implementing Managed Code in SQL Server
14 - STORING AND QUERYING XML DATA IN SQL SERVER
- Understand XML and XML Schemas
- Store XML Data and Schemas in SQL Server
- Implement the XML Data Type
- Use the Transact-SQL FOR XML Statement
- Get Started with XQuery and Shredding XML
- Lab: Storing and Querying XML Data in SQL Server
15 - STORING AND QUERYING SPATIAL DATA IN SQL SERVER
- Store and Query Spatial Data
- Work with SQL Server Spatial Data Types
- Apply Spatial Data to Applications
- Lab: Working with SQL Server Spatial Data
16 - STORING AND QUERYING BLOBS AND TEXT DOCUMENTS IN SQL SERVER
- Understand Considerations for Working with BLOB Data
- Store Unstructured Data Using FILESTREAM
- Perform Full-Text Searches
- Lab: Storing and Querying BLOBs and Text Documents in SQL Server
17 - SQL SERVER CONCURRENCY
- Learn how to Create Concurrency in SQL Server
- Execute Transactions and Lock Internals to Establish Concurrency
- Lab: SQL Server Concurrency
18 - PERFORMANCE AND MONITORING
- Work with Extended Events
- View and Interpret Live Query Statistics and Metrics
- Optimize Database File Configuration
- Lab: Monitoring, Tracing, and Baselining