Database school training courses in Buffalo, NY (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.

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.
- Restore databases
- Monitor...

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.

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, create, and optimize indexes.
-...

Full archival course description>>

This two-day instructor-led course provides students with the knowledge and skills to design databases for Microsoft SQL ServerT 2005 using business requirements to guide their decisions (beyond structured third normal form [3NF] modeling techniques). Students will also learn to incorporate security requirements throughout their design.

After completing this course, students will be able to:
- Approach database design from a systematic perspective, gather database requirements, and for...

Full archival course description>>

Students will be introduced to database design and implementation. Topics include database history, structure, objects and introductory Structured Query Language (SQL).

6232: Implementing a Microsoft SQL Server 2008 Database

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