Database school training courses in Birmingham, AL (public, in-house or online)

This course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

At Course Completion:
After completing this course, students will be able to:
- Install and configure SQL Server 2005
- Manage database files.
- Manage security.
- Perform administrative tasks.
- Backup databases. <...

Full archival course description>>

This course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.

At Course Completion:
After completing this course, students will be able to:
- Create databases and database files.
- Create data types and tables.
- Use XML-related features in Microsoft SQL Server 2005.
- Plan, cre...

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

In the course, students create and modify new databases and their various objects. They learn how to maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Accessâ„?2007 with other applications. (Second Edition)

At Course Completion:
Upon successful completion of this course, students will be able to: - examine the basic database concepts and explore the Microsoft Office Access 2007 environment. - design a simple database. - build a new databa...

Full archival course description>>

In this course, students create complex reports and data sources using Crystal Reports’ tools. They will also increase the speed and efficiency of their reports by using SQL queries.

At Course Completion:
Upon successful completion of this course, students will be able to:
- create automatic and manual running totals.
- work with cross-tab reports.
- add subreports.
- create drill-downs in a report.
- use SQL statements in report processing.
- create comp...

Full archival course description>>