110 Polaris Parkway, Suite 100, Westerville, OH 43082, 614-505-0770, resultdata@resultdata.com
© 2020 Result Data Consulting, Ltd. - all rights reserved - This site uses cookies

SQL Level 1 Training Class

Introduction to SQL - 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 common 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.

Register for a SQL Level 1 Class
Select a Class Date

Course Outline and Details

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.

rd-logo-2.png

better data, better results