SQL in FSD Development

Beginner
  • 13 videos | 1h 1m 48s
  • Includes Assessment
  • Earns a Badge
Likes 23 Likes 23
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1.  Course Overview
    1m 42s
  • Playable
    2.  Database Types
    4m 18s
    In this video, you will learn how to differentiate between relational and non-relational databases and recognize their basic structure. FREE ACCESS
  • Locked
    3.  Using a Relational Database in FSD
    3m 22s
    During this video, you will learn how to identify situations when a relational database should be used in software development. FREE ACCESS
  • Locked
    4.  Overview of SQL
    5m 25s
    After completing this video, you will be able to describe what SQL is and identify the role SQL plays when using a relational database in full-stack development. FREE ACCESS
  • Locked
    5.  DDL and DML Statements
    3m 25s
    Upon completion of this video, you will be able to describe the difference between DDL and DML statements in SQL and identify some of the more common commands for each category. FREE ACCESS
  • Locked
    6.  Required SQL Knowledge
    3m 50s
    After completing this video, you will be able to recognize the level of SQL programming knowledge required for a FSD developer. FREE ACCESS
  • Locked
    7.  SQL Best Practices
    6m 46s
    Upon completion of this video, you will be able to describe the best practices to use when working with SQL code. FREE ACCESS
  • Locked
    8.  Configuring PostgreSQL
    5m 20s
    In this video, you will learn how to install and configure the PostgreSQL relational database system for use in FSD development. FREE ACCESS
  • Locked
    9.  Connecting to a Database Using SQLAlchemy
    6m 49s
    In this video, find out how to connect to a relational database using SQLAlchemy. FREE ACCESS
  • Locked
    10.  Working with DDL Statements
    5m 21s
    In this video, you will create SQL DDL statements to work with database objects. FREE ACCESS
  • Locked
    11.  Working with DML Statements
    4m 26s
    In this video, you will learn how to create DML statements using SQL to manipulate data in a relational database. FREE ACCESS
  • Locked
    12.  SQL Change Management
    5m 32s
    In this video, find out how to use Alembic to manage database revisions. FREE ACCESS
  • Locked
    13.  Exercise: SQL Essentials for the FSD Developer
    5m 32s
    After completing this video, you will be able to recognize the importance of and how to work with SQL in the role of an FSD developer. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 285 Likes 285  
Course SQL Views
Likes 107 Likes 107  
Likes 108 Likes 108