SQL Server 2005: Transact-SQL Querying/Updating + Programming

Show more Microsoft SQL Server Training Courses

Who will the lesson benefit?

IT Professionals, IT generalists, and Information Workers who want to learn about writing queries for Microsoft SQL Server 2005. Candidates should have at least 3 years experience working in the IT field-typically in the area of databases. No experience with SQL Server is necessary.

What delegates will learn

After completing this course, students will be able to:

• Get started with databases and Transact-SQL.
• Perform basic queries.
• Group and summarize data.
• Join data from multiple tables.
• Work with subqueries.
• Modify data.
• Query metadata, XML, and full-text indexes.
• Use programming objects for data retrieval.
• Use advanced querying techniques.

Examination details

This course will help the student prepare for the following Microsoft Certified Professional exam:

• Exam Exam 70-431: TS: Microsoft SQL Server 2005-Implementation and Maintenance. :

What prerequisites are required

This course requires that students meet the following prerequisites:

• An understanding of basic relational database concepts, including:
• Logical database design.
• Physical database design.
• How data is stored in tables (rows and columns).
• Data integrity concepts.

SQL Server 2005: Transact-SQL Querying/Updating + Programming / MS2778 (M2778, MOC 2778)

(C) AquinasTraining.co.uk - Contact Us