Category Archives: Database Management Systems

Topic 6 – 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?

Database management systems is a huge topic. However at this time you just need to learn how to use database management systems under a user's point of view.

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.
After that please read
- this "Jeff Carpenter, Eben Hewitt (2016). Cassandra: The Definitive Guide. O'Reilly Media" book, and
- this "Bradshaw Shannon, Eoin Brazil and Kristina Chodorow (2019). MongoDB: The Definitive Guide. 3rd Edition. O'Reilly Media" book.

After finishing the books please click Topic 7 – Introduction to Web Application Development to continue.

Topic 14 – Introduction to Database Design

Why do I need to learn about database design?

Database is the heart of your application, especially enterprise applications. Designing a database incorrectly will cause your application eventually fail.

What can I do after finishing learning about database design?

You will know how to design a relational database and write SQL code PROPERLY. You will know how to build a data warehouse. You will know WHY you should use a relational database system and how it actually works.

That sounds useful! What should I do now?

Please read this "Stephane Faroult and Peter Robson (2006). The Art of SQL" book first.
Then please read
- this "W. H. Inmon (2005). Building the Data Warehouse" book and
- this "Ralph Kimball and Margy Ross (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling" book and
- this "Vincent Rainardi (2007). Building a Data Warehouse: With Examples in SQL Server" book.
Finally, please read
- this "C. J. Date (2012). Database Design and Relational Theory: Normal Forms and All That Jazz" book and
- this "C.J. Date (2011). SQL and Relational Theory: How to Write Accurate SQL Code" book.
After finishing the books please click Topic 15 - Advanced Software Design to continue.

Topic 7 – Introduction to Web Application Development

Why do I need to learn about web application development?

Desktop applications are very powerful and convenient but their development, deployment and maintenance are daunting. The reason is that the platform dependency makes it very expensive to create a desktop application working on different versions of different operating systems, such as Windows, Linux and Mac OSX. Deployment and updates of desktop application typically require high privileges access to a computer machine, causing a problem for companies requiring high security.

Fortunately, you can overcome these limitations by creating a web application running on a browser. To create a web application you need to learn about web application development.

What can I do after finishing learning web application development?

You will be able to create web applications like The BBC News, The WordPress Blog or The White House Website.

This is just what I want to learn! What should I do now?

Web application development requires a lot of reading. You have to master networking concepts, HTML, CSS, Javascript, a programming language and a database management system for web. Please read this Semmy Purewal (2014). Learning Web App Development. O'Reilly Media book first to get familiar with web application development.
After that you will have 4 options. You can choose one of them. We STRONGLY recommend that you choose only ONE option. You should NOT learn all of them at the beginning. You could save your time by digging into only one option. After mastering the selected path, you will realize that all of them are very similar in the sense of use. One note is that although their concepts are similar to one another but they will still take us much time to learn how to apply implementation of an approach in real world solutions.
When developing a real world web application, you often use only one or two of these 4 approaches. If you cannot make your own selection then we recommend you a combination of the first and second option or a combination of the second and third option.
The first option is ASP.NET Core. Please read 
- this "Adam Freeman (2017). Pro ASP.NET Core MVC 2. Apress" book or 
- this "Dino Esposito (2018). Programming ASP.NET Core. Pearson Education" book.
A complementary part for this option is ASP.NET Web Forms. Please read this "Imar Spaanjaars (2014). Beginning ASP.NET 4.5.1: in C# and VB" book.
The second option is PHP world.  Please read 
- this Luke Welling and Laura Thomson (2016). PHP and MySQL Web Development. Addison-Wesley Professional book or
- this Robin Nixon (2018). Learning PHP, MySQL & JavaScript. O'Reilly book.

After that depending on your projects you can read these books below.
- Brad Williams, David Damstra and Hal Stern (2015). Professional WordPress: Design and Development. Wrox.
The third option is Java world. You will need to read 2 books for this option. Please get this "Cay S. Horstmann (2012). Core Java Volume I--Fundamentals" book and read it if you are not familiar with Java language.

Then please read 
- this "Tim Downey (2012). Guide to Web Development with Java: Understanding Website Creation" book or 
- this "Nicholas S. Williams (2014). Professional Java for Web Applications" book.
The 4th option is Node world.  Please read this
- this "Jonathan Wexler (2019). Get Programming with Node.js. Manning Publications" book, and
- this "Bruno Joseph D'mello et al. (2017). Web Development with MongoDB and Node. Packt Publishing" book.
After that please read 
- this Kirupa Chinnathambi (2018). Learning React. Addison-Wesley Professional book, and
- this Robin Wieruch (2020). The Road to React - Your Journey to Master Plain Yet Pragmatic React. Leanpub book to learn how to create a single page application (SPA).
After finishing these books if you want to create sophisticated interactive web applications please read 
- this "David Flanagan (2011). JavaScript - The Definitive Guide. Sixth Edition. O'Reilly Media" book and
- this "Kyle Simpson (2015). You Don't Know JS" book.
If you want to convert a web application from one platform to another or create a web application framework please read this "Leon Shklar and Richard Rosen (2009). Web Application Architecture: Principles, Protocols and Practices" book.
After finishing the books please click Topic 8 - Introduction to Mobile Application Development to continue.