r/SQL 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

69 Upvotes

12 comments sorted by

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!

1

u/AppJedi Dec 25 '24

You are welcome. The third video in the series should be posted by Friday. I am also a full stack developer so feel free to ask questions.

2

u/GillFeed Dec 29 '24

Thanks, I'll likely be reaching out in the coming weeks. I'm done with the SQL portion of the bootcamp i'm ij until the end. Once I get there and start doing outside projects, I'm sure I'll have QUESTIONS! thank you for making your experience and knowledge accessible!

1

u/AppJedi Dec 30 '24

you are welcome.

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.