• Live Instruction

• Hands-on, Guided Activities

• LIVE Remote or Classroom Delivery

What’s Included

  • Small class sizes
  • A digital SQL training manual
  • Certificate of course completion
  • FREE retake valid for 12 months
  • Virtual Lab (LIVE Remote)

Onsite SQL training available countrywide.

SQL COURSE OUTLINES

SQL

Our SQL 1 course will build on your existing knowledge of database concepts, structure, and terminology by using SQL to query databases. You will perform conditional searches and calculations, organize data, retrieve data from multiple tables, and export query results by using simple queries, queries that include functions, and combining multiple queries.

1 Day $396 3 Tickets

Detailed Course Outline

Executing a Simple Query
  • Connect to the SQL Database
  • Query a Database
  • Save a Query
  • Modify and Execute a Saved Query
Performing a Conditional Search
  • Modify Table Data
  • Search for a Range of Values and NULL Values
  • Search Data Based on String Patterns
Working with Functions
  • Perform Date Calculations
  • Calculate Data Using Aggregate Functions
  • Manipulate String Values
Organizing Data
  • Sort Data
  • Rank Data
  • Group Data
  • Filter Grouped Data
  • Summarize Grouped Data
  • Use PIVOT and UNPIVOT Operators
Retrieving Data from Multiple Tables
  • Combine the Results of Two Queries
  • Compare the Results of Two Queries
  • Retrieve Data by Joining Tables
Exporting Query Results
  • Generate a Text File
  • Generate an XML File

"Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class."

SQL Advanced

Building on our SQL Querying 1 class, SQL Querying 2 will teach you how to identify and use advanced querying techniques to handle large amounts of data allowing you to query multiple tables simultaneously and with increasing frequency.

Recommended Preparation: SQL Querying 1

Book LIVE Remote Book Classroom Download PDF
1 Day $396 3 Tickets

Detailed Course Outline

Using Nested Queries
  • Search Based on Values from a Subquery
  • Compare Values from a Subquery
  • Search Based on the Existence of Records
  • Generate Output Using Correlated Subqueries
  • Filter Grouped Data Within Subqueries
  • Perform Multiple-Level Subqueries
Manipulating Table Data
  • Insert Rows
  • Modify and Delete Data
Manipulating Table Structure
  • Create a Table
  • Create a Table with Constraints
  • Modify a Table’s Structure
  • Delete Tables
Working with Views
  • Create a View
  • Manipulate Data in Views
  • Modify and Delete Views
Indexing Data
  • Create Indexes
  • Create a Junction Table
  • Drop Indexes
Managing Transactions
  • Define Transactions
  • Commit Transactions

"Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class."

Three Class Discount

Buy any three classes and receive 20% off.

The Training to YOU Three Class Discount is a terrific way for an individual to purchase multiple classes for a discount. Whether you are looking for a series of classes like Excel 1, 2 & 3 or a variety of classes such as Google Sheets, Docs and Slides the Three Class Discount is the way to go!

State of Arizona employees are eligible for an additional discount.

Training to YOU Tickets

Tickets are a great way to reduce the cost of training your team. Save up to 45% by purchasing your training in bulk.

We are now providing a custom-made registration portal for each organization that purchases 50+ training tickets. These portals allow supervisors and employees to schedule training easily and information workflows keep everyone in the loop.

Give us a call

We are happy to answer any questions you may have.

Call us

(602) 266-1500

TRAINING TO YOU


Class Ratings
4.9 stars from 1984 reviewers:

“Instructor is very patient and helpful. Takes time to help student catch up if lagged a little behind. Plan to take Access Level 3 later. Training to You has always been  great.  Have taken classes in the past few years.”

— J.P. took Access 2 Database Design, Advanced Input and Retrieval

“My Instructor was great. He was knowledgeable and attentive throughout the course. He presented lofty concepts in a manner that was easy to understand and apply in real life. I look forward to my next course! ”

— C.K. took Access 1: Data Structure and Input and Retrieval

“We appreciate Training to You providing the training on site at our office. This was an excellent training for us to train the majority of our team. Thank you to our instructor for his patience and willingness to assist us with our questions.”

— K.P. took Access 2 Database Design, Advanced Input and Retrieval

SQL TRAINING FAQ

Training to YOU is dedicated to providing the best online and in-person SQL training classes in Phoenix. Find answers to some of our most frequently asked SQL training related questions below, or contact us should you require further assistance.

Our SQL Querying training classes are all face-to-face, whether you come to our facility or take the class remotely through our virtual meeting and lab.  Our trainers are subject matter experts and passionate about teaching, ensuring that you will have a great learning experience. 

LIVE Remote classes start the set-up process at 8:00 a.m. 

In-person classroom participants should arrive no by 8:15 a.m. 

Students that arrive late will be asked to reschedule. 

Instruction begins at 8:30 a.m. for both classroom and LIVE Remote delivery. 

Classes are scheduled to end at 4:30 p.m. but this may vary depending on class size and student skill level.  

All times are in MST for Phoenix, AZ where Daylight Savings Time is not observed. 

See the local time in Phoenix here for clarification. 

You will need: 

  • A stable, high-speed internet connection (wired is recommended over Wi-Fi whenever available) 
  • A PC or laptop with mouse and keyboard 
  • A second monitor (preferred) or device (screen size should be large enough to view instructor’s share) 
  • Speakers or headphones are a must and a microphone is recommended.  

Click here for full setup instructions, including links to test your system and network.  

If you do not have the resources above, consider taking your class in-person at our training center and we will provide everything you need. 

This depends on your current level of experience. Most will benefit from starting at the beginning with SQL Querying 1 which is the perfect introduction to the core concepts, terminology and navigation of the application. Before you decide to start with a course later in the series, we recommend reviewing the full list of topics covered by downloading the PDF outline for that course below the course description. 

Our instructors can travel anywhere in the United States to deliver training. Contact registration for a quote at registration@trainingtoyou.com