FlexStack: SQL Fundamentals 1 - Schemas and Queries

  • Overview
  • Course Content
  • Requirements & Materials
Overview

FlexStack: SQL Fundamentals 1 - Schemas and Queries

Course Description

This introductory course provides an overview of structured query language (SQL), where it is used, and the many flavors of Database Management Systems (DBMSes). Students will gain skills in querying, joining data, and creating databases. They will also learn how to use powerful database features to ensure the integrity of stored data. It is the first course in the FlexStack: SQL Fundamentals Certificate series.

Course Content
  • Individual modules to help participants learn SQL databases one step at a time
  • Interactive sessions for gaining knowledge and asking questions in real-time
  • Immersive exercises to practice using SQL right away
  • Hands-on guidance available during every class session
Requirements & Materials

Requirements

A Windows or Mac laptop with a webcam is required to participate in the course. Tablets or other devices are not supported. Recommended: Additional Monitor. 

Familiarity with using a computer and adequate typing ability. 

Participants are expected to have their cameras on during the interactive sessions and must attend 80% of the sessions to pass the course.

Prerequisites

While there are no prerequisites for this course, the third course in the FlexStack: SQL Fundamentals Certificate series requires previous Python programming experience or successful completion of the FlexStack: Python Fundamentals Certificate.

Materials

Supplemental resources provided.

Session Details

Who Should Attend

This course is perfect for those wanting more control over the data collected and stored through their work. Everyone, including managers, programmers, engineers, teachers, accountants, and more, is surrounded by data and accesses databases every day. This certificate teaches participants how to use SQL databases to appropriately store and manage data, query and update the data within them, and gain essential skills for implementing database-centric programs.  

A person sitting at a desk with a computer

What You Will Learn

  • SQL implementation and its uses within a Database Management System (DBMS)
  • Data retrieval and modification in databases using SQL
  • Refinement of SQL queries, using filters to fetch specific data
  • Sorting implementation to ensure a specific ordering for query results
  • Aggregation functions for data summarization
  • Combination of related data via joins, sub queries, and nested queries
  • Creation of models, tables, and views to store data and enhance access to data
  • Setup of keys, foreign keys, database constraints, and data types to enforce data integrity
  • Modification of database schemata for adapting to changes
A person looking at a screen

How You Will Benefit

  • Learn to write, refine, and optimize SQL queries from the ground up.
  • Practice skills in a hands-on lab environment using real-world data.
  • Design and manage databases with schemas, keys, views, and constraints.
  • Work with advanced SQL features like joins, subqueries, and aggregations.
  • Develop practical skills used in data analysis, development, and BI roles.
  • Prepare for technical interviews with foundational SQL concepts.
  • Strengthen problem-solving through structured exercises and assessments.
  • Grow Your Professional Network icon
    Grow Your Professional Network
  • Taught by Experts in the Field icon
    Taught by Experts in the Field

Want to learn more about this course?