As few of functions like DESCRIBE does not work in mssql so it things s lot.other things are also different. Please tell me what to understand. Please tell which is popular and helpful. Mssql, mysql or both?
I was about to close the video after the first 5 mins as I couldn't get his point until I scrolled down and saw your command. Bro, wish you could highlight your command somewhere to avoid the next person who wastes their 5 mins..
differences in short sql stands for structured query language whereas mysql is a database software which implements or uses sql as a language to create database with queries if we draw an analogy then C is also a language and SQL is also a language but mysql is a software just like turbo c++ or vs code
Its wrong brother..don't spread wrong information...mySQL is not IDE...sql is a language which is able to handle dbms and rdbms softwares...you can assume sql as an interface which is implemented by various dbms and rdbms softwares..talking specifically about rdbms then these are MYsql,Oracle,Postgres,DB2,SQL-server etc...and these softwares are created to structure the databases in an efficiemt manner for that it takes help of SQL language.... finish.
SQL is a programming language while MySQL is a database and SQL is used to interact with this MySQL database. Am I right?? Thanks for the video and *_ppt_*, both of them were definitely helpful.
Thank you for the breakdown on the difference between the 2! I been racking my brain on the differences! Thank you, on making things completely clearer for me and the reason for both of them in the industry and what'a their purpose. 🙏🙌
Hi @Archana aa We appreciate your interest towards learning, we will forward your request to our content team, subscribe to Intellipaat for more updates.
@venkaat reddy You must first learn SQL in order to learn MySQL. If you wish to learn SQL Course from top experts and get certification and job assistance then kindly call our course advisors on IND: +91-7022374614 US: 1-800-216-8930 (Toll-Free).
which one is better isnt a relevant question therrs so much data to be gathered its just a stepping stone to more analytic software the future is in information analsysis
Congrats...!! but consider this : what about speaking a little bit slower ?? After all, your english has very strong accent... I can understand you if you pronounce the words correctly and slowly... divide by 3 your speed, ok ? thanks !!!
We appreciate your feedback and understand your request for slower speech and clearer pronunciation. We'll do my best to slow down and enunciate more clearly in the future. Thank you for your patience!
What should I learn first ? This was the question before I watched this video ,now I got the answer I should learn SQL first ,have i understood properly ,if im wrong correct me?
Hi, your videos are too good. Can you please provide full stack developer tutorial videos with all technologies like html5, css3, javascript, React, Angular, NodeJs and Mongodb. Thanks in advance....!
Hi, sure, will forward the topic to the respective team and will upload the video soon. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss that video from us.
Yes, there is huge scope for MySQL DBA. If you wish to learn MySQL DBA then please write us to sales@intellipaat.com, or call us at: +91- 7847955955 US : 1-800-216-8930(Toll Free)
Hey, I am a mechanical engineer pass-out in 2017, right now I'm doing job in US staffing. It's a night shift job, so its not much comfortable for future. So I want to learn or come into programing or computer science field. Could you please suggest me best option to learn programing language.. so that I could get secure and day shift opportunity.
Hi, please share your contact number so that we can arrange a call back with our course advisor and the person will help you in suggesting best course for you based on your experience/knowledge.
To back up just the application database, create a dump file using the mysqldump tool. In this example, the database is named bitnami_app; replace this with the name of the database you wish to export. mysqldump -u root -p bitnami_app > backup.sql To back up all the databases, use this command instead: mysqldump -A -u root -p > backup.sql This operation could take some time depending on the database sizes. Once you have the backup file, you can restore the data with a command like the one below: mysql -u root -p < backup.sql To restore the data to a specific database, include the database name in the command, as shown below. For example, to import the data to a database named bitnami_app, use this command: mysql -u root -p -D bitnami_app < backup.sql
@mixed entertainment_ hub! If you wish to get Personal support Kindly call our course advisors on IND : +91-7022374614 US : 1-800-216-8930 (Toll Free).
@@mixedentertainment_hub7217 sql is the language that mysql will use to query its database. If you learn mysql then you will learn sql along the way. Maybe you're better off comparing postgresql and mysql.
@mahaboob iyaz SQL is a type of programming language, yes. It provides looping, logic instructions, variables, and other features. It's not a language in the same sense as something like Java or C++, though. Do like, share & subscribe to our channel to get updates on upcoming videos.
Hi Kindly contact our course advisors on IND: +91 70 223 74614 US: 1-800-216-8930 (Toll-Free) | sales@intellipaat.com So that we can assist you better:- )
Hi @Vivek verma The SQL is much more secure than the MySQL in case of Data Analytics If you wish to get Personal support Kindly call our advisors on IND : +91-7022374614 US : 1-800-216-8930 (Toll Free)
Hii guys. I have commented my question but didn't get reply til now. My question is that what are the basic terms and topics we should study before starting learning a programming languages like java and c or c++. Please sir guide us...🙏
All languages are same bro Syntax will be different thats it Java is very easy And the topic from which you have to start in java is : Basics: what are keyword,identifiers,class name,print and println statements and how to use these #VeryEasy 1. Data types: primitive and non primitive, types of primitive and non primitive data types 2.varibles 3. Arithmetic operators 4. Scanner class 5. If condition and if else conditions #FirstLearnUpto here and start practicing Prime, fib series,factorial,palandrome programs. After practicing this from very next topic which you learn start practicing 6. Switch case 7. Loops 8. Patterns 9. Toggle concept 10. Methods 11. Var args 12. Parse/parsing 13. Method overloading 14. Method Overriding 15. Recursion 16. Type casting 17. Static and non static control flow 18. Oops 19. Constructors 20. Inheritance 21. Annotation(@Override concept) 22. Upcasting 23. Binding 24. Downcasting 25. Abstract 26. Polymorphism 27. Interface 28. Marker interface 29. Abstraction 30. Factory method 31. Encapsulation 32. Aggregation 33. Object methods: ToString 34. String concept 35. String Methods 36. Arrays 37. Wrapper class 38. Exceptions 39. Collections 40. Multi threading
@@Intellipaat I haven't watched your full course till now. But when i have started, many keyword like string, flow etc are started trouble me. If i start learning java now, all the terms told above by manoj, are already explained or i have to learn these from other sources.
Sir please tell me how much databases can i do the everythings with mysql which is possible any other database like firebase , sql , nosql Sir can i do anything possible with databases with only mysql please tell me sir 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏💓💓💓💓💓💓💓💓💓💓💓💓💓
My only request is that you try and speak much slower no offense but you speak extremely quickly and at least for me native English speaker from Pacific Northwest who is bilingual as well in Spanish but my first language is definitely English I have a hard time and I'm sure I am far from the only person who has a hard time completely understanding especially when it's extremely specific technical terms being you used such as coding language new terms to people as well as words that aren't used and in day-to-day basis outside of programming I'm certain that I'm far from the only person who finds it very hard to understand you no offense but you're not you are so far from the only one you're definitely not the only one it's just constructive criticism please don't take it offensively or any more than that thank you
Guys, which technology you want to learn from Intellipaat? Comment down below and let us know so we can create in depth video tutorials for you.:)
Does it mean MySql NEEDS php knowledge? Can Sql be used also with more than one user?
data warehousing ***
As few of functions like DESCRIBE does not work in mssql so it things s lot.other things are also different. Please tell me what to understand. Please tell which is popular and helpful. Mssql, mysql or both?
Which technologi is good in now a days both my sql and ms sql can you say that pleaew
Python
Skip to 5:36 .. before 5:36 its a waste of time ..
Anirudh Pandey best communication
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
I was about to close the video after the first 5 mins as I couldn't get his point until I scrolled down and saw your command. Bro, wish you could highlight your command somewhere to avoid the next person who wastes their 5 mins..
Thanks for this
Thanks boss
differences in short
sql stands for structured query language whereas mysql is a database software which implements or uses sql as a language to create database with queries
if we draw an analogy then C is also a language and SQL is also a language but mysql is a software just like turbo c++ or vs code
Well said
better explanation than the video above, lol XD
So sql is the language and my sql is more like ide ??
Basically, yeah.. lol
Its wrong brother..don't spread wrong information...mySQL is not IDE...sql is a language which is able to handle dbms and rdbms softwares...you can assume sql as an interface which is implemented by various dbms and rdbms softwares..talking specifically about rdbms then these are MYsql,Oracle,Postgres,DB2,SQL-server etc...and these softwares are created to structure the databases in an efficiemt manner for that it takes help of SQL language.... finish.
Thank god for creating indians.. best tutorials out there! Thanks a lot for your efforts!!
Glad you liked it. Keep learning with Intellipaat. :)
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
Indians are the Best😭😭😭❤
6:14 SQL needs to be worked on and learned
6:30 MySQL doesn’t need much prerequisite
6:55 u need to know SQL to use MySQL -_-
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
This is programming
@jeff pentagon the purpose of making this video is to clear the confusion between these two.
so in my sql, we can run the sql queries,There is no different query for that ?
@@alpha23381 that is what @jeff pentagon is a fool 🤣🤣
The whole point of this video is that if u r a beginner then jst go for SQL first👍🏼
Thanks, I don't need to watch video just because of you
SQL is a programming language while MySQL is a database and SQL is used to interact with this MySQL database. Am I right?? Thanks for the video and *_ppt_*, both of them were definitely helpful.
Most welcome 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Hatsoff ...you cleared all of my doubts💥🙏🏼
Glad to hear that. Keep learning with Intellipaat😊
Thank you for the breakdown on the difference between the 2! I been racking my brain on the differences! Thank you, on making things completely clearer for me and the reason for both of them in the industry and what'a their purpose. 🙏🙌
Most welcome 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
@@Intellipaat You got it! 😁👊
Thank you very much
Most welcome 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Thank you so much for a fantastic presentation.
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Plse upload video on how to create database n queries using SQL
Hi @Archana aa We appreciate your interest towards learning, we will forward your request to our content team, subscribe to Intellipaat for more updates.
So is MySQL technically a compiler/IDE for SQL??
Yeah... Almost
so is MySQL that important to use SQL?
@@chillymoozy7093 mysql is a Relational DBMS. There are other RDBMSs. We need to learn 'SQL - the language' to work with these RDBMSs.
great video. thank you
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Awesome explanation....
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Thank God for creating Indians.
our pleasure @Residue class mod 44 NUMBERSON Keep learning :- )
I appreciate the thoughtful content displayed in this video. God bless you sir.
This video helped to take overview ..thank YOu.
@Lovely Dreams You're welcome! Do like, share & subscribe to our channel to get updates on upcoming videos.
Learned alot🎉
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
one of the best Tech channels on you tube.!!! ..You guys are amazingly outstanding.!!
Thanks for the kind words. :)
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
video starts at 1:18
simply put sql is the interface for dbms and rdbms softwares. MySql is a rdbms software that uses sql language to manipulate its datasets
Great explanation, thanks.
You're welcome!
Well explained..
@Englishwell India(www.englishwellindia.online). We are going to explain more topics in furure. Do like, share & subscribe to our channel.
Greatness in its simplicity !
@justin therattil Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Congratulations for 1.3m😇
@caption#coding Thank you
Thank you so much for this precious information to learn for me as a beginner.🙏👌💟👍
Glad it was helpful. Keep learning with Intellipaat. :)
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
Tnx....nd congrats for 150 comments😊
@Army lover Anil Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
thank u
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
which one is used for data analyst
@Abhishek Sharma If you wish to get Personal support Kindly call our course advisors on IND: +91-7022374614 US: 1-800-216-8930 (Toll-Free).
Thanks for information bro 😊
Most welcome 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
I want my website to use these query written in mysql workbench...... How could i directly without xampp
If you wish to get Personal support, fill out this form and we will reach out to you. Have a great day!
.
Google Form: forms.gle/XWy7MtQPrHkgq7Pt7
So in order to learn MySQL, do we need to learn SQL first?
Or Straight away learn MySQL.
@venkaat reddy You must first learn SQL in order to learn MySQL. If you wish to learn SQL Course from top experts and get certification and job assistance then kindly call our course advisors on IND: +91-7022374614 US: 1-800-216-8930 (Toll-Free).
What is the difference between a bear and conclusion?
Please make video on my sql
Hi Abhay, please click on the link mention for SQL full course 😊ua-cam.com/video/wkOD6mbXc2M/v-deo.html
Thank you for the video!
My pleasure!
which one is better isnt a relevant question therrs so much data to be gathered its just a stepping stone to more analytic software the future is in information analsysis
Congrats...!! but consider this : what about speaking a little bit slower ?? After all, your english has very strong accent... I can understand you if you pronounce the words correctly and slowly... divide by 3 your speed, ok ? thanks !!!
We appreciate your feedback and understand your request for slower speech and clearer pronunciation. We'll do my best to slow down and enunciate more clearly in the future. Thank you for your patience!
Great video!
Glad you enjoyed it @Aniebiet Sunday Do like, share & subscribe to our channel to get updates on upcoming videos.
microsoft sql server vs my sql which one is better?
May I know life sciences background also learn on this technology
sir...!
how much to apply for mysql
Content is good.
But there is a requirement of to control the speed of speech.
Speed of speech is little bit fast.
Hi, please reduce the speed to 0.75
What should I learn first ? This was the question before I watched this video ,now I got the answer I should learn SQL first ,have i understood properly ,if im wrong correct me?
@Crazylove Ever Do like, share & subscribe to our channel to get updates on upcoming videos.
Hi Sir,
Pls make practice tutorial for Computer Security /Ethical Hacking.pls reply
Hi Pritam, please watch ethical hacking here: intellipaat ethical hacking
@@Intellipaat Thank you so much for this precious information to learn for me as a beginner.🙏👌💟👍
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
This guy is the only guy with an Indian accent I can follow along with
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
Hi,
your videos are too good. Can you please provide full stack developer tutorial videos with all technologies like html5, css3, javascript, React, Angular, NodeJs and Mongodb.
Thanks in advance....!
Hi, sure, will forward the topic to the respective team and will upload the video soon. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss that video from us.
Iam a ios developer, but need to learn more useful course. Could you suggest me
As a fresher which is best to learn SQL r MySQL??
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
U learn SQL and PL/SQL properly
Thank you
You're welcome @sohul anjum
Great video, thank you for explaining!
Asked in interview
@Ros Ediz Do like, share & subscribe to our channel to get updates on upcoming videos.
Plzz tell me uses of SQL
Very clear!
Glad it was helpful!
Thank you sir !
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
Is there any scope for MySQL DBA?
Yes, there is huge scope for MySQL DBA. If you wish to learn MySQL DBA then please write us to sales@intellipaat.com, or call us at: +91- 7847955955 US : 1-800-216-8930(Toll Free)
Hey, I am a mechanical engineer pass-out in 2017, right now I'm doing job in US staffing. It's a night shift job, so its not much comfortable for future. So I want to learn or come into programing or computer science field. Could you please suggest me best option to learn programing language.. so that I could get secure and day shift opportunity.
Hi, please share your contact number so that we can arrange a call back with our course advisor and the person will help you in suggesting best course for you based on your experience/knowledge.
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
Can I get the procedure to restore backup from MariaDB to SQL server std
To back up just the application database, create a dump file using the mysqldump tool. In this example, the database is named bitnami_app; replace this with the name of the database you wish to export.
mysqldump -u root -p bitnami_app > backup.sql
To back up all the databases, use this command instead:
mysqldump -A -u root -p > backup.sql
This operation could take some time depending on the database sizes.
Once you have the backup file, you can restore the data with a command like the one below:
mysql -u root -p < backup.sql
To restore the data to a specific database, include the database name in the command, as shown below. For example, to import the data to a database named bitnami_app, use this command:
mysql -u root -p -D bitnami_app < backup.sql
Pls guys don't waste time kindly do practical.All your videos are very long at the end practical knowledge 0.
I learned python but I have little bit confuse to which database to start first sql or MySQL reply me quickly
@mixed entertainment_ hub! If you wish to get Personal support Kindly call our course advisors on IND : +91-7022374614 US : 1-800-216-8930 (Toll Free).
@@Intellipaat I just want reply for my question please
@@mixedentertainment_hub7217 sql is the language that mysql will use to query its database. If you learn mysql then you will learn sql along the way. Maybe you're better off comparing postgresql and mysql.
What should I learn first sql or mysql?
SQL is best for beginners.
@@Intellipaat syntax for writing commands is same in SQL and MySQL?
In SQL there is coding?
@mahaboob iyaz SQL is a type of programming language, yes. It provides looping, logic instructions, variables, and other features. It's not a language in the same sense as something like Java or C++, though.
Do like, share & subscribe to our channel to get updates on upcoming videos.
How much do you offer MySQL?
If you wish to get Personal support, fill out this form and we will reach out to you. Have a great day!
.
Google Form: forms.gle/XWy7MtQPrHkgq7Pt7
if i want to do a course od DBMs which can I do either SQL or MYSQL
Hi Kindly contact our course advisors on IND: +91 70 223 74614 US: 1-800-216-8930 (Toll-Free) | sales@intellipaat.com So that we can assist you better:- )
for data analytics which one is best Sql or mysql
Hi @Vivek verma The SQL is much more secure than the MySQL in case of Data Analytics If you wish to get Personal support Kindly call our advisors on IND : +91-7022374614 US : 1-800-216-8930 (Toll Free)
@@Intellipaat Thank you for your Reply
sql is a coding language
mysql is a software 👻
@dara Do like, share & subscribe to our channel to get updates on upcoming videos.
Is there any certification or course for MYSQL??
@Ahmad Jawid Haidary Yes we do have a certification course for MYSQL, you can check it out here ---> shorturl.at/nwLQU
@@Intellipaat
This link is not working
Hii guys. I have commented my question but didn't get reply til now.
My question is that what are the basic terms and topics we should study before starting learning a programming languages like java and c or c++. Please sir guide us...🙏
C language sikhna start kr do
Easy hai and aur samajh me aa gya to c++ bhi easily samajh jaoge
Bro u wanna ask aah? Just google it out and get the solution
All languages are same bro
Syntax will be different thats it
Java is very easy
And the topic from which you have to start in java is :
Basics: what are keyword,identifiers,class name,print and println statements and how to use these #VeryEasy
1. Data types: primitive and non primitive, types of primitive and non primitive data types
2.varibles
3. Arithmetic operators
4. Scanner class
5. If condition and if else conditions
#FirstLearnUpto here and start practicing
Prime, fib series,factorial,palandrome programs. After practicing this from very next topic which you learn start practicing
6. Switch case
7. Loops
8. Patterns
9. Toggle concept
10. Methods
11. Var args
12. Parse/parsing
13. Method overloading
14. Method Overriding
15. Recursion
16. Type casting
17. Static and non static control flow
18. Oops
19. Constructors
20. Inheritance
21. Annotation(@Override concept)
22. Upcasting
23. Binding
24. Downcasting
25. Abstract
26. Polymorphism
27. Interface
28. Marker interface
29. Abstraction
30. Factory method
31. Encapsulation
32. Aggregation
33. Object methods: ToString
34. String concept
35. String Methods
36. Arrays
37. Wrapper class
38. Exceptions
39. Collections
40. Multi threading
Hi Dipanshu, i think Manoj has explained really well.
@@Intellipaat I haven't watched your full course till now. But when i have started, many keyword like string, flow etc are started trouble me. If i start learning java now, all the terms told above by manoj, are already explained or i have to learn these from other sources.
Level of confusion is increased. SQL is language then what is MSSQL? Is it a RDBMS? just like MYSQL.
Hi Sachin, SQL is a common language that is used to handle the Database, Where MSSQL and MYSQL are Different tools used for RDBMS
I need training video on Oracle Sql database server for beginners. Please let me know the link. Thank you
Hi, please watch this: ua-cam.com/video/wkOD6mbXc2M/v-deo.html
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
Can I use SQL app in android mobile
No
oracle sql vs sql vs my sql vs microsoft sql which one have more value.
Sir please tell me how much databases can i do the everythings with mysql which is possible any other database like firebase , sql , nosql
Sir can i do anything possible with databases with only mysql please tell me sir 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏💓💓💓💓💓💓💓💓💓💓💓💓💓
Hi all anime, Kindly Call Our Course Advisors IND : +91-7022374614 US : 1-800-216-8930 (Toll Free) so that we can assist you better.
❤
@Brothers Gaming Xtreme Do like, share & subscribe to our channel to get updates on upcoming videos.
Sql
Do like, share & subscribe to our channel to get updates on upcoming videos.
SQL vs MySQL? :D, what the hell is that supposed to mean, maybe you meant MSSQL vs MySQL???
Sir i have a dought to become an AI engineer after 12th? Is that we can do it from bscit
Hi Rohit, yes you can learn while doing Bsc IT. Please check this link to know more: intellipaat.com/artificial-intelligence-masters-training-course/
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
thnx very much Indians are smart ppl but why they warship a cow ? and idols its 21 century just wondering am not trying to offend anyone
every difference given by you is almost similar to one another
please produce some meaningful content.
My only request is that you try and speak much slower no offense but you speak extremely quickly and at least for me native English speaker from Pacific Northwest who is bilingual as well in Spanish but my first language is definitely English I have a hard time and I'm sure I am far from the only person who has a hard time completely understanding especially when it's extremely specific technical terms being you used such as coding language new terms to people as well as words that aren't used and in day-to-day basis outside of programming I'm certain that I'm far from the only person who finds it very hard to understand you no offense but you're not you are so far from the only one you're definitely not the only one it's just constructive criticism please don't take it offensively or any more than that thank you
Hi @Lila Alejandra Abegunrin Sure we will consider your suggestions. Thank you Keep learning with us:-)
Is MySQL safe for database?
yes of course.
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
Please send this app
App link vejo
ua-cam.com/video/d6qFSq1S4_Y/v-deo.html
.
Oh, my Gosh !!! you speak like a wild river flowing downhill... don't you even stop to breath ????
Thank you so much
You're most welcome @Thank you so much Do like, share & subscribe to our channel to get updates on upcoming videos