Intermediate SQL (UGotClass)
Adult Enrichment / Computers & Technology -
UGotClass Winter 23
Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously.
Requirements:
- Windows 8 or later. Macs are not compatible.
- Necessary rights (local administrative rights) to install programs on the computer.
Prerequisite: Introduction to SQL - This class can be taken individually or as part of the SQL Certificate
Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ
Class details:
Unit 1: The Relational Database and Structured Query Language
|
Unit 2: Table Management
|
|
Unit 3: Selecting and Retrieving Data
|
Unit 4: Filtering Data
|
Cecelia Allison
Dr. Cecelia Allison is a course developer, published author, technical writer, and an online professor with more than 20 years of hands-on experience using and teaching SQL. She has taught over 90,000 students SQL worldwide. Through her past employment as a technical specialist, software tester, and teaching SQL, she has gained extensive experience in writing and implementing SQL. She holds a Bachelor of Science in Finance, a Master of Science in Information Systems, and a Doctor of Business Administration in Management Information Systems.
