Schedule or Request a Class

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:

SQL Fundamentals of Querying

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

 

 

You may also be interested in:

20761 Querying Data with Transact-SQL