SQL Scripting Fundamentals Training
Increase your marketability as a web developer, programmer, or database administrator with our SQL training.
In
this SQL training class, you'll master the skill of writing correct and effective SQL (Structured Query Language) statements that manipulate and
retrieve data from your database. Once you know SQL, you can use it to interact with most major databases, such as MS Access, Oracle, Microsoft SQL
Server, and MySQL.
Prerequisites:
- Experience with a desktop database such as Filemaker or MS Access. *Please note: A Mac environment will not work for this class
What is Structured Query Language (SQL)?
- Relational Databases
- Basic SQL Keywords
- Tips for Planning Queries
- What People Do with Queries
- SQL Platforms
Selecting Data
- Using SELECT Statements to Examine Database Tables
- Using Results to Figure Out Other Tables to Examine
- Narrowing Your SQL Statements Down to Fields You Need
- Sorting Records
- Using Field Aliasing
- Saving a SQL Statement
Getting Data From Multiple Tables
- Inner and Outer JOINS
- Table Aliasing
- Self JOINS
Using Criteria in SQL Statements
- Avoiding Ambigious Situations
- Using A Single Criterion to Limit Records
- AND/OR Situations in Criteria
- Criteria Keywords
- Using Comparison Criteria
- Using Wildcards
Generating Totals Using SQL
- Aggregate Keywords
- The GROUP BY Clause
- Using Criteria in Aggregate-based Queries
Generating Calculated Fields Using SQL
- Math Calculations
- Using SQL Keywords to Enhance the Display of Data
- DATE Calculations
- TEXT Calculations
UNIONS, SUBQUERIES, and More JOINS
- Using a WHERE Clause as an INNER JOIN
- Using UNIONS
- Using SUBQUERIES
Action Queries
- Using the INSERT Keyword
- Using the UPDATE Statements
- Using the DELETE Keyword
Working with VIEWS
- Creating a VIEW to Simplify Data Retrieval
- Altering a VIEW
- Creating a VIEW to Restrict Accessbile Data
- Inserting Data Through a VIEW
- Delete VIEWS
Using SQL to Structure Databases
- Understanding DATA Types
- Creating Tables
- Altering Tables
- Deleting Tables
Indexing
- Creating a Single-Column Index
- Creating a Multiple-Column Index
- Dropping an Index
Conditional Queries
- Using an IF Statement
- Using a CASE Statement
Common Tables Expressions
- Creating and Using Common Table Expressions (CTES)