module 1

Module Content

• An introduction to Database management systems

• An Introduction to RDBMS

• An Introduction to MySQL

• Installing MySQL

Introduction to DBMS

• A Database Management System (DBMS) is defined as the software system that allows users to define, create, maintain and control access to the database.

• DBMS makes it possible for end users to create, read, update and delete data in database.

• A DBMS serves as an interface between an end-user and the database.

• DBMS Examples: MySQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS.

Where are DBMS used ?

Database Management Systems are used in:

• Airlines- reservations, schedules, etc

• Telecom- calls made, customer details, network usage, etc

• Universities- registration, results, grades, etc

• Sales- products, purchases, customers, etc

• Banking- all transactions etc

Advantages of DBMS

Advantages of DBMS:

• Improved Data Availability

• Improved Data Security

• Improved data integration

• Improved decision making

• Increased end-user productivity

• Simplicity

Relational Database Management Systems (RDBMS)

Relational Database Management Systems (RDBMS)

• A relational database organizes data into tables which can be linked—or related—based on data common to each.

• This capability enables you to retrieve an entirely new table from data in one or more tables with a single query.

• Data is represented in the terms of rows/records and columns.

• In a relational database, each row in the table is a record with a unique ID called the key.

Relational Database Management Systems (RDBMS)

MYSQL

MySQL is one of the most recognizable technologies in the modern big data ecosystem. Often called the most popular database and currently enjoying widespread, effective use regardless of industry, it’s clear that anyone involved with enterprise data or general IT should at least aim for a basic familiarity of MySQL

Relational Database Management Systems (RDBMS)

MYSQL

MySQL is a relational database management system (RDBMS) developed by Oracle that is based on structured query language (SQL).

MySQL is integral to many of the most popular software stacks for building and maintaining everything from customer-facing web applications to powerful, data-driven B2B services. Its open-source nature, stability, and rich feature set, paired with ongoing development and support from Oracle, have meant that internet-critical organizations such as Facebook, Flickr, Twitter, Wikipedia, and YouTube all employ MySQL backends.

Advantages and Disadvantages of MYSQL

Advantages of MYSQL

MySQL is secure as it consists of a solid data security layer to protect sensitive data from intruders and passwords in MySQL are encrypted

MySQL is free and open source

MySQL is compatible with most platforms including Windows, MacOS and Linux

MySQL provides the ability to run the clients and the server on the same computer or on different computers, via internet or local network.

MySQL has a unique storage engine architecture which makes it faster, cheaper and more reliable.

MySQL gives developers higher productivity by using views, Triggers and Stored procedures

MySQL is simple and easy to use. You can build and interact with MySQL with only the basic knowledge of MySQL and a few simple SQL statements.

MySQL is scalable and capable of handling more than 50 million rows. This is enough to handle almost any amount of data. Although the default file size limit is 4GB but it can be increased to 8TB.

Disadvantages of MYSQL

MySQL is not very efficient in handling very large databases.

MySQL doesn’t have as good a developing and debugging tool as compared to paid databases.

MySQL versions less than 5.0 do not support COMMIT, stored procedure and ROLE.

MySQL is prone to data corruption as it inefficient in handling transactions.

MySQL does not support SQL check constraints.

Installing MYSQL

Installing MYSQL

To install MYSQL on your computer, please visit

https://dev.mysql.com/downloads/mysql/

And download the free and open source community edition of MYSQL

For Windows select “Installer for Windows”

For Mac select “MacOS”

For Linux select “APT” or “YUM”

And here is a video...

Here is the official guide: MqSQL Workbench

Once downloaded, run the installer and follow the instructions to install MYSQL on your computer then launch the MYSQL Workbench

The workbench home screen

Here is a link to the official page: dev.mysql.com/doc/workbench/en/wb-home.html

Creating A New MySQL Connection

Here is a link to creating connections: dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial-create-connection.html

Some common errors (permissions)

we might get permission errors. So here is a link to resolving those.

installing MySQL workbench

Here are the module 1 notes