SQL Programming: Introduction and Beyond Training in Trenton

Enroll in or hire us to teach our SQL Programming: Introduction and Beyond class in Trenton, New Jersey 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.

Answers to Popular Questions:

Yes, this class can be tailored to meet your specific training needs.
Yes, we provide consulting services.
Yes, group discounts are provided.

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)



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
Column Definitions
Numeric Datatypes
ENUM and SET Types
Date and Time Datatypes
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
Removing Table Rows
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
Combining Data from Two Tables
Using WHERE to Choose Matching Rows
Multiple Tables, Fields, Joins, and Ordering
SELECT * and USING Columns
Advanced SQL Techniques
Multipliers, Anchors, and Grouping
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
Stored Routines, Triggers, and the Binary Log
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
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.