Generally no, you need some sort of server side technology with some kind of database to make your side dynamic. Some times it can be complicated and require more advanced inside into how databases work and how to store and retrieve data. So to make your website dynamic you need a database and there is no way around it, adding jQuery to you site doesn't make it dynamic. If it sounds to complicated, don't worry, magicedit has you covered. With magicedt you don't have to worry about any of this stuff. By using some simple html tags you can add dynamic capability to your site.
So with magicedit, it's yes, you can build a dynamic website with only html and css as your tools.