Developing SQL Databases M20762
Choose your attendance option:
Choose your attendance option:
Introduction to Database Development: Introduction to the SQL Server Platform - SQL Server Database Development Tasks
Designing and Implementing Tables: Designing Tables - Data Types - Working with Schemas - Creating and Altering Tables
Advanced Table Designs: Partitioning data - Compressing Data - Temporal Tables
Ensuring Data Integrity through Constraints: Enforcing data Integrity - Implementing Domain Integrity - Implementing Entity and Referential Integrity
Introduction to Indexes: Core Indexing Concepts - Data Types and Indexes - Single Column and Composite Indexes
Designing Optimized Index Strategies: Index Strategies - Managing Indexes - Execution Plans - The Database Engine Tuning Advisor - Query Store
Columnstore Indexes: Introduction to Columnstore indexes - Creating Columnstore indexes - Working Columnstore indexes
Designing and Implementing Views: Introduction to views - Creating and managing views - Performance considerations for views
Designing and Implementing Stored Procedures: Introduction to Stored Procedures - Working with Stored Procedures - Implementing Parameterized Stored Procedures - Controlling Execution Context
Designing and Implementing User-Defined Functions: Overview of Functions - Designing and Implementing Scalar Functions - Designing and Implementing Table-Valued Functions - Implementation Considerations for Functions - Alternatives to Functions
Responding to Data Manipulation via Triggers: Designing DML Triggers - Implementing DML Triggers - Advanced Trigger Concepts
Using In-Memory Tables: In-Memory tables - Native Stored Procedures
Implementing Managed Code in SQL Server: Introduction to SQL CLR Integration - Importing and Configuring Assemblies - Implementing SQL CLR Integration
Storing and Querying XML Data in SQL Server: Introduction to XML and XML Schemas - Storing XML Data and Schemas in SQL Server - Implementing the XML Data Type - Using the T-SQL FOR XML Statement - Getting Started with xQuery
Working with SQL Server Spatial Data: Introduction to Spatial Data - Working with SQL Server Spatial Data Types - Using Spatial Data in Applications
Storing and Querying Blobs and Text Documents in SQL Server: Considerations for BLOB Data - Working with FileStream - Using Full-Text Search
SQL Server Concurrency: Concurrency and Transactions - Locking Internals
Performance and Monitoring: Extended Events - Working with extended Events - Live Query Statistics - Optimize Database File Configuration - Metrics
Shareable on LinkedIn
You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.
Call:
01225 308979
Email:
info@go.courses
Find us at:
Go Courses Ltd.
Kemp House
152 - 160 City Road
London
United Kingdom
EC1V 2NX
Registered Office:
Go Courses Ltd.
10 Laura Place
Bath
United Kingdom
BA2 4BL