Course 4326: An Introduction to Transact-SQL in Microsoft SQL Server 2008

Product type
Logo Microsoft Learning

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

Description

Introduction In this 2 hour course the students will be introduced to the types of T-SQL statements, the Transact-SQL Syntax elements and explain the SQL Server tools that make use of Transact-SQL.

Topics covered in the courses within the course include:
  • Introduction to Transact-SQL programming language.
  • Introduction to Transact-SQL elements.
  • Using Transact-SQL Querying tools.
  • Using Books Online.
This course also helps prepare you for exam: 70-432: Microsoft SQL Server 2008, Implementation and Maintenance and 70-433: Microsoft SQL Server 2008, Database Development.

This course has the same content as the previous version in an updated viewer with a new look and feel.
Objectives At the en…

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.

Introduction In this 2 hour course the students will be introduced to the types of T-SQL statements, the Transact-SQL Syntax elements and explain the SQL Server tools that make use of Transact-SQL.

Topics covered in the courses within the course include:
  • Introduction to Transact-SQL programming language.
  • Introduction to Transact-SQL elements.
  • Using Transact-SQL Querying tools.
  • Using Books Online.
This course also helps prepare you for exam: 70-432: Microsoft SQL Server 2008, Implementation and Maintenance and 70-433: Microsoft SQL Server 2008, Database Development.

This course has the same content as the previous version in an updated viewer with a new look and feel.
Objectives At the end of the course, students will be able to:
  • Describe the Transact-SQL programming language.
  • Describe the Transact-SQL elements.
  • Use Transact-SQL Querying tools.
  • Use Books Online.
Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information An Introduction to Transact-SQL in Microsoft SQL Server 2008 Module Overview Overview of the SQL Language Overview of the SQL Language What Is Transact-SQL? Types of Transact-SQL Statements Transact-SQL Statements Self Test Elements of Transact-SQL Part 1 Elements of Transact-SQL Part 1 Using Identifiers Referencing SQL Server Objects Using T-SQL Operators SQL Data Types Using Batch Directives Using Comments in T-SQL Code Self Test Elements of Transact-SQL Part 2 Elements of Transact-SQL Part 2 Using Temporary Tables in T-SQL Using Variables in T-SQL Using Functions in T-SQL Using Expressions in T-SQL Using Control-of-Flow Language Elements Self Test Using Transact-SQL Querying Tools Using Transact-SQL Querying Tools Introduction to SQL Server Management Studio Working with Object Explorer What Is a SQL Server Solution? What Is SQLCMD? Other Uses of Transact-SQL in Microsoft SQL Server 2008 Self Test Using SQL Server Books Online Using SQL Server Books Online What Is SQL Server Books Online? Making Effective Use of SQL Server Books Online Self Test Best Practices Best Practices Lab: An Introduction to Transact-SQL in Microsoft SQL Server 2008 Lab: An Introduction to Transact-SQL in Microsoft SQL Server 2008 Scenario Exercise Information Launch the Lab Lab Review Module Summary Module Summary Glossary Glossary System Requirements To view this course, you need:
  • A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
  • Microsoft® Windows® 2000 or higher
  • Microsoft Internet Explorer 6.0 or higher
  • Adobe Flash 7.0 or higher (1MB disk space needed to install)
  • Microsoft Silverlight 4.0 or higher
  • Microsoft Windows Media Player 7.0 or higher
  • Microsoft XML Core Services 3.0 or higher
  • A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
  • A sound card, and either speakers or headphones (for multi-media audio).
  • Internet bandwidth of 56K or faster. Broadband internet access is recommended.
For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:
  • Microsoft Virtual Server ActiveX control (1MB disk space needed to install)
Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:
  • Microsoft Internet Explorer 6.0 or higher
  • Window-Eyes from GW Micro
  • JAWS from Freedom Scientific
  • MSAA enabled
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.