DatabasesLaajuus (5 cr)
Code: DA00EK57
Credits
5 op
Teaching language
- Finnish
Objective
You can describe a relational database.
You can collect data from business databases for analyzing with SQL-language.
You know the basics of the data warehouse.
Content
How to use databases?
How to collect data from business databases with SQL-language?
How to take advantage of data warehouse in business intelligence?
Enrollment
08.04.2024 - 21.04.2024
Timing
02.09.2024 - 31.12.2024
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Distance learning
Unit
Liiketalouden koulutusyksikkö
Campus
Ecampus
Teaching languages
- Finnish
Seats
20 - 60
Degree programmes
- Degree Programme in Data Analytics
Teachers
- Väinö Toots
Teacher in charge
Väinö Toots
Groups
-
DAKV23SVData analytics, online studies
Objective
You can describe a relational database.
You can collect data from business databases for analyzing with SQL-language.
You know the basics of the data warehouse.
Content
How to use databases?
How to collect data from business databases with SQL-language?
How to take advantage of data warehouse in business intelligence?
Opiskelumateriaali
Azure SQL database (SQL Server) is used on the course for practicing database queries. The connection is established and queries are made using Azure Data Studio software. Each student will have own login to the database
Yksilölliset oppimisväylät
Individual learning tracks can be discussed with the lecturer
TKI ja työelämäyhteistyö
Collaboration with Dataamo-projects database
Opiskelijan työmäärä
1 credit = 27 hours of work
Evaluation scale
1-5
Assessment methods and criteria
Evaluation is based on graded assignments
Enrollment
06.04.2023 - 21.04.2023
Timing
04.09.2023 - 31.12.2023
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Distance learning
Unit
Liiketalouden koulutusyksikkö
Campus
Kouvola Campus
Teaching languages
- Finnish
Seats
20 - 60
Degree programmes
- Degree Programme in Data Analytics
Teachers
- Väinö Toots
Groups
-
DAKV22SMData analytics, part-time
Objective
You can describe a relational database.
You can collect data from business databases for analyzing with SQL-language.
You know the basics of the data warehouse.
Content
How to use databases?
How to collect data from business databases with SQL-language?
How to take advantage of data warehouse in business intelligence?
Opiskelumateriaali
Kurssilla käytetään Azure SQL -tietokantaa. Kannan hallintaan ja kyselyihin käytetään Azure Data Studio ohjelmaa. Kurssi suoritetaan kokonaan verkossa
Lisäksi käytetään sähköisiä opetusmateriaaleja.
Yksilölliset oppimisväylät
Individual learning tracks can be discussed with the lecturer
TKI ja työelämäyhteistyö
Yhteistyö Dataamo-hankkeen IPR-Suomi tietokannan kanssa.
Opiskelijan työmäärä
1 op = 27 tuntia työtä
Assessment methods and criteria
Kurssin arviointi tapahtuu annettujen tehtävien perusteella
Enrollment
06.04.2022 - 22.04.2022
Timing
29.08.2022 - 31.12.2022
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Liiketalouden koulutusyksikkö
Campus
Kouvola Campus
Teaching languages
- Finnish
Seats
20 - 40
Degree programmes
- Degree Programme in Data Analytics
Teachers
- Väinö Toots
Groups
-
DAKV21SPData-analytics, full-time studies
Objective
You can describe a relational database.
You can collect data from business databases for analyzing with SQL-language.
You know the basics of the data warehouse.
Content
How to use databases?
How to collect data from business databases with SQL-language?
How to take advantage of data warehouse in business intelligence?
Opiskelumateriaali
Web materials
Yksilölliset oppimisväylät
Individual learning tracks can be discussed about with the lecturer
TKI ja työelämäyhteistyö
The course may have assignments made for companies or assignments agreed individually with students.
Opiskelijan työmäärä
1 cr = 27 hours work
Toteutuksen osien kuvaus
Kurssilla opetellaan tietokantojen perusteita sekä SQL-kyselykieltä.
SQL-kielessä kurssi kattaa peruskomennot, laskemisen kyselyssä, ryhmittelyn, usean taulun kyselyt sekä alikyselyt.
Evaluation scale
1-5
Assessment methods and criteria
Evaluation according given exercises and projects.