Querying and Modifying Data in Microsoft SQL Server 2008 with Transact-SQL

Product type
Level
Logo OnlineITcourses.com

Need more information? Get more details on the site of the provider.

Description

In this training course you will learn the Transact-SQL query language for Microsoft SQL Server 2008. With Transact-SQL you can request data and manipulate it in a SQL Server database.

Among the topics covered are working with Transact-SQL, querying and filtering data, grouping and combining data, working with multiple tables, changing data in tables, querying XML and text indexes, querying metadata and much more.

Livelab: practice in a live environment

During this training course you are given access to livelabs. In the livelabs you can exercise in a real life environment. A livelab is a computer and/or server into which you logon using your browser. All the software you need to perform …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

In this training course you will learn the Transact-SQL query language for Microsoft SQL Server 2008. With Transact-SQL you can request data and manipulate it in a SQL Server database.

Among the topics covered are working with Transact-SQL, querying and filtering data, grouping and combining data, working with multiple tables, changing data in tables, querying XML and text indexes, querying metadata and much more.

Livelab: practice in a live environment

During this training course you are given access to livelabs. In the livelabs you can exercise in a real life environment. A livelab is a computer and/or server into which you logon using your browser. All the software you need to perform practical assignments is installed here. In this way you acquire hands on experience.

Your result

You can work with Transact-SQL for Microsoft SQL Server 2008. You can manipulate data and are familiar with a database environment, using Transact-SQL.

Audience profile

DBAs, administrators, database designers, support engineers wanting to learn the basis of Microsoft Transact-SQL for SQL Server 2008.

Contents of the training course

The training course is comprised of a number of lessons:

  • An Introduction to Transact-SQL in Microsoft SQL Server 2008
  • Querying and Filtering Data in Microsoft SQL Server 2008
  • Grouping and Summarizing Data in Microsoft SQL Server 2008
  • Joining Data from Multiple Tables in Microsoft SQL Server 2008
  • Working with Subqueries Using Microsoft SQL Server 2008
  • Modifying Data in Tables with Microsoft SQL Server 2008
  • Integrated Full Text Search and Returning XML Result Sets in SQL Server 2008
  • An Introduction to Programming Objects in Microsoft SQL Server 2008
  • Querying Metadata in Microsoft SQL Server 2008
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.