Category Archives: Database Management Systems

Topic 14 – Introduction to Database Design

Why do I need to learn about database design?

Database is the heart of any software system, especially enterprise systems. A bad database design will eventually cause your system fail.
Designing enterprise databases requires a lot of specific enterprise knowledge and in-depth understanding of structure of big databases.
That's why you need to learn about database design.

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 WHEN you should use a relational database management system or WHEN you should use a NoSQL database management system and HOW they actually work.

That sounds useful! What should I do now?

Please read this Stephane Faroult and Peter Robson (2006). The Art of SQL. O'Reilly Media book first.
Then please read
- this W.H. Inmon (2003). Building The Data Warehouse. Wiley book and
- this Ralph Kimball and Margy Ross (2002). The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. Wiley book and
- this Vincent Rainardi (2008). Building a Data Warehouse: With Examples in SQL Server. Apress book.
After that please read
- this Pramod J. Sadalage and Martin Fowler (2012). NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Addison-Wesley Professional book, and
- this Martin Kleppmann (2017). Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems. O'Reilly Media book, and
- this Alex Petrov (2019). Database Internals. O'Reilly Media book to learn about designing big data systems.
Finally, please read 
- this C. J. Date (2019). Database Design and Relational Theory: Normal Forms And All That Jazz. Apress book and 
- this C. J. Date (2015). SQL and Relational Theory: How to Write Accurate SQL Code. O'Reilly Media 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, and
- this Jon Duckett (2011). HTML & CSS - Design and Build Websites. John Wiley & Sons book first to get familiar with web application development.
After that please read
- this Stephen Greig (2013). CSS3 - Pushing the Limits. John Wiley & Sons book and
- this Anne Boehm and Zak Ruvalcaba (2018). Murach's HTML5 and CSS3. Mike Murach and Associates book to learn in-depth about HTML and CSS.
JavaScript is the language for web development because it is implemented in most of the web browsers. Please read 
- this David Flanagan (2020). JavaScript: The Definitive Guide. O'Reilly Media book, and 
- this Kyle Simpson (2015). You Don't Know JS. O'Reilly Media book to master it. Strong knowledge of JavaScript will ease your web development learning very much.
Single page application is the default front-end choice for most of new web development projects. 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 that you will have 4 main 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 first and third option, or
- a combination of the first and fourth option.
The first 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 second option is ASP.NET Core. Please read
- Adam Freeman (2020). Pro ASP.NET Core 3: Develop Cloud-Ready Web Applications Using MVC, Blazor, and Razor Pages. Apress book and
- this Andrew Lock (2021). ASP.NET Core in Action. Manning 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 third option is Java world. Please read this Cay S. Horstmann (2019). Core Java. Volume I - Fundamentals. Pearson book first if you are not familiar with Java language.

Then please read 
- this Tim Downey (2021). Guide to Web Development with Java - Understanding Website Creation. Springer book or 
- this Nicholas S. Williams (2014). Professional Java for Web Applications. John Wiley & Sons book.
The 4th option is Node.js 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.
There are also several other options that you may consider. These options include Ruby on Rails and Flask.
If you need 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. John Wiley & Sons book, and
- this Leonard Richardson and Mike Amundsen (2013). RESTful Web APIs. O'Reilly Media book.
After finishing the books please click Topic 8 - Introduction to Mobile Application Development to continue.

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?

Learning about database management systems requires a lot of effort. First you 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 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.

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