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: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 🎉 Thanks to our Champion and Sponsor supporters: 👾 Nattira Maneerat 👾 Heather Wcislo 👾 Serhiy Kalinets 👾 Erdeniz Unvan 👾 Justin Hual 👾 Agustín Kussrow 👾 Otis Morgan -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news