Submit your application by Sunday night to save $1,000. 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

Check back soon for upcoming course dates.

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