Management Information Systems (English) | |||||
Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 |
Course Code: | MIS030 | ||||
Course Name: | Big Data Technologies | ||||
Semester: | Spring | ||||
Course Credits: |
|
||||
Language of instruction: | English | ||||
Course Condition: | |||||
Does the Course Require Work Experience?: | No | ||||
Type of course: | Departmental Elective | ||||
Course Level: |
|
||||
Mode of Delivery: | E-Learning | ||||
Course Coordinator: | Doç. Dr. ŞEBNEM ÖZDEMİR | ||||
Course Lecturer(s): | Ahmet Tezcan Tekin | ||||
Course Assistants: |
Course Objectives: | This course aims to introduce students to the basic concepts and techniques that support modern database management systems (DBMS). It deals with different architectures and the applications in which they are used. It aims to teach relational data model, relational database languages and SQL. The course also covers NoSQL databases, MongoDB and Redis for new systems in big data management. At the end of the course, Apache Spark technology for real-time data processing, a very popular approach to big data management, will be covered. |
Course Content: | This course covers Data and Knowledge Management Systems, Database Systems, Relational Database Management Systems, CRUD operations, Procedures and Views in RDBMS, Constraints in RDBMS, Document Based Database Systems, Cache Memory Database System, SPARK Applications. |
The students who have succeeded in this course;
1) Upon successfully completing the course, students understand and apply the scope and contents of Big Data Management in real life. 2) Upon successfully completing the course, students can use current Big Data Management tools utilized in the industry. 3) Upon successfully completing the course, students can Process real-time data. |
Week | Subject | Related Preparation |
1) | Introduction to Database | |
2) | Database Design | |
3) | Structured Query Language (SQL) and Industrial Practices | |
4) | Crud Operations and Industrial Practices | |
5) | SQL Joins and Industrial Practices | |
6) | SQL Constraints and Industrial Practices | |
7) | Procedural Language in RDBMS | |
8) | Midterm Week | |
9) | Document Based Databases and Industrial Applications | |
10) | Document Based Databases and Industrial Applications | |
11) | Advances Practices in Document Based Data Base | |
11) | Not Only Structured Query Language (NoSQL) and Industrial Applications | |
12) | Not Only Structured Query Language (NoSQL) and Industrial Applications | |
13) | Advances Practices in Document Based Data Base | |
14) | Advances Practices in Document Based Data Base | |
15) | Project Presentations | |
16) | Final Week |
Course Notes / Textbooks: | 1. "Big Data: Principles and best practices of scalable real-time data systems" by Nathan Marz and James Warren. 2. "Hadoop: The Definitive Guide" by Tom White. |
References: | 1. "Learning Spark: Lightning-Fast Big Data Analysis" by Holden Karau, Andy Konwinski, Patrick Wendell, and Matei Zaharia. 2. "Programming Hive" by Edward Capriolo, Dean Wampler, and Jason Rutherglen. |
Course Learning Outcomes | 1 |
2 |
3 |
||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Program Outcomes | |||||||||||||
1) It has a wide range of interdisciplinary approaches to management information systems, primarily business and computer engineering. | 3 | 3 | 3 | ||||||||||
2) Comprehends the management information systems in terms of technical, organizational and managerial aspects and uses the current programming language by knowing the logic of programming. | 3 | 3 | 3 | ||||||||||
3) Uses different information technologies and systems for understanding and solving various business problems. | 3 | 3 | 3 | ||||||||||
4) Interpret the data, concepts and ideas in the field of management information systems with scientific and technological methods. | 2 | 2 | 3 | ||||||||||
5) Analyze the needs for an information system and analyze the processes of analysis, design and implementation of the database. | 2 | 2 | 2 | ||||||||||
6) Gains technical and managerial contributions to IT projects and takes responsibility. | 2 | 2 | 2 | ||||||||||
7) Solve complex business and informatics problems by using various statistical techniques and numerical methods and make analyzes using statistical programs effectively. | |||||||||||||
8) Uses a foreign language at the B1 General Level in terms of European Language Portfolio criteria according to the level of education. | |||||||||||||
9) Develops teamwork, negotiation, leadership and entrepreneurship skills. | 1 | 1 | 1 | ||||||||||
10) Has universal ethical values, social responsibility awareness and sufficient legal knowledge. | |||||||||||||
11) Develops positive attitudes related to lifelong learning and identifies individual learning needs and carries out studies to correct them. | |||||||||||||
12) Students will be able to communicate their ideas and solutions both written and orally, and present and publish them on both national and international platforms. | 1 | 1 | 1 | ||||||||||
13) It uses information and communication technologies together with computer software at the advanced level of European Computer Driving License required by the field. | 3 | 3 | 3 |
No Effect | 1 Lowest | 2 Average | 3 Highest |
Program Outcomes | Level of Contribution | |
1) | It has a wide range of interdisciplinary approaches to management information systems, primarily business and computer engineering. | 3 |
2) | Comprehends the management information systems in terms of technical, organizational and managerial aspects and uses the current programming language by knowing the logic of programming. | 3 |
3) | Uses different information technologies and systems for understanding and solving various business problems. | 3 |
4) | Interpret the data, concepts and ideas in the field of management information systems with scientific and technological methods. | 3 |
5) | Analyze the needs for an information system and analyze the processes of analysis, design and implementation of the database. | 3 |
6) | Gains technical and managerial contributions to IT projects and takes responsibility. | 2 |
7) | Solve complex business and informatics problems by using various statistical techniques and numerical methods and make analyzes using statistical programs effectively. | 2 |
8) | Uses a foreign language at the B1 General Level in terms of European Language Portfolio criteria according to the level of education. | 2 |
9) | Develops teamwork, negotiation, leadership and entrepreneurship skills. | 1 |
10) | Has universal ethical values, social responsibility awareness and sufficient legal knowledge. | 2 |
11) | Develops positive attitudes related to lifelong learning and identifies individual learning needs and carries out studies to correct them. | 1 |
12) | Students will be able to communicate their ideas and solutions both written and orally, and present and publish them on both national and international platforms. | 2 |
13) | It uses information and communication technologies together with computer software at the advanced level of European Computer Driving License required by the field. | 3 |
Semester Requirements | Number of Activities | Level of Contribution |
Quizzes | 4 | % 5 |
Homework Assignments | 3 | % 10 |
Project | 1 | % 20 |
Midterms | 1 | % 25 |
Final | 1 | % 40 |
total | % 100 | |
PERCENTAGE OF SEMESTER WORK | % 60 | |
PERCENTAGE OF FINAL WORK | % 40 | |
total | % 100 |
Activities | Number of Activities | Preparation for the Activity | Spent for the Activity Itself | Completing the Activity Requirements | Workload | ||
Course Hours | 14 | 0 | 2 | 28 | |||
Presentations / Seminar | 1 | 4 | 1 | 5 | |||
Project | 1 | 12 | 1 | 13 | |||
Homework Assignments | 3 | 10 | 30 | ||||
Quizzes | 4 | 0 | 4 | 16 | |||
Midterms | 1 | 10 | 1 | 11 | |||
Final | 1 | 15 | 1 | 16 | |||
Total Workload | 119 |