Web Systems Fundamentals and Databases, 11 credits

Main field of study with advanced study

Computer Systems Administration 7,5 credits and Programming 7,5 credits. English 6.

The course is included in IT Forensics and Information Security 180 credits.

The aim of the course is for students to develop the knowledge and skills essential to modern web development, including database concepts and practices crucial for database-driven web development.

Following successful completion of the course the student should be able to:

Knowledge and understanding

• Describe the fundamental concepts and principles in web development and database-driven web development

Skills and ability

• Design, construct and deploy simple static and dynamic web applications using HTML5, CSS3, JavaScript, and a LAMP stack (that is, Linux, Apache, MySQL, and PHP)
• Apply the principles of relational databases to design simple databases and use SQL to define and manipulate data
• Write and execute SQL queries in a relational database to create dynamic content in a web system

Judgement and approach

• Reflect on the different perspectives and expertise required in modern web development
• Reflect on the integration of the databases management systems into the Web environment
• Reflect on the evolving nature of web technologies and how this affects the required knowledge and skills of web developers

The World Wide Web provides a platform for producing, searching, consuming, and sharing information. In the Web, web pages are dynamically generated using various technologies and remotely accessible via the Internet. In practice, web development requires different expertise.

The course introduces different topics required for modern web development and database-driven web development. Initially, the course introduces the field of database systems and the concepts behind the relational model. The course also presents data definition and manipulation using SQL. Later in the course, the course introduces and covers web development, which concerns how web systems work and the foundational knowledge required for the client- and server-side development.

The teaching consists of lectures, supervised laboratory exercises, and project work.

The assessment tasks include written and oral presentation of a web development project, laboratory exercises, and two written exams.

If there are special reasons, the examiner may make exceptions from the specified examination format and allow a student to be examined in another way. Special reasons can e.g. be study support for students with disabilities.

Course evaluation is part of the course. This evaluation offers guidance in the future development and planning of the course. Course evaluation is documented and made available to the students.