Advanced SQL & Optimization for Microsoft SQL Server

PT2592
Training Summary
Soaring Eagle presents "Advanced SQL Optimization for Adaptive Server," this course is directed to application developers, SQL Server developers and Systems Administrators who write queries and stored procedures to be used within applications. This course does not over optimizing the SQL Server configuration options and physical database design. When you complete this course, you learn how to write efficient SQL Statements, Understand When to Reorganize a Query. You will be able to Recognize Performance Issues and understand how stored procedures function
Prerequisites
Before taking this course, students should take SQL syntax: SELECT, INSERT, UPDATE, DELETE: Recommended: " Introduction to Microsoft SQL Server" a knowledge of SQL Syntax, SELECT, INSERT, UPDATE and DELETE. We also recommend at least 2 years of hands on T-SQL but that is not mandatory.
Duration
5 Days/Lecture & Lab
Audience
This course is designed for application developers, SQL Server developers and Systems Administrators who write queries and stored procedures to be used within applications.
Course Topics
  • Fundamentals of Query Processing
  • Query Troubleshooting
  • SQL Statement Processing
  • Problem Queries
  • Table Optimization
  • Join Processing
  • Subqueries
  • Datatype Conversion & Conflicts
  • Views
  • Union Queries
  • Cursors
  • Stored Procedures
  • BLOBs
  • Full Text Search
  • Session Configuration
  • Nulls
  • Advanced Select Options
  • Dynamic Queries
  • Common Table Expressions
  • Specific SQL Problems, Solutions & Issues
  • Case Studies
  • In-Memory OLTP Highlights

Related Scheduled Courses