212-828-7089
Excel on YouTubeExcel Class NYC Faceook PageExcel Class on LinkedInExcel Class on TwitterExcel Class on YelpExcel on BloggerExcel on WordpressGoogle Places

Return to Microsoft

SQL Training

SQL Training

SQLStructured Query Language (SQL) is used to write (statements) that manipulate data stored in databases. Where most classes require two days of training and strictly focus on Microsoft’s transact SQL (T-SQL), our course covers most topics in a single day and also covers Oracle’s MySQL highlighting differences between each vendor’s implementation of the ANSI standard.

class schedules

Course Schedules

Individuals
August 10
September 9
Companies
Register 4 or more students for a discount – Choose one full day or two half days
registerLength: 1 full day
Price: $295

Frequently Asked Questions

frequently asked questions

  • What time does class start?
    Weekday classes start at 9am
    Weekend classes start at 10am
  • Do I need to bring a computer?
    We provide a Windows computer.
  • Do I receive a certificate?
    Yes, upon completion you will receive an attractive gold foil certificate.
  • Are there any prerequisites?
    Ability to use a mouse and a keyboard. Familiarity with advanced Excel Index Match functions helpful.
  • Where are you located?
    31 West 34th Street. Convenient to Penn Station, NJ Transit, and the N, Q, R, W, B, D, F, 1, 2, 3, A, C, E trains.

About The Instructor

Glenn Harris is a Microsoft Certified Technical Trainer and Office Master Instructor with 20 years of classroom experience. He has published many training manuals on Microsoft products. Excel Class is the only class that offers programmed self-assessment labs and online access to videos of Glenn teaching class (to himself).
microsoft certified trainer
microsoft office master
certified technical trainer

SQL Outline

pdf outlineDownload a PDF

  • Lesson 1: SQL Terminology
    • Key Words Defined
    • Types of SQL
    • Microsoft T-SQL
    • Oracle MySQL
    • SQL Interfaces
    • Command Line
    • Graphical User Interface (GUI)
    • SQL Syntax Best-Practice
  • Lesson 2: Connect To A SQL Server
    • Microsoft T-SQL
      • Command Line
      • GUI
    • Oracle MySQL
      • Command Line
      • GUI
    • Use A Table
      • T-SQL
        • Command Line
        • GUI
      • MySQL
        • Command Line
        • GUI
    • Execute A Query
      • T-SQL
        • Command Line
        • GUI
      • MySQL
        • Command Line
        • GUI
  • Lesson 3: Select From A Single Table
    • Select All Columns And Rows
    • Select Specific Columns
    • Select Specific Rows with Where
    • Find Data With Wildcards
      • Like
      • Between And
    • Sort Queries With Order By
    • Top Queries
    • Cast Function
    • Concatenate Text
    • Coalesce Functions For Null Values
    • Cast Function
    • Convert Function
    • Distinct Clause
  • Lesson 4: Select From Multiple Tables
    • ANSI 89 – Where Clause
    • ANSI92 – Join Clause
      • Avoid Ambiguity
    • SQL Designer
    • SQL Calculated Columns
      • SUM Function
    • Group By Repeating Values
    • Calculate With Variables
    • Cross Join Queries
    • Inner Join Queries
  • Lesson 5: Action Queries
    • Create A Database
    • Create A Table
      • T-SQL
      • MySQL
    • Table Options
      • Fields
      • Data Types
      • Null
      • Auto Increment
      • Create Indices
    • Insert Rows
      • Primary Key Considerations
      • Foreign Key Considerations
    • Append Rows
      • Copy and Paste
      • Import And Append
    • Delete Rows
    • Drop Tables
    • Update Queries
  • Lesson 6: Views And Stored Procedures
    • Views
    • Stored Procedures
  • Lesson 7: Export Data
  • Lesson 8: SQL Resources
Summary
Event
SQL Training
Location
Excel Class, 31 West 34th Street,New York City,New York-10001
Description
Learn to write SQL statements with Microsoft SSMS, Visual Studio, and Oracle's MySQL Workbench. From beginner to advanced SQL in one day
Offer Price
USD 295