SQL statements are used to perform tasks such as updating data on a database, or retrieving data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, and others.
Some of these database systems will have extensions specific only to their system. However, the standard SQL commands such as “Select”, “Insert”, “Update”, “Delete”, “Create”, and “Drop” are used with all these database systems.
Course Content
- Lesson 1: Executing a Simple Query
- Lesson 2: Performing a Conditional Search
- Lesson 3: Working with Functions
- Lesson 4: Organizing Data
- Lesson 5: Retrieving Data from Multiple Tables
- Lesson 6: Exporting Query Results
Please Note:- You may want to bring a flash (thumb) drive on which to store your completed exercise files.
- Business casual attire is recommended. A sweater or light jacket which you can remove or put on is a good idea if you get cold easily.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.