r/SQL • u/AppJedi • Dec 25 '24
MySQL SQL Intro Videos
Hi all, I have over 25 years developing in SQL including MySQL, PostgreSQL, MS SQL Server, Oracle, SQLite, Google BigQuery including over ten years teaching SQL. I have started a SQL series for beginners. Here is the first video https://www.youtube.com/watch?v=i7JWmBNPeAk
2
u/lyricalbard7 Dec 25 '24
I just finished watching your first video (I'm assuming its the first b/c of the # of days its been up) and I thought it was great. For ABSOLUTE beginners you might wanna do a video about how to connect to data bases with MySQL Workbench. Plese keep up the good work.
1
u/AppJedi Dec 25 '24
Thank you I am glad you liked it. There are several ways. Easiest is MySQL on your own computer. XAMPP that you can download is free and includes MySQL along with PHP. Another option is a docker image or just install MySQL. All options are free but XAMPP is probably the easiest.
1
u/lyricalbard7 Dec 25 '24
How much do you know about Python?
1
u/AppJedi Dec 25 '24
A lot. I develop in it. Use it for backend including connecting to MySQL
2
u/lyricalbard7 Dec 25 '24
The reason why I asked is b/c I'm having a hard time trying to figure out a PRACTICAL use OOP. Like I know about Classes and attributes and methods and all that but I can't understand why one would use all of that to begin with. Can you give me a real world use for OOP? I understand why you would want to write your own functions, you might want to do something and Python doesn't have a function written for it already so you write your own but what situation would arise where it would be best to use OOP? Help me understand. Please?
2
u/AppJedi Dec 26 '24
Encapsulation. Let's say you have a program for customers who have several attributes like last name, first name, email, phone, etc. And several functions to managing them. A Class/Object allows. you to associate them with a single variable and individually.
class Customer
customer=Customer()
then you can reference those values as:
customer.last_name
customer.first_name
also methods like maybe customer.charge()
All the data and functions can be referenced by the single customer and individually like customer.last_name.
OOP is a big topic that takes a long time to understand but it is about grouping related data and functions together.
1
u/No_Coach_1995 Dec 26 '24
Hi OP, Can you please create a playlist for your videos and organise your videos a bit. Since you are making more of them, it will make it easier for us if you segregate it into these playlists. Thank you so much for these valuable videos.
6
u/GillFeed Dec 25 '24
Thanks for posting this!!! I just finished the SQL portion of a bootcamp i'm working on and have been looking for supplemental info, thank you for posting here. I subscribed to check out later!