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
    UP NEXT
  • Playable
    2. 
    Introducing the Menu Bar
    7m 36s
  • Locked
    3. 
    Creating a Tkinter App with Seaborn Charts
    7m 36s
  • Locked
    4. 
    Editing the Format of a Seaborn Chart
    6m 2s
  • Locked
    5. 
    Running MySQL from the Shell
    8m 23s
  • Locked
    6. 
    Writing Code to Connect to MySQL
    6m 41s
  • Locked
    7. 
    Reading Data from MySQL into Python
    5m 50s
  • Locked
    8. 
    Writing Data to MySQL from Python
    9m 46s
  • Locked
    9. 
    Creating an Archive Database to Store Old Data
    7m 30s
  • Locked
    10. 
    Understanding Code for an App Which Connects to MySQL
    5m 59s
  • Locked
    11. 
    Accepting an Uploaded File and Write It out to MySQL
    9m 11s
  • 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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.