ALL >> Education >> View Article
Mysql Tutorial For Beginners
MySQL Tutorial for Beginners
MySQL- Tutorial.jpg
MySQL tutorial
MySQL was developed by MySQL AB, a Swedish company formed in 1995. In 2008, MySQL AB announced that Sun Microsystems had agreed to purchase it for around $1 billion.
MySQL is RDMS(Relational Database Management System). It's a free open source SQL database management system and storing information for your website and directly use PHP to access that material and it's very easy for beginners to learn MySQL for MySql Tutorial for Beginners. It is fast, reliable and user-friendly. MySQL is a cross-platform that operates on a computer.
There are different Types Of Keys that are used in Database
Candidate Key - The candidate keys in a table are specified as the minimum set of keys, and can identify any data row in the table uniquely.
Primary Key - It is chosen from one of the candidate keys and becomes a table's identifying key.
Super Key - It is the main key Superset. It includes a set of attributes including the primary key, which can define every data row in the table in a unique way.
Composite Key - If any ...
... single table attribute can not be the key i.e. it can not uniquely identify a row, instead we combine two or more attributes to form a key. This is known as the key to composite.
Secondary Key - This chooses only one of the candidate keys as the primary key.
Foreign Key - It is a value of the attribute in a table that acts as the primary key in another. Therefore, the international key is useful in connecting two tables together. Information should be entered with great care in the international key column because information entered incorrectly will invalidate the relationship between the two columns.
There are four types of SQL:
DDL(Data Definition Language)
DML(Data Manipulation Language)
DCL(Data Control Language)
TCL(Transaction Control Language)
1. DDL
DDL is a Data Definition Language is the statement or commands which are used to define the database and Change the structure of your database tables.
There are some commands of DDL are:
CREATE – It is used to create the records in the database.
Following syntax are:
CREATE DATABASE ;
ALTER - It is a command that is used to alters the structure of the database.
Following syntax are:
ALTER TABLE table_name ADD(
column_name datatype);
DROP – It is used to drop/delete the table from the database.
Following syntax are:
DROP TABLE table_name
TRUNCATE – It is used to remove all records from a table, including all spaces allocated to the information/records are removed.
Following syntax are:
TRUNCATE TABLE table_name
COMMENT – Comment is used to add comments to the data dictionary.
RENAME – It is a command that is used to rename a table.
Following syntax are:
RENAME TABLE old_table_name to new_table_name
2. DML
DML is a Data Manipulation Language is the statement or commands which are used to manipulate the data including various SQL commands.
There are some commands of DML are:
SELECT - It is used to select/retrieves data from a table.
Following syntax are:
SELECT
column_name1,
column_name2,
column_name3,
...
column_nameN
FROM table_name;
INSERT - It is a command that is used to insert new data into a database.
Following syntax are:
INSERT INTO table_name VALUES(data1, data2, ...)
UPDATE - It is used to update/modify existing data within a table.
Following syntax are:
UPDATE table_name SET column_name = new_value WHERE some_condition;
DELETE - It is used to delete all records from a database table.
Following syntax are:
DELETE FROM table_name;
3. DCL
DCL is a Data Control Language is the statement or commands which is used to deals with rights, permissions and other controls of a database system and the commands include such as Grant and Revoke.
There are some Commands of DCLare:
GRANT - It is used to allow users to access privileges to the database.
Following command of grant is:
GRANT privilege_name
ON object_name
TO {user_name |PUBLIC |role_name}
[WITH GRANT OPTION];
REVOKE - It is used to withdraw the user's access privileges given by using the GRANT command.
Following the syntax of revoke is:
REVOKE privilege_name
ON object_name
FROM {user_name |PUBLIC |role_name}
4. TCL
TCL is used to Transaction Control Language is the statement or commands which are used to deal with the transaction of the database.
This MySQL tutorial is meant for absolute beginners and as we all know it is a business database platform that is easy and simple to use and it is generally used with PHP. Nowadays, when the world is in constant need of people who can work with huge amounts of data if you have the opportunity, you shouldn’t think twice about it because you will be prepared every time for every chance and that is the best reason to learn MySQL.
https://www.phptpoint.com/mysql-tutorial/
We offer an online free tutorial on many web technologies such as php, laravel, Codeigniter, MySQL and so on web technologies
Add Comment
Education Articles
1. Assignment Help In The Uk: Expert Support For Academic SuccessAuthor: Nick Dell
2. The Best Oracle Cloud Infrastructure Training And Certification
Author: SIVA
3. Data Science Course Exploring Generative Ai In Data Science? Transformative Applications And Techniques
Author: Eshwar
4. Amazon Quicksight Training | Aws Quicksight Training In Hyderabad
Author: himaram
5. Microsoft Fabric Training | Expert Led Microsoft Fabric Course
Author: Renuka
6. Data Science And Artificial Intelligence: Collaborators In Technological Innovation
Author: Gajendra
7. Kubernetes Certification Training Course | Docker Online Training
Author: krishna
8. Curriculum At Diyafah International School
Author: diyafah
9. Affordable World-class Medical Education For Aspiring Doctors
Author: Mbbs Blog
10. Explore The World With Your International Driving Licence
Author: Motolic
11. Building Credibility In Ai: How Generative Ai Certifications Enhance Professional Trust
Author: Dorothy Benson
12. Assignment Help In The Uk: Your Path To Academic Success
Author: Nick Dell
13. Germany's 90,000 Work Visa Initiative A New Chapter For Indian Talent
Author: Videsh
14. The Best Google Data Engineer Certification Online Training In Hyderabad
Author: SIVA
15. Scrum Master Training - Scrum Master Online Training
Author: himaram