Enrollments closing soon for Post Graduate Certificate Program in Applied Data Science & AI By IIT Roorkee | 3 Seats Left
Apply NowLogin using Social Account
     Continue with GoogleLogin using your credentials
We have a lot of records to maintain in this data-oriented world. In the olden days where computers were not very oftenly used by people, they used to notedown the information in tabular froms on papers/record-books.
But this system of maintaining data has some costly loopholes:
With growing data everywhere, there is a dire need for softwares which could help us in:
Here comes the role of Database Management Systems(DBMS).
Databases:
Recordbooks come under physical way of recording/maintaining data, whereas database is an electronic way of maintaining the data.
DBMS:
DBMS is a software used to created, manipulate, maitain data. Thers is something called RDBMS whic is an extension for DBMS. In RDBMS, we can store data in tabular forms.
Examples of RDBMS softwars are MySQL, Oracle, Microsoft SQL Server database, etc.
There are also non-relational databses(known as No-SQL databses) such as HBase, MongoDB, etc., but we shall main focus on learning RDBMS using the MySQL software throughout the topic.
Tables:
A database is a collection of tables. Each table contains data related to a desired set of records. For example, a college database may be designed to have various tables:
and other tables needed as per the needs of our scenario.
The above image represents a schematic view of a relational database system for students.
A database is a collection of tables and a table is a collection of rows/records.
The above database contains 3 tables: student_biodata table, student_courses table and courses_table table. The table student_biodata contains rows related to Alex, Snow White etc.
SQL(Structured Query Language) is a language used to wite queries to create/manipulate the data in the RDBMS.
Throughout this course, we will learn how to use the MySQL RDBMS software.
Taking you to the next exercise in seconds...
Want to create exercises like this yourself? Click here.
No hints are availble for this assesment
Answer is not availble for this assesment
Loading comments...