Great course by Cecilia. It was well written, easy to read and understand. The assignments enforced what was presented in the lesson."
Cecelia, I've learned a lot from both of your SQL courses (Introduction & Intermediate). I appreciate the opportunity to study online (good use of time since I work full-time with a daily commute). I've enjoyed these classes, thank you."
Cecelia Allison is by far the best instructor that I've had. She teaches in a way that makes it so easy to understand. I have read books by others who taught SQL and there is no comparison. I strongly recommend her course to anyone wanting to learn SQL."
I enjoyed the class. Great writing! Things were explained very well. For me, some things were a review and I was challenged by several new things, so it was the perfect course for me. I feel the content was very practical and I can put it to use immediately in my job. Thank you!"
Cecelia is so organized and she presents the information in understandable components. Her instructions are outstanding! This is the second course I’ve taken by Cecelia and I would highly recommend her courses."
This is my second course from this particular instructor. She definitely is an expert in her field and provided a learning environment that was conducive to learning and understanding. I appreciate that the information was understandable as I had no prior experience with SQL before her two classes. Thank you again."
I really like this instructor's teaching style. The lessons are the right length and always presented in a way which makes it easy to retain the information. Her teaching by example helps me apply what I learn and better understand how to approach similar problems."
I had last used MS Access in 2002. My new work assignment required the use of MSA 2010. The use of the MSA tool plus the SQL technique training helped me greatly to "get up to speed" on both SQL use with MSA and the new environment that MSA 2010 provides. The thorough explanations and comparisons in SQL, as I had been using SQL/89, and the options made available proved valuable."
I took the Introduction course with Cecelia as well, and I enjoyed both courses. I really liked how the Intermediate course had you try what she was teaching during the lesson and prior to trying it for the first time in an assignment. It helped me to learn the material in a more effective way. I also found the tips to be especially helpful, because she explained the reasoning behind doing things one way vs another. It was like she was reading my mind! I would definitely take another course taught by Cecelia and would recommend her classes."
Course Code: ins
Get a quick review of some of the basic concepts of the SQL language, including commonly used keywords, SQL data types, constraints, logical operators, and comparison operators. Then, discover how to query multiple tables using subqueries.
Learn how to use unions to create queries that combine records from multiple queries, enabling you to either exclude or include duplicate records. You also will learn how to order the results from a union query, how to create an alias within a union query, and how to use a text string to display a value in a union query. Then find out how to create joins using SQL-92 and SQL-89 syntax.
Learn how to use advanced update techniques to update data stored in your tables. Then, find out how to use advanced insertion techniques to add to your tables.
Learn advanced filtering techniques that implement the LIKE operator. Then, see how to create, query, and modify temporary tables.
Learn how to handle duplicate values stored in a table and how to limit the results of a result set. Then learn how to use string functions to manipulate strings.
Learn how to use the NOW () function to insert the date and time and how to insert a calculated date and time. And you'll learn how to use the YEAR (), MONTH (), MONTHNAME (), WEEKDAY (), and WEEKDAYNAME () functions to extract the year, month, name of the month, week, and name of the week from a date. You'll also learn how to use the FORMAT () function in a subquery to format dates. Finally, learn how to create and implement parameter queries.
Dr. Cecelia Allison is an experienced software tester and technical specialist with more than 15 years of hands-on experience using and teaching SQL. She is also a technical writer, a published author, and a university professor. 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.
There are no prerequisites for this course.
Microsoft Access 2003 or later (software must be installed and fully operational shortly before the course begins). Microsoft Access is bundled with Microsoft Office at the following web site: https://products.office.com/en/try. Depending on your operating system, you may be required to install additional service packs, which are available at the Microsoft Download Center: https://www.microsoft.com/en-us/download.
NOTE: This course is not suitable for Macintosh users.
A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits!
Once a session starts, two lessons will be released each week, for the six-week duration of your course. You will have access to all previously released lessons until the course ends.
Keep in mind that the interactive discussion area for each lesson automatically closes 2 weeks after each lesson is released, so you’re encouraged to complete each lesson within two weeks of its release.
The Final Exam will be released on the same day as the last lesson. Once the Final Exam has been released, you will have 2 weeks plus 10 days to complete the Final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.