1. INTRODUCTION TO DATABASE MANAGEMENT SYSTEM
A database is a collection of data stored in a format that can be easily accessed. To manage our databases, we use a software application called database management system, or, DBMS. We connect to a DBMS and give it instructions for querying or modifying data. The DMBS will execute our instructions and send the results back. Now we have several database management systems out there, and these are classified into two categories, relational and non-relational, also called NoSQL.
In relational databases, we store data in tables that are linked to each other using relationships. That's why we call these databases relational databases, each table stores data about a specific type of object, like customer product, order, and so on. SQL or SQUEL is the language that we use to work with these relational database management systems. We use SQL to query or modify our data. Now, there are many different relational database management systems out there, some of the most popular ones are MySQL, Microsoft SQL Server, Oracle Database, MS Access, and plenty more.
Each database management system has a different flavor of SQL. But all these implementations are very similar and are based on the standard SQL specification. So, most of the SQL code that you will learn will work with any database management system. In this course, we'll be using MySQL, which is the most popular open-source database in the world.
what about non-relational databases?
In non-relational databases, we don't have tables or relationships, these databases are different from relational databases. What you need to know is that non-relational database systems don't understand SQL. They have their own query language.
So, we use SQL to work with relational database management systems.
2. MYSQL INSTALLATION ON WINDOWS
Step 01: Go to mysql.com
Step 02: Then go to the DOWNLOADS tab
Then click on Windows (x86, 32-bit), MSI Installer
Note: No need to create an account, just click on downloads
After Installation Run the MySQL file.
The below-shown page will open
Keep the default setting and click next.
Click on Execute (it will take around 5min)
Once the execution is complete, keep clicking the next button.
Now we need to enter the password,
Give password as - adminuser
Again we need to keep clicking on the next button
Till we reach to below-shown page (i.e. connect to server page)
Here, Enter the password gain. (same password which we have set earlier i.e. adminuser)
Then keep clicking next, till the process is complete.
After installation is done, 2 windows will pop up.
1. MySQL Shell 2. MySQL Workbench
We can close MySQL Shell, as we don’t need it.
We will be working on MySQL workbench. It will look as shown below.
Now you will see a local instance of MYSQL80 on the welcome page.
If you don’t then, click on the + sign shown and set up a new connection
Give a name to New Connection (Here we have given the name as MyInstance) and keep the rest of the settings as default.)
Then click on the Store in Vault button. It will ask for the password. Enter your password.
Hire us to get any software support related to projects and programming languages. We have skilled team of software installation, fix issues in software and more other.
If you have any query then contact us at: