This class is ideal for Programmers, Analysts, Database Administrators, IT Managers, or anyone writing SQL queries regularly. It covers SQL tips for any relational database management system, however queries within the material are specific to Db2, SQL Server, Oracle, and PostgreSQL.
Like all programming languages, Structured Query Language (SQL) can be written in an efficient way or not. SQL developers may see a drastic improvement in performance if they learn a few simple coding techniques. Embedding SQL statements in a program introduces even more performance implications to consider.This is a class that anybody writing SQL on any relational database system should take to learn to write more efficient SQL. By following a good set of SQL standards and guidelines and understanding the inefficiencies of the language, response times can be reduced which can lead directly to CPU savings and lower overall IT costs.Students will leave with a will better understanding of the SQL language and a knowledge of coding techniques to use and avoid. They will learn how to code queries in multiple ways that return the same set and evaluate each for performance. They will learn about how database optimizers evaluate and cost queries and where to start when analyzing performance problems. In short, they will be better SQL developers! Do most developers know where to start and look when it comes to a performance issue? They will after this class.
Basic SQL. Our SQ1000 class or equivalent experience.