Microsoft
SQL
General
1013: Fundamentals of SQL Querying (1013)

In this 2-day instructor led course students will learn what SQL is and how it can help them query a database to answer business questions. This course will combine instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities. Students will learn how to use SQL statements to query a database. Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning.

About the course

Prerequisites:

The knowledge and skills that the learner should have before attending this course are as follows:

  • Basic end-user computer skills and some familiarity with database terminology and structure are required
  • The following courses or equivalent knowledge and skills are highly recommended:
    • Windows
    • Relational Databases Design (Second Edition)
    • Access: Designing a Database

Course Objectives:

Upon completing this course, the learner will be able to meet these overall objectives:

  • 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
Course content

Lesson 1: Executing a Simple Query

  • Connect to the SQL Database
  • Query a Database
  • Save a Query
  • Modify a Query
  • Execute a Saved Query

Lesson 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

Lesson 3: Working with Functions

  • Perform Date Calculations
  • Calculate Data Using Aggregate Functions
  • Manipulate String Values 

Lesson 4: Organizing Data

  • Sort Data
  • Rank Data
  • Group Data
  • Filter Grouped Data
  • Summarize Grouped Data
  • Use PIVOT and UNPIVOT Operators

Lesson 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

Lesson 6: Presenting Query Results

  • Save the Query Result
  • Generate an XML Report
Who Should Attend

The primary audience for this course is as follows:

  • Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.