Database school training courses in Dover, DE (public, in-house or online)

Topics include database terminology, understanding relational databases, the Access environment, managing data in forms and tables, table relationships, select queries, calculated fields in queries and reports, designing forms and designing reports, and all of the exciting new features of Access 2007.

6232: Implementing a Microsoft SQL Server 2008 Database

2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

After completing this SQL Server 2008 R2 training course, students will be able to:
Explain SQL Server 2008 R2 architecture, resources requirements and perform pre-checks of I/O subsystems
Plan, install and configure SQL Server 2008 R2
Backup and restore databases
Import and export wizards and explain how they relate to SSIS
Use BCP and BULK INSERT to import data
Manage security
Assign, configure fixed database roles and create and assign user defined database roles
Full archival course description>>

After completing this SQL Server 2008 R2 training course, students will be able to:
Understand the product, its components, and basic configuration.
Work with the data types supported by SQL Server.
Design and implement tables and work with schemas.
Design and implement views and partitioned views.
Describe the concept of an index and determine the appropriate data type for indexes and composite index structures.
Identify the appropriate table structures and implement clus...

Full archival course description>>

This 5-day SQL Server 2012 training from Solartehc introduces Microsoft SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR are also covered in this course.