SQL in FSD Development

Beginner
  • 13 Videos | 1h 7m 18s
  • Includes Assessment
  • Earns a Badge
Likes 8 Likes 8
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
    UP NEXT
  • Playable
    2. 
    Database Types
    4m 18s
  • Locked
    3. 
    Using a Relational Database in FSD
    3m 22s
  • Locked
    4. 
    Overview of SQL
    5m 25s
  • Locked
    5. 
    DDL and DML Statements
    3m 25s
  • Locked
    6. 
    Required SQL Knowledge
    3m 50s
  • Locked
    7. 
    SQL Best Practices
    6m 46s
  • Locked
    8. 
    Configuring PostgreSQL
    5m 20s
  • Locked
    9. 
    Connecting to a Database Using SQLAlchemy
    6m 49s
  • Locked
    10. 
    Working with DDL Statements
    5m 21s
  • Locked
    11. 
    Working with DML Statements
    4m 26s
  • Locked
    12. 
    SQL Change Management
    5m 32s
  • Locked
    13. 
    Exercise: SQL Essentials for the FSD Developer
    5m 32s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 214 Likes 214  
Likes 24 Likes 24  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 1602 Likes 1602  
Likes 24 Likes 24  
Likes 38 Likes 38