SQL Database App with Windows GUI – Project Tutorial
By freeCodeCamp.org
Published: Mar 16, 2023“
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
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
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news
”
Category: Video Tutorials
Video Tutorials on Photoshop, after effects, coding, managing your YouTube channel, etc
[#Video #Editing] 5 Simple Ways To EDIT FASTER In Premiere Pro
5 Simple Ways To EDIT FASTER In Premiere Pro
By Olufemii
Published: Jan 27, 2022“
Be efficient and edit faster in Premiere Pro with these Premiere Pro Shortcuts and video editing tips.
Get All The Premiere Pro Templates You Need Here: https://1.envato.market/P0AJneSubscribe Here: https://www.youtube.com/c/OlufemiiTut…
**Equipment Used To Make This Video – Via Amazon:**
- Canon C200 (Camera) – https://amzn.to/3gkU4zr
- Tokina 11-20mm f/2.8 (Lens) – https://amzn.to/34gl6EZ
- Aputure 120D Mark II (Lighting) – https://amzn.to/3IKTJC0
- Aputure Light Dome II Studio Reflector (Lighting) – https://amzn.to/3rQqd6Y
- SanDisk 128GB Extreme Pro SDCX (Memory Card) – https://amzn.to/3KNKzGJ
- Rode NT1 (Microphone) – https://amzn.to/35wePpy
- Rode PSA1 (Microphone Boom Arm) – https://amzn.to/35oMt0h
”
[#Script #Coding] Best Shortcut You Didn’t Know!!
Best Shortcut You Didn’t Know!!
By codeSTACKr
Published: Feb 15, 2023“
Code Tip of the Day
Do you ever need to go back up to some code you wrote earlier to copy a piece of it, then have to figure out where you were at just before that?Just press Alt+LeftArrow, you’ll go right back to that previous cursor location.
You’re welcome!
Become A VS Code SuperHero Today: https://vsCodeHero.com
Join my Discord developer community: https://discord.gg/A9CnsVzzkZ
Tools I use:
- codeSTACKr VS Code Theme: https://marketplace.visualstudio.com/…
- STACKr Code Font (Exclusive to my VS Code Course – https://vsCodeHero.com)
- SuperHero Extension Pack: https://marketplace.visualstudio.com/…
Show support!
- PayPal: https://paypal.me/codeSTACKr
Watch Next:
- Playlist: Web Development For Beginners – https://www.youtube.com/watch?v=Ez4yH…
Connect With codeSTACKr:
- Website: https://www.codestackr.com
- Twitter: https://twitter.com/codeSTACKr
- Instagram: https://instagram.com/codeSTACKr
- Facebook: https://facebook.com/codeSTACKr
”
[#AfterEffects #Video] How To Make An Audio Spectrum Waveform in After Effects | Easy Tutorial
How To Make An Audio Spectrum Waveform in After Effects | Easy Tutorial
By Learnin5
Published: Sep 21, 2016“
In this tutorial, we learn how to make colors and waveforms react to audio in After Effects with audio spectrum waveforms! Easy and quick tutorial for a cool logo.
If you enjoyed the video, make sure to subscribe to give your next video that added value in 5 minutes or less.
Share your video in the comments below!
Get the latest version of After Effects here:
Follow me on Instagram:
@austinmakesfilmsMy Filmmaking Gear:
- Sony a6300 http://amzn.to/2mTTFJt
- Canon C100 http://amzn.to/2mkKQFr
- Ricoh Theta S (360 cam) http://amzn.to/2mkxHwl
- GoPro Hero Session http://amzn.to/2nmWbpm
- Neewer Stabilizer $89 http://amzn.to/2lUjf1W
Want to request a video? Tweet to me!
http://www.twitter.com/Learnaein5”
[#Script #Coding] JavaScript Tutorial – Create a Card Game
JavaScript Tutorial – Create a Card Game
By freeCodeCamp.org
Published: Dec 14, 2022“
Improve your JavaScript skills by creating a basic card game with HTML and CSS.
This tutorial not only covers creating a basic card game using JavaScript
but also:- How to create dynamic user interactive code using vanilla JavaScript
- Creating some animation effects
- Responsive layout design using CSS grid, CSS FlexBox and media queries
- How to dynamically change the positions of grid cells, so as to randomize the positions of the cards contained in a css grid using JavaScript,
- localStorage functionality
- And much More…
Code: https://github.com/GavinLonDigital/HuntTheAceJSGame
Gavin Lon created this tutorial. Check out his channel: @GavinLon
Contents
- (0:00:00) Introduction
- (0:05:26) Getting Started
- (0:07:00) Live Server Extension
- (0:09:50) Create Cards – HTML
- (0:14:44) Create the Game Play Grid
- (0:19:55) Create Cards Dynamically – JS Code
- (0:28:46) Initialise Card Positions
- (0:34:39) Load Game and Start Game
- (0:38:43) Stack Cards
- (0:41:53) Flip Cards
- (0:45:14) Shuffle Cards
- (0:49:28) Deal Cards
- (0:54:37) Choose Card
- (1:16:56) Styling and Layout
- (1:24:28) Animation
- (1:32:39) Responsive Layout
- (1:36:43) Local Storage
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news
And subscribe for new videos on technology every day: https://youtube.com/subscription_cent…
”
[#Adobe #Design] How to Add Text to Surfaces in Adobe Photoshop
How to Add Text to Surfaces in Adobe Photoshop
By Adobe Masters
Published: Apr 13, 2022“
Today I go over how to add images and text onto surfaces in Adobe Photoshop CC.
Get near unlimited stock footage and premiere pro templates: http://1.envato.market/…
Join the Community at: https://adobemasters.net/
Request a Tutorial at: https://adobemasters.net/request-a-tutorial/If you want to learn more about the Adobe products. Here are a couple of cheap courses I learned from.
http://adobemasters.net/courses/Subscribe to see more Adobe related content, videos every other day.
”
[#AfterEffects #Video] How we Edit a COPY CAT in only 3 Days!
How we Edit a COPY CAT in only 3 Days!
By Cinecom.net
Published: Jun 16, 2022“
Learn how to edit faster an more efficient with the Loupedeck CT in this Adobe Premiere Pro tutorial video. See how we edit an entire copycat episode in only 3 days.
Learn More about the Loupedeck and get 10% OFF
https://loupedeck.co/3OdN2Lw (use CINECOM10 at checkout)
https://www.amazon.com/dp/B0837LKGL6?…Premiere Basics Voice Tutorial
How To Make Your VOICE Sound CINEMATIC (Premiere Pro)
- MERCH: https://cinecom.net/merch
- Get 1 Month of FREE Skillshare Premium: https://cinecom.info/Skillshare
LETS CONNECT WITH CINECOM!
- Instagram: http://cinecom.info/Instagram
- Discord: http://discord.gg/Cinecom
Download Unlimited Video Assets
”
[#Script #Coding] Open VS Code from Finder in macOS
Open VS Code from Finder in macOS
By codeSTACKr
Published: Mar 17, 2023“
Become A VS Code SuperHero Today: https://vsCodeHero.com
Join my Discord developer community: https://discord.gg/A9CnsVzzkZ
Want to quickly open a file or folder in VS Code from Finder in MacOS?
Add a quick action:
– Open the Shortcuts App
– Select “Quick Actions”
– Add a new action
– Change “Receive Any” to “Receive Files and Folders”
– From the right menu under Categories, choose Scripting and add “Run Shell Script”Permissions may need to be added.
– Enter this script: open -n -b “com.microsoft.VSCode” –args “$*”
– For the Input choose Folder as the Type and Get the File Path
– Pass input: as arguments
– Name the Quick Action “Open with Code”Now, when you right-click any folder or file in Finder, you’ll get this quick action to open it in VS Code.
Tools I use:
- codeSTACKr VS Code Theme: https://marketplace.visualstudio.com/…
- STACKr Code Font (Exclusive to my VS Code Course – https://vsCodeHero.com)
- SuperHero Extension Pack: https://marketplace.visualstudio.com/…
Show support!
- PayPal: https://paypal.me/codeSTACKr
Watch Next:
- Playlist: Web Development For Beginners – https://www.youtube.com/watch?v=Ez4yH…
Connect With codeSTACKr:
- Website: https://www.codestackr.com
- Twitter: https://twitter.com/codeSTACKr
- Instagram: https://instagram.com/codeSTACKr
- Facebook: https://facebook.com/codeSTACKr
”
[#Video #Editing] Stretch Text Effect in After Effects
Stretch Text Effect in After Effects
By Olufemii
Published: Apr 09, 2022“
Today we are learning about Stretch Text in After Effects by our channel’s incredible VFX teacher Herman Huang aka Coffeelicker!
Get The Project File Here:
Ep 1: Minimalist Text Animation
https://shorturl.at/aduTW
Ep 2: Maximalism Text Animation
https://shorturl.at/twCPX
Ep 3: Psychedelic Text Animation
https://shorturl.at/ekpwC
Ep 4: Stretch Text Animation
https://shorturl.at/loAQW
Ep 5: Abstract Text Animation
https://shorturl.at/psNV7Wanna follow Herman?
Check out his You Tube channel here: @Herman Huang
Follow him on Instagram here: https://www.instagram.com/coffeelicker/Buy his ETF Pack here:
”
[#Script #Coding] How to Make Money From Your Website Using Microtransactions
How to Make Money From Your Website Using Microtransactions
By freeCodeCamp.org
Published: Oct 24, 2022“
Learn how to make money from your website without having to reply on third party advertisers or selling your users data by using the Interledger Protocol and microtransactions.
Ania Kubów developed this course. Check out her channel: https://www.youtube.com/c/AniaKub%C3%B3w
Sign up for Uphold: https://wallet.uphold.com/signup
Coil Chrome extension: https://chrome.google.com/webstore/detail…
Sign up for Coil: https://coil.com/auth/signupGrant for the Web provided a grant to make this course possible. Grant for the Web is an Interledger Foundation program to boost open, fair, and inclusive standards and innovation in Web Monetization.
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news
”
