SQL Database App with Windows GUI – Project Tutorial

SQL Database App with Windows GUI – Project Tutorial

freeCodeCamp.org via freeCodeCamp Direct link

⌨️ Programming the new search button

19 of 45

19 of 45

⌨️ Programming the new search button

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

SQL Database App with Windows GUI – Project Tutorial

Automatically move to the next video in the Classroom when playback concludes

  1. 1 ⌨️ Introduction
  2. 2 ⌨️ Tools we’ll need
  3. 3 ⌨️ Creating a new database
  4. 4 ⌨️ Saving the data
  5. 5 ⌨️ How to fill in a table
  6. 6 ⌨️ Select star from albums
  7. 7 ⌨️ How to delete backticks
  8. 8 ⌨️ Intro to the series
  9. 9 ⌨️ How to delete the backticks
  10. 10 ⌨️ Building the database app
  11. 11 ⌨️ Start of the demo
  12. 12 ⌨️ Creating an album class
  13. 13 ⌨️ Adding two albums to the list
  14. 14 ⌨️ Connecting the database to the database
  15. 15 ⌨️ Where does the data source live?
  16. 16 ⌨️ Setting up the database
  17. 17 ⌨️ Running the app
  18. 18 ⌨️ How to create searches
  19. 19 ⌨️ Programming the new search button
  20. 20 ⌨️ The problem with parameter queries
  21. 21 ⌨️ Adding a picture to the screen
  22. 22 ⌨️ How to test the problem
  23. 23 ⌨️ Adding new records to the database
  24. 24 ⌨️ Adding an integer to the database
  25. 25 ⌨️ Adjusting the column titles
  26. 26 ⌨️ Execute non-query query
  27. 27 ⌨️ Creating a foreign key
  28. 28 ⌨️ Install mysql workbench
  29. 29 ⌨️ Connecting to the database
  30. 30 ⌨️ Configuring the tracks table
  31. 31 ⌨️ We have a problem with Mamp synchronization
  32. 32 ⌨️ Inserting data into the tracks table
  33. 33 ⌨️ Selecting items from the database
  34. 34 ⌨️ Changes to the definition of tracks
  35. 35 ⌨️ Fixing the problem with the binding source
  36. 36 ⌨️ Foreign keys and joins
  37. 37 ⌨️ Selecting from the table
  38. 38 ⌨️ Changing the query using a join
  39. 39 ⌨️ Uml diagrams for our current application
  40. 40 ⌨️ Associative vs aggregation
  41. 41 ⌨️ Introduction to compound queries
  42. 42 ⌨️ Fetching the list of all tracks
  43. 43 ⌨️ Using the delete statement to delete tracks
  44. 44 ⌨️ The problem with converting an integer to an integer
  45. 45 ⌨️ Deleting a track by deleting its Id

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.