SQL Programming

Length: 3 days | Price: Please contact us for pricing information.

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.

Prerequisites: General computer knowledge. Familiarity with relational database concepts is helpful but not required.

SQL Programming Training 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)

IT Training Across the Mid-Atlantic