SQL in FSD Development


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/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.



Expected Duration (hours)
1.0

Lesson Objectives

SQL in FSD Development

  • discover the key concepts covered in this course
  • differentiate between relational and non-relational databases and recognize their basic structure
  • identify situations when a relational database should be used in FSD development
  • describe what SQL is and identify the role SQL plays when using a relational database in FSD development
  • describe the difference between DDL and DML statements in SQL and identify some of the more common commands for each category
  • recognize the level of SQL programming knowledge required by a FSD developer
  • describe the best practices one should use when working with SQL code
  • install and configure the PostgreSQL relational database system for use in FSD development
  • work with SQLAlchemy to connect to a relational database
  • create DDL statements using SQL to work with database objects
  • create DML statements using SQL to manipulate data in a relational database
  • use Alembic to manage a database revision
  • recognize the importance of and how to work with SQL in the role of an FSD developer
  • Course Number:
    it_fssqlfdj_01_enus

    Expertise Level
    Beginner