ICC Teleservices Ltd
Your Trusted ICT Partner

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

OUR PARTNER