Udemy, Coursera, 2U/edX Face Lawsuits Over Meta Pixel Use

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

freeCodeCamp

SQL Database App with Windows GUI – Project Tutorial

via freeCodeCamp

Start learning Write review

Overview

Learn how to design and use databases by creating a graphical Windows application with C# that interacts with a mySQL database server. The course covers creating databases, writing SQL queries, designing a GUI front end app, connecting to databases, querying data, adding multimedia elements, working with foreign keys, performing table joins, and designing with UML and ER diagrams. The course duration is 3-4 hours, and the intended audience includes individuals interested in database design, Windows application development, and SQL programming.

Syllabus

⌨️ Introduction
⌨️ Tools we’ll need
⌨️ Creating a new database
⌨️ Saving the data
⌨️ How to fill in a table
⌨️ Select star from albums
⌨️ How to delete backticks
⌨️ Intro to the series
⌨️ How to delete the backticks
⌨️ Building the database app
⌨️ Start of the demo
⌨️ Creating an album class
⌨️ Adding two albums to the list
⌨️ Connecting the database to the database
⌨️ Where does the data source live?
⌨️ Setting up the database
⌨️ Running the app
⌨️ How to create searches
⌨️ Programming the new search button
⌨️ The problem with parameter queries
⌨️ Adding a picture to the screen
⌨️ How to test the problem
⌨️ Adding new records to the database
⌨️ Adding an integer to the database
⌨️ Adjusting the column titles
⌨️ Execute non-query query
⌨️ Creating a foreign key
⌨️ Install mysql workbench
⌨️ Connecting to the database
⌨️ Configuring the tracks table
⌨️ We have a problem with Mamp synchronization
⌨️ Inserting data into the tracks table
⌨️ Selecting items from the database
⌨️ Changes to the definition of tracks
⌨️ Fixing the problem with the binding source
⌨️ Foreign keys and joins
⌨️ Selecting from the table
⌨️ Changing the query using a join
⌨️ Uml diagrams for our current application
⌨️ Associative vs aggregation
⌨️ Introduction to compound queries
⌨️ Fetching the list of all tracks
⌨️ Using the delete statement to delete tracks
⌨️ The problem with converting an integer to an integer
⌨️ Deleting a track by deleting its Id

Taught by

freeCodeCamp.org

Reviews

5.0 rating, based on 1 Class Central review

Start your review of SQL Database App with Windows GUI – Project Tutorial

  • Profile image for Smeet Nasit
    Smeet Nasit
    Overall, the SQL Database App with Windows GUI project is well-executed, meeting the requirements effectively and providing a valuable tool for managing database interactions
Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.