INTRODUCTION
TOPIC IS DATA BASE,SQL,MY SQL:
WHAT IS DATA BASE?
DATA BASE:an organised collection of information(data).
ex: a book like really pages
< data base is allows us to access and DMS intract with data base(DMS TO DB),
(DMS:DATA BASE MANAGEMENT SYSTEM)
WHAT IS SQL?
Structured query language
it is a standard language used to communaction with data base
SQL is used to performed taskson data base
EX:SELECT*FORM customers;
WHAT IS MY SQL?
MYSQL is a data management system
mysql is relational data base management [Link] provides a ui for us to access
and interact with the database
RDBMS
. MYSQL
. POSTGRESQL
. SQL Server
oracle
RDBMS:
in this viedo learn the rdbms.
WHAT IS AN RDBMS?
.. A relational database is a collection of data organised into tables.
.. TABLES contain columns of data categories,and rows with particular instance of
that data category.
.. Tables in a relational database can be linked together.
RDBMS is what we use to access and interact with the relational database.
<< sql downlaod web site is [Link]
>> after click the mysql downloads
MYSQL Workbench: