Python & MySQL Crash Course

[@mannyc1065]

I wrote my first little html website using one of Brad's crash courses alittle over a year ago and now im going to play with SQL for the first time in a Brad video! I can't express enough how much gratitude I have for him! :)

[@MULTICODE]

Brad loves what he does , coding. He is a real programmer, he always have time to Create stuff for us and working on his client project. May God continue to bless you and your family. Am one of your favorite fan.

[@nitroflap]

I love it, even before watching.

[@corneliusjermainehightower7539]

Thank you for taking time and giving knowledge. I’m on my 2nd read of Python crash course and watching your videos helps me tie in beginner and advanced together.

[@joshalvarez298]

I was literally talking about doing this for my church to our pastor today... Crazy! Thanks for the info on where to start! I know SQL and some python so this will be perfect.

[@surplusvalue3271]

Can u please make an in-depth course for Django.

[@surplusvalue3271]

@@thecodinghumans2580 will surely check it out ... thnx

[@HereIam123]

Thank you Brad! You have taught me so much in the past four years, and have helped considerably in having a stable, fun, challenging job. You are the man!!!!

[@HereIam123]

The man!!!

[@alexcheriyan7760]

Thank you. I had a project in mind and started coding from this tutorial. It incorporates a professional coding methodology.

[@microman99]

It took me days to figure out... If you get Lost connection to MySQL server at 'localhost:3306' error when trying to CREATE TABLE `log`, it's because the table_description query printed from TABLES array has curley braces around it, hence it's improperly formated. Hence, we should format the query string by writing cursor.execute(str(table_description)[2:-2]) instead

[@alexanderthaara]

I'm gonna invent some new framework or programming language just to see how fast Brad Traversy is going to create a tutorial for that framework or language... But then again, he'll probably have a tutorial out before I'm done inventing it!

[@EkelundDK]

Brad has a tingling spider sense, when a new framework is being developed, just like how Trinity downloads the helicopter pilot skills in The Matrix. Then he'll upload a "The Matrix Crash Course for beginners" the same day.

[@rukotanafreddy3444]

thanks for your time to support us, junior devs!!!!! wish you all the best!!!!

[@grahamkatana1891]

Brad can teach you the whole essential concepts in just a blink of an eye regardless of your expert level, even us beginners can follow along

[@KeyserTheRedBeard]

incredible video Traversy Media. I shattered that thumbs up on your video. Keep on up the terrific work.

[@davidmares6053]

how can someone dislike this high quality content? doesn't make sense

[@ajitha8216]

Is this a coincidence??....I was just searching on chrome about whether to use postgresql or mysql for Django ....I come to KZbin , and boom , first video on my recommendation:)....

[@tigere01]

Thanks a bunch Brad, this could well be the shortest full CRUD tut you ever dished out.

[@yablablaable]

This was great, thank you Brad! Short and snappy, easy to follow along, and really showcases the potential of interacting with sql through python

[@CodeWithPrince]

Great tutorial man👍👍👍, best of two worlds

[@ifeoluwaAlao]

Believe it or not Mr Brad , I'm Nigerian , it's pretty hard here to get a career as a remote developer based on the "scammers" stigma that the country has developed for itself , but I look up to you , I follow channels that acknowledge your work and you've been an inspiration and I've done a whole lot since I started watching your videos ,I started following you since 2016 and I adore your work

[@wholel9346]

great tutorial! I see if you delete for example logs 1-3 and then add a new log, the new log has the id 4. This is something we need to fix

[@rebelmachine88]

Oh nice, I will definitely take a look at this! Thank you Brad!

[@ryan.aquino]

Great tutorial using mysql connector without any ORM :), I prefer it that way rather using ORM, which has latency on big data sets

[@shlemekian]

Man, if you drop a Python course on udemy I am buying that thing so quick. You're a king amongst kings Brad.

[@Italya3343]

Any chance Brad you consider full Udemy one or more courses, in which you make Python Django React Mysql full stack medium and big full stack projects

[@FAROOQ95123]

You can also use miniconda instead of pipenv. Using it you can specify the python version for your virtual environment.

[@eddytech3767]

I waited for this ... love love bro

[@pythonantole9892]

Owefu, kula code.

[@JakobRobert00]

20:15 wow that trailing comma is really confusing, i debugged for like half an hour because I thought my sql query was wrong and I was just missing the comma :D

[@billgross3579]

Just in time for a new project I have at work! Thank you!!

[@abdurahmanyusuf5170]

