Writing Queries Using Microsoft® SQL Server® 2008 Transact-SQL (MOC2778)
This instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
The course is included in the following category: |
Databáze → Microsoft SQL → MS SQL 2005/2008 Microsoft |
Difficulty of the course: Advanced
Course duration: 3 days
Contents of the course:
- Getting Started with Databases and Transact-SQL in SQL Server 2008
- Querying and Filtering Data
- Grouping and Summarizing Data
- Joining Data from Multiple Tables
- Working with Subqueries
- Modifying Data in Tables
- Querying Metadata, XML, and Full-Text Indexes
- Using Programming Objects for Data Retrieval
- Using Advanced Techniques
Expected knowledge: Knowledge of data integrity concepts. Core Windows Server skills. Relational database design skills. Programming skills.
.Course dates:
This course is no longer in our offer. For more information or if you are interested in contact us at skoleni@pcdir.cz a > or phone +420 543 533 610.