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