SQL Querying 1 – Supported – Full Day

$ 470.00

Class Duration: 2 Days, 7 Hours/Day

Class Agenda

Day One Morning Session 3 Hours
Lunch 1 Hour
Afternoon Session 3 Hours
Breaks Prescribed by Instructor
Day Two Morning Session 3 Hours
Lunch 1 Hour
Afternoon Session 3 Hours
Breaks Prescribed by Instructor

Our SQL Querying 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.

  • Connect to the SQL Database
  • Query a Database
  • Save a Query
  • Modify and Execute a Saved Query
  • Search Using One or More Conditions
  • Search for a Range of Values and NULL Values
  • Search Data Based on String Patterns
  • Perform Date Calculations
  • Calculate Data Using Aggregate Functions
  • Manipulate String Values
  • Sort Data
  • Rank Data
  • Group Data
  • Filter Grouped Data
  • Summarize Grouped Data
  • Use PIVOT and UNPIVOT Operators
  • Combine the Results of Two Queries
  • Compare the Results of Two Queries
  • Retrieve Data by Joining Tables
  • 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.”

Event Details

Phone: (602)252-3955

Email: registration@trainingtoyou.com

Other options for this content:

Scroll to Top