West Des Moines Community Schools Community Education

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. Students should have a competency in the Introductory level of SQL. Requirements: - Windows 10 or later. Macs are not compatible. - Necessary rights (local administrative rights) to install programs on the computer. To progress through this course you will: Read the print readings. Have the option of accessing the online readings. Listen to the audio presentation for the Unit and view the slides. Have the option of taking a self-quiz to see how much you have learned. Engage in written online discussion with your instructor and other participants. The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience. Discussion: The discussion for each unit lasts one week. All comments are made in writing and can be made at any time of the day or night. Your instructor will log into the discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants. We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.

Transform your customer service into something extraordinary. As a result more repeat business will improve your bottom line. Customer service separates you from your competition. Extraordinary customer service comes from focusing on the few essential elements that yield big results. Discover how easy it is to tweak your customer service from the ordinary to the extraordinary. You'll take away a customer service plan that will help you focus on the key elements that will get you started on your pathway to success. To progress through this course you will: Read the print readings. Have the option of accessing the online readings. Listen to the audio presentation for the Unit and view the slides. Have the option of taking a self-quiz to see how much you have learned. Engage in written online discussion with your instructor and other participants. The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience. Discussion: The discussion for each unit lasts one week. All comments are made in writing and can be made at any time of the day or night. Your instructor will log into the discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants. We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.

Learning to build your customer service skills will have a powerful impact on your career success as well as success in other areas of your life. Through this course you will discover the direct relationship between service skills and career achievement. You will become skilled at being an exceptional service provider. You can help your organization and your career by translating your good service intentions into a workable plan and gain knowledge of ways to consistently deliver great service. The payoff is enormous. To progress through this course you will: Read the print readings. Have the option of accessing the online readings. Listen to the audio presentation for the Unit and view the slides. Have the option of taking a self-quiz to see how much you have learned. Engage in written online discussion with your instructor and other participants. The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience. Discussion: The discussion for each unit lasts one week. All comments are made in writing and can be made at any time of the day or night. Your instructor will log into the discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants. We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.