microsoft partner logo color
8379  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
$675 USD
Duration 1 day
Course Code 36072
Available Formats Classroom, Virtual

Overview

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

Schedule

3 options available

  • May 27, 2025 - May 27, 2025 (1 day)
    Virtual | 9:00 AM 5:00 PM EDT
    Language English
    Select from 1 options below
    Virtual |9:00 AM 5:00 PM EDT
    Virtual | 9:00 AM 5:00 PM EDT
    Enroll
    Enroll Add to quote
  • Jun 12, 2025 - Jun 12, 2025 (1 day)
    Virtual | 9:00 AM 5:00 PM EDT
    Language English
    Select from 1 options below
    Virtual |9:00 AM 5:00 PM EDT
    Virtual | 9:00 AM 5:00 PM EDT
    Enroll
    Enroll Add to quote
  • Jun 26, 2025 - Jun 26, 2025 (1 day)
    Virtual | 9:00 AM 5:00 PM EDT
    Language English
    Select from 1 options below
    Virtual |9:00 AM 5:00 PM EDT
    Virtual | 9:00 AM 5:00 PM EDT
    Enroll
    Enroll Add to quote

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

The technical data in the AWS Solutions Architect course was very thorough.

ExitCertified was a great. They gave me all the materials and information I needed ahead of time to prepare for the course.

The platform is very intuitive and easy to navigate. Great tool for learning

Simply great training provider that I can go for updating/acquiring my skill sets.

I found this course informative. It was easy to follow and provided some good information.