FlexStack: SQL Fundamentals 1 - Pulling Up to the Database Table

  • Overview
  • Course Content
  • Requirements & Materials
Overview

FlexStack: SQL Fundamentals 1 - Pulling Up to the Database Table

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, along with learning how to use powerful database features to ensure the integrity of stored data. It is the first course in the SQL Fundamentals 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 at every class session
  • No homework
Requirements & Materials

Requirements

A Windows or Mac computer with a webcam is required to participate in the course. Tablets or other devices are not supported.

Prerequisites

Familiarity with using a computer and adequate typing ability.

Materials

Supplemental materials 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

  • Utilize SQL to store, retrieve, and manipulate data.
  • Create and modify database schemas within a database management system (DBMS). 
  • Provide additional insights on data beyond basic data retrieval by employing aggregation, filters, and sorting.
  • Implement keys, constraints, indices, and normalization to improve database performance and ensure data integrity. 
  • Create stored procedures, triggers, and use transactions to facilitate easier database usage for applications. 
  • Build basic database-driven web applications for humans and structured data interfaces for machines using the Python programming language and associated frameworks.
  • Recognize applications of the object-relational model and its usage for rapid application development.
  • Assess AI-generated code for accuracy and effectiveness.
  • 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?