Skip to main content
MyCourses MyCourses
  • Schools
    School of Arts, Design, and Architecture (ARTS) School of Business (BIZ) School of Chemical Engineering (CHEM) –sGuides for students (CHEM) – Instructions for report writing (CHEM) School of Electrical Engineering (ELEC) School of Engineering (ENG) School of Science (SCI) Language Centre Open University Library Aalto university pedagogical training program UNI (exams) Sandbox
  • Service Links
    MyCourses - MyCourses instructions for Teachers - MyCourses instructions for Students - Teacher book your online session with a specialist - Digital tools for teaching - Personal data protection instructions for teachers - Workspace for thesis supervision Sisu Student guide Courses.aalto.fi Library Services - Resourcesguides - Imagoa / Open science and images IT Services Campus maps - Search spaces and see opening hours Restaurants in Otaniemi ASU Aalto Student Union Aalto Marketplace
  • ALLWELL?
    Study Skills Guidance and support for students Starting Point of Wellbeing About AllWell? study well-being questionnaire
  •   ‎(en)‎
      ‎(en)‎   ‎(fi)‎   ‎(sv)‎
  • Toggle Search menu
  • Hi guest! (Log in)

close

Can not find the course?
try also:

  • Sisu
  • Courses.aalto.fi

ABL-C1102 - Hands-On Analytics on Accounting Information Systems, Lecture, 1.3.2023-19.4.2023

This course space end date is set to 19.04.2023 Search Courses: ABL-C1102

  1. Home
  2. Courses
  3. School of Business
  4. department of...
  5. abl-c1102 - h...
  6. Sections
  7. module: sql &...
 
Syllabus
 

Module: SQL & Database Management

  • Module: SQL & Database Management

    Module: SQL & Database Management

    THE Three COURSES - Introduction to SQL, Intermediate SQL and Joining Data in SQL need to be completed in a specific order.

    You need to start with the Introduction to SQL, then move to the Intermediate SQL and then to Joining Data in SQL. 

    This module focuses on providing you with an understanding of database management. First, you will delve into the concepts of relational databases, which provide a crucial foundation for most of the modern integrated AISs. Second, you will learn about XBRL, and its potential in accounting. Third, this module will introduce you to the basics of SQL (Structured Query Language) and some advanced functions. After providing you with the conceptual foundations of SQL, you will get to set your skills as a Data Scientist into practice running SQL yourself in the SQL Practice Assignment! In fact, SQL is rated among the most essential skills among Data Scientists and a host of business job openings require a foundational level SQL knowledge. As such, now is your time to develop your skills from the overall themes of database management to mastering practical means to create tables as well as retrieve and manipulate data in databases using SQL!

    After studying this module, you will be able to:

    • Explain relational databases and relational database management systems (RDBMS) on a profound level
    • Describe XBRL, its potential, and applications
    • Discuss SQL basics and its applications 
    • Understand and run basic and some advanced SQL in practice


    To monitor your progress using the completion bar, be sure to perform and check off all activity items at the bottom of this section. The instructors will not monitor your activity completion status but strongly encourage you to keep track to successfully complete this course.

    DataCamp Assignments (35p): Introduction to SQL (7p), Intermediate SQL (14p), 

    Joining Data in SQL (14p)

    The SQL Practice Assignment will be completed using DataCamp, which is an interactive learning platform that teaches topics related to data science. This assignment entails completing the courses "Introduction to SQL" (2h), Intermediate SQL (4h), and Joining Data on SQL (4h). The courses provide you the opportunity to learn SQL in practice by completing quizzes and assignments as a part of the 10 hour course grouping/module. You don't have to install anything, but an Internet connection is required to do assignments on DataCamp.
    We strongly encourage you to start completing this course parallel to Modules II-VI to get the most out of your learning. These SQL Practice Assignments will contribute 35 points towards your overall grade.


    What is DataCamp?


    DataCamp_image


    Hands-On Analytics on Accounting Information Systems -course makes use of DataCamp to provide you an opportunity to extend your learning into practice and gain hands-on experience using SQL. This course has set up a digital AIS course area where you can find the DataCamp assignment -- I will invite you to the course area personally at your course registered mail.

    DataCamp is a beginner-friendly online interactive training and education platform. It's used by companies, universities, and governmental organizations worldwide to help employees and students learn basic data science skills. For the AIS -course, DataCamp provides an interactive, browser-based environment wherein students get instant feedback as they learn SQL in practice.

    DataCamp offers 350+ self-paced courses in SQL, as well as Python and R, through a combination of short expert videos, slideshows, and hands-on-the-keyboard exercises on topics such as importing data, data visualization, and machine learning.


    Signing Up, Progress, and Certificates:

    Please read the DataCamp instructions before starting the DataCamp Assignment: Introduction to SQL -course. 


    Additional Resources:


    Signing up for a new DataCamp Account


    Course progress and XP points: An Overview


    Statements of Accomplishment


    Frequently Asked Questions in Help (A little bit old link, but could be useful)



    • Restricted Not available unless: You are a(n) Student
      Watch the video Relational Database Concepts! URL
    • Restricted Not available unless: You are a(n) Student
      Read slides Relational Database Concepts! File
      PDF document
    • Restricted Not available unless: You are a(n) Student
      Watch Esko Penttinen's views on the importance and potential of XBRL! URL
    • Restricted Not available unless: You are a(n) Student
      Watch the video SQL Basics! URL
    • Restricted Not available unless: You are a(n) Student
      Read slides SQL Basics! File
      PDF document
    • icon for activity
      FileDataCamp Instructions File
      PDF document
    • Restricted Not available unless: You are a(n) Student
      INDIVIDUAL: DataCamp Assignment: Introduction to SQL (Due: Friday, 14 April 2023, 11:59 PM)
    • Restricted Not available unless: You are a(n) Student
      INDIVIDUAL: DataCamp Assignment: Intermediate SQL (Due: Friday, 14 April 2023, 11:59 PM)
    • Restricted Not available unless: You are a(n) Student
      INDIVIDUAL: DataCamp Assignment: Joining Data in SQL (Due: Friday, 14 April 2023, 11:59 PM)

