Microsoft SQL Server SQL
- Recommended Duration:
- 3 Days
- Version
- SQL Server 2008 and SQL Server 2005. Course can be taught with earlier versions of the database.
- 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.