SQL Querying: Advanced Training
In today’s competitive environment, information is one of the most important factors in determining the success of an organization. If you are able to manage and retrieve information efficiently, you can streamline the organization’s processes and give it a competitive edge. Some data analysis tasks may require that you query multiple tables simultaneously or create complex views of data.
SQL Querying: Advanced
Course Overview
In the course SQL Querying: Fundamentals, you learned the basics of SQL querying. In this course, you will build on this foundation, learning advanced querying techniques, such as writing nested queries, using JOINs to combine data from multiple tables, summarizing query results, using advanced filtering, and using views to simplify repetitive querying tasks. You will also learn how to perform common database administration tasks such as duplicating tables, modifying table structures, inserting, updating, or deleting data, and indexing tables to optimize query performance. You will also learn how to work with multiple tasks as a transaction.
In this course, you will work with advanced queries to manipulate and index tables. You will also create transactions so that you can choose to save or cancel the data entry process. You will:
- Use nested queries to generate query output.
- Manipulate table data by inserting and updating records in a table and deleting records from a table.
- Manipulate table structure.
- Create views, manipulate data through views, modify the view structure, and drop views.
- Create indexes on table columns and drop inefficient indexes.
Course Outline
- Lesson 1: Using Nested Queries
- Topic A: Search Based on Values from a Subquery
- Topic B: Compare Values from a Subquery
- Topic C: Search Based on the Existence of Records
- Topic D: Generate Output Using Correlated Subqueries
- Topic E: Filter Grouped Data Within Subqueries
- Topic F: Perform Multiple-Level Subqueries
- Lesson 2: Manipulating Table Data
- Topic A: Insert Rows
- Topic B: Modify and Delete Data
- Lesson 3: Manipulating Table Structure
- Topic A: Create a Table
- Topic B: Create a Table with Constraints
- Topic C: Modify a Table’s Structure
- Topic D: Delete Tables
- Lesson 4: Working with Views
- Topic A: Create a View
- Topic B: Manipulate Data in Views
- Topic C: Modify and Delete Views
- Lesson 5: Indexing Data
- Topic A: Create Indexes
- Topic B: Drop Indexes
- Lesson 6: Managing Transactions
- Topic A: Define Transactions
- Topic B: Commit Transactions
Intended Audience
Students should have basic computer skills and SQL skills and be familiar with concepts related to database structure and terminology.
- Business Analysts
- Data Analysts
- Developers
- Those needing to know how to query in a SQL database.
Prerequisites
To ensure your success, we recommend you first take the following Logical Operations courses, or have equivalent skills and knowledge:
- SQL Querying: Fundamentals
- Course-specific Technical Requirements
Hardware:
Each computer will need the following minimum hardware configurations:
- 2 GHz or faster 64-bit (x64) processor
- 4 gigabytes (GB) RAM
- 40 GB available hard disk space
- CD-ROM drive (if installing any software from a CD-ROM)
- Keyboard and mouse (or other pointing device)
- 1024 x 768 (or higher) resolution monitor recommended
- Network cards and cabling for local network access
- Internet access (contact your local network administrator)
- Printer (optional) or an installed printer driver
- Projection system to display the instructor’s computer screen
Software:
To prepare a system for the class, install the following software according to the instructions provided. You will need the following software:
Microsoft® Windows® 10 64-bit with sufficient licenses.
Windows 10 requires activation unless you have volume-licensing agreements. There is a grace period for activation. If the duration of your class will exceed the activation grace period (for example, if you are teaching the class over the course of an academic semester), you should activate the installations at some point before the grace period expires. Otherwise, the operating system may stop working before the class ends.
Microsoft® SQL Server® 2022 Express. (When this course was written, the installation file for this free software was available for download from https://www.microsoft.com/en-us/sql- server/sql-server-downloads . )
Microsoft® SQL Server® Management Studio (SSMS). (When this course was written, the installation file for this free software was available for download from https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio- ssms . )
Follow-On Courses
Related training topics
Justify your training
Use this sample request letter — copy it into an email to your manager and personalize the bracketed details to make the case for the time and budget.
Sample training request letter
Subject: Request for Data Analytics & Databases training from Applied Technology Academy
[Decision Maker Name],
I'm writing to request time and budget approval to complete Applied Technology Academy's course, SQL Querying: Advanced Training. The information below outlines how this training benefits our organization, the tasks I'll be able to perform after completing it, and relevant cost and funding details.
Course Description
In today’s competitive environment, information is one of the most important factors in determining the success of an organization. If you are able to manage and retrieve information efficiently, you can streamline the organization’s processes and give it a competitive edge. Some data analysis tasks may require that you query multiple tables simultaneously or create complex views of data. Applied Technology Academy is an award-winning, SBA-certified woman-owned training provider (est. 2008) whose instructors are active practitioners; the course is hands-on with virtual labs and a learn-by-doing methodology.
Course Objectives
Once I've completed the course, I'll have hands-on, job-ready skills in data analytics & databases that I can apply immediately to our work.
Expected Organizational Benefits
After completing this course, I will be better equipped to apply these skills directly to our projects, reduce our reliance on outside expertise, strengthen our team's capabilities, and share what I learn with colleagues.
Expected Cost & Funding
Course fee: [request an itemized quote at the link below]. Applied Technology Academy supports multiple funding paths that may reduce or cover this cost: GSA MAS purchasing and government purchase orders, military credentialing funding (Army CA, AF COOL, CG COOL), VA GI Bill and VR&E, ATA Flexible Spending, and student financing. Private team cohorts are available if colleagues should attend with me.
Conclusion
This training provides practical, hands-on experience I can apply immediately to strengthen our work in data analytics & databases. Additional course information is available at https://appliedtechnologyacademy.com/microsoft-training/sql-querying-advanced-training/.
Thank you for your consideration,
[Your Name]
Design training around your team, not the other way around.
Talk to a training advisor about private cohorts, funding paths and program management.