What is MySQL? | How to Create Database and Tables in MySQL | MySQL Tutorial For Beginners | Edureka

preview_player
Показать описание
This Edureka tutorial video on What is MySQL? gives you an insight on the basics of MySQL.
The following are the topics covered in this mysql tutorial:
1. What is Data & Database?
2. What is DBMS?
3. What is MySQL?
4. Install MySQL On Windows
5. Normalization

--------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
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.

Рекомендации по теме
Комментарии
Автор

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

edurekaIN
Автор

Great Video Mam..I find it very Easier..Basically you described it in very simple & understandable manner..Hats off Mam & Team Edureka..Good Wishes To U & Team Edureka..

trekkingworld
Автор

Perfect timing, I was just reading about it an hour ago. Thanks!

Henry-cmho
Автор

*can't find "mysql ommand line client" in windows search bar after extracting...please help me*

sumitdey
Автор

Please upload next session of sql please..

sauravkashyap
Автор

In 4m 30 sec to 4m 49 sec
Good History
It is new for Me

Generally Databases are Two Types
1)Local Machine Database examples) MS Access
Using this we can desktop applications
2)Server Side Database
Examplesl) SQL Servers
Using this Web Application and Dynamic Websites

Is MySQL is Local Machine Databases or Server Side Database

karthickrajalearn
Автор

Edureka
I love u and all.But u have got so many videos, u need to arrange them properly in ur playlists.Some of ur playlists contain multiple vids
relating to same concept.So a viewer who can not stream might go to playlists and literally get confused at the content.
Other than that they r great.

sachinsd
Автор

I downloaded the mysql shell, extract it and put in the c- drive but problem is i am not able to run it. Please help me out.

sauravkashyap
Автор

I want to learn advanced queries, sub queries inside queries...can you please make a video on it

aartigoel
Автор

how to connect python programme with MySQL?

shrutibakutra
Автор

How to see the saved database in this command line prompt

karanbhardwaj
Автор

When I enter any command in MySQL 8.0.13 version shell ....It shows "unexpected help what need to do

gautam
Автор

Hi,
When i try to open mysql command client window it is showing error and closing the window automatically.Kindly help me with the issue.
ThankYou.

saiprashinya
Автор

How to install mysql in Kali Linux yeah how to use mysql in terminal

rupeshranjan
Автор

I am not able to download my SQL ...help ...please

mohddanish-ufgp
Автор

What is the password in the prompt that u entered

kavikolip