Building WEB sites
You will build your website for a long period. It is wise to consider all aspects of your website ownership like website creation, hosting and maintenance.
Do all you can to have a responsive website, today all websites should be created for mobile devices (phone, tablet, notebook, desktop). The mobile browsing is used more and more every single day. Check Bootstrap and Material Design for responsive design CSS.
There are a lot of solutions to create and deliver web pages based on dynamic pages, static pages or both.
Generally a dynamic page is used when part of the content is stored into a database or another data source and the page content is changed by updating the data source. Dynamic pages are generally managed by a CMS (Content Management System), the most used CMS is Wordpress (https://wordpress.com/).
Static pages are created by a variety of applications starting with a simple text editor to complex dedicated web builders. When a WEB builder application is used, the static pages option can be easy to maintain (...).
If you have the time a good choice is to use a web design
company to create a state-of-the-art website for you. On the other hand
if you have a short time to delivery or a short time to apply changes in to the future it is better to use a CMS or a web builder at choice.
The vast majority of today CMS's are using SQL databases like MySQL. While SQL's are great as database servers for ERP's and other company systems, please keep in mind that DO NOT scale up easily and your total cost will increase exponentially with your page requests per second.
Scalability should be considered any time you have a website that can have success respectively have a lot of page views in a time frame. A decent blog built using MySQL should be proper hosted to have an acceptable minimum read access per second to the database, otherwise when you will write your good article it will crush your server just because it was shared on Facebook and read by too many. When you get a shared hosting you will get a shared database server also, that means you will have very limited access to your databases (few reads/write per second). A full SQL server running on an average computer is limited to few hundreds (generally less than 300) concurrent client access for read/write operations. One web page load may need several database accesses depending on used CMS.
An alternative for SQL's are NO SQL's databases like MongoDb. From the start NO SQL's offers a faster response having a less complicated architecture than SQL's and that's good for web pages and web applications in general.
Do not mess with scalability, if it is not considered from the start it will cost you several times more later.