SQL » SQL Fundamentals - Introduction & Intermediate

Email this page | Print this page      

SQL Fundamentals of Querying


The SQL Advanced course (2 days) is follows this course. See dates to register.
* Training at your company site (group or 1on1) -- click here.
 

Course Description
You have access to company databases and your job may require you to retrieve data from those databases. Retrieval of information from a database is dependent on precisely ordered logic and specific information. This course will help you to use Structured Query Language (SQL) as a tool to implement that logic and define instructions.

Course Objective: You will learn how to compose SQL queries to retrieve information from the database.

Performance-Based 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 based on the data types to perform calculations on data.
  • organize the data obtained from the query before it is displayed on the screen.
  • retrieve data by combining information from multiple tables.
  • format the output, save the result, and generate a report.


Course Content

Lesson 1: Executing a Simple Query

Topic 1A: Connect to the Database
Topic 1B: Query the Database
Topic 1C: Modify a Query
Topic 1D: Save a Query
Topic 1E: Execute a Saved Query

Lesson 2: Performing a Conditional Search

Topic 2A: Search Using a Simple Condition
Topic 2B: Compare Column Values
Topic 2C: Search Using Multiple Conditions
Topic 2D: Search for a Range of Values and Null Values
Topic 2E: Retrieve Data Based on Patterns

Lesson 3: Working with Functions

Topic 3A: Perform Date Calculations
Topic 3B: Calculate Data
Topic 3C: Manipulate String Values

Lesson 4: Organizing Data

Topic 4A: Sort Data
Topic 4B: Group Data
Topic 4C: Filter Grouped Data
Topic 4D: Summarize Grouped Data

Lesson 5: Retrieving Data from Multiple Tables

Topic 5A: Combine Results of Two Queries
Topic 5B: Retrieve Data by Joining Tables
Topic 5C: Check for Unmatched Records
Topic 5D: Retrieve Information from a Table Using Joins

Lesson 6: Presenting Query Results

Topic 6A: Customize and Save the Query Result
Topic 6B: Generate an HTML Report



Email this page | Print this page      
Available locations for this course:
SQL Fundamentals - Introduction & Intermediate Training in Orange County | SQL Fundamentals - Introduction & Intermediate Training in Portland | SQL Fundamentals - Introduction & Intermediate Training in Tucson | SQL Fundamentals - Introduction & Intermediate Training in Springfield | SQL Fundamentals - Introduction & Intermediate Training in Savannah | SQL Fundamentals - Introduction & Intermediate Training in Newark | SQL Fundamentals - Introduction & Intermediate Training in Sacramento | SQL Fundamentals - Introduction & Intermediate Training in Phoenix | SQL Fundamentals - Introduction & Intermediate Training in Chicago | SQL Fundamentals - Introduction & Intermediate Training in Seattle |