CONTINUING EDUCATION HOME    
REGISTRATION HOME           
SEARCH    
MY ACCOUNT    

Course Schedule
Architecture
Business: Accounting/Finance
Business: Communication
Business: Healthcare
Business: Human Resource Mgt.
Business: Languages
Business: Leadership, Management & Supervision
Business: Lean and Six Sigma
Business: Marketing & Sales
Business: Public Relations & Communications
Business: Project Management
Business: Purchasing & Supply Management
Business: Skills Courses
Business: Train the Trainer
Certificate Programs
Computer: Adobe
Computer: Autodesk
Computer: Business Applications
Computer: Database
Computer: Desktop Support Specialist Certificate
Computer: Designing elearning
Computer: Geographic Information Systems(GIS/GPS)
Computer: Graphic Design
Computer: Hardware & CompTIA
Computer: Microsoft Certification
Computer: Microsoft Office
Computer: Spreadsheet
Computer: VMware
Computer: Web Design
Computer: Web Development & Programming
Access: Advanced Topics
Access: Database Application Development
Access: Introduction to Relational Database Design
Advanced Internet Prog. using Visual Basic.NET & XML Web Services
Advanced Visual Basic.NET Topics
Data Collaboration with XML
Enhancing Web Design with Active Server Pages
Introduction to Internet Prog. using ASP.NET & Visual Basic.NET
Introduction to Programming using Visual Basic.NET
Java Programming Language
Mastering Web Design/Advanced Web Authoring
Object-Oriented Programming using Visual Studio.NET
Programming Data Access with ADO.NET using Visual Basic.NET
Structured Query Language (SQL)
Session 2010-001
Web Design Basics/Introduction to HTML
Computer: Wordprocessing
Engineering: Autodesk
Engineering: Civil
Environmental
Legal Studies: Exam Reviews
Legal Studies: Paralegal Studies
Medical Coding
Safety Management
Test Preparation
Youth: Pre-College
Industry Solutions


Structured Query Language (SQL)
You will learn what SQL is and how it can help you query a database to answer business questions. You will also learn advanced queries and how to add, update, and delete data, tables, views, and indexes.
  • Define what a relational database is and identify some uses for the SQL language.
  • Recognize proper syntax for an SQL statement.
  • Use aggregate functions, column aliases, and mathematical expressions in a query statement.
  • Use the WHERE clause to select specific rows of information from a database.
  • Write queries that return both aggregate and non-aggregate information simultaneously.
  • Write queries that select information from two tables simultaneously.
  • Generate a query and its report using MIcrosoft Access.
  • Query with subqueries.
  • Add data to a database.
  • Change and delete data from a database.
  • Create, alter, and delete tables, and create, use, and delete views.
  • Manage how data is altered through the use of transactions.

    Prerequisites:Object-Oriented Programming using Visual Studio.NET, Microsoft Access 2003: Introduction to Relational Database Design or equivalent experience.


    For more information, contact Melissa Stafford at (225) 578-1263.

Select an upcoming session/workshop:
 

Session 2010-001
     (April 7-8, 2010)



© Copyright 1999-2010 Peopleware. All Rights Reserved.