Does your kiddo love science? In this camp they will experience different domains of science and nature. Concepts taught include everything from astronomy, earth science and biology to chemistry and physics using LEGO® bricks and other interactive learning tools. We will make science fun! To ensure that our high-quality enrichment classes are accessible to all families, Minneapolis Community Education offers fees on a sliding scale. The class fee is the average cost of providing a class. Families are asked to pay the class fee or pick a price that they can pay. When families participate as they are able, at all levels of our sliding scale, the whole program becomes self-sustaining. Thank you for your consideration as you register for summer programs!

Structured Query Language (SQL) is the industry standard database programming language. It is one of the most in demand skills in occupations that require interaction with data and analyzing data. Through your knowledge of Structured Query Language, you will become more marketable in computer related career fields that pertain to database administration. Learning SQL can also lead to a job that is specific to analyzing data such as a data analyst, a quality assurance analyst, or a business analyst. You’ll first learn about relational database structures, the history and uses of Structured Query Language, and how to use Structured Query Language to create a database, add records to database tables, and how to use SQL queries to extract meaningful data from database tables. You will quickly progress from creating simple SQL queries that query a single table to querying multiple tables simultaneously. You’ll also learn how to alter data in a database and how to gather significant statistics from data stored in a database. Finally, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. This certificate will enhance your competitiveness in the field of database administration and data analyst jobs. Requirements: Windows 8 or later. Macs are not compatible. Necessary rights (local administrative rights) to install programs on the computer. This Certificate must be taken in the following order: Introduction Intermediate Advanced 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: Introduction to SQL Unit 1: The Relational Database and Structured Query Language The relational database structure Structured Query Language Table creation and data insertion Defining datatypes and constraints Creating Indexes Unit 2: Table Management Table management Adding columns to a table Deleting columns from a table Deleting a table Unit 3: Selecting and Retrieving Data Creating a SELECT statement to retrieve data Using DISTINCT to display unique values in a column Using the AS keyword to create an alternate name for a column Merging columns Unit 4: Filtering Data Creating a WHERE clause Using comparison, character, and logical operators to match conditions Using the IN operator to match a condition Using the BETWEEN operator to match a condition Intermediate SQL Unit 1: The Relational Database and Structured Query Language The relational database structure Structured Query Language Table creation and data insertion Defining datatypes and constraints Creating Indexes Unit 2: Table Management Table management Adding columns to a table Deleting columns from a table Deleting a table Unit 3: Selecting and Retrieving Data Creating a SELECT statement to retrieve data Using DISTINCT to display unique values in a column Using the AS keyword to create an alternate name for a column Merging columns Unit 4: Filtering Data Creating a WHERE clause Using comparison, character, and logical operators to match conditions Using the IN operator to match a condition Using the BETWEEN operator to match a condition Advanced SQL Unit 1: Creating Advanced Subqueries Structured Query Language Review Using the IN keyword to link queries Using the EXISTS keyword to link queries Using the ANY keyword to link queries Using the ALL keyword to link queries Unit 2: Creating Advanced Joins Creating inner joins review Creating outer joins review Creating joins with aggregate functions Creating nested joins Unit 3: Creating Union Queries Creating UNION queries Creating UNION ALL queries Creating a WHERE clause and multiple UNION queries Unit 4: Transaction Processing, Stored Procedures, Triggers Implementing transaction processing Implementing stored procedures Implementing triggers

Mix secret potions to create goo, slime, Oobleck and bubbles. Come dressed for a mess and find the fun in gunk. To ensure that our high-quality enrichment classes are accessible to all families, Minneapolis Community Education is now offering fees on a sliding scale. The different prices reflect the average cost of offering a class as well as a discounted option and options that help us cover our administrative costs. Fees cover instructor pay, most class supplies, program materials, marketing and scholarships. Families are asked to pick the price that they are able to pay. As always, we will continue to offer additional financial assistance upon request. When families participate as they are able, in all levels of our sliding scale, the whole program becomes self-sustaining. Thank you for your consideration as you sign up for summer programs!

Perform experiments to discover the magic of light and sound. Harness a better understanding of the wonders around you. To ensure that our high-quality enrichment classes are accessible to all families, Minneapolis Community Education is now offering fees on a sliding scale. The different prices reflect the average cost of offering a class as well as a discounted option and options that help us cover our administrative costs. Fees cover instructor pay, most class supplies, program materials, marketing and scholarships. Families are asked to pick the price that they are able to pay. As always, we will continue to offer additional financial assistance upon request. When families participate as they are able, in all levels of our sliding scale, the whole program becomes self-sustaining. Thank you for your consideration as you sign up for summer programs!

