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 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 get this "Semmy Purewal (2014). Learning Web App Development" book and read it first.
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" book.
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 "Bruno Joseph D'mello et al. (2017). Web Development with MongoDB and Node" book. A note is that the accompanied source code of this book is not perfect and up-to-date. Please refer to the official tools and modules documentation for fixing the issues.
After finishing these books if you want to create sophisticated interactive web applications please read this "Kyle Simpson (2015). You Don't Know JS" book.

If you want to create a single-page application (SPA) please read this "Kirupa Chinnathambi (2018). Learning React. Addison-Wesley Professional" 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.

 

Topic 6 – Introduction to Relational Database Management Systems

Why do I need to learn about relational 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 applications like airlines and railways, banking, education, telecommunications, digital libraries and digital publishing, finance, sales, health care information systems, etc.

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 a database management system under a user's point of view.

Please get this "Ignatius Fernandez (2015). Beginning Oracle Database 12c Administration: From Novice to Professional" book and read it.

Alternatively, please get this "Adam Jorgensen et al. (2012). Microsoft SQL Server 2012 Bible" book and read it.
After finishing the books please click Topic 7 - Introduction to Web Application Development to continue.