Course Information
Introduction to SQL
Course Description
This course teaches students the basics of the Structured Query Language (SQL) Language in a fast paced and hands-on environment. The course begins with a discussion of relational concepts and terminology and quickly moves into a practical discussion of data retrieval and manipulation using SQL.
Course Objectives
Understand the concepts of databases and SQL.
Write SQL queries that:
Use the SELECT and FROM statements.
Use the WHERE clause to select specific rows.
Use the LIKE keyword, wildcards, logical operators, and NULL testing.
Transform data using scalar functions, aggregate functions, and mathematical operators.
Group data via the GROUP BY and HAVING clauses.
Sort the results.
Use multiple tables via join operations.
Use Oracle SQL Developer to execute SQL statements and review the results.
Prerequisites
Basic computer literacy and editing skills.
Database skills not required.
Instructors
Chuck founded McCullough & Associates in 1991 to deliver software development skills to software development organizations in large companies. Clients include: Verizon, Tektronix, HP/Compaq, Samsung, Northern Telecom, DSC, Frito Lay, EDS, JC Penney’s, Brinker, Fidelity, Federal Reserve Bank, Legent Systems, General Electric, Compaq/Tandem, Mayo Clinic, Caterpillar, CI/WorldCom, Southwest Central Services, Cybertek, BlueCross, SW Airlines, AMR, PepsiCo, and others.
Technology areas include: C, C++, .Net, Java, TSQL, Object Oriented Analysis & Design, MFC, COM/DCOM/ActiveX, CORBA, Smalltalk. Strong practitioner of best practices, such as test-driven, iterative, patter-rich object-oriented application development.
Additional Information
TAC Rule 523.142(g) requires the CPE Sponsor to monitor individual attendance and assign the correct number of CPE credits. Participants will be asked to document their time of arrival and departure in compliance with this Rule. Additionally, attendance will be monitored throughout the day and CPE certificates will reflect actual attendance of each participant.
If you are making travel plans to come to Austin, we recommend making "refundable" air and hotel reservations or waiting until 14 days before the class to actually book your reservations. Courses are occasionally canceled or rescheduled due to low enrollment. We determine whether a course has enough participants 16 days prior to the course date. If we cancel or reschedule, we will email the participant and his or her billing contact no later than 14 days before the original class date.
A self-service vending area with beverages and snacks can be found on the first floor of our building next to the DPS office. There is also a refrigerator and microwave in our coffee bar area. Feel free to bring in your own drinks and food if you prefer.
You might want to bring a light sweater or jacket, as room temperatures vary.
To see answers to our Frequently Asked Questions, visit http://www.sao.texas.gov/training/faq.html