Course length: 1.0 day
Course Objective:
You will compose SQL queries to retrieve desired information from a database.
After completing this course the student should be able to:
- connect to the SQL Server database and execute a simple query
- include a search condition in a simple query
- use various functions to perform calculations on data
- create indices on table columns and drop inefficient indices
- mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction
Prerequisites:
Course Content
Lesson 1: Using Subqueries to Perform Advanced Querying
Lesson 2: Manipulating Table Data
Lesson 3: Manipulating the Table Structure
Lesson 4: Working with Views
Lesson 5: Indexing Data
Lesson 6: Managing Transactions