SQL Programming: Introduction and Beyond Training in Gresham

Enroll in or hire us to teach our SQL Programming: Introduction and Beyond class in Gresham, Oregon by calling us @303.377.6176. Like all HSG classes, SQL Programming: Introduction and Beyond may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, SQL Programming: Introduction and Beyond may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.

Course Description

 
The ability to write the SQL language the cornerstone of all relational database operations is essential for anyone who develops database applications. In this training course, you learn how to optimize the accessibility and maintenance of data with the SQL programming language, and gain a solid foundation for building, querying, and manipulating databases.
Course Length: 2 Days
Course Tuition: $1090 (US)

Prerequisites

None

Course Outline

 
Introduction to Database Concepts
Features of a Relational Database
Where does SQL Fit in?
Database Access
 
Database Design
The Primary Key
Foreign Key Relationships
Data Models and Normalization
Second Normal Form (2NF)
Third Normal Form (3NF) and Beyond
 
DDL – Data Definition Language
DDL & DML Overview
Building Table Definitions
Identifiers
Column Definitions
Numeric Datatypes
ENUM and SET Types
Date and Time Datatypes
AUTO_INREMENT
UNIQUE Constraints
Primary Keys
Modifying Tables
Foreign Keys
Renaming and Dropping Tables
 
DML – Data Manipulation Language
DDL & DML Overview
Data Values: Numbers
Data Values: Strings
Working with NULL Values
Bulk Loading of Data
Bulk Data Format
Working with Special Values in Bulk Data
Adding New Table Rows with INSERT
Copying Rows
UPDATE
REPLACE
Removing Table Rows
Transactions
InnoDB: Using Transactional Processing
Locking Tables
 
Queries – The SELECT Statement
SELECT Syntax Summary
Choosing Data Sources and Destinations for SELECT
Presentation of Table Data with SELECT
Being Selective About Which Rows are Displayed
User-Defined Variables
Expressions and Functions
Control Flow Operators and Functions
Function Names
Comparison Operators and Functions
String Functions
Numeric Operators and Functions
Date and Time Functions
Forcing Data Interpretation
Miscellaneous Functions
 
Building a Result Set from Several Sources
UNION
Combining Data from Two Tables
Using WHERE to Choose Matching Rows
INNER JOIN
OUTER JOINs
Multiple Tables, Fields, Joins, and Ordering
SELECT * and USING Columns
 
Advanced SQL Techniques
Multipliers, Anchors, and Grouping
GROUP BY
Aggregates
Subqueries
Subquery Comparisons and Quantifiers
Other Subqueries
Subquery Alternatives and Restrictions
InnoDB Multi-Table Updates and Deletes
Building a VIEW
Updatable VIEWs
 
Database Programmability
Stored Routines: Basic Concepts
Routine Creation and Use
Flow Control Statement
Writing Blocks of Code
Triggers
Stored Routines, Triggers, and the Binary Log
Table HANDLERs
Prepared Statements
 
Optimization and Performance Tuning
Optimizing Your Database
Optimizing Queries
The Use of Indexes to Support Queries
Thinking about JOIN Queries
Query Sorts, Indexes, and Short-Circuiting
INSERT, UPDATE, DELETE, and Table Locks
Some General Optimizations
 
 

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.