SQL Databases Using SQLAlchemy: Getting Started

SQLAlchemy 1.3    |    Beginner
  • 10 Videos | 1h 24m 5s
  • Includes Assessment
  • Earns a Badge
Likes 6 Likes 6
There are many advantages to using SQLAlchemy, including using native Python language constructs for queries, transactions, and stored procedures and easily porting code between database servers. You begin this course by installing MySQL on both Windows and Macintosh platforms. You'll then learn how to access a database from SQLAlchemy using the create_engine method, and how to specify the driver, dialect, and server information correctly. You move on to creating database tables as well as associated constraints from Python using SQLAlchemy's Core API and the Table abstraction. You'll then query that table using a fluent-style API from SQLAlchemy's SQL Expression Language. You'll also learn how to specify primary key, unique, and not null constraints. At the end of the course, you'll have a solid handle on basic functionalities of the core APIs of SQLAlchemy.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    install MySQL and run it from the command line on Windows
    install MySQL and run it from the command line on MacOS
    install SQLAlchemy and connect to MySQL
    create a table and insert rows into it
  • insert rows into a table
    perform insert and delete operations
    create and use SQL unique constraints
    create and use a SQL primary key constraint with autoincrement
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 2s
    UP NEXT
  • Playable
    2. 
    Installing MySQL on Windows
    7m 59s
  • Locked
    3. 
    Installing MySQL on MacOS
    10m 19s
  • Locked
    4. 
    Installing SQLAlchemy and Connecting to a Database
    8m 59s
  • Locked
    5. 
    Creating a Table and Inserting Data
    9m 48s
  • Locked
    6. 
    Inserting Data into Tables
    8m 29s
  • Locked
    7. 
    Performing Valid and Invalid Insert Statements
    11m 19s
  • Locked
    8. 
    Creating and Using SQL Unique Constraints
    8m
  • Locked
    9. 
    Using SQL Not Null and Primary Key Constraints
    10m 8s
  • Locked
    10. 
    Course Summary
    3m 3s

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