NFON 57332 - SQL, Intermediate - ONLINE

Course Description

In this course, you will learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. First, you will explore how to write and implement complex queries on multiple tables simultaneously and how to apply advanced filtering techniques. You will learn to create union queries that combine records from multiple queries, and you'll discover how to use union queries to exclude or include duplicate records. Next, you will master advanced techniques for updating various types of data stored in your tables. You will learn how to update a single field, multiple fields, multiple records, date fields, and calculated fields. And you will see how to update and set NULL values using an update statement. In addition, you will use advanced insertion techniques to add data to your tables and learn how to create, query, and modify temporary tables. You will also see how to implement techniques to handle duplicate values stored in a table and how to limit the results of a result set. And finally, you will discover how to use string functions to perform complicated searches on strings, how to implement date and time functions to insert and extract portions of a date, and how to create queries that accept input from users. Note: Microsoft Access 2003 or later (software must be installed and fully operational before the course begins); you can download (after you download the trial and open it, do not complete the activation portion within the software until the first day of class) a free 60-day trial of Microsoft Access from the Microsoft web site: http://www20.buyoffice.microsoft.com/usa/product.aspx?sku=10234386&cache=-944519518&culture=en-us. Before downloading the Microsoft Access trial, be sure to refer to the system requirements on the site. Depending on your operating system, you may be required to install additional service packs which are available at the Microsoft Download Center: http://www.microsoft.com/downloads/en/default.aspx.