Instructor-led training

SQL Programming: Introduction and Beyond Training in Totowa, New Jersey

The ability to write the SQL language the cornerstone of all relational database operations is essential for anyone who develops database applications.

Request a Training Proposal View Course Outline

What you'll learn

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.

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

Training locations

SQL Programming: Introduction and Beyond training across the U.S. and beyond.

We provide SQL Programming: Introduction and Beyond training onsite and live online for organizations throughout the United States and internationally.

View all SQL Programming: Introduction and Beyond training locations

Ready to train your team?

Let's customize this training for your organization.

Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.

Request a Training Proposal

or call 303.377.6176