One Day at Bootcamp [All Cities] - Next Two Weekends! RSVP

Accredited Professional Development Course

SQL Fundamentals

Offered Live Online Only

Are you interested in sharpening your SQL and data engineering skills, but don't know where to start? This SQL Fundamentals course is designed to take a beginner practitioner and up-skill them to confidently manage, query, and analyze data within a relational database using the SQL language. We will cover:

  • Creating and managing tables
  • Queries
  • Joins
  • Subqueries
  • Sets
  • Functions
  • Advanced data management

Course placeholder

Who the course is designed for:

This course focuses on true beginners who want to learn SQL and data management. Prior experience with SQL or another functional language is not required. Whether you’re considering a new career in data engineering or data science, you want to master SQL in order to advance your current career, or you want to communicate more effectively with data-oriented colleagues, you’ll finish this program with a solid understanding of SQL and foundational platforms.

Outcomes

  • Communicate effectively with data teams
  • Use SQL to build tables, capture data, and query results
  • Apply data management best practices to your firm's datasets
  • Create advanced SQL functions and reports
  • Analyze and mine complex datasets
Have questions? Get answers to frequently asked questions. FAQs

What you'll receive upon completion:

  • Certificate of completion
  • 1 Continuing Education Unit

Dates & Instructors

Live Online
$499

SQL Fundamentals

October 9 to October 18

Tuesdays and Thursdays

6:30 - 9:30PM Pacific Time

Jenna olsen
Jenna Olson
Instructor

Jenna is currently a data analyst with Western Governors University where she builds and maintains the data schema and runs analysis on the Learning Analytics team. She has also worked in data engineering and programming for government agencies (police departments, county and state governments) throughout the U.S. She has a Master’s of Science in Instructional Technology & Learning Science and a B.S. in Management Information Systems from Utah State University.

Enroll Sign Up for a Free Sample Class
Live Online
$499

SQL Fundamentals

October 20 to October 21

Saturdays and Sundays

9:00 - 3:00PM Pacific Time

Trent hauck
Trent Hauck
Instructor

Trent Hauck is currently a Senior Data Scientist at Zymergen, where he builds data products that help biologists and other scientists improve their decision outcomes. Prior to his that role he spent 18 months consulting in the insurance and e-commerce industries, and prior to that worked at Zulily on the relevancy team building recommendation tools for the e-commerce site and conducting operational analysis. He is also the author of two books through Packt Publishing: Instant Data Intensive Apps with pandas How-to, and Scikit-Learn Cookbook. Ask him to get coffee, he can't say no.

Enroll Sign Up for a Free Sample Class
Live Online
$499

SQL Fundamentals

November 17 to November 18

Saturdays and Sundays

9:00 - 3:00PM Eastern Time

John navarro
John Navarro
Instructor

John is a Senior Data Scientist for Kroger's data analytics subsidiary, 84.51°. There, he leads analytical projects focusing on merchandising, customer targeting and store planning. John has also worked as a lead quantitative trader for over 17 years, accumulating expertise in quantitative modeling, risk management and team leadership. He has an MS in Analytics and a BA in Economics, both from the University of Chicago. John also works as a Teaching Assistant for the Introduction to Statistical Analysis and Machine Learning courses in the MScA program at the University of Chicago. When he isn’t working with data he spends time with his three sons, cooking barbecue or working out.

Enroll Sign Up for a Free Sample Class
Live Online
$499

SQL Fundamentals

December 3 to December 12

Mondays and Wednesdays

6:30 - 9:30PM Pacific Time

Nathan grossman
Nathan Grossman
Instructor

As a former engineer, Nathan enjoys data science because it allows him to apply the mathematical skill set he developed designing algorithms for individual products to optimize the behavior of entire organizations. Nathan began his career developing signal processing algorithms for wireless communications at Qualcomm. He subsequently worked in data analytics for intellectual property applications, and in data science for telecom applications. Nathan is currently a data scientist at Wells Fargo, working on machine learning for FinTech applications. He holds a BS in Mechanical Engineering from the University of Illinois, an MS in Electrical Engineering from the University of Michigan, and an MBA from the University of Pennsylvania’s Wharton School, as well as certificates in data science and data analytics from UC Berkeley and UC Santa Cruz. When not working, Nathan enjoys skiing, cycling, playing tennis and spending time with his wife and three sons.

Enroll Sign Up for a Free Sample Class

Prerequisites

There are no requirements other than a working laptop and internet connection. Having an understanding of your firm's data, technologies, and goals will motivate and direct your focus in this program. You do not need prior experience with SQL or another programming language, but it helps!

Considering our immersive data science bootcamp?

Professional development alumni can apply the amount of tuition paid for one part-time course towards enrollment in an upcoming bootcamp upon admittance.

Course Structure & Syllabus

Class 1
Introduction to SQL and Table Management
  1. Understanding relational databases
  2. Overview of technologies and platforms used in the course
  3. Creating and populating tables
Class 2
Joins and Queries
  1. SQL join types
  2. Querying and selecting relevant database information
  3. Intelligent filtering
Class 3
Subqueries, Sets, and Functions
  1. String logic
  2. Math functions
  3. Embedded queries
  4. Inserting data dynamically
  5. Set types and uses
Class 4
Advanced SQL Management
  1. Constraints
  2. Table indexing
  3. Creating custom views
  4. Summary and review

Live Online Interactive Learning

Learn from world-class data science practitioners.

Our Live Online instructors bring deep industry experience from a broad range of industries and companies including Viacom, Spotify, and Capital One Labs. You’ll have an Instructor and Assistant Instructor to support you throughout your learning process.

Interact with instructors and classmates in real-time.

This course is truly live, which means you can interact with the instructors and your fellow students in real-time. Stay engaged by asking questions and participating in polls and conversations, and join your course Slack channel for additional support, communication, and collaboration.

Learn online without sacrificing the value of live instruction.

The world is your classroom. Log in from wherever you are and gain access to live, interactive data science instruction that will push your career further in the right direction. In case you have to miss a class, you can access all recordings 24/7 to stay caught up and refer back.

Earn CEUs for accredited courses.

Not only will you walk away with new data science skills and knowledge, you’ll also earn up to 3.3 Continuing Education Units (CEUs). Our courses are accredited by ACCET, who requires we maintain high standards in areas such as quality of instruction and positive student feedback.

Register for a live online sample class

November 6, 2018

7:30 - 8:30PM Eastern Time

Our 1-hour sample class is a great way to preview what the Live Online experience is like!

John Navarro, Senior Data Scientist for Kroger's data analytics subsidiary, 84.51°, and instructor of the Live Online SQL Fundamentals course, will cover a few sample topics in the sample class that will give you a sneak peek into what the course will be like! He will also be available for Q&A after the class.

What to expect:

- A demo of some of the key concepts taught in this course
- A walk through of the syllabus and answers to key questions about course design
- A description of the types of students this course is best suited for (and any prerequisites, if applicable)
- A highlight of the instructor's qualifications for teaching the course
- A description of the types of students this course is best suited for

* By submitting this form you allow Metis to send you awesome updates on events, content, courses & more!

FAQs

Have more questions? No problem. Schedule a chat with admissions