Prepare for liftoff! Reach for the stars as you learn about our solar system and universe through activities, books, crafts and games. To ensure that our high-quality enrichment classes are accessible to all families, Minneapolis Community Education is now offering fees on a sliding scale. The different prices reflect the average cost of offering a class as well as a discounted option and options that help us cover our administrative costs. Fees cover instructor pay, most class supplies, program materials, marketing and scholarships. Families are asked to pick the price that they are able to pay. As always, we will continue to offer additional financial assistance upon request. When families participate as they are able, in all levels of our sliding scale, the whole program becomes self-sustaining. Thank you for your consideration as you sign up for summer programs!

Does running through the rain help you stay dry? Can you cook an egg on the sidewalk on a hot day? What questions do you have? Join us in this class based on the popular show and test the myths. To ensure that our high-quality enrichment classes are accessible to all families, Minneapolis Community Education is now offering fees on a sliding scale. The different prices reflect the average cost of offering a class as well as a discounted option and options that help us cover our administrative costs. Fees cover instructor pay, most class supplies, program materials, marketing and scholarships. Families are asked to pick the price that they are able to pay. As always, we will continue to offer additional financial assistance upon request. When families participate as they are able, in all levels of our sliding scale, the whole program becomes self-sustaining. Thank you for your consideration as you sign up for summer programs!

Take your slime skills to the next level! Concoct an array of slimes like butter, clear and cloud, confetti and scented slime; all with different textures, colors and styles. Use your slime for challenges and have a glow-in-the-dark slime party. To ensure that our high-quality enrichment classes are accessible to all families, Minneapolis Community Education is now offering fees on a sliding scale. The different prices reflect the average cost of offering a class as well as a discounted option and options that help us cover our administrative costs. Fees cover instructor pay, most class supplies, program materials, marketing and scholarships. Families are asked to pick the price that they are able to pay. As always, we will continue to offer additional financial assistance upon request. When families participate as they are able, in all levels of our sliding scale, the whole program becomes self-sustaining. Thank you for your consideration as you sign up for summer programs!

Discover what it takes to become an inventor by doing experiments with everyday household items, like generating electricity with a potato or making plastic out of milk. To ensure that our high-quality enrichment classes are accessible to all families, Minneapolis Community Education is now offering fees on a sliding scale. The different prices reflect the average cost of offering a class as well as a discounted option and options that help us cover our administrative costs. Fees cover instructor pay, most class supplies, program materials, marketing and scholarships. Families are asked to pick the price that they are able to pay. As always, we will continue to offer additional financial assistance upon request. When families participate as they are able, in all levels of our sliding scale, the whole program becomes self-sustaining. Thank you for your consideration as you sign up for summer programs!

Learn to sew by hand using different stitches to make pillows, stuffed animals or handbags, and more. To ensure that our high-quality enrichment classes are accessible to all families, Minneapolis Community Education offers fees on a sliding scale. The class fee is the average cost of providing a class. Families are asked to pay the class fee or pick a price that they can pay. When families participate as they are able, at all levels of our sliding scale, the whole program becomes self-sustaining. Thank you for your consideration as you register for summer programs!

Nature is for more than just observing. Use the beauty of nature to inspire colorful and creative masterpieces. Students should be 4 years old by the date the class starts. Grades are the year your student will be entering in the fall. Please select this option when you register. Community Education uses a sliding scale model for program fees so our summer programs can be financially sustainable and more equitable. The different prices reflect the average cost of offering a class as well as discounted options and options that help us cover our administrative costs. Families are asked to pick the price that they are able to pay. If you need further financial assistance, please contact the lead coordinator of the Super Summer Program at Sanford at lissa.gordon@mpls.k12.mn.us or 612-668-4922.

Make your own bath bombs, face masks, lip balm, and more as we celebrate beauty inside and out! Register your child for a morning class and an afternoon class and we will provide lunch and supervision free of charge from 12-1 pm. When signing up for the morning class, you will be able to choose the option “Stay for free lunch and recess from 12:00 – 1:00 pm” as you complete your registration. To ensure that our high-quality enrichment classes are accessible to all families, Minneapolis Community Education offers fees on a sliding scale. The class fee is the average cost of offering a class. Families are asked to pick the class fee or the price that they are able to pay. When families participate as they are able, at all levels of our sliding scale, the whole program becomes self-sustaining. Thank you for your consideration as you sign up for summer programs!