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

Database Administrators are an integral part of the digital economy. Administrating a Microsoft SQL Server Database skills are in hot demand. Ecommerce would not exist without huge data repositories to keep track of inventories, accounts receivables, accounts payables, trend analysis, medical records, etc..

Post-graduate certificate designed to update or enhance skills in object-oriented technologies. Students will experience the object-oriented environment of programming, database and Web technologies.

Students will learn how to perform full and dial-tone recoveries of a mailbox server, as well as repair a mailbox database. They will also learn how to perform a full recovery of Client Access servers, Hub Transport servers, and Unified Messaging Servers.

Objective :
After completing this course, students will be able to: - Recover messaging databases. - Prepare for and recover from Mailbox server failures. - Prepare for and recover from non-Mailbox server failures.

At Course...

Full archival course description>>

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>>