• Online, Self-Paced
Course Description

This 13-video course explores the importance of SQL in Full Stack Development (FSD), how to use SQL statements to create and manipulate database objects and data, and some best practices for using SQL efficiently. Key concepts covered in this course include the differences between relational and nonrelational databases and their basic structure; situations when a relational database should be used in FSD development; and the role SQL plays when using a relational database in FSD development. Learn the difference between DDL and DML statements in SQL; learn the level of SQL programming knowledge required by a FSD developer; and examine best practices needed when working with SQL code. Next, you will install and configure the PostgreSQL relational database system for use in FSD development; work with SQLAlchemy to connect to a relational database; and create DDL and DML statements using SQL to manipulate data in a relational database. Finally, learn to use Alembic to manage a database revision and learn the importance of SQL in the role of an FSD developer.

Learning Objectives

{"discover the key concepts covered in this course"}

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Software Development