Introduction to SQL for Database Queries

Abstract

SQL is the widely accepted database language and knowledge of SQL is important when interacting with databases. It provides simple to complex query methods to extract, insert, update, and delete data from database tables. This introductory course is designed for people who would like to use SQL for basic database queries and analysis. This is a one day hands-on class that will provide students with practical working knowledge of the language.

Objectives

  • Define basic database structure Simple data retrieval
  • Filter data
  • Sort data
  • Create calculated fields
  • Use of data manipulation functions Summarize data
  • Group data
  • Use of subqueries
  • Join multiple tables

Outline

  • Understanding SQL
  • Retrieving Data
  • Sorting Retrieved Data
  • Filtering Data
  • Advanced Data Filtering
  • Using Wildcard Filtering
  • Creating Calculated Fields
  • Using Data Manipulation Functions
  • Summarizing Data
  • Grouping Data
  • Working with Subqueries
  • Joining Tables
  • Creating Advanced Joins
  • Combining Queries
  • Using Views
  • Working with Stored Procedures


Would you like help finding your SAS training solution? Call 1-800-997-7081 or email train@sys-seminar.com for assistance!