A hands-on introduction to using SQL-databases will be given. Throughout the course, we use dynamic web-pages as an example application, which allows us to work through data extraction from databases, data input from webpages, as well as how to present data from databases through online pages showing key numbers and graphs. A blended learning-by-doing approach will be taken throughout the course. While the course will use web analytics as an application, this is more of an example application, and though this application is of practical importance in itself, the course focus is more general: The course aims at being a general introduction to applied work with databases, illustrated through a simple application-field. This means that for example web-page design will be kept to an extreme minimum, and the technical focus will be instead on themes that are of general value in the industry.
- An introduction to SQL
- The basics of dynamic and user-specific web-pages, implemented using Python and SQL.
- Basic SQL usage of specific importance for web-pages: user databases, page information, collecting usage statistics, and in general dynamic content generation.
- Collecting data from web surveys, including usage statistics and similar information.
- Learn to create online presentations with key numbers and graphs.
This is an excerpt from the complete course description for the course. If you are an active student at BI, you can find the complete course descriptions with information on eg. learning goals, learning process, curriculum and exam at portal.bi.no. We reserve the right to make changes to this description.