Hey Alex, just wanted to say I’ve been following your projects and followed your videos on how to build your resume, and was blessed to receive a job offer because of you. Thank you for everything.
@MOHAMEDMAHMOUD-zr9ds9 ай бұрын
ممكن مساعدة ازاى عملت بروفايل عشان يجى لك وظيفة
@fazrikurniawan96438 ай бұрын
Awesome!
@uzairmemon20963 ай бұрын
are you from pakistan? i need your help.
@saintrhemajl3 ай бұрын
Congratulations
@pandabear0Ай бұрын
Congratulations! I hope to be in the same boat as you soon!
@sound-mind2 ай бұрын
Hey Alex, I wanted to thank you for this bootcamp. It's so kind of you to offer these treasures for free. You've made becoming a DA even easier and less daunting. Thank you!
@zainabusama-ut9os9 ай бұрын
🎯 Key Takeaways for quick navigation: 00:00 *📝 Introduction to Triggers in MySQL* - Triggers in MySQL automatically execute code when specific events occur on a table. - Triggers are useful for maintaining data consistency and automating tasks based on data changes. - A trigger consists of a name, event, and action to perform after the event. 03:26 *🔧 Creating a Trigger in MySQL* - Delimiters in MySQL are essential for handling multi-line queries, allowing multiple statements within a single query. - Triggers are defined using the `CREATE TRIGGER` statement with specific event conditions. - Triggers can be set to execute before or after an event, such as insertion, deletion, or update. 08:50 *🔄 Testing and Utilizing Triggers* - Triggers provide a mechanism for automating tasks, such as updating related tables when data changes occur. - Testing triggers involves inserting data to observe trigger behavior and ensure proper functionality. - Triggers save time and effort in maintaining data integrity and consistency in real-world database operations. 09:04 *🗓️ Introduction to Events in MySQL* - Events in MySQL are scheduled tasks that can be executed at specified intervals. - Unlike triggers, events are not triggered by data changes but are executed according to a predefined schedule. - Events are beneficial for automating recurring tasks such as data imports, exports, or cleanup operations. 11:08 *⏰ Creating Scheduled Events in MySQL* - MySQL events are created using the `CREATE EVENT` statement, specifying the schedule and actions to be performed. - Scheduled events can execute SQL statements, allowing for data manipulation, cleanup, or reporting tasks. - Events provide a convenient way to automate routine database maintenance and management tasks. 13:52 *🔍 Testing and Troubleshooting MySQL Events* - Testing MySQL events involves verifying their execution according to the defined schedule and expected actions. - Troubleshooting event creation issues may require checking the status of the event scheduler and adjusting user permissions. - Understanding the nuances of event scheduling ensures effective automation of database tasks while minimizing errors. Made with HARPA AI
@bystander71143 ай бұрын
Can't wait to start the projects next! I'm so glad I came across this series 👍 Thanks Alex!
@srp40246 ай бұрын
I am having a great time learning with your series for MySQL which I did not even learn in my Coursera course ! Everything is explained in a simple way to understand. I plan to finish the bootcamp and land up in job as data analyst. Thanks a lot for the great work and helping out so many people around the globe.
@justinkings6355 ай бұрын
Just finished the series and I'm amazed on how you teach. I full understand every detail unlike other online courses.
@SobreoEscrito8 ай бұрын
Hey Alex, thanks for this series on MySQL. The way you explain things is so dynamic and clear, you really do a great work! Also, your examples with The Office and Parks and Recs characters are simply fantastic. We have fun while learning and this is amazing. Thanks for all that !
@sarthakshriramАй бұрын
hey alex recently found your channel and has followed through this series had amazing chance to learn new things and clear out the previous topics thanx for this bootcamp
@emansabra-n7g7 ай бұрын
Hey Alex, thank you so much for this series on Mysql. I really appricaite all the hard work you've put to bring us this amazing work. Your way of explaning topics is so easy. Thanks again.
@DasaHerrera5 ай бұрын
for some reason this was by far my favorite lesson. Thank you Alex!
@BruceBeck-f1n8 ай бұрын
Greetings Alexs & All. Just finished watching this lesson at work. Can hardly wait until I get home to run the code on my personal laptop (No MySQL @ work - BOO!). Everything Alex presented here made sense to me. Lots to digest & eventually memorize. Good thing there's a couple of projects to work through to start the process. Cheers! BB😎 UPDATE: Just finished working through Alex's code at home. Worked perfectly, no issues. Thanks again Alex!
@AnastasiaFreeland7 ай бұрын
very useful series, i finished the sql and excel so far. very excited for the projects
@shilpa26378 ай бұрын
Hi Alex I am really really glad that I went through with this. I already have a masters degree in this but I don’t know about the coding language and anything but now I am starting to click into 8t. Thank you lots of love
@hkashkir3 ай бұрын
I have just finished the course series and am eager to get started on the upcoming projects!
@NaijagoldgistNaijagoldgistcomАй бұрын
Alex made learning so easy with the way he teaches, he made me come this far. Thank you Alex. I'm really Hoping I become an expert in D.A soon. Anybody want to connect so that we can learn together?
@phantomavatar884113 күн бұрын
Hello! I wouldnt mind coonnecting, what about discord? IGN phanthomavatar
@ihabmohammedisak61874 ай бұрын
Thank you Alex! You're my SQL idol!
@nadeemjan10005 ай бұрын
Thank you, Alex, I am very great full that I have learned a lot of things from Basic to Advanced level. you are Great
@JairajRegan4 ай бұрын
An amazing SQL course Alex, thank you so much! I heard about normalisation, primary and foreign keys and optimisation, would there be any way of creating a couple videos for these? Love the way you teach so if this is possible I would be truly thankful!
@raphaelmarkd26 күн бұрын
Thanks Alex!
@colewalker517810 ай бұрын
Love your videos Alex, always learn something new. 'Preciate you
@josephoche708116 күн бұрын
No badges on this level?🎉🎉 Thank you so much Alex
@AmanTiwari-ow6rc10 ай бұрын
your videos trigger me to excel SQL
@WilnerSumagingsing5 ай бұрын
Hoping you can make a playlist for SQL Debugging (Exploring errors and how to fix that, I know there's a lot of error we may encounter but this is very helpful). Anyway thanks for the SQL topics, very insightful.
@thipetebogo7 ай бұрын
Enjoyed, poor Jerry finally getting a break
@afunsizedmia18863 ай бұрын
Hi Alex! I love your videos, I've been watching them to review for my technical interviews! Do you think you could make a video going over date and time functions in MySQL? I'm having a hard time finding some good ones here on KZbin. Thanks for everything!
@ARAOYEOMOTOLA6 ай бұрын
Hi Alex, thanks for the great work. I am a beginner and these videos are beneficial.
@samyarkhanzadeh4 ай бұрын
Hello Mr. Freberg. I have a short question.first of all Thanks for your channel. I am following you from your freecodecamp video. I just find out that you teach other things in your freecodecamp course ( like here it is Mysql and there you use Microsoft sql . of course all they both uses sql but there are some differences as well) I just want to ask you which one of your courses do you recommend ?
@paskistanichorayt13024 ай бұрын
my sql is best
@SaeedBarrie5 ай бұрын
Thank you Alex I will enjoy it here 🥰
@isaacfigueroa10 ай бұрын
Great! Thanks!!! I was looking to Know More about triggers!
@habibullah74254 ай бұрын
Great Work Alex.
@pdxbeachvolleyball1084Ай бұрын
Hey Alex, quick question, when do we have to use "Lightning bolt without the "I" and the one WITH the "I" to run individual queries?
@salmanahmed-wm1dz8 ай бұрын
Hi Alex, could you please create a tutorial for 'views'?
@botaberd8466 ай бұрын
GOD BLESS YOU, ALEX!
@anshusaxena086 ай бұрын
when i am running this trigger getting error 11:55:29 insert into employee_salary (employee_id, first_name,last_name,occupation ,salary,dept_id) values (13,'anshu','saxena','ceo',1000000,null) Error Code: 1054. Unknown column 'empoyee_id' in 'field list' 0.000 sec can someone help
@haidarkanaan7562 ай бұрын
You can seee that you mistyped the name of the column " empoyee_id, you forgot 'l' It's 'employee_id'
@vangiang20716 ай бұрын
hi, where can I look at those 2 projects that you are mentioned in the video: Data Cleaning Project & Exploratory Data Analysis Project. Thanks Alex!!
@Sholzie5 ай бұрын
Check his KZbin channel; there's a data analyst boot camp playlist The video you mentioned is there
@melvin6228Ай бұрын
To what extent is it needed to know stored procedures + triggers and events? I've asked it also on Reddit and it seems that it is in the realm of "things SQL can do" but not "things you need to know, unless you encounter it" What do you think? I don't mind (re)learning it (I'm coming from a dev background), but I'd rather do the 80/20 as I don't need to secure a job. I got one in 2 weeks
@Setayy6 ай бұрын
thank you so much it was very helpful
@Abi.haspurpose3 ай бұрын
This is cool!
@pavlik04083 ай бұрын
Thank you very much!
@dragway03858 ай бұрын
Thank you so much sempai🙏🔥💌
@dragnar47438 ай бұрын
nice and informative video, but can you tell me that, how do we decide that when to use AFTER trigger and when to use BEFORE trigger?? like is there any general rule?
@rahalvithanage32955 ай бұрын
if the "event scheduler" value is off, do we edit it on the table itself or is there a specific code to write to turn it on?
@mychanel39523 ай бұрын
Thanks
@jasxteo7 ай бұрын
@Alex The Analyst how do you insert multiple row data in one go?
@Mr.Arshad-oc1fd7 ай бұрын
Thanks for this . O little bit difficult 😊
@benardwanjai21314 ай бұрын
Thank You Alex, and sorry for Jerry Gergich
@isaacjoseph87257 ай бұрын
Damn you Ron Swanson!
@akinlooluwasemilogo322520 күн бұрын
How can you delete a trigger, I made an error when creating trigger employee insert and the insert into employee salary won’t work
@tiagomisosantos17 күн бұрын
DROP TRIGGER name_of_the_trigger;
@MJ-eq4bw10 ай бұрын
Hi Alex, is the market for Data Analysts oversaturated?
@ilovesalmon2159 ай бұрын
very
@tigerch3339 ай бұрын
It's a new field
@tutran-pv3vu8 ай бұрын
What is an event used for? When will it be used in real life situation?
@rahalvithanage32955 ай бұрын
what's the code for "before" - to store the data somewhere BEFORE its deleted
@sachin-b8c4m8 ай бұрын
thank you
@nwanebunkemjika78228 ай бұрын
AMAZING
@adityadhiman34567 ай бұрын
Hi, I did everything (troubleshooting), but jerry still doesn't get deleted. Can anyone explain that to me please?
@jasxteo7 ай бұрын
me too. I went back and it doesnt delete as well.
@bybashaer60897 ай бұрын
Same here
@valerioharvey72897 ай бұрын
let jerry have a job
@ladioyedele8 ай бұрын
How do i add multiple entries into a my trigger
@kanikasuneja77776 ай бұрын
Events not working for me, tried troubleshooting the also
@juliewali16815 ай бұрын
I did all the recommendations but creation of event still doesn't work , anyone to help please?
@julienmonso-lq1qr10 ай бұрын
Ok Alex the analyst ; intend to make a huge session of learning how to do things with your vidéo that are just incredeables, but the question will be : how did you learned so much in such a short Time (sorry for my english speacking, i'm french)
@chandrikaleamon91916 ай бұрын
I am getting syntax errors and the error 'CREATE TRIGGER' must be the first statement in a query batch. I can't seem to find a solution. Does anyone know the cause of this error?
@abiramunir66 ай бұрын
End the before statement with the 'go' statement and issue will be resolved.
@makarsh298 ай бұрын
make VDOs on recursive query ...
@Izzatgold47478 ай бұрын
Hey guys, is there anyone who got error code 1442 (Can't update table in stored function/trigger because it is already used by statement which invoked this stored function) while practicing with Triggers in mysql? If so, let me know how you handled the problem, I've been stuck at it for a while.
@ertoff65406 ай бұрын
DROP EVENT IF EXISTS delete_retirees; (try this) DELIMITER $$ (then run this again) CREATE EVENT delete_retirees ON SCHEDULE EVERY 30 SECOND DO BEGIN DELETE FROM employee_demographics WHERE age >= 60; END $$ DELIMITER ; select* (then run this) from employee_demographics;
@Kiki-yp9te5 ай бұрын
Hiii. I just started this and I'm getting the same error. Were you able to fix it by chance?
@Alfa108695 ай бұрын
DROP TRIGGER name_trigger
@LogarPassport6 ай бұрын
Not working for me
@toke73426 ай бұрын
Why not?
@michaeldenkyi5 ай бұрын
even after every check jerry gergich still exist in my employee demographics
@blessingchikumbirike87094 ай бұрын
I had the same problem. However, after doing everything Alex suggested, I changed the event name to 'delete_retirees' (I just recreated the event with a different name). I reran the code, and it worked. It might work for you too!
@oioioim8432 ай бұрын
check if you also remembered to change the "select * " statement to "delete" instead, inside the begin-end command