SQL Database App with Windows GUI – Project Tutorial

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 ❤️ Try interactive Databases courses we love, right in your browser: https://scrimba.com/freeCodeCamp-Databases (Made possible by a grant from our friends at Scrimba) ⭐️ 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: