Course Catalog  > Microsoft  > SQL Server
36072

SQL Querying Fundamentals - Part 2 Training

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.
Request Information
Request On-Site or Customized Course Info
Course Details

Duration

1 day

Prerequisites

No prior knowledge is presumed.

Target Audience

Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

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.
Course Outline
  • Using Subqueries to Perform Advanced Querying
  • Manipulating Table Data
  • Manipulating the Table Structure
  • Working with Views
  • Indexing Data
  • Managing Transactions
Upcoming Course Dates
USD $595
Online Virtual Class
Scheduled
Date: Dec 4, 2024
Time: 9 AM - 5 PM ET
Partner Registration

The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.

You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.

USD $595
Online Virtual Class
Scheduled
Date: Dec 16, 2024
Time: 9 AM - 5 PM ET
Partner Registration

The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.

You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.

USD $595
Online Virtual Class
Scheduled
Date: Dec 27, 2024
Time: 9 AM - 5 PM ET
Partner Registration

The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.

You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.

USD $595
Online Virtual Class
Scheduled
Date: Jan 10, 2025
Time: 9 AM - 5 PM ET
Partner Registration

The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.

You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.