978.250.4983

SQL Programming Course

Locations in Abilene, Amarillo, Arlington, Garland, Laredo, Lubbock, Irving, Midland, Plano, Richardson and Wichita Falls

Course Search

SQL Programming

Duration: 3 days | Price: $1795

View Schedule

This SQL programming training course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements. Extensive hands on exercises are used throughout to reinforce learning and develop real competency.

Course Prerequisites

General computer knowledge.

Course Overview

  • Introduction to Relational Databases and SQL
  • Relational Database Management Systems
  • Relational Database Components
  • Structured Query Language (SQL)
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Control Language (DCL)
  • Syntax Categories
  • SQL Server Management Studio
  • Designing Relational Databases
  • Database Design Process
  • Designing Table Structures
  • Completing the Physical Model
  • Creating Databases and Tables
  • Creating Databases and Schemas
  • Data Definition Language (DDL)
  • SQL Code Editors
  • Schemas on SQL Server
  • Creating and Modifying Tables
  • Creating Indexes
  • SQL Server Indexes
  • Dropping (Deleting) Objects
  • Working with Records
  • Data Manipulation Language (DML)
  • JOIN Statements
  • How Joins Work
  • Using MIN() and MAX()
  • Using AVG()
  • Using SUM()
  • Using COUNT()
  • Stored Procedures and Custom Functions
  • CREATE PROCEDURE Syntax
  • Using IF…ELSE
  • Views and Triggers
  • Database Security and Transactions
  • Data Control Language (DCL)