What is a database? A database is a collection or data that has been stored in a way that makes it easy to access and secure. Database products are attractive because of their security and management efficiency. There are two types of database systems: Relational or NoSQL.
Relational Data Management System (RDBMS) stores information in a component called Table in ROWS or COLUMNS. Relational refers to a set of tables that are often related. Example includes MySQL, SQL Server, Oracle, etc.
NoSQL databases, on the other hand, store data in documents and not tables. They do not use SQL language to administer data. Examples include MongoDB, Cassandra, Redis etc.
This course is all about SQL and RDBMS. We will use the MySQL SQL product. The SQL language is 95% identical across all RDBMS products with some minor syntactical differences. This means that the SQL we learn in this course with MySQL will also be applicable to other RDBMS products such as SQL Server, Oracle and PostgreSQL.
