MySQL Tutorial For Beginners | Introduction to MySQL | Learn MySQL | MySQL Training | Edureka

This Edureka tutorial video on MySQL explains all the fundamentals of MySQL with examples.
The following are the topics covered in this MySQL tutorial for beginners:
1. What is Database & DBMS?
2. Structured Query Language
3. MySQL & MySQL Workbench
4. Entity Relationship Diagram
5. Normalization
6. SQL Operations & Commands

#Edureka #MySQLEdureka #SQLEdureka #MySQLTutorial #MySQLTraining

--------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
References: Fundamentals of Database Systems - Elmasri-Navathe

How does it work?

1. This is a 4 Week Instructor-led Online Course.
2. The course consists of 24 hours of online classes, 25 hours of assignment, 20 hours of project
3. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course.
4. You will get Lifetime Access to the recordings in the LMS.
5. At the end of the training, you will have to complete the project based on which we will provide you with a Verifiable Certificate!

- - - - - - - - - - - - - -

About the Course

MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data.

- - - - - - - - - - - - - -

Who should go for this course?

This course can be beneficial for people having the below professional background:
Database Developers
Application Developers
Database Designers
Database Administrators
- - - - - - - - - - - - - -

Project

In the project you will be creating a Database using MySQL on SALARY MANAGEMENT SYSTEM :-

• Employee list to be maintained having id, name, designation, experience
• Salary details having employee id, current salary
• Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee
• Salary increment to be given by next year if any depending upon constraints
• Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted.

- - - - - - - - - - - - - -

Got a question on the topic? Please share it in the comment section below and our experts will answer it for you.

[RajaRam-jklh]

Very very thankyou... Bcoz by this knowledge only i got selected in 2 software companies as a fresher

[sudheer]

Edureka always wonderful, excellent and perfect for any technology. If anyone has a little knowledge about any technology if they go through Edureka videos seriously, they make their careers beautifully😀😀😀

[ranjanchhetry]

Thank You so much for the course. It was completely easy to catch. I am a beginner in MySQL. Now then I have completed the course, I have gained a lot of confidence in me.
Thank you again.

[rishuyadav]

Awesome explanation. Very helpful
Plzz make a video about placements interviews on dbms questions

[divyakn]

So informative video... Thank u so much mam

[anupamprudent]

Great tutorial and very high energy level of the instructor. Thank you so much.👍

[educationguru]

Thank you for this tutorial it was really beneficial for me👍👍
Please upload a vedio over networking fundamentals.

[SMARTPALASH]

Thanks to edureka!, I learn lot of things from this video.

[explorelearn.develop]

Thanks a lot. This tutorial was more helpful for me to learn the ways and statement we can implement in a database to get expected output.

[moizashaikh]

Thank you. It helped me alot in brushing up my knowledge for my interview.

[khushalchaudhari]

Very helpful video for beginers, so informative and very high energy of instructor. Loved it. Thanks .

[nikhili]

thats an amazing way to explain entity & cardinality :)

[alishasingh]

While accessing data from different table, arent we supposed to use joins to allow the foreign key to reference the primary key?

[titangamezone]

Awesome lecture Wanted to ask if its possible to make the code available

[thecloudstories]

Great video, much informative in a single video. Thanks.

[ajisefiniabimbola]

Thanks for this wonderful tutorial, I don't know if the dataset used in this tutorial can be given out for practice. thanks in advance.

[sunilsubedi]

thank you for sharing your knowledge with us..
Found it very helpful and point to point.

[SMARTPALASH]

alter command is not working for foreign key relationship in video time: 1:09:49 . You choose the most critical way to establish foreign key relationship, you can do it during table creation.
I encounter the following error: Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails (`COMPANY`.`#sql-462_4`, CONSTRAINT `#sql-462_4_ibfk_1` FOREIGN KEY (`Mgr_ssn`) REFERENCES `employee` (`ssn`))

[sudhakarsubramaniyan]

thank you so much this great video as well as for your very good explanation. may I ask you why I am getting error, when I try to create tables as u did, I used single quote only still I'm am getting error . the error is 'company' is not valid at this position expecting an identifier".

[perfumedeath]

Thanks you for this great educational video.
It helps me a lot !