If you are interested in a class that does not have a scheduled date, please click on the CONTACT US button
Two Days • Instructor-led This is the second course in a five part SQL development series. This course assumes you have completed the SQL Server I class or know basic SQL syntax and have SQL coding experience. In this course you will learn how to run queries. Writing queries is the key to capturing the data you want. Course Outline Data, Information & Tables Query Options Null, Expressions & Identity Fields Aggregating Data Aggregation Strategies Top Records Ranking Functions Multiple Query Operators Common Table Expressions (CTE) Data Recursion Using Subqueries Table Data Actions The Merge Statement The Output Clause Common System FunctionsSQL Server 2 – Queries