you are the most valuable of the programmers i am full fun thank you for time from Somalia

[@b1n0ry92]

Wow ! Finally someone from my country 🙂 happy to see you here "walaalo"

[@abdurahmanyusuf5170]

@@b1n0ry92 thanks

[@b1n0ry92]

@@abdurahmanyusuf5170 ada mudan walalo enjoy learning n keep going 😊 happy coding

[@kiddicode6897]

HELP ME, PLZ!!! You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''logs' ( id int NOT NULL AUTO_INCREMENT, text varchar(250) NOT NULL, user varcha' at line 1

[@dhokare.shailesh]

Nice brad you are inspiration. please do more videos on golang, especially web development in golang or frameworks like gin.

[@isaiahdaniel2522]

Nice video Brad.............i heared node now support the es6 import module, and u said in ur node crash course, u can't wait to see that implemented, can you please do a little something on that

[@heavydirtysoul1491]

Hey Bred, you have had 100,000,000 views recently. congrats!

[@johnnymartin3911]

Wait, Workbench has a dark mode? I stackoverflowed it, but it just showed me how to change the colors of everything but the editor.

[@LongJourneys]

I really like your crash courses, keep em coming.

[@bhuvaneshwarymahesh4368]

Awesome work Brad (knew it would be before clicking on the video)!!!!!

[@theshredguitarist25]

Great video, I love how you get right into it, no bullshit. Gave it a like! and I'm already subscribed.

[@rakshithsn1511]

Regex Crash Course Plz

[@Bayo106]

there are plenty on youtubr

[@BrinleyPavitt]

Dude, just wanna say thanks for all the awesome videos.

[@mukhtarhussain2659]

love the notification when it notifies you have uploaded a new video, lots of love and respect from Pakistan.

[@MrAyubX]

I am stuck at the python interpreter selection. My vscode does not seem to find it. Any ideas ? Thanks

[@lefegoenterprise1455]

amazing! Can you also show us how to update a database using a downloaded csv with data. This would be, for example, a web app that needs analytics updated every week by running python scripts

[@b1n0ry92]

RESPECT you BRAD, let me ask you sth. Am python type, some times i stuck choosing suitable DB for .py either POSTGRE'SQL & MYSQL, so wich one could you suggest to me. THANKS BTW

[@b1n0ry92]

Also would like to see in depth python Desktop application 🙂

[@harissaleem8688]

Can you please make a video on this concept recently i learned java, But in javascript it is difficult for me to understand that suppose we have let a = "Brad".length; then console .log(a) result will be 4 ; so, how we are accessing the dot length thing or maybe like let a = "Brad".toUpperCase(); how this function we are calling because " Brad " it is not a reference variable because in java we use the reference variable them put dot to call any thing inside the object of that class in javascript where is this coming from ???? Please make a video that will be all for me ane it will others also to build concept .

[@Bengadeer]

Hmm. I just tried to download MySQL and Catalina ver 10.15.5 isn't having any of it. Says it's incompatible and I should contact Oracle about it. So I did... still waiting.

[@mussieteshome8232]

If its your will please make a tutorial on Graphql with vuejs together...tired of finding one..

[@anindasadman443]

Node + Express and MySQL please using vs code and datagrip

[@emmanouilmorfiadakis118]

Very good video.Simple and well explained.I love videos like this explanation

[@abhimendiratta8503]

Watching it... Really helpful.

[@patriotlightning7791]

It's great what you're doing Brad

[@jiqi353]

The instructions are very clear. Enjoy it!

[@netranjitborgohain9360]

Getting this error: Creating table (logs) Traceback (most recent call last): File "c:\Users\LENOVO\Desktop\Project1\setup.py", line 39, in create_tables() File "c:\Users\LENOVO\Desktop\Project1\setup.py", line 31, in create_tables cursor.execute(table_description) File "C:\Users\LENOVO\.virtualenvs\Project1-kcaoUNYC\lib\site-packages\mysql\connector\cursor.py", line 545, in execute stmt = operation.encode(self._connection.python_charset) AttributeError: 'set' object has no attribute 'encode'

[@Oda3908]

Is there anyone having the same courtesy notice issue when starting a pipenv shell? Courtesy Notice: Pipenv found itself running within a virtual environment, so it will automatically use that environment, instead of creating its own for any project. I also noticed in this video and seems Brad just ignored that..

[@rajatmehra2186]

Hello Sir please make complete python course with projects same like your javascript course on udemy

[@DefCantGame]

