SQL classes logo

SQL classes

 


 

 

 

 

  • SQL Beginner Class 

Sorry, we currently do not have any public classes scheduled for the Capivate level 1 class. Please contact us to see if we can put one on the schedule for you

Sorry, we currently do not have any public classes scheduled for the SQL level 1 class. Please contact us to see if we can put one on the schedule for you

SQL level 1 beginner class


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


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 class. We may change or alter the course topics to meet the objectives of a particular class.