Print Course information
Email me when offered.
Return to Course Catalog

Workshops

SQL Queries for Mere Mortals   

Learn the basics of retrieving data from MySQL, Microsoft SQL Server, Oracle SQL, or even Microsoft Access and Excel. For anyone who creates Access databases or Excel spreadsheets, financial officers, data miners, software support analysts, database administrators, or software developers. By using the native language of your database server you can get the information you need quicker and more accurately than any other tool. Cut your development time for reports and applications tremendously.

SQL allows the user to turn “data” into usable “information.” Each learning section is followed by both an instructor-led hands-on and independent student practice.

You will learn to use the SQL structures of SELECT, INSERT, UPDATE, and DELETE with emphasis on SELECT. Cutting through the noise of too much information, filtering, is discussed and practiced using the WHERE, GROUP BY, and HAVING clauses.

Since most databases are multi-tabled: UNIONs, INNER, LEFT, and RIGHT JOINS are discussed and practiced. You will learn to make complex information gathering tasks more manageable by learning to use subqueries.

DB design, history, and best practices are touched upon.

Click here for information on our Administering SQL Server Server class.

No sections are currently available for this workshop. Click here to continue searching for workshops.

If you have any questions, please email us at cce.information@icc.edu.

Some Title