DotNetNuke uses SQL as one of its core technologies. The database stores all of the information for the site and this allows DotNetNuke to function as a true content management system. Rather than having to make changes to individual pages, changes are made to the database and the site is served up to the user based on what is stored in the database.
You can compare DNN CMS to other content management systems (such as Wordpress) here or you can view a cost-benefit analysis of DNN here.
Instead of having to work with a webpage where security is a constant headache, the DotNetNuke SQL database provides a very structured and flexible way to control access to the various pages and other content that make up the site.
Why is the Database Necessary?
Without the database, there is no DotNetNuke. DotNetNuke takes all of the information that goes into the site from the database tables and therein lays the heart of what it has to offer.
Without the database, there is no DotNetNuke. DotNetNuke takes all of the information that goes into the site from the database tables and therein lays the heart of what it has to offer. This allows features such as granular control over security and the ability to update the site on the fly, without having to upload new pages every time a change is made.
Understanding the DotNetNuke SQL Database
If your responsibilities end at getting the basic site up and running, you won't need to know that much about SQL to get a DotNetNuke site going. You'll have to install SQL on your server and create an empty database to house the site. One of the advantages of the DotNetNuke SQL system is that one can create many different sites very quickly in this way.
Quite frequently, people run into problems when permissions come into play. To properly install DotNetNuke, the DotNetNuke database has to be installed on the root of the server. If the installation isn't done in this way, the administrator will not have the proper access they need to make all the changes to the site. Make certain that you have this level of control when you sign up for your web host.
DotNetNuke SQL databases are like any other SQL databases. Information is stored in an organizational system based on columns and rows and the ability to change that information and the structure of the database is strictly controlled by the administrator. When you change the data in one of the SQL containers, the data that appears on the webpage that DotNetNuke creates for the user will change, as well. This and the incredible search features of the SQL database are among the reasons this system is so popular with very dynamic sites that have constantly updated information.
DotNetNuke is a great platform with which to build your web presence.