Would be interested in seeing you do an updated laravel series with roles and permissions, maybe a user/admin dashboard.

[@ayush.kumar.13907]

does connecting with PostgreSQL work similarly?

[@litheshshetty7839]

Hay brad..hi..when is ur new platform releasing..will u release ur new courses in udemy as well?

[@tokoiaoben3842]

please make full series to create project based tutorial ... maybe creating some apps along the way so we can really learned

[@SkyFly19853]

Just what I need... 💯💯💯💯💯💯

[@eduriseworld]

Sweet. Could you please check our Deno+GraphQL tutorial and would love your feedback @Traversy Media.

[@danimusbar]

Wow this awesome, Does if we can make own framework like Django or flask ?

[@fsix4012]

Brad pls i need a mern stack e-commerce cousre

[@RealRurik]

we NEED IT!

[@ofekezra7567]

can someon help me i have this problem (windows 10): mysql.connector.errors.OperationalError: 2055: Lost connection to MySQL server at 'localhost:3306', system error: 10038 An operation was attempted on something that is not a socket

[@williamw.2610]

sorry i dont knopw

[@cristianscoop7487]

Hey buddy please make a video on in depth java courses

[@RameenFallschirmjager]

When the grandpa found a new bride! I always associated MySQL with the past and Python with the future. I'm surprised by this marriage!

[@Ramziddin_Rustamovv]

Hi bro , I have problem . I am a student , can you tell me which language to learn . I know PHP yii2 framwork vue.js and other some technologies which I need to know for example html CSS bootstrap

[@k-techdev8992]

Great course like always

[@ramigamal6637]

Easy and informative as usual.

[@digitalnomad6262]

Please a make a tutorial on how to make Admin Dashboard using Python and MySQL. Thx in advance Brad!

[@soksamnang2150]

Hey Brad, are you going to create django framework crash course?

[@andilesimelane4771]

I jst loved it as soon as i hear the sound track

[@Muratmenzilci]

Can you make a tutorial react with Django API please? Love your teaching!

[@lucifer-5ybtn]

Using PHP to do the same thing is so much more convenient

[@rakesh_tolangi]

Mysql with python seems unmatch for me. What about other people any thoughts?

[@jon8367]

Why? They are just tools.

[@__Y1a2s3h4__]

hey can make video on web automation with puppeteer.

[@mahathirmohammad8635]

How do I send server-log via flask_socketio? I watch your video regularly. I watched your python videos. Now I got a project on freelancer.com, Where I have to collect server logs and send that log via socket. I tried to send logs via flask_socket but failed. I read official documentation but didn't understand anything. My request to you, please make a video about "How to send server logs via socket"

[@andistheinforitbutso7513]

what editor is Brad using?

[@TraversyMedia]

I use VSCode. I have used it for the past 4 years or so

[@andistheinforitbutso7513]

@@TraversyMedia Thanks man 👍

[@reyalvarez1617]

Will like to see with Django someday as well, Thanks.

[@تألقمصمم]

Is it web development or Windows application

[@Joshua-dl3ns]

keras/tensorflow crash course?

[@ΓιώργοςΠαυλής-γ9ν]

Great video more python videos plz,Ideally I want a tutorial for FastAPI

[@tech4028]

why mysql and not postgres?

[@alhassankiwamdeen7252]

Thanks Brad

[@XbattlepopeX]

Would love to see a video on Firebase pagination

[@koodauskanava9096]

You should really use f-strings rather than .format().

[@nketiahjoseph9675]

We are waiting for your comprehensive Vue Js course

[@waseem1162]

Upload Python postgreSQL crash course.

[@hauntedspear5728]

So many video videos I want to watch on your channel... but I dont have time to watch it.

[@abhishekmaurya8330]

Sir please make a crash course on vala language

[@Alex-xw5bc]

Can you do a video on Firebase?

[@neoX12000]

Awesome 👍❣️

[@Versa_Sajid]

Please create a crash course on Python FastAPI

[@inigoalday16]

Is this a crash course?, maybe yes but not for people with much experience

[@didierleprince6106]

Merci beaucoup.

[@riandraft]

Wow your the man!

[@jayprecode8012]

Inspired one

[@digigoliath]

Wonderful!

[@harisbashir2719]

Brad ♥️

[@dnsimmons]

Decent tutorial as always. I adapted your code examples into OOP format and added dot-env support: github.com/dnsimmons/python-logger Had a few gotchas with weak references but worked out fine in the end.

[@experimentalhypothesis1137]

very good. Now please PostgeSQL