Send to a Friend
 
Content to send

Microsoft SQL Server

Course Number: 662-JK
Recommended Duration: 3 days

Intended Audience: Personnel needing to create and execute queries and manipulate the SQL Server database.

Course Overview

Participants are introduced to the SQL Server database and SQL. Several exercises use Transact-SQL and SQL to query and modify the database. The participant will also learn how to work with views, indexed views, and XML. SQL Server 2008 and SWL Server 2005. Course can be taught with earlier versions of the database.

Prerequisities

No programming background or experience is necessary, although a technical orientation is helpful.

Topics

  • Relational database concepts
  • SQL syntax and usage
  • SELECT statement
  • Expressions
  • XML, XPath, and XQuery
  • Built-in functions
  • Joins, Outer joins
  • Subqueries (Nested Queries)
  • Views and Indexed Views
  • Synonyms
  • Sequences
  • Data Dictionary
  • UPDATE, INSERT, DELETE, and
  • MERGE
  • COMMIT, ROLLBACK, SAVE (savepoints)
  • Locking
  • CREATE/ALTER: Tables, Views, Indexed Views, Synonyms, Indexes
  • Referential Integrity (Primary & Foreign keys)
  • Security: GRANT/DENY/REVOKE, roles
  • Statistics and Performance overview

Share with others
Please provide the following information
Your Name
Your Email Address
Recipient Emails
Message

Can't Read? Click to Generate New Code
Enter the verification code shown above into the text box below