Read Anywhere and on Any Device!

Subscribe to Read | $0.00

Join today and start reading your favorite books for Free!

Create Free Account

Quick and Easy Sign Up!

It takes less then 1 minute to sign up, then you can enjoy Unlimited eBooks.

Sign Up Browse

Popular Genres

Read Anywhere and on Any Device!

  • Download on iOS
  • Download on Android
  • Download on iOS

Learn SQLite with Python: Building Database-Driven Desktop Projects

Learn SQLite with Python: Building Database-Driven Desktop Projects

Vivian Siahaan
3.5/5 ( ratings)
Read Download
This book is SQLite-based python programming for database-driven desktop projects. Deliberately designed for various levels of programming skill, this book is suitable for students, engineers, and even researchers in various disciplines. There is no need for advanced programming experience, and school-level programming skills are needed.In the first chapter, you will learn to use several widgets in Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes.In chapter two, you will learn to use the following Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets.In chapter three, you will How to create the initial three tables project in the School Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. In chapter four, you will learn how Create a main form to connect all forms; Create a project will add three more tables to the school Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables.In chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. In chapter six, you will create dan configure database. In this chapter, you will create Suspect table in crime database. This table has eleven suspect_id , suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table.In chapter seven, you will create a table with the name Feature_Extraction, which has eight feature_id , suspect_id , feature1, feature2, feature3, feature4, feature5, and feature6. The six fields will have VARBINARY data type. You will also create GUI to display, edit, insert, and delete for this table.In chapter eight, you will create two tables, Police and Investigator. The Police table has six police_id , province, city, address, telephone, and photo. The Investigator table has eight investigator_id , investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables.In the last chapter, you will create two tables, Victim and Case_File. The Victim table has nine victim_id , victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven case_file_id , suspect_id , police_id , investigator_id , victim_id , status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.
Language
English
Pages
538
Format
Paperback
Release
September 29, 2019
ISBN 13
9781696314794

Learn SQLite with Python: Building Database-Driven Desktop Projects

Vivian Siahaan
3.5/5 ( ratings)
Read Download
This book is SQLite-based python programming for database-driven desktop projects. Deliberately designed for various levels of programming skill, this book is suitable for students, engineers, and even researchers in various disciplines. There is no need for advanced programming experience, and school-level programming skills are needed.In the first chapter, you will learn to use several widgets in Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes.In chapter two, you will learn to use the following Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets.In chapter three, you will How to create the initial three tables project in the School Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. In chapter four, you will learn how Create a main form to connect all forms; Create a project will add three more tables to the school Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables.In chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. In chapter six, you will create dan configure database. In this chapter, you will create Suspect table in crime database. This table has eleven suspect_id , suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table.In chapter seven, you will create a table with the name Feature_Extraction, which has eight feature_id , suspect_id , feature1, feature2, feature3, feature4, feature5, and feature6. The six fields will have VARBINARY data type. You will also create GUI to display, edit, insert, and delete for this table.In chapter eight, you will create two tables, Police and Investigator. The Police table has six police_id , province, city, address, telephone, and photo. The Investigator table has eight investigator_id , investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables.In the last chapter, you will create two tables, Victim and Case_File. The Victim table has nine victim_id , victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven case_file_id , suspect_id , police_id , investigator_id , victim_id , status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.
Language
English
Pages
538
Format
Paperback
Release
September 29, 2019
ISBN 13
9781696314794

More books from Vivian Siahaan

Rate this book!

Write a review?

loader