Advanced SQL – Query Optimization

Advanced SQL - Query Optimization

Public courses

£1400

- Anyone can join the training
- Course outline as presented on the website
- Small groups, 3-10 people

Private courses

Price set individually

- Training workshop just for your team
- You choose date and location of the training
- Course outline tailored to your needs

About the training

Advanced SQL and high performance  database queries can make data processing and application faster. Keeping code clean and writing easy to read SQL queries makes working with code effortless and speeds up the performance of the team. Coding standard and respecting database designing rules are key values to create a good IT system. System maintenance requires knowledge about how to tune database. To optimize slow queries, one needs to understand the query execution plan and apply SQL query optimization and database tuning techniques.

Who is this training for?

The Advanced SQL and Optimization course is for those who work with SQL and want to improve their coding skills and to gain knowledge about advanced SQL, coding standards and designing databases.

What will I learn?

  • write clean and standardized SQL queries
  • know new functions and objects in database and SQL
  • design database in normalized way
  • find inefficient queries and use optimization techniques

Course outline

  1. Coding standards
  • Clean code
  • Autoformat tools
  • ANSI 92 standard
  1. Advanced SQL
  • CASE and PIVOT
  • Triggers
  • Dynamic queries
  • Materialized views
  • Isolation levels
  • Transactions
  • Text searching
  1. Database designing standards
  • Naming convention
  • Constraints
  • Data types
  • Normalization
  • Useful tools
  • Traps
  1. Performance
  • Detecting queries to optimize
  • Query execution plan
  • Statistics
  • Indexes
  • Joins

Course Curriculum

Curriculum is empty

Instructors


Send an enquiry

I am interested in


 

Enquire about the private (on-site) training course

I am interested in


 

Enquire about the public training course
 

I am interested in


 
Szybki kontakt