SQL Databases Using SQLAlchemy: Getting Started

SQLAlchemy 1.3    |    Beginner
  • 10 videos | 1h 20m 5s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 34 users Rating 4.4 of 34 users (34)
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

  • 2m 2s
  • 7m 59s
    In this video, you will install MySQL and run it from the command line on Windows. FREE ACCESS
  • Locked
    3.  Installing MySQL on MacOS
    10m 19s
    In this video, you will install MySQL and run it from the command line on macOS. FREE ACCESS
  • Locked
    4.  Installing SQLAlchemy and Connecting to a Database
    8m 59s
    During this video, you will learn how to install SQLAlchemy and connect to a MySQL database. FREE ACCESS
  • Locked
    5.  Creating a Table and Inserting Data
    9m 48s
    During this video, you will learn how to create a table and insert rows into it. FREE ACCESS
  • Locked
    6.  Inserting Data into Tables
    8m 29s
    In this video, you will learn how to insert rows into a table. FREE ACCESS
  • Locked
    7.  Performing Valid and Invalid Insert Statements
    11m 19s
    In this video, you will learn how to perform insert and delete operations. FREE ACCESS
  • Locked
    8.  Creating and Using SQL Unique Constraints
    8m
    In this video, learn how to create and use SQL unique constraints. FREE ACCESS
  • Locked
    9.  Using SQL Not Null and Primary Key Constraints
    10m 8s
    Find out how to create and use a SQL primary key constraint with autoincrementing. FREE ACCESS
  • 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 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

Channel Introduction to SQL with MySQL and Workbench
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Book Getting Started with SQL and Databases: Managing and Manipulating Data with SQL
Course SQL Databases Using SQLAlchemy: Querying Data
Rating 4.5 of 22 users Rating 4.5 of 22 users (22)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL Databases Using SQLAlchemy: Chaining Joins, Views, & Indexes
Rating 4.4 of 20 users Rating 4.4 of 20 users (20)
Course SQL 2016 Tables
Rating 4.5 of 473 users Rating 4.5 of 473 users (473)
Course Certified Information Systems Auditor (CISA) 2019: Performance & Management
Rating 4.6 of 1774 users Rating 4.6 of 1774 users (1774)