- Видео 94
- Просмотров 1 063 158
MPrashant TECH
Индия
Добавлен 10 янв 2023
MySQL and Data Science Related Tech Videos HINDI
.
.
ALRIGHT DOSTO... KI HAAL CHAAL,,,,,,,,,
In this channel we will be focusing on -
- Programming languages
- Scripting
- Database
and other tech related topics in very easy language in Hindi
By Profession - TECH LEAD in FINTECH
Purpose of making videos - to share all my experience, knowledge and guidance that I have learnt so far.
I believe that if students get right directions and guidance and if they working on their skills development, no one can stop them to become successful and achieve their goals.
I will try my best to help such peoples who need proper guidance and knowledge to grow.
If you like my videos please Subscribe my Channel!
Keep commenting and feedback for the improvements.
Thanks!
.
.
ALRIGHT DOSTO... KI HAAL CHAAL,,,,,,,,,
In this channel we will be focusing on -
- Programming languages
- Scripting
- Database
and other tech related topics in very easy language in Hindi
By Profession - TECH LEAD in FINTECH
Purpose of making videos - to share all my experience, knowledge and guidance that I have learnt so far.
I believe that if students get right directions and guidance and if they working on their skills development, no one can stop them to become successful and achieve their goals.
I will try my best to help such peoples who need proper guidance and knowledge to grow.
If you like my videos please Subscribe my Channel!
Keep commenting and feedback for the improvements.
Thanks!
CAREER as FRESHER | How to get your first job as fresher? Step by Step Guide | | MPrashant
#career #freshers #job
Roadmap to get first job as fresher
CAREER Motivation
GET First job as Fresher
How To Prepare for the Job in IT
Career in IT company
00:00 INTRO
03:16 Skills Development
06:50 Project & Internship
10:03 Resume Building
11:55 Networking
13:38 Prepare for Written Exam
16:50 Interview Preparation
19:08 Bonus Tips
Description:
Are you currently in India and finding it challenging to get interview calls? Don't worry, you're not alone! In this video, we will explore various productive activities you can engage in to enhance your skills, expand your network, and improve your job prospects. Whether you're a recent graduate, a seasoned professional, or someone in between, there's somethin...
Roadmap to get first job as fresher
CAREER Motivation
GET First job as Fresher
How To Prepare for the Job in IT
Career in IT company
00:00 INTRO
03:16 Skills Development
06:50 Project & Internship
10:03 Resume Building
11:55 Networking
13:38 Prepare for Written Exam
16:50 Interview Preparation
19:08 Bonus Tips
Description:
Are you currently in India and finding it challenging to get interview calls? Don't worry, you're not alone! In this video, we will explore various productive activities you can engage in to enhance your skills, expand your network, and improve your job prospects. Whether you're a recent graduate, a seasoned professional, or someone in between, there's somethin...
Просмотров: 564
Видео
What is NoSQL? How it is Different from SQL? [HINDI]
Просмотров 31514 дней назад
#mprashant #mysql #sql SQL vs NoSQL: Which One Should You Choose? | Database Comparison Explained Are you confused about whether to use SQL or NoSQL for your project? In this video, I break down the differences between these two database types in a clear and simple way. Whether you're a beginner in database technologies or a seasoned developer, this video will give you the insights you need to ...
What is SQL For Beginners in Hindi? SQL Explained in Simple Terms!
Просмотров 7 тыс.Месяц назад
#mprashant #mysql #sql 🎥 What is SQL? Learn the Basics of SQL in Minutes! Are you curious about SQL and how it works? In this video, we’ll break down SQL (Structured Query Language) in the simplest way possible, so you can quickly understand what it is and how it’s used. Whether you're a complete beginner or just exploring databases, this video is perfect for you! 📌 In this video, you’ll learn:...
Master MONGODB in ONE VIDEO: Beginner to Advanced Course For Beginners in [HINDI]
Просмотров 76 тыс.5 месяцев назад
#mongodb #sql #nosql #mprashant Are you ready to master MongoDB? Look no further! In this comprehensive course, I will guide you from the basics to advanced concepts of MongoDB, all in one video, and in Hindi! Whether you're a complete beginner or looking to enhance your MongoDB skills, this video is designed just for you. What you'll learn: Introduction to MongoDB and NoSQL databases Installat...
Master POSTGRESQL in ONE VIDEO: Beginner to Advanced Course For Beginners in Hindi | MPrashant
Просмотров 205 тыс.7 месяцев назад
@MPrashant #postgres #postgresql #sql PostGreSQL FULL COURSE PostGreSQL COURSE IN HINDI PostGreSQL FOR BEGINNERS PostGreSQL Tutorial in Hindi POSTGRES In Hindi SQL in Hindi Complete SQL Course for Beginners Link for the Notes/Slides of this Video - www.canva.com/design/DAGGQI3jsQo/aZYZy0_PSEFsRfFUMNZx2g/edit?DAGGQI3jsQo& Queries- TaskDB www.canva.com/design/DAGQjSCN04I/5E1IRUJHAxJyV0O5G36rnw/ed...
Video - 83 | MySQL - How to IMPORT and EXPORT Database | DB Backup Hindi
Просмотров 1,6 тыс.8 месяцев назад
#mprashant #mysql #sql @MPrashant In this section I have covered the usage of MySQL CTE with practical example. Mprashant M Prashant Mysql tutorial in hindi mysql tutorials for beginners Learn mysql mysql course in hindi MySQL Tutorial MySQL Course in Hindi MySQL Free Course MySQL Exercise
Video - 82 | MySQL - INDEXES with Example | What is SQL INDEX and HOW IT WORK Hindi
Просмотров 1,4 тыс.8 месяцев назад
#mprashant #mysql #sql @MPrashant In this section I have covered the usage of MySQL CTE with practical example. Mprashant M Prashant Mysql tutorial in hindi mysql tutorials for beginners Learn mysql mysql course in hindi MySQL Tutorial MySQL Course in Hindi MySQL Free Course MySQL Exercise
Video - 81 | MySQL - CTE with Example | Common Table Expressions Hindi
Просмотров 1,8 тыс.8 месяцев назад
#mprashant #mysql #sql @MPrashant SQL CTE What is Common Table Expressions with Example in Hindi In this section I have covered the usage of MySQL CTE with practical example. Mprashant M Prashant Mysql tutorial in hindi mysql tutorials for beginners Learn mysql mysql course in hindi MySQL Tutorial MySQL Course in Hindi MySQL Free Course MySQL Exercise
SAMPLE MySQL Database | How to IMPORT Database? | MPrashant
Просмотров 1,4 тыс.8 месяцев назад
#mysql #sql #mprashant Description: Welcome to this comprehensive tutorial on how to import and use a sample MySQL database! Whether you're a beginner in database management or looking to refresh your skills, this video will provide you with a clear, step-by-step guide to getting started with MySQL databases. In This Video, You Will Learn: Downloading a Sample Database: I'll show you where to f...
Website Free Host with GitHub Pages | Host Your Online Resume | MPrashant
Просмотров 4678 месяцев назад
#mprashant #git Description: Are you looking to create a professional online presence with your resume? Look no further! In this tutorial, I'll guide you step-by-step on how to host your digital resume for free using GitHub Pages. Whether you're a student, a job seeker, or a professional looking to showcase your skills, this video is for you! What You Will Learn: Setting Up Your GitHub Reposito...
Video - 80 | MySQL - TRIGGERS with Example | MPrashant
Просмотров 2 тыс.9 месяцев назад
#mprashant #mysql #sql @MPrashant In this section I have covered the usage of MySQL Triggers with practical example. Mprashant M Prashant Mysql tutorial in hindi mysql tutorials for beginners Learn mysql mysql course in hindi MySQL Tutorial MySQL Course in Hindi MySQL Free Course MySQL Exercise
50 MySQL Interview Questions For Beginners for JOB and EXAM | SQL Questions
Просмотров 42 тыс.11 месяцев назад
#mprashant #mysql #interview SQL Interview questions MySQL Interview questions 50 MySQL questions from Basics to Intermediate Description: 🚀 Ready to kickstart your journey into the world of databases? Look no further! Our comprehensive video, "50 MySQL Interview Questions for Beginners: Master the Basics to Intermediate Level," is tailor-made for aspiring database professionals, job seekers, a...
PYTHON For Beginners in 60 Min [HINDI] 2024 | Python in One Video
Просмотров 870Год назад
#mprashant #python #pythontutorial @MPrashant PYTHON In one video Hindi PYTHON In One hour PYTHON Fast Learn PYTHON Fast Track Course PYTHON in One Shot 🐍🌟 Welcome to our comprehensive guide: 'Python for Beginners in Hindi in 60 Minutes'! 🌟🐍 In just one hour, this tutorial will take you through the fundamentals of Python, one of the most popular programming languages in the world. Designed spec...
Master MySQL in ONE VIDEO: Beginner to Advanced Course For Beginners in Hindi | MPrashant
Просмотров 458 тыс.Год назад
@MPrashant #mysql #sql #database 🚀 My MySQL PDF notes! 📚 Get yours at a special price of 39/- only! 🔥 👉 rzp.io/l/CDuN4OC 💡 MYSQL FULL COURSE MYSQL COURSE IN HINDI MYSQL FOR BEGINNERS MYSQL Tutorial in Hindi SQL in Hindi Link for the Notes/Slides of this Video - drive.google.com/file/d/1HO1fxqH4VTBruhc2Scc18OPoo0ERv0q0/view?usp=sharing Want to learn MySQL but don't know where to start? Then this...
Video - 79 | MySQL - WINDOW FUNCTIONS with Example | MPrashant
Просмотров 1,8 тыс.Год назад
#mprashant #mysql #sql @MPrashant MySQL window functions MySQL ROW_NUMBER MYSQL RANK() MYSQL DENSE_RANK() MYSQL LEAD() LAG() In this video, I'm going to show you how to use a MySQL window function. I'll use an example to demonstrate how to use this function. If you're looking to learn how to use MySQL window functions, then this video is for you! I'll show you how to use this powerful feature o...
Video - 78 | MySQL - USER DEFINED FUNCTIONS with Example | MPrashant
Просмотров 9 тыс.Год назад
Video - 78 | MySQL - USER DEFINED FUNCTIONS with Example | MPrashant
Video - 77 | MySQL - STORED PROCEDURE with Example | MPrashant
Просмотров 2,4 тыс.Год назад
Video - 77 | MySQL - STORED PROCEDURE with Example | MPrashant
Video - 76 | MySQL - HAVING Clause, WITH ROLLUP Concept | MPrashant
Просмотров 1,5 тыс.Год назад
Video - 76 | MySQL - HAVING Clause, WITH ROLLUP Concept | MPrashant
Video - 75 | MySQL - What Are VIEWS, Virtual Tables | MPrashant
Просмотров 1,7 тыс.Год назад
Video - 75 | MySQL - What Are VIEWS, Virtual Tables | MPrashant
Video - 74 | MySQL - Many to Many Relationship With Example | MPrashant
Просмотров 1,7 тыс.Год назад
Video - 74 | MySQL - Many to Many Relationship With Example | MPrashant
Video - 73 | MySQL Exercise 8 on Join Solution | MPrashant
Просмотров 1,3 тыс.Год назад
Video - 73 | MySQL Exercise 8 on Join Solution | MPrashant
Video - 72 | MySQL Exercise 8, MySQL Practice Session on Joins | MPrashant
Просмотров 1,5 тыс.Год назад
Video - 72 | MySQL Exercise 8, MySQL Practice Session on Joins | MPrashant
Video - 71 | MySQL - ON DELETE CASCADE | MPrashant
Просмотров 1,6 тыс.Год назад
Video - 71 | MySQL - ON DELETE CASCADE | MPrashant
Video - 70 | MySQL LEFT & RIGHT JOIN | MPrashant
Просмотров 1,6 тыс.Год назад
Video - 70 | MySQL LEFT & RIGHT JOIN | MPrashant
Video - 69 | MySQL INNER JOIN, GROUP BY with INNER JOIN | MPrashant
Просмотров 2,1 тыс.Год назад
Video - 69 | MySQL INNER JOIN, GROUP BY with INNER JOIN | MPrashant
Video - 68 | MySQL Joins, CROSS JOIN | MPrashant
Просмотров 2,3 тыс.Год назад
Video - 68 | MySQL Joins, CROSS JOIN | MPrashant
Video - 67 | MySQL Foreign Key | MPrashant
Просмотров 2 тыс.Год назад
Video - 67 | MySQL Foreign Key | MPrashant
Video - 66 | MySQL Relationship Explained | MPrashant
Просмотров 1,7 тыс.Год назад
Video - 66 | MySQL Relationship Explained | MPrashant
Video - 65 | MySQL ALTER Query, HOW TO ADD or DROP Constraint? | MPrashant
Просмотров 1,7 тыс.Год назад
Video - 65 | MySQL ALTER Query, HOW TO ADD or DROP Constraint? | MPrashant
Video - 64 | MySQL ALTER Query, HOW TO Modify Column Datatype | MPrashant
Просмотров 1,7 тыс.Год назад
Video - 64 | MySQL ALTER Query, HOW TO Modify Column Datatype | MPrashant
I firstly watch'ed complete ✅ video of postgre sql on youtube , nice experience ❤
you win my heart brother awesime
appreciate your efforts
It's my pleasure!!
Thanku very much ❤❤ bhot ache se DBMS krya aap ne ❤❤
Glad to hear that!
If i have add 2 phone numbers how to add means in the table 102 and 103 need to add the contact using update table
PLEASE BOARDS KE PEHLE CLASS 12TH CS PADHA DIJIYEE (aapse bohot achhe se smjh aa rha sab kuchh) 😭😭😭
😮🎉🎉🎉
Amazing Teaching 👌
Thank you! 🙂
you are best
The code at 3:00:00 i think there is no need for the second case (for mid range car) as this will work just fine: db.cars.aggregate([ {$project:{ _id:0, maker:1, model:1, Car_category:{$switch:{ branches:[ { case: {$lt:["$price", 500000]}, then: "Budget Car" }, { case: {$gt:["$price", 1000000]}, then: "Premium car" } ], default: "Mid-range car" }} }} ]) If the price of a car is not less than 5L and not greater than 10L then it should be between 5L and 10L, so that case can be Mid-range Car...
your the best bro from my side nice explanation
sir what is your LinkedIn id?
www.linkedin.com/in/prashant-kumar-paradkar-493a11a4/
What an amazing course it is! Thanks a lot brother for providing this course...
Glad it helped!!
31 complete
sir i m EEE student and maine core JAVA complete krli and next what should i do ?? SQL ? i have no knowledge...... plz guide (i want to be backend dev)
SQL is good choice and must have skills these days
I downloaded web installer like sir, but i did not get the developer default option. Also, while downloading full installer, i did not get that option
NOTES: AUTO-INC -> CREATE TABLE rating ( -> userid INT AUTO_INCREMENT PRIMARY KEY, -> username VARCHAR(50), -> rating INT) CONCAT- SELECT emp_id, CONCAT(name, ' is a/an ', desig) FROM employees; CONCAT_WS (where ws- with seperator) SELECT CONCAT_WS('-', 'Hi', 'Hello', 'Jim', 'Luci');
Is this course for dba or developer ??
developer
Really interviewer asked these type of questions
I have mentioned 'Beginners' also. questions depends upon the role and department. I have been taking interviews and hiring since last 6 years :)
31/01/2025 today is my third day and finally Completed 🎉thanks you soo much sir 😊
Good job!! All the best
sir can u provide ppt for this complete mysql playlist
That is very well explained ....Thanks
Welcome!!
THE only problem with your explanation is u keep adding rows and column without telling us how to add rows and column.
it was just for reference to explain the topic, however I have covered in later part using ALTER query
Quality Content
Thank you!
Marked for Revision 05:10:22
Good video
Glad you enjoyed!
why you're teachnig majorly "shell" when we we have the better UI version of it. Though I could see your knowledge and hard work, many things were harder on shell and I couldn't get over the errors
If you work in a company where database is installed on linux based server (which is most common) its easy to work on it, however if you learnt Shell then you can easily work on UI :)
Uff! Finally, I have completed this amazing course
Great job!
mysql> use bank_db; Database changed mysql> create table employees( -> emp_id int not null auto_increment primary key, -> name varchar(10) not null, -> desig varchar(20) default 'Probation', -> dept varchar(20) not null ) auto_increment = 101; mysql> desc employees; +--------+-------------+------+-----+-----------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+-------------+------+-----+-----------+----------------+ | emp_id | int | NO | PRI | NULL | auto_increment | | name | varchar(10) | NO | | NULL | | | desig | varchar(20) | YES | | Probation | | | dept | varchar(20) | NO | | NULL | | +--------+-------------+------+-----+-----------+----------------+ mysql> insert into employees (name , desig , dept ) -> values -> ("Raju" , "Manager" , "Loan"), -> ("Sham" , "Cashier" , "Cash"), -> ("Paul" , "Associate" , "Loan"), -> ("Alex" , "Accountant" , "Account"), -> ("Victor", "Associate" , "Deposit"); mysql> select * from employees ; +--------+--------+------------+---------+ | emp_id | name | desig | dept | +--------+--------+------------+---------+ | 101 | Raju | Manager | Loan | | 102 | Sham | Cashier | Cash | | 103 | Paul | Associate | Loan | | 104 | Alex | Accountant | Account | | 105 | Victor | Associate | Deposit | +--------+--------+------------+---------+ mysql> select emp_id , name from employees; +--------+--------+ | emp_id | name | +--------+--------+ | 101 | Raju | | 102 | Sham | | 103 | Paul | | 104 | Alex | | 105 | Victor | +--------+--------+
This was a wonderful lecture, Thanks man.
Glad it was helpful!
sir i am facing problem in setting up root password how to solve it
For my reference: 59:00
You are using Incognito window any specific reason or you don’t want to be too much ads related this field 😂
Sir data analysis le liye kafi hai
not sufficient but very important fundamentals covered in this video.
Thank you for a well-designed & explained tutorial with examples on mongoDB sir... a 💘 from </>
Glad you liked it!!
Database administrator part on PostGreSQL DBMS Make Video on this too
Delivery needs be to improved. Rushing too much.
Bhai Cassandra Databse ki bna do ek Zero to hero.
I will try
sir mysql ko direct nodejs ke sath sikh sakte hai kya
yes you can
thanks sir, it was a great tutorial.
Glad it was helpful!
We can achieve all use cases without CTE, so what is the main purpose of CTE? You have just explained the syntax. We need the use case and purpose to explain why we need CTE instead of the traditional approach of writing queries.
Thanks a lot for sharing this
bhai data analyst ko kya sikhna chahiye postgresql ya mysql
Postgres is most widely used However if you learn Postgres, learning other databases like mysql becomes very easy
sir yaar, ye 7:56 pe mera "system cls;" kaam ni akr rha error aa rha haaiiiii
Hi, online training available?
No, sorry
Sir Poora dekh loya
sir can u provide your ppt for our revision .It will be very helpful for us .Your lecture is so good for a beginner .Thank u so much for your efforts
www.canva.com/design/DAGbdhgGw0M/X0G5aF4xhV84q3aJxnybVg/edit?DAGbdhgGw0M&
Sir not this one, notes of your complete SQL playlist
sir can u provide your ppt for our revision .It will be very helpful for us .Your lecture is so good for a beginner .Thank u so much for your efforts
Hi sir kindly mongo db with express node ke sath v ek video bana dijiye
sir node ki one shot ki itni request ki hy phr bhi ap na ni bnai i will try khty hy or bnia nai one shot sir plz plz one shot bna da🥲
ohh, sachi me time ni mil rha, but ab node react pr video bnaunga
@@MPrashantTech ok sir bhot bhot bhot thanks phly node pr bna da plz