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
”
Tag: database
[#Script #Coding] Microservices with FastAPI – Full Course
Microservices with FastAPI – Full Course
By freeCodeCamp.org
Published: Mar 24, 2022“
Learn how to create a simple Microservices app using Python FastAPI with React on the frontend. We will use RedisJSON as a Database and dispatch events with Redis Streams. RedisJSON is a NoSQL database just like MongoDB and Redis Streams is an Event Bus just like RabbitMQ or Apache Kafka.
Course from Scalable Scripts. Check out their channel: https://www.youtube.com/c/ScalableScripts
Code: https://github.com/scalablescripts/fa…
Course Contents:
- (00:00) Intro
- (01:30) App Demo
- (03:29) Inventory Microservice Setup
- (05:46) Redis Cloud
- (07:13) Connect to Redis Cloud
- (09:04) Products CRUD
- (20:05) Payment Microservice Setup
- (25:40) Internal Http Requests
- (30:54) Background Tasks
- (36:50) Redis Streams
- (58:34) Frontend
”
[#Script #Coding] NoSQL vs SQL – Which Type of Database Should You Use?
NoSQL vs SQL – Which Type of Database Should You Use?
By freeCodeCamp.org
Published: Sep 13, 2022“
When should you use RDBMS, and when should you use NoSQL?
This course describes the differences between NoSQL and SQL databases as well as when and why to use each kind of database.Register for a free Astra DB account to use for this tutorial: https://astra.datastax.com/register/s…
Ania Kubow developed this course. Check out her channel: https://www.youtube.com/aniakubow
DataStax provided a grant to made this course possible.
- SQL Tutorial – Full Database Course for Beginners on FreeCodeCamp: https://www.youtube.com/watch?v=HXV3z…
- NoSQL Database Tutorial – Full Course for Beginners on FreeCodeCamp: https://www.youtube.com/watch?v=xh4gy…
- Apache Cassandra Database – Full Course for Beginners on FreeCodeCamp: https://www.youtube.com/watch?v=J-cSy…
- Everything You Need to Know About Storage Attached Indexing in Apache Cassandra | DataStax: https://www.youtube.com/watch?v=D9CUk…
- Enough CQL To Get You Started – Data Modeling with Apache Cassandra | DataStax: https://www.youtube.com/watch?v=mhHM3…
Contents
- Introduction (0:00)
- 01: What actually is a database (2:17)
- 03: What is a database management system (5:53)
- 04: Demo: Creating a database (6:27)
- 05: Common Database Models (9:21)
- 06: Relational databases (9:46)
- 07: SQL (11:33)
- 08: Non-relational databases (16:33)
- 09: Pros and Cons: Comparing RDBMS and NoSQL (19:21)
- 10: Wide Column Database (31:25)
- 11: Document Database (47:38)
- 12: Key-Value Database (1:03:51)
- 13: Multi-Model Databases (1:21:57 )
- Use cases: When to use RDBMS or NoSQL (1:23:12)
[READ MORE]”
[#Script #Coding] Apache Cassandra Database – Full Course for Beginners
Apache Cassandra Database – Full Course for Beginners
By freeCodeCamp.org
Published: Jul 21, 2022“
Apache Cassandra is an open source NoSQL distributed database. This beginner’s Cassandra course has four modules. The first three modules will cover the basics of Apache Cassandra data modeling. The final module covers practical applications of Cassandra.
Get Started with Astra DB, built on Apache Cassandra: https://astra.datastax.com/register/a…
Course Contents
- (00:30) Module 1: Cassandra Intro and Background
- (21:53) Module 2: Collections, User Defined Types, and Counters
- (31:29) Module 3: Data Modeling
- (1:04:22) Module 4: Practical Applications
Links
- Build scalable API-based Microservices with Spring Boot and Cassandra
https://astra.dev/3vIUwyx- REST API in AstraDB – Introduction and curl: https://www.youtube.com/watch?v=oSVuP…
- https://astra.dev/3rNnOL5
- Build a Reactive app in Apache Cassandra™ with Spring Framework: https://www.youtube.com/watch?v=1aRbn…
- https://astra.dev/3xSxaZW
- Advanced Data Modeling in Apache Cassandra™: https://astra.dev/3xX5QK7
- Introduction to #MachineLearning with Cassandra and Spark: https://astra.dev/39aPqU5
- NoSQL Course from Anna Kubow: https://www.youtube.com/watch?v=xh4gy…
”
[#Script #Coding] MySQL Database – Full Course
MySQL Database – Full Course
By freeCodeCamp.org
Published: Jul 20, 2021“
Learn about MySQL Database in this full tutorial course for beginners. This course teaches you not just SQL basics, but it also goes into key database concepts such as Data Modeling, Locks, Indexes, Data Modeling, SQL Explain, and more.
- Tips and Resources: https://docs.google.com/document/d/1tDPgLoE1SakXJlwBF283nG12iUaBVy-OngmFaC4KHbI/edit
- GIT Repo with mysql scripts: https://github.com/jmbharathram/execu…
- Course created by Execute on Command. Check out their channel: https://www.youtube.com/channel/UCwfA…
”
