The role of a data scientist is to turn raw data into actionable insights. To be an effective data scientist, you must know how to extract data from these databases using SQL. In this course you’ll learn the skills you need to extract critical insights in a database.
Who this course is for:
- Anyone who wants to start a data analyst or data scientist role in professional life.
- Anyone interested in expanding data skills.
- Anyone who wants to start learning data science.
Course Requirements:
- There are not prerequisites for this course.
What will you learn?
● DB Basics
● Subqueries
● Aggregations
● Joins
● Rollups and Cubes
● Window Functions
● Transposing and Ranking Data
● Hierarchical Queries
● Analytical SQL Functions
Start learning the SQL for Data Science with outside of business hours schedule!
The 12 hours of schedule is as follows:
February 15 – 22 – 29 and March 7
Saturdays, from 9:00 am to 12:00 pm
The venue for the bootcamp is Magnimind Academy Sunnyvale Campus: 830 Stewart Dr #182, Sunnyvale, CA 94085. The capacity is limited to 20 people.
SQL for Data Science Mini Bootcamp is now also available online. Anyone who wants to attend this mini bootcamp can join online live webinars where the same course content will be taught. Online sessions will be distributed through zoom conferences. Students will have access to the screen of the instructor, external camera showing class atmosphere, whiteboard, and be able to ask questions through chat. You may attend this mini bootcamp no matter where you are.
Tuition fee
SQL for Data Science Mini Bootcamp has a $300 tuition fee.
For the “Early Bird” applicants (January 15 – February 8), the tuition fee is $250.
Payment process
After you finish filling your application form, the website will direct you to the payment page. There, you can select available payment options.
Cancellation
If you’re not satisfied with the course you may cancel your application.
Course Application
The application process starts at magnimindacademy.com. You can view the course pages and learn more about your intended course. You can apply by clicking the “Buy now” button and then fill out the application form.
Over the past five years, Dane has been working as a science educator in Palo Alto. Where he teaches science, builds hands-on science programs, and mentors students. His passion is science! Prior to being a science educator Dane worked in the field of paleontology for 10 years. He worked on several paleontology projects focused on data collections and curatorial work with the Denver Museum of Nature and Science and the Smithsonian National Museum of Natural History. In 2010, he was part of a major paleontological discovery in the state of Colorado’s history. Working with a team from the Denver Museum of Nature and Science, we unearthed a treasure trove of fossils 30,000+ vertebrate fossils from mammoths, mastodons, camels, deer, bison, bear, and many other animals. The discovery of this ice age ecosystem drew news coverage from the New York Times, NOVA, and National Geographic. The fossil conifer cones from this discovery led to his graduate research at the University of Wyoming, Laramie.
In graduate school he started finding the power of scientific programming using SAS and R. Two years ago, he was inspired to pursue data science by a keynote address by Dr. Debbie Berebichez. Since then Dane has become proficient in Python, R, and SQL. He actively reaches out in the data science community to collaborating with a wide range of interests in paleontology, healthcare industry, wine, and here with Magnimind Academy.