Programmes and courses Norsk English
My Application
My Application

Please sign in to view your application

Sign In
  • NorskProgrammes and courses
  • Programmes and individual courses
    • Front page
    • Bachelor programmes
    • Master programmes
    • Exchange programme
    • Summer School at BI
    • Executive Education
    • Courses for companies and organizations
    • PhD
    • Scholarships
    • How to apply
  • Study at BI
    • Front page
    • Why study in Norway?
    • Why choose BI?
    • What can I do with my degree?
    • Life as a student
    • International Students
    • Housing
    • Our campuses
    • Life at BI - Student blog
    • For students
  • Faculty and research
    • Front page
    • Find Department
    • Find Research Centre
    • Centres, groups and other initiatives
    • Find an expert
    • BI Business Review
    • Library
    • Learning Center
  • Business and Alumni
    • Front page
    • BI Alumni
    • Corporate Partner
    • Recruit from BI
    • Webinars and seminars from BI
  • About BI
    • Front page
    • For the press
    • Accreditation and Ranking
    • Sustainability
    • DEIB
    • Vacant positions
    • Guests
    • Erasmus Policy Statement
    • Programme Quality System
-
Excerpt from course description

Data Management and Python Programming

Introduction

Using available data to gain insights and make correct decisions is becoming essential for almost any business in today’s world. This course introduces two of the most popular and indispensable programming languages for data analysts:

  • Python (with focus on data cleaning, processing, analysis and visualization)
  • SQL

In addition, the course also covers the basics of data management with focus on relational databases.

Course content

  • Introduction, installation of Python, Jupyter lab, IDEs.
  • Executing Python code.
  • Variables, basic types, user input and output.
  • Control flow (conditional execution, loops).
  • Organizing code (functions and libraries).
  • Data structures.
  • Strings, reading, writing and processing text files.
  • Vectors and matrices (NumPy), random numbers and the Monte Carlo method.
  • Processing and analyzing tabular data with Pandas (reading, cleaning, manipulating, grouping and aggregating data).
  • Plotting and visualization (Matplotlib, Seaborn).
  • Introduction to relational databases.
  • Structured Query Language (SQL).
  • Relational model.
  • Programming with databases.
  • Indexes.
  • Transactions.

Disclaimer

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.