SQL Querying Training

SQL Querying Introduction Training

Course Duration: 1 Day

This Course Covers Version(s): N/A

Available Delivery Methods

In this SQL Querying Introduction Training course, students will learn the basics of retrieving data from a database using Structured Query Language (SQL.) Students will also learn how to sort, filter and group data in a query result. In addition this course shows students how to join tables in a SQL statement and how to use basic SQL functions.

Upon successful completion of this course, students will be able to:

  • Connect to the SQL Server database and execute a simple query
  • Include a search condition in a simple query
  • Use various functions to perform calculations on data
  • Organize data obtained from a query before it is displayed on-screen
  • Retrieve data from tables
  • Format an output, save a result, and generate a report
  1. Executing a Simple Query
    • Connect to the SQL Database
    • Query a Database
    • Save a Query
    • Modify a Query
    • Execute a Saved Query
  2. Performing a Conditional Search
    • Search Using a Simple Condition
    • Compare Column Values
    • Search Using Multiple Conditions
    • Search for a Range of Values and Null Values
    • Retrieve Data Based on Patterns
  3. Working with Functions
    • Perform Date Calculations
    • Calculate Data Using Aggregate Functions
    • Manipulate String Values
  4. Organizing Data
    • Sort Data
    • Rank Data
    • Group Data
    • Filter Grouped Data
    • Summarize Grouped Data
    • Use PIVOT and UNPIVOT Operators
  5. Retrieving Data from Tables
    • Combine Results of Two Queries
    • Compare the Results of Two Queries
    • Retrieve Data by Joining Tables
    • Check for Unmatched Records
    • Retrieve Information from a Single Table Using Joins
  6. Presenting Query Results
    • Save the Query Result
    • Generate an XML Report

Basic end-user computer skills and some familiarity with database terminology and structure are required.

Live, Instructor-Led Online Class for INDIVIDUALS

$325.00

  • Open Enrollment Class for Individuals
  • Live Class with an Instructor
  • Six Months of Instructor Email Support
  • Hands-on Exercises and Student Labs
  • Classes Never Cancelled Due to Low Enrollment
  • Money-back Guarantee
Click here to load this Caspio Online Database.

Live, Instructor-Led Online or Onsite Class for GROUPS

Contact Us For Quote

  • For Private Groups as small as 2 people
  • Live, Instructor-led Online or Onsite Class for your group.
  • Hands-on Exercises and Student Labs
  • Customizable
  • Six Months of Email Support After Class
  • Money-back Guarantee
Click here to load this Caspio Online Database.