SQL Database App with Windows GUI – Project Tutorial

From the creator

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) Cr

Published 2023-03-16 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.