Developing Apps with Tkinter: Menu Bars, Seaborn Visualization, & MySQL DBs

Tkinter 8.6    |    Expert
  • 12 videos | 1h 18m 17s
  • Includes Assessment
  • Earns a Badge
Buttons are useful widgets but they occupy screen real estate even when not being clicked and often clutter the UI of an app. Menus are a natural and popular choice to mitigate these weaknesses of buttons. Combining menus with visualization libraries such as Seaborn and databases such as MySQL can help you build a fully functional data analysis app in Python. Begin by adding menu bars to your app and link up actions to these menu bar items. Add a Seaborn line plot to your app which will allow the user to visualize the commodity price data they uploaded. You will then set up MySQL and run SQL code from the MySQL command line. Next, create a database that you will later connect to from an app, and load data from a file on your computer. Finally, you'll create an archive database to store old data and connect to MySQL from your app. After completing this course, you'll be able to add menus and menu items to a Tkinter app and leverage MySQL for database connectivity and Tkinter for visualizing data by integrating it with Seaborn.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    introduce the menu bar widget
    add Seaborn charts to a Tkinter app
    customize a Seaborn chart in a Tkinter app
    open MySQL on a shell and create a table
    run queries from the MySQL shell and connect to MySQL from an app
  • connect to MySQL from an app and pull data to display in tree view
    write out to MySQL from an app
    set up an archive database
    illustrate the code for a complex UI
    write code for an app which connects to MySQL
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1.  Course Overview
    1m 34s
  • Playable
    2.  Introducing the Menu Bar
    7m 36s
    During this video, you will learn how to introduce the menu bar widget. FREE ACCESS
  • Locked
    3.  Creating a Tkinter App with Seaborn Charts
    7m 36s
    Find out how to add Seaborn charts to a Tkinter application. FREE ACCESS
  • Locked
    4.  Editing the Format of a Seaborn Chart
    6m 2s
    Learn how to customize a Seaborn chart in a Tkinter application. FREE ACCESS
  • Locked
    5.  Running MySQL from the Shell
    8m 23s
    In this video, find out how to open MySQL on a shell and create a table. FREE ACCESS
  • Locked
    6.  Writing Code to Connect to MySQL
    6m 41s
    Learn how to run queries from the MySQL shell and connect to MySQL from an application. FREE ACCESS
  • Locked
    7.  Reading Data from MySQL into Python
    5m 50s
    During this video, you will learn how to connect to MySQL from an app and pull data to display in a tree view. FREE ACCESS
  • Locked
    8.  Writing Data to MySQL from Python
    9m 46s
    Learn how to write an app that can access a MySQL database. FREE ACCESS
  • Locked
    9.  Creating an Archive Database to Store Old Data
    7m 30s
    Find out how to set up an archive database. FREE ACCESS
  • Locked
    10.  Understanding Code for an App Which Connects to MySQL
    5m 59s
    After completing this video, you will be able to illustrate the code for a complex UI. FREE ACCESS
  • Locked
    11.  Accepting an Uploaded File and Write It out to MySQL
    9m 11s
    In this video, find out how to write code for an app which connects to a MySQL database. FREE ACCESS
  • Locked
    12.  Course Summary
    2m 10s

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.