SQL Database App with Windows GUI – Project Tutorial
By freeCodeCamp.org
Published: Mar 16, 2023“
Learn how to design and use databases. You will create a graphical Windows application with C# that can display and modify data from a mySQL database server.
You need Microsoft Windows to follow along.
@shadsluiter is your instructor for this course. He is a Professor Of Computer Science and Software Development at Grand Canyon University.
Professor Sluiter has more courses here: http://studycoding.org
Contents
- Course Outline
- Create a new database in mySQL
- How to write sql queries
- Create a GUI front end app
- Create a Data Access Object and connect to a database
- Query the database
- Add a picture box to display album art
- Insert new records into the database
- Create a second table and a foreign key
- Table joins part a
- Table joins part b
- Design with UML and ER diagrams
- Perform compound select actions
- Delete data from a table
- Add a video player to the app
- Extended Features
- (0:00:00) Introduction
- (0:04:33) Tools we’ll need
- (0:08:49) Creating a new database
- (0:12:16) Saving the data
- (0:16:04) How to fill in a table
- (0:20:26) Select star from albums
- (0:23:44) How to delete backticks
- (0:27:16) Intro to the series
- (0:34:40) How to delete the backticks
- (0:37:49) Building the database app
- (0:42:22) Start of the demo
- (0:46:33) Creating an album class
- (0:51:19) Adding two albums to the list
- (0:55:11) Connecting the database to the database
- (0:58:08) Where does the data source live?
- (1:04:42) Setting up the database
- (1:07:53) Running the app
- (1:10:37) How to create searches
- (1:13:55) Programming the new search button
- (1:18:12) The problem with parameter queries
- (1:21:56) Adding a picture to the screen
- (1:26:12) How to test the problem
- (1:30:45) Adding new records to the database
- (1:39:22) Adding an integer to the database
- (1:43:27) Adjusting the column titles
- (1:46:13) Execute non-query query
- (1:49:06) Creating a foreign key
- (1:51:47) Install mysql workbench
- (1:55:05) Connecting to the database
- (1:59:04) Configuring the tracks table
- (2:06:49) We have a problem with Mamp synchronization
- (2:10:01) Inserting data into the tracks table
- (2:13:08) Selecting items from the database
- (2:16:46) Changes to the definition of tracks
- (2:20:55) Fixing the problem with the binding source
- (2:24:12) Foreign keys and joins
- (2:27:36) Selecting from the table
- (2:31:15) Changing the query using a join
- (2:39:10) Uml diagrams for our current application
- (2:41:58) Associative vs aggregation
- (2:45:47) Introduction to compound queries
- (2:49:53) Fetching the list of all tracks
- (2:53:03) Using the delete statement to delete tracks
- (2:56:35) The problem with converting an integer to an integer
- (3:00:33) Deleting a track by deleting its Id
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news
”