SQL Querying: Fundamentals

Homes / Services / Training / SQL Querying: Fundamentals

Summary

Many organizations use databases to store their most critical information: the information that manages their day-to-day operations. After the data is stored in databases, however, it is useless unless you can retrieve it for further business analysis. One example of a database management system is Microsoft SQL Server 2012. The language you use to retrieve information from SQL Server 2012 databases is the Structured Query Language (SQL). This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.

Outline

  • Lesson 1: Executing a Simple Query

    • Topic 1A: Connect to the SQL Database
    • Topic 1B: Query a Database
    • Topic 1C: Save a Query
    • Topic 1D: Modify and Execute a Saved Query
  • Lesson 2: Performing a Conditional Search

    • Topic 2A: Search Using One or More Conditions
    • Topic 2B: Search for a Range of Values and NULL Values
    • Topic 2C: : Search Data Based on Patterns
  • Lesson 3: Working with Functions

    • Topic 3A: Perform Date Calculations
    • Topic 3B: Calculate Data Using Aggregate Functions
    • Topic 3C: Manipulate String Values
  • Lesson 4: Organizing Data

    • Topic 4A: Sort Data
    • Topic 4B: Rank Data
    • Topic 4C: Group Data
    • Topic 4D: Filter Grouped Data
    • Topic 4E: Summarize Grouped Data
    • Topic 4F: Use PIVOT and UNPIVOT Operators
  • Lesson 5: Retrieving Data from Multiple Tables

    • Topic 5A: Combine the Results of Two Queries
    • Topic 5B: Compare the Results of Two Queries
    • Topic 5C: Retrieve Data by Joining Tables
  • Lesson 6: Exporting Query Results

    • Topic 6A: Generate a Text File
    • Topic 6B: Generate an XML File

Course Schedule

DATES
LOCATION
START
END
STATUS
08/13/20 August 13, 2020
Lexington
9:00 am
4:30 am
Register
08/20/20 August 20, 2020
Louisville
9:00 am
4:30 am
Register
09/10/20 September 10, 2020
Louisville
9:00 am
4:30 am
Register
09/21/20 September 21, 2020
Virtual
9:00 am
4:30 am
Register
09/24/20 September 24, 2020
Lexington
9:00 am
4:30 am
Register
*Indicates a course that spans over multiple days.

**Indicates a course that is only a half day.