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?
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.
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..
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. 🙏🙌
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
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?
@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
Hi @Archana aa We appreciate your interest towards learning, we will forward your request to our content team, subscribe to Intellipaat for more updates.
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)
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.
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)
@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.
@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.
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.
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 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏💓💓💓💓💓💓💓💓💓💓💓💓💓
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!
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.
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