Private

SQL Class

Would you prefer to take a private online SQL class with one of our certified trainers, that is customized to suit your specific needs, or perhaps just need some expert help with a project or problem and at no additional cost?

Take advantage of the latest technology

providing personal 1:1 tuition with an experienced instructor. We can offer flexible dates and times to suit your schedule.

SQL classes
in Columbus

SQL level 1 beginner class in Columbus

Course Description:

SQL or Structured Query Language is a standard language used to communicate with almost any database including MySQL, Microsoft SQL Server, Microsoft Access and Oracle.
This course will teach you all you need to know about SQL from basics to advanced joins.

SQL level 1 beginner class in Columbus

Course Outline:

Introduction

What is SQL

Relational Databases

SQL and Standards

SQL Implementations

Client - Server

SQL Syntax

Select Statements

Overview of select

Selecting One Field

Selecting Multiple Fields

Using a Wild Card

Calculations

Filtering Results

Limiting rows

Exercise

Using WHERE

Using AND/OR and NOT

Using LIKE

Functions

String Functions

Numeric Functions

Date Functions

Aggregate (Group) Functions

Sorting and Grouping

Sorting Results

Grouping Results

Column Aliases

Filtering Using Having

Joins

Inner Joins

Self Joins

Outer Joins

Joining Multiple Tables

Sub Queries
Create,Drop Delete and Alter

Create Database

Create Schema

Create TablData Types

Field Modifiers

Create Select

Create View

Drop Queries

Delete

ALTER TABLE

INSERT

INDEXES

Update Queries

Transactions

Database Design

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.

We guarantee your training when you register for a SQL class in Columbus, even if you are the only student. We will not cancel your class due to "low enrollment" in Columbus and offer all our students a full refund if they are not satisfied with their SQL training course. You are also welcome to retake the SQL class at no charge for up to 6 months