Topic outline

• 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?

  
  

  

  
  

  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)

  
  
  

  • 

    Watch the video Relational Database Concepts! URL

    Not available unless: You are a(n) Student
  • 

    Read slides Relational Database Concepts! File

    PDF document

    Not available unless: You are a(n) Student
  • 

    Watch Esko Penttinen's views on the importance and potential of XBRL! URL

    Not available unless: You are a(n) Student
  • 

    Watch the video SQL Basics! URL

    Not available unless: You are a(n) Student
  • 

    Read slides SQL Basics! File

    PDF document

    Not available unless: You are a(n) Student
  • 

    DataCamp Instructions File

    PDF document
  • 

    INDIVIDUAL: DataCamp Assignment: Introduction to SQL (Due: Friday, 14 April 2023, 11:59 PM)

    Not available unless: You are a(n) Student
  • 

    INDIVIDUAL: DataCamp Assignment: Intermediate SQL (Due: Friday, 14 April 2023, 11:59 PM)

    Not available unless: You are a(n) Student
  • 

    INDIVIDUAL: DataCamp Assignment: Joining Data in SQL (Due: Friday, 14 April 2023, 11:59 PM)

    Not available unless: You are a(n) Student