FUNDAMENTALS
OF SQL
ITE8 - INFORMATION MANAGEMENT
CONTENT
Introduction
How does MySQL Works?
Who uses MySQL?
MySQL DBMS
How MySQL Works
Why MySQL is Popular?
History of MySql
What MySQL?
INTRODUCTION TO MYSQL
MySQL is a relational database management
system based on the Structured Query
Language, which is the popular language for
accessing and managing the records in the
database.
MySQL is open-source and free software under
the GNU license.
It is supported by Oracle Company.
MySQL is ideal for both small and large
applications.
INTRODUCTION TO MYSQL
MySQL is very fast, reliable, scalable, and
easy to use
MySQL is cross-platform
MySQL was first released in 1995
MySQL is named after co-founder Monty
Widenius's daughter: My
INTRODUCTION TO MYSQL
It is developed, marketed, and supported by
MySQL AB, a Swedish company, and written in C
programming language and C++ programming
language.
The official pronunciation of MySQL is not the My
Sequel; it is My Ess Que Ell.
MySQL supports many Operating Systems like
Windows, Linux, MacOS, etc. with C, C++, and
Java languages.
WHO USES MYSQL?
Huge websites like Facebook,
Twitter, Airbnb, Booking.com, Uber,
GitHub, YouTube, etc.
Content Management Systems like
WordPress, Drupal, Joomla!, Contao,
etc.
A very large number of web
developers around the world
MYSQL IS A RELATIONAL DATABASE
MANAGEMENT SYSTEM (RDBMS)
SOFTWARE THAT PROVIDES :
It allows us to implement database
operations on tables, rows, columns,
and indexes.
It defines the database relationship
in the form of tables (collection of
rows and columns), also known as
relations.
It provides the Referential Integrity
between rows or columns of various
tables.
MYSQL IS A RELATIONAL DATABASE
MANAGEMENT SYSTEM (RDBMS)
SOFTWARE THAT PROVIDES :
It allows us to updates the table
indexes automatically.
It uses many SQL queries and
combines useful information from
multiple tables for the end-users.
HOW MYSQL WORKS?
MYSQL IS BECOMING SO POPULAR
BECAUSE OF THESE FOLLOWING
REASONS:
It is an open-source database
Very powerful that handles a large set of
functionality
Customizable
Quicker than other databases
Supports many operating systems with many
languages like PHP, PERL, C, C++, JAVA ETC.
Use the standard form of SQL data language
Friendly
Supports large database - up to 50 million rows
or more in a table
HISTORY OF MYSQL
MySQL was developed at the Swedish software company named “MySQL
AB”
In the year 1994 founders of “MySQL AB” Mr. David Axmark and Mr.
Michael (Monty) Widenius started the development of MYSQL
MySQL has been developed using C and C++
The name MYSQL is the combination of the name of Michael’s daughter “My”
and Structured Query Language abbreviation “SQL”
MySQL is initially released in the year 1995.
Sun Microsystems acquired MySQL AB in the year 2009 for $1bn.
Oracle Corporation acquired Sun Microsystems in the year 2010 for $7.4bn
So MySQL is now managed by Oracle Corporation
Latest version of MySQL is 5.7 released in the year 2017.
Latest preview version of MySQL is 8.0
MySQL RDBMS WHAT IS RDBMS?
RDBMS stands for Relational Database
Management System.
RDBMS is a program used to maintain a
relational database.
RDBMS is the basis for all modern
database systems such as MySQL,
Microsoft SQL Server, Oracle, and
Microsoft Access.
RDBMS uses SQL queries to access the
data in the database.
What is a Database Table?
A table is a collection of related data
entries, and it consists of columns and
rows.
A column holds specific information about
every record in the table.
A record (or row) is each individual entry
that exists in a table.
W H A T I S A R EL A T I O N A L
DATABASE?
A relational database defines
database relationships in the form of
tables. The tables are related to
each other - based on data common
to each.
What is SQL?
SQL is the standard language for
dealing with Relational Databases.
SQL is used to insert, search, update,
and delete database records.
Keep in Mind That...
SQL keywordsare NOT case
sensitive: select is the same as
SELECT
Semicolon (;) after SQL
Statements?
Some database systems require a s emi colon at the
end of each SQL statement.
Semicolon is the standard way to s eparate each SQL
statement in database systems that allow more than
one SQL statement to be executed i n the s ame call
to the server.
SOME OF THE MOST IMPORTANT
SQL COMMANDS
SELECT - extracts data from a database
UPDATE - updates data in a database
DELETE - deletes data from a database
INSERT INTO - inserts new data into a database
CREATE DATABASE - creates a new database
ALTER DATABASE - modifies a database
CREATE TABLE - creates a new table
ALTER TABLE - modifies a table
DROP TABLE - deletes a table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index
