Channel BannerChannel Banner
VX4wl7qIcbAVX4wl7qIcbA

SQL Database App with Windows GUI – Project Tutorial

155,638
Socialcounts.OrgEnter Fullscreen (f)
3,218
likes
66
comments
daily view 0
monthly view 0

Share

Live Analytics

Comments 0

SQL Database App with Windows GUI – Project Tutorial Analytics Table

Income Estimates for SQL Database App with Windows GUI – Project Tutorial

Based on this YouTube video's total view count of 155K views and industry-standard rates, the estimated total earning is $109 - $311 through ad revenue. Historical data is not yet available to calculate daily, weekly, or monthly averages.

About SQL Database App with Windows GUI – Project Tutorial

Explore SQL Database App with Windows GUI – Project Tutorial with 155,638 views, 3,218 likes, and 66 comments. Experience the impact of this video content that has captured audience attention.

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

About YouTube Real-Time View Count

With SocialCounts.org’s view counter, track your YouTube video’s live view count and YouTube likes count in real time with fast, reliable updates.

Watch every YouTube video live view count rise with our real-time YouTube views tracker—built for accuracy and minimal delay.

Follow YouTube real time views as they happen, using our dedicated view counter for YouTube videos.

Get up-to-date live view count on YouTube and see real-time growth with SocialCounts.org’s smart tracking tools.

Embed Widget

Parameters:

  • fullscreen=true - Fullscreen counter
  • graph=true - Live graph chart
  • counter=0/1/2 - Select counter (0=likes, 1=views, 2=comments)
URL

Click to copy the embed URL to your clipboard