Previous section

◄Choose your Team

Next section

REEXAM May 29, 2023 (1600-1900) Helsinki Time►
Skip Upcoming events
Upcoming events
Loading
Site event MyCourses maintenance, service out of use
Monday, 12 June, 10:00 » 17:00

Go to calendar...
  • ABL-C1102 - Hands-On Analytics on Accounting Information Systems, Lecture, 1.3.2023-19.4.2023
  • Sections
  • Welcome to HOAOAIS 2023
  • Choose your Team
  • Module: SQL & Database Management
  • REEXAM May 29, 2023 (1600-1900) Helsinki Time
  • Home
  • Calendar
  • Learner Metrics

Aalto logo

Tuki / Support
Opiskelijoille / Students
  • MyCourses instructions for students
  • email: mycourses(at)aalto.fi
Opettajille / Teachers
  • MyCourses help
  • MyTeaching Support form
Palvelusta
  • MyCourses rekisteriseloste
  • Tietosuojailmoitus
  • Palvelukuvaus
  • Saavutettavuusseloste
About service
  • MyCourses protection of privacy
  • Privacy notice
  • Service description
  • Accessibility summary
Service
  • MyCourses registerbeskrivining
  • Dataskyddsmeddelande
  • Beskrivining av tjänsten
  • Sammanfattning av tillgängligheten

Hi guest! (Log in)
  • Schools
    • School of Arts, Design, and Architecture (ARTS)
    • School of Business (BIZ)
    • School of Chemical Engineering (CHEM)
    • –sGuides for students (CHEM)
    • – Instructions for report writing (CHEM)
    • School of Electrical Engineering (ELEC)
    • School of Engineering (ENG)
    • School of Science (SCI)
    • Language Centre
    • Open University
    • Library
    • Aalto university pedagogical training program
    • UNI (exams)
    • Sandbox
  • Service Links
    • MyCourses
    • - MyCourses instructions for Teachers
    • - MyCourses instructions for Students
    • - Teacher book your online session with a specialist
    • - Digital tools for teaching
    • - Personal data protection instructions for teachers
    • - Workspace for thesis supervision
    • Sisu
    • Student guide
    • Courses.aalto.fi
    • Library Services
    • - Resourcesguides
    • - Imagoa / Open science and images
    • IT Services
    • Campus maps
    • - Search spaces and see opening hours
    • Restaurants in Otaniemi
    • ASU Aalto Student Union
    • Aalto Marketplace
  • ALLWELL?
    • Study Skills
    • Guidance and support for students
    • Starting Point of Wellbeing
    • About AllWell? study well-being questionnaire
  •   ‎(en)‎
    •   ‎(en)‎
    •   ‎(fi)‎
    •   ‎(sv)‎