microsoft partner logo color
8351  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

4 options available

  • May 7, 2025 - May 7, 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
  • 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

it was good and very informative. Instructure covered everything in detail.

very good and spcecific course and above all a very good instructor. In few days I have learned a lot.

Instructor knew her stuff. Long time in the industry. Course was easy to follow and very informative.

I like their training. A lot of material covered. The labs are very good. l learned a lot.

Exit certified was great as it is very in depth and hands on learning which made it very easy to learn this type of work.