SQL Querying Fundamentals - Part 1 Virtual Classroom Live January 22, 2018

Price: $450

This course runs for a duration of 1 Day.

The class will run daily from 9:00am to 5:00pm.

Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

Description

In this course, students will compose SQL queries to retrieve desired information from a database.

Course Objectives

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.

Target Student:

This course is intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Course Overview

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

Course Comments

This course is the starting point for those who are new to SQL or a good refresher for those who have some knowledge but would like to fine tune their skills.

The SQL information is ANSI standards and can be applied to any RDBMS, including DB2, Oracle, SQL/Server, Sybase, etc.

You may also be interested in our Microsoft Querying Class: Writing Analytical Queries for Business Intelligence- Course 55232

Other Available Dates for this Course

Virtual Classroom Live
April 29, 2024

$490.00

Featured Class 1 Day 8:00 AM CT - 4:00 pm CT

Virtual Classroom Live
May 10, 2024

$490.00