microsoft partner logo color
7878  Reviews star_rate star_rate star_rate star_rate star_half

SQL Querying Fundamentals - Part 2

In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Skills...

Read More
$595 USD
Course Code 36072
Duration 1 day
Available Formats Classroom, Virtual

In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process.

Skills Gained

  • Use subqueries to generate query output.
  • Manipulate table data by inserting, updating, and deleting records in a table.
  • Manipulate the table structure.
  • Create views, manipulate data through views, modify the view structure, and drop views.
  • 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.

Who Can Benefit

Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology.

Prerequisites

There are no prerequisites for this course.

Course Details

Course Outline

  • Using Subqueries to Perform Advanced Querying
  • Manipulating Table Data
  • Manipulating the Table Structure
  • Working with Views
  • Indexing Data
  • Managing Transactions
|
View Full Schedule