YTSP0200 Data Modelling and Back-end Development
General information
Name | Data Modelling and Back-end Development |
Code | YTSP0200 |
Target Group | Masters's Degree |
Number of ECTS Credits | 5 ECTS |
Language | English |
Prerequisites | Basics of databases, prior working knowledge of HTML, CSS and JavaScript |
Grading | 0-5 |
Communication | Dedicated Microsoft Teams channel: DM and Backend development - General |
Lecturer | Huotari Jouni, Manninen Pasi |
firstname.lastname@jamk.fi |
Introduction
Welcome to the Data Modelling and Back-end Development course! The first focus of the course is to learn data modelling whether you are using relational databases (such as MySQL or PostgreSQL) or NoSQL databases (such as MongoDB or Redis). The second (and main) focus is to learn the basics of building simple back-end applications using Node.js with Express.
Personal and group guidance
Remember that you don't need to study alone even this course is mostly done remotely. We have group meetings at Teams and you can discuss with other students or teacher then. This way we can discuss one on one about any issues you might face during the course or you can try to find help from other students.
Friday 12.01.2024 at 14.30
The course starts on January 12th, 2024 at 14.30 EET. To attend physically, come to the Dynamo building (Piippukatu 2, Jyväskylä - to computer lab D330). To attend remotely, come to Teams.
The first day is important for many reasons:
- If you are not participating in the first lecture, you are marked as a not-attending student
- We introduce the course and the assignments
- The only data modelling lecture (by Jouni) takes place and you can show your skills in data modelling and pass that part
Fridays 19.01.2024 - 26.04.2024 14:30-17:00 (except weeks 8 and 9)
Pasi Manninen takes care of the back-end development part. Join Live Meetings in the following Teams channel YTSP0200 - DM and Backend development - General.
Course contents
Data modelling
Use the book mentioned below and search topics such as "Data modeling"; you will find e.g. Data Modeling Made Simple: A Practical Guide for Business and IT Professionals. It contains "Data Model Scorecard" which can and will be used for evaluating your data models.
Data modelling
- Skillsoft Books ITPro (formerly Books24x7)
- Please check also the course Advanced databases provided by Jouni Huotari
Backend programming with JavaScript
This course materials mainly focuses on the frameworks and libraries used for developing applications for backend using JavaScript. Prior knowledge of JavaScript is highly recommended. You can find all the course materials from left side menu.
If you are completely new to JavaScript then you might want to consider checking out below tutorials from internet.
Learn JavaScript
- The Modern JavaScript Tutorial
- JavaScript for impatient programmers
- Mozilla / JavaScript
- 33 Concepts Every JavaScript Developer Should Know
- Official documentation of Node.js
- Express
- MongoDB - Guides
- JavaScript Fundamentals 2018 ES6 for beginners -course at Udemy
- Open full stack course containing basics of JavaScript
Learning outcomes of the course from Peppi: Student is able to design, document and implement a database, server-side software, and related application programming interface for a scalable application.
Course contents:
- Advanced data modelling
- Backend architecture
- Backend frameworks
- Server side programming languages
- Scalability
- Application programming interfaces and integration
- Security settings and hack prevents
Student workload
- Weekly guidances: 24 h
- Assignments and exercises: 80 h
- Presentation and code review in a seminar: 1 h
- Independent studies: 25 h
- Total: 135 h
Assessments
To pass the course, you must complete the course assignments:
- Data modelling assignment (this will be given during the first lecture)
- Back-end development assignment