On-Line: Intermediate SQL

Course Number:ZOLNE2G01
Begin Date:2022-06-15
End Date:2022-08-05
Days/Times:null Anytime, Day or Night
Number of Sessions:12
Description:Expand your knowledge of Structured Query Language (SQL), the industry standard database programming language. In this course, you’ll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. You’ll explore how to write and implement complex queries on multiple tables simultaneously, and you’ll discover advanced filtering, update, and insertion techniques. You’ll also find out how to create queries that accept input from users and queries that perform complicated searches on strings and dates. By the end of this course, you’ll be able to use a wide range of advanced SQL techniques with confidence. Your new skills with databases will enhance your competitiveness in the technical fields of software development and database administration. Requirements: 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. Any Windows Operating System; Internet access, e-mail, the Microsoft Internet Explorer or Mozilla Firefox Web browser, and the Adobe Flash and PDF plug-ins (two free and simple downloads you obtain at http://www.adobe.com/downloads by clicking Get Adobe Flash Player and Get Adobe Reader). Note: this course is not suitable for Macintosh users.
Register For This Course

Return to Course Listings