SQL school training courses in Buffalo, NY (public, in-house or online)

You have access to company databases and your job may require you to retrieve data from these databases. Retrieval of information from a database is dependent on precisely ordered logic and specific information. The course, SQL: Fundamentals of Querying will help you use Structured Query Language (SQL) as a tool to implement logic and define instructions.

--------------------------------------------------------------------------------

Course Outline:

------------------------...

Full archival course description>>

In the course SQL: Fundamentals of Querying, you performed basic SQL querying. Because of various business conditions and requirements, in addition to querying the database, you may need to restructure and index tables. You may also need to manipulate the data in the tables using advanced queries. In this course, SQL: Advanced Querying, you will create advanced SQL queries to manipulate and index tables.

--------------------------------------------------------------------------------
<...

Full archival course description>>

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