Class #3.2 : MYSQL Database DemoHow to create database, tables and run queries.
Vložit
- čas přidán 13. 09. 2024
- Class #3.2 : MYSQL Database Demo
How to create database, tables and run queries.
Exercise Details :
Exercises in text format : macappstudiobr... (Please use this to copy pasting queries)
Exercises in PDF format : macappstudiobr... (Please use only for quick reference and for printout and not for copy pasting queries)
macappstudiobr...
***************************************
Course - Basics of App Development:
***************************************
Play List:
• Class #1 : Vision of B...
Class List:
-----------
Class# 1. Vision of Bridge - • Class #1 : Vision of B...
What is the Bridge program all about, who can join, what it contains and what we need from the participants.
Class# 2. Basics of App Development - • Class #2 : Basics of A...
What happens behind the scenes when you use your mobile apps, how does an app work and what are the layers in app development?
Class# 3. Overview of Database - • Class #3 : Overview of...
What is a database, how does it store data, the four major database operations and how they help in the application flow.
Class# 3.1. MAMP Installation Demo - • Class #3.1 : MAMP Inst...
How to download and install MAMP Server and common problems faced during installation.
Note : This is a very important step needed for the next steps of the course like DB and PHP.
Kindly ensure that you follow the video and install the MAMP server.
MAMP Download link : www.mamp.info/en
Class #3.2 : MYSQL Database Demo - • Class #3.2 : MYSQL Dat...
How to create database, tables and run queries.
Exercise Details :
Exercises in text format : macappstudiobr... (Please use this to copy pasting queries)
Exercises in PDF format : macappstudiobr... (Please use only for quick reference and for printout and not for copy pasting queries)
Class# 4. Basics of PHP - - Coming Soon
Class# 5. Overview of App Development - Coming Soon
Class# 6. Basics of Kotlin - Coming Soon
Class# 7. Basics of Swift - Coming Soon
Class# 8. Basics of HTML / JS /CSS - Coming Soon
Class# 9. Best Practices in App Development - Coming Soon
Class# 10. Build, Deployment and Releasing in Stores - Coming Soon
Premiere Today at 6 pm in MacAppStudio Channel:
Class# 3.2. MYSQL Database Demo - czcams.com/video/J5ipv3RXNmI/video.html.
How to create database, tables and run queries.
Before this video pls see Class #3.1 : MAMP Installation Demo - czcams.com/video/tB7kteydhrE/video.html
Class #3.1 : MAMP Installation Demo:
How to download and install MAMP Server and common problems faced during installation.
Note : Class 3.1 is a very important step needed for the next steps of the course like DB and PHP. Kindly ensure that you follow the video and install the MAMP server.
sir need to clarify some doubts in sql topics..how to contact you
George anna discussion forum epo na expect pannalam..
Next class eppo bro upload pandringa
Discussion blog venum george anna..
George anna discussion blog ku waiting anna..
Very useful na👍👍 successful ah work aguthu
Most of the comments antha concept um podunga, Intha concept podunga, atha sollunga, itha sollunga nu than kekuranga.. Anna's rendu perum just oru kodu than poduvanga.. Naama than road podanum.. Road podurathukum anna's a ethir pakurathu thappu.. Meen pidika solli kodutha namale kathupom nu than intha muyarchi panranga.. So nama than practice pannanum.. Vera vera site lam refer panni kathukanum..
#Nammala_Mudium
#WeCanDo
Super bro This is what I wish to tell all 👍
Waiting for php
Yes brother. You are right We will cover basics and concepts so people can explore further from there.
Correct bro
Clearly explained. Thanks a lot George 💕. Small hint(🔥): there is not used single quote. If we use instead of acute symbol(keyboard 2nd row 1st key) we can ignore the error in the query. It's look acute symbol and left quote are same.
Anna thanks na thirumba eduthathuku. First time lesson enaku puriyala. IPA nalla puriyuth. Romba thanks🙏
Explanation was very clear had more knowledge about it trying the the things from the links u sent in pdf and waiting for the next classes...
Romba Nalla muyarchi. Thodarattum ungal sevai. Romba Nandri
George brother Thanks for all your efforts..The least we could do is Thanking you brothers and including you in our prayers 😊
You are very welcome
3 yers above ha production field la iruke but mind romba nala ithu try pannu solitea iruku atha unga videos try panitu iruku
Thank you for caring youngsters sir
So kind of you sir
வாழ்க நலமுடன் ,வளமுடன்
Thanks from both of us. Your Wishes means a lot to us.
Laptop vangalanu iruka
Ethana GP ram vanum
Practice panrathuka
Gowerment laptop vanagalama
Sollungana
Hi Anna,
I did figure out on how to perform the exercises tasks provided in previous video but your explanation has taken out all my doubt and I did understood clearly. You are a great instructor as well. Thanks for making all these videos. It is helping and motivating me.
அண்ணா உங்களுடைய busy schedule la எங்களுக்காக நீங்க இவ்வளவு விஷயங்களை ரொம்ப பொறுமையாக சொல்லி தருவதற்கு ரொம்ப நன்றி அண்ணா🙏
Video avlo clear ah illa na... Konjam enga explain panringlo anga zoom panna innum konjam useful ah irukkum.... Please consider my comment.... Thank you so much 🙏
very easy to understanding sir unga bridge program follow pannitu varan sir unga bridge program la coding kathukitu nanum Nalla oru app developer a varuvan sir...💐💐🙏.....innu Nirya pannunga sir...enka codinga varathu sir....but bridge follow pannathula irunthu romba interest a easya understand pannikira...
Successfully installed mamp in my government laptop anna.confidence boosted and excited to learn.Thank u so much anna.🥰🥰
நீங்க இந்த மாதிரி உதவி பன்றது எனக்கு ரொம்ப பிடிச்சிருக்கு forum create பண்ண என்னால முடிஞ்ச உதவி பண்றேன் அண்ணா,
எனக்கு beginner level python flask தெரியும்.
Awesome video sir
Thank you so much Anna, love from adambakkam, chennai. The session was very useful. 👌👌👌👌♥️
You're most welcome
Thanks brother! This is going to help many
I need More knowledge for MySQL , you have top to bottom all concepts cover ,sir! I need Job based concepts are highlights...😊👍 waiting...
Thank you so much 🙂. We will cover basics which will help you to start and explore further.
velai ilama kastapadravungaluku..intha bridge oru Periya opportunity sir...💐💐..unga help velai ilama kastapadravungaluku thavai sir...💐...Nirya ENTREPRENEURs make pannunga sir...God is always with you sir 💐
Thanks for clear explanation Anna.. romba porumaiya.. theliva explain panninga.. romba nanri anna.. waiting for upcoming classes.. #nammala_mudiyum 👍💪
The session was very clear...Thank you Sir
Always welcome
U guys rock, keep share good things
Thanks so much for your kind wishes. 😊🙏
I am a 12th csc student I am having this SQL lessons I could able to understand more clearly thank you for effort🎉🎉🔥😎
Keep going 🔥
Super anna roomba use full ha iruku anna. ❤️❤️❤️❤️
Thanks anna
Thanks so much for your kind wishes. 😊🙏
❤️❤️❤️
Tnx For Ur Caring Anna🙏Waitting For Next Video 💪
So nice of you
I eager to see the next video
Way of explaining the topic is absolutely amazing sir, hopefully it will help me to do lot, Thank you so much for your effort and time
Anna i am happy that you starting teaching basic with more examples to making us strong 😊
Sir neega sollithara mathri yarrum solli tharavailla thank you so much🙏🙏🙏🙏🙏🙏🙏🙏🙏
nice explanation. Keep doing your great work.
Super sir. Clear concepts. Learning
ஆனந்த விகடனில் என் கவிதை வந்தால் எவ்வளவு சந்தோஷப் படுவேனோ அவ்வளவு சந்தோஷப் படுவேன், என் கேள்விக்கும் நீங்கள் பதில் தந்தால், எந்த டேட்டாபேஸ் அதிக அளவில் Disk Space எடுத்துக்கொள்ளும், Oracle 12c/ SqlServer / MySql
Simple explanation sir.. 👌
Anna , epdi na very great tq so much for your effort my humble request cover everything na at the end of this program I hope I can able to develop an Demo app insha allah and Tq once again
Thnk u sir,Ur teaching is very clear and understanding here after do like this video teaching sir❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️
Thanks and welcome 😊
@@macappstudio4548 Excercise are very good clear formats to understand also sir ❤️ thanks a lot sir..❤️
Thanks for giving interview in behind Woods , After that I came accross your channel and it's very useful for me 👍
very helpful
It's really helpful.. Thanks for your efforts..
Superb anna tq so much, ur teaching was excellent😊
Games Gosling கூட நீங்க பேசினதால தான் உங்க பக்கம் திரும்பினோம் நாங்க 1000 பேர். பயங்கரம் சார், வேற லெவல்ல போயிட்டிங்க - Senthilkumaran R Oracle Certified DBA, Singapore SMRT
I think James gosling!
Super Anna ❤️ I get inspired from you & Suresh Anna and developing my skill. This bridge course use very useful for me Anna🔥🔥
george sir thank you for your time and the videos!!
Very thank you sir 🙏🏻
Thanks so much for your kind wishes. 😊🙏
thanks, anna for your time
Clear👏
Hello Sir, eagerly waiting for the further classes
Thank you so much for taking your time and uploading videos🙏Wating for more videos🔥
Good Explanation Anna.
It is a good explanation for beginners...
.
.
.
It is a good recap of what i know.
One Suggestion Anna. In this video phpMyAdmin fonts are too small.
Since I am using a computer I could follow. But if they watch this from mobile devices. It is an issue.
So please increase those font size in your next video.
No bro i see it on my mobile only. Yeah, its small but it's not unreadable it is enough to read what george anna do by using my mobile phone small screen.
@@sivaganesh4979 Ok bro. If it is readable then its ok... I was just concerned about the mobile users....
Thank you so much 🙂.
Sir i am very much interest to learn IOS Development. But i don't know where to start. i have approached many of training centers. not satisfied. this will be very helpful to learn from the basics. Surely will do all the exercises you have given. George na + Suresh na = motivational to youngsters. Hatsoff naa..Thanks.
its very usefull.upload new video sir
Tables Relation panrathu pathi sollunga na...
Thank you
Cool
Thanks a lot😊
Great video!
Do create a doubts forum
I'm waiting
Thanks so much for your kind wishes. 😊🙏
Thanks
Thanks 😊
If I updated the row it shows
0 row affected 😔?
Good efforts. Thanks
Most welcome
Sir, can I use xampp server instead of mamp or wamp?
Okay Anna my sql completed Anna
Thank You Anna ❤️🙏
Thanks so much for your kind wishes. 😊🙏
Thanks a lot Sir
Most welcome
its very usefull for me sir:)
Sir, eager for the next video. Any video for this weekend? Kindly consider...
Anna we are waiting for the next video in this series
Sir next video yepo sir poduvinga romba exitmend ha iruku sir ,unga videova 10 time mela pathuutu irukea ipo tha konjam konjma clear ha puriyea aaramikuthu
Anna, enkitta laptop illa. Naan mysql kathukitten. CZcams la simple English la course irukku. Ippothikku, CRUD, inner,outer, natural, cross join varaikkum theriyum. Ithula enna question kettalum solluven. No prob. But laptop illa. Android mobile irukku. Neraya app try pannen. Ellame client tha kidachuthu. Server kidaikkala. Ethavathu idea irundha sollunga pls. And enakku c++ um konjam nallave theriyum. I wanna do something with my knowledge. Android mobile ku nalla app ethavathu sollunga na. RDBMS ku. C++ ku kuda neraya compiler irukku. Athuvum continuous ah kathukittu irukkuren. Konjam basic and interesting program lam pottu irukkuren. One day, naan kandippa app develop pannuven. Thank you for inspiring anna
Sir waiting for next Class, please
completed all w3school exercises
Sir we are waiting for next video sir
George sir good work but I need your help I did Copy paste I had problem plz fixed it bro
Vanakkam anna naan table create pannitten romba nandri anna 🙏
Anaa oru problem update and delete panna browse la change agala anna.
Basic php vedio podungga sir.
George anna.. oru doubt.. enuku coding suthama theriyathu... aws kathuka coding theva paduma...
Bro I did it that day when u post the first videos but this one looks better but I finished the exercise
Sir, Please Next video....
Thank you so much brother 👍🤝🤝💐🥰
Welcome 👍
Hello sir, your session was good. I worked in a BPO and would like to switch over to software development. Kindly advise me.
அண்ணா எனக்கு அவ்வளவாக ஆங்கிலம் தெரியாது
,
(நீங்கள் பேசுவது புரியும் ஆனால் திரும்ப என்னால் சரளமாக பேச இயலாது ). அதனால்,என்னால் எதையும் தெளிவாக கற்றுக்கொள்ள முடியவில்லை.
ஆனால்,தற்பொழுது என்னைப்போன்ற அரசு பள்ளிகளில் தமிழில் படித்தவர்களுக்கும் எளிதில் புறியுமாறு கற்றுத்தருகிறீர்கள்.
மிக்க நன்றி அண்ணா.
Anna,Joins pathi w3 schools la paathen antha alavuku puriyala niinga explain pannunga,athoda application in real time athaiyum unga❤️
❤️ உங்கள் வழியில் நாங்கள் 🎉
நன்றி !!!
Thank you anna 💜😊
Welcome 😊
which database occupies more disk space oracle, sqlserver, mysql ?
thank you so much
PHP video sir, I am waiting
Sir எப்போ basic PHP வீடியோ வரும் sir
Thanks Anna...
Anna suresh anna sonnanga neenga wrok la irrukinganu .next video eppona
sir, please start next update database
Anaa naa table create pannitten anaa query la poittu CRUD use pnnina query correct ah irukku and one row affected apdinnu um varudhu but browse panni patha adhula entha changes um agala pls help me
Vanakkam anna enkku software la arvam athikam, ennoda thambi app developer, but enakku sollikuduna sollithara matenkiran, pls ungaloda video paththa puraku, ithule kathukka asaya irukku, pls help
About data base
George sir contact bridge program about data base
I understand sir
(Ex) : single user
4 columns
Database name : user info
1. User id
2. Name
3.email
4.password
This type George sir explained i understand
but
Suppose
Data base name : Rebal foods
4 types of cuisine : South indian , North indian , thantoori, Chinese
20 different verity for each one cusine
So many Different rate each one cuisine
Delivery boys 10
Contact numbers different each 1 delivery boys
Then how can i set database sir
MAMP is not working. Even they did not connect to the server. what should I do? Respective persons, could you help me? Kindly let me know what should I do. 32 Bit windows 8.1.
Please upload it quickly
what is mean by Engine = innoDB given at last of the query sir
Next video eppa upload pannivinga romba nàal wait pandra
Anna whn ur gonna uploaded nxt video?? 'IM WAITING';
Next class upload pannunga anna