|Check-in Time:||12:00 am|
|Start Time:||12:00 am|
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.
- 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
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.
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.
Call us at 614.505.0770 for more information.