Topic 7 – Introduction to Database Management Systems

Why do I need to learn about database management systems?

Your software must help users to do their work. The most important part of the users’ work is the information. You need to learn about database management systems to store, manipulate, retrieve and secure this information.

What can I do after finishing learning database management systems?

You can create enterprise systems, such as airlines and railways, banking, education, telecommunications, digital libraries and digital publishing, finance, sales, health care information systems.

It sounds interesting! What should I do now?

Learning about database management systems requires a lot of effort. First you need to learn how to use database management systems.

Please read
– this Ignatius Fernandez (2015). Beginning Oracle Database 12c Administration: From Novice to Professional. Apress book, or
– this Adam Jorgensen et al. (2012). Microsoft SQL Server 2012 Bible. Wiley book, or
– this Vinicius M. Grippa and Sergey Kuzmichev (2021). Learning MySQL. O’Reilly Media book, or
– this Regina O. Obe and Leo S. Hsu (2017). PostgreSQL Up and Running. O’Reilly Media book.

After that please read
– this Jeff Carpenter and Eben Hewitt (2020). Cassandra: The Definitive Guide: Distributed Data at Web Scale. O’Reilly Media book, and
– this Bradshaw Shannon, Eoin Brazil and Kristina Chodorow (2019). MongoDB: The Definitive Guide: Powerful and Scalable Data Storage. 3rd Edition. O’Reilly Media book.

Terminology Review:

  • Database Management Systems
  • Relational Databases
  • (Oracle) Tablespaces, Datafiles, and Objects
  • (Oracle) Databases, Instances, Schemas
  • Entity-Relationship Model
  • SQL, TSQL
  • Stored Procedures
  • Functions
  • Relational Model
  • Joins
  • Subqueries
  • Views
  • Common Table Expressions
  • Indexes
  • Recovery
  • Replication
  • NoSQL
  • Key-Value Databases
  • Document Databases
  • Column-Family Databases

After finishing learning about database management systems please click Topic 8 – Introduction to Web Application Development to continue.

 

(Visited 60 times, 1 visits today)

Leave a Reply