Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More .NET

Microsoft SQL Server SQL

Recommended Duration:
3 Days
Benefits
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.
Audience
Personnel needing to create and execute queries and manipulate the SQL Server database.
Prerequisites
No programming background or experience is necessary, although a technical orientation is helpful.
Major 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
Exercises
There are eleven machine exercises.