SQL school training courses in Cleveland, OH (public, in-house or online)

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Maintaining a Microsoft SQL Server 2008 Database
Implementing a Microsoft SQL Server 2008 Database

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

Objective :
After completing this course, students will be able to: - Describe the uses of and ways to execute the Transact-SQL language. - Use querying tool. - Write SELECT queries to retrieve data. - Group and summarize data by using Transact-SQL. - Join data from multiple tables. - Write queries that retrieve and modify data by using subqueries. - Mod...

Full archival course description>>

In this course, students will compose SQL queries to retrieve desired information from a database.

Objective :
Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, an...

Full archival course description>>

This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the development tools to create reports, and how to use the Reporting Services management and administrative tools.

Objective :
After completing this course, students will be able to: - Describe SQL Server Reporting Services and its components. - Create a Reporting Services report. - Enhance a Reporting Services report. - Create and manipulate data sets. - U...

Full archival course description>>