12/3: Winter Bootcamp Final Application Deadline. Apply Now

Accredited Professional Development Data Science 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

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

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 an on-demand sample class

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

Gordon Dri, Data Scientist at Oracle, and instructor of the Live Online SQL Fundamentals course, will cover a few sample topics in the on-demand sample class that will give you a sneak peek into what the course will be like! 

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