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: 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
🎉 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: www.freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news

[@arcadelinkauthor]

Thanks for this! This is something I've been thinking about lately. BTW part #2 is accidentally shown twice within this video. When you finish part 2, you can skip to 38:40.

[@niranjanshankaran3493]

Thanks

[@xBloodXGusherx]

Holy crap! I needed this! Thank you!

[@s-sg2640]

wow, this was just in time for my needs! Thank you for posting.

[@baohagia5192]

Finally, this is what i needing now ! Thanks

[@maheenmohiuddin4230]

First view! Keep it up. I am very thank full of you guys such a good platform to learn.💯

[@johnnymoore948]

Excellent course...you can always spot an experienced professor from the moment he explains the notions in a manner that is easy to understand even for a child ^_^

[@senyotsedze3388]

Same here. With me Apache Server turns green but MySQL would not.

[@goodboyreaction]

I am SMART now . thanks for this tutorial.

[@frankypinto3594]

Thank u Sir, Practical application is Excellent , also voice is good and personality too.

[@ccitsolution4192]

thanks you very much sir to get new updated.

[@marcosmacias2087]

😊thanks very good video

[@oshushujoshua1557]

Lovely tutorial I must confess. However Shad, I have got a problem. After installing MAMP 5.0 on my Windows 10 Pro, it is taking a long time to initiate Start Servers. Is internet connection needed to have the Apache and MySQL servers dotted? It is really taking a very long time to 'green-dot' the servers. I strongly desire to see this amazing course to its end. Please what should I do? Anticipating any helpful response. Thanks

[@auwalmb]

Wow thank you

[@tejp33]

Thank you I am waiting for this video, I think this project will change my life

[@stephenxs8354]

Exactly what I currently working on!

[@balachandran2053]

Me to😅

[@AbdullahAbdullah-kz5dq]

Tell about ur experience bro

[@oumardicko5593]

you know the man's old school when you see window XP wallpaper as a background

[@jannatgaoshiqqalb3598]

Please, tell me about how to build a gui program that blocks exe application with given password for that, and when you want to open that exe application, there should be a form which asks for you a password to open that exe application?

[@user-qj3ot2ii9d]

Hello! Please help me how to correctly solve the administration problem, for example, use Python,QT, PostgreSQL. Please recommend an algorithm for organizing an access level for adesktop application where different interface components are included in different access classes, and when a new user is added, he will be included in one of these classes, and for him there will be Only components that are included in this access class are accessible. The question is, in order to implement this, what algorithm can be supported, or if there is documentation that can help resolve this issue. Thank you very much in advance!

[@mobo8933]

I love this channel

[@aidenstocking8910]

In the "Running the app" section, I have some Null values in my database in a field that otherwise contains ints, how can I allow for them?

[@hc6008]

Can I use SQL Server instead of MySQL Database?

[@tomdriver6733]

How to implement the video view?

[@pet.me102]

I need this but in python lol. But great tutorial indeed.

[@AnsarKhan-di7eg]

Finally I got the video I was looking for it ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤ ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

[@jmini1558]

I am creating a database for work and am trying to get it available to my other coworkers in a way that they do not have to use the querys or codes, do you have a recommendation for an app or an API that I can use to simply search for data without having to put in computer code?

[@chiefeveryday7541]

Mac users do not have windows form app option

[@pibob7880]

Nope, visual studio doesn't show the same as in the video no idea what's going on.

[@chiefeveryday7541]

My layout is also different from the video I can’t follow along on a Mac bummer

[@ItsGoodToBeHater]

Thank you sir.

[@sergioanzaldo62]

Sometimes when I click on an album in my UI i get an error message on the image "The remote server returned an error : (403) forbidden. Is there a solution?

[@courage2002]

What data type would you use in C# if the database table has an attribute that uses date and time types?

[@austins.219]

You can put any type of data in a string. You just can't use mathmatical operations on it.

[@usmanmarkaz]

Sir Plz Upload React Native Tutorials from beginner to advance with projects plz

[@freecodecamp]

This is coming soon.

[@viru._.]

hi freecode camp can we have pinescript toturial

[@epictetus__]

Bookmark : 31:00

[@lanangjagad_id]

🔥🔥🔥🔥

[@kwaningemmanuel4977]

can i get the source code

[@kishankulkarni2893]

Is the source code available somewhere?

[@BluePandaLife]

Don’t think there is annoyingly

[@eslammohsen1714]

Where's the github?

[@omkeshlimkar3670]

..♥️

[@christianjamesguevarra6257]

Please disable showing video transcript by default just like in this video. I can't watch your previous video (react course by John Smilga) without my browser tab constantly crashing.

[@Bloodreignification]

Is the anyone completed the future features and like to share? :)

[@Bloodreignification]

I am desperate :/

[@Nodsaibot]

oh my god the draaaaag mother of exposition, forgot to teach us the history of the internet video starts at 43:00

[@weiSane]

Haha ..ok

[@demdimi9316]

how to deploy this online?