Course: SQL Level 1 – Introduction to SQL

Date: 01-29-2020
Duration: 1 day
Check-in Time: 8:30 am
Start Time: 9:00 am
Location: Result Data Training Room 1
Fee: $485.00
Register for this Course

Course Outline

This one day workshop is designed to provide the student with a solid understanding of database concepts and the basics of the SQL language. It includes review of database structures, application architecture, SQL constructs and client-server fundamentals. The course utilizes a series of hands on activities where the student writes, executes and examines SQL statements using 92ANSI compliant (multi-vendor) SQL syntax. The exercises are progressive adding more sophisticated elements of SQL on to existing work. The course is taught by an experienced consultant with a SQL development and programming background and substantial real world exposure.

TOPICS COVERED:

  • Database Fundamentals & Vocabulary
  • Database Types (Sequential vs. Relational)
  • Relational Concepts Overview (RI, PK, FK)
  • Installing & Configuring a Database Client
  • ODBC/ADO Overview
  • SQL constructs
  • Basic Select Statements
  • Selecting Distinctly (distinct)
  • The Where and Order By clauses
  • Multi-Table Joining (inner & outer joins explained & tested)
  • Aggregate Functions (Sum, Count etc.)
  • Group By
  • Deleting Data Conditionally
  • Updating Data Conditionally
  • Inserting Data

MATERIALS:
Slides and other course materials are available to students in electronic format (via download).

WHO SHOULD ATTEND:
Individuals with little or no SQL experience. This course is targeted at users who will need to write, analyze and use SQL statements. It’s ideal for database administrators, analysts, consultants, programmers, business people or anyone seeking to have a greater understanding of the SQL language.

PREREQUISITES:
No prior database experience is necessary (but it’s helpful). A firm understanding of MS-Windows and Windows applications is mandatory. The course is best suited for people who have used spreadsheets and word processing applications for several years and wish to learn about databases and the SQL language.

MORE INFORMATION:
Call us at 614.505.0770 for more information.

Registration

Request a seat for this Course

We'd love to have you in our class! Please fill out this form to request a seat.