SQL Fundamentals of Querying SQL-E

Module 1What is Structured Query Language (SQL)?

• Relational Databases
• Basic SQL Keywords
• Tips for Planning Queries
• What People do with Queries

Module 2Selecting Data

• Using Select Statements to Examine Database Tables
• Using Results to Figure out other Tables to Examine
• Narrowing your SQL Statements to Fields you Need
• Sorting Records
• Using Field Aliasing
• Saving a SQL Statement

Module 3Getting Data from Multiple Tables

• Inner and Outer Joins
• Table Aliasing
• Self Joins

Module 4Using Criteria in SQL Statements

• Avoiding Ambiguous Situations
• Using a Single Criterion to Limit Records
• And/Or Situations in Criteria
• Criteria Keywords
• Using Comparison Criteria
• Using Wildcards

Module 5Generating Totals Using SQL

• Aggregate Keywords
• The Group By Clause
• Using Criteria in Aggregate-Based Queries

Module 6Generating Calculated Fields using SQL

• Math Calculations
• Using SQL Keywords to Enhance the Display of Data
• Date Calculations
• Text Calculations

Module 7Unions, Subqueries and More Joins

• Using where clause as an inner join
• Using unions
• Using Subqueries

Module 8Action Queries

• Using the INSERT Keyword
• Using UPDATE Statements
• Using the DELETE Keyword

Module 9Working with Views

• Creating a View to Simplify Data Retrieval
• Altering a View
• Creating a View to Restrict Accessible Data
• Inserting Data Through a View
• Deleting Views

Module 10Using SQL to Structure Databases

• Understanding Data Types
• Creating Tables
• Altering Tables
• Deleting Tables

Module 11Indexing

• Creating a single column index
• Creating a multiple-column index

Module 12Conditional Queries

• Using an IF statement
• Using a Case statement