Information Technologies (English) (Thesis) | |||||
Master | Length of the Programme: 2 | Number of Credits: 120 | TR-NQF-HE: Level 7 | QF-EHEA: Second Cycle | EQF: Level 7 |
School/Faculty/Institute | Graduate School | ||||
Course Code | ITC 505 | ||||
Course Title in English | Big Data Analytics and Management | ||||
Course Title in Turkish | Big Data Analytics and Management | ||||
Language of Instruction | EN | ||||
Type of Course | Exercise,Flipped Classroom,Lecture | ||||
Level of Course | Intermediate | ||||
Semester | Fall | ||||
Contact Hours per Week |
|
||||
Estimated Student Workload | 174 hours per semester | ||||
Number of Credits | 7.5 ECTS | ||||
Grading Mode | Standard Letter Grade | ||||
Pre-requisites | None | ||||
Expected Prior Knowledge | Querying on RDBMS systems | ||||
Co-requisites | None | ||||
Registration Restrictions | Only Graduate Students | ||||
Overall Educational Objective | To learn the basic designing relational database and big data systems. | ||||
Course Description | Big Data Analysis is the hot topic job nowadays. But it’s a big problem too. In this lesson’s aim is how to query on RDBMS and big data ecosystems products, designing modern edition data warehouses and managing massively parallel processing data warehouse technologies on cloud platforms. We will start to ask a few questions: What’s the problem of data world. What’s the technologies? Why does this technology exist and why do I need it? How can I get the best out of it utilizing something familiar like SQL. How can I design and query on RDBMS system, Hadoop ecosystem products like Pig Latin, Hive, Spark etc. and MPP products like Azure SQL DW, AWS Redshift, Azure Stream Analytics, Big Data Lake Analytics etc. | ||||
Course Description in Turkish | Bu ders büyük veri analizine giriş olarak tasarlanmıştır. Günümüzde gittikçe önem kazanan ve aynı zamanda bir problem olarak karşımıza çıkan büyük veri yapılarının tasarlanması ve üzerinde çalışılması hedeflenmektedir. Derse bir kaç soru ile başlayacağız. Gerçek dünyanın veri dünyasındaki problemleri nelerdir ve bu problemler için hangi teknolojiler mevcuttur. Hangi problemde hangi teknolojileri ve muadillerini kullanmalıyız. Veritabanı ve büyük veri ekosistemindeki ürünlerin tasarlanması ve sorgulanması için gerekli programlama dillerinin öğrenilmesi ve ürünlerin kurulumlarının gerçekleştirilerek üzerinde gerçek dünya ile ilgili problemlerin çözümlerinin sunulması. |
Course Learning Outcomes and CompetencesUpon successful completion of the course, the learner is expected to be able to:1) Design and querying OLTP Systems, some of NoSQL Products and Hadoop products. 2) Selecting the right products (compare other products) to related with problems 3) Designing of modern data warehouse architecture 4) Execution on real world problems and data systems |
Program Learning Outcomes/Course Learning Outcomes | 1 | 2 | 3 | 4 |
---|---|---|---|---|
1) An ability to develop and deepen their knowledge in the field of Information Technologies at the level of expertise based on their undergraduate level qualifications. | ||||
2) An ability to apply scientific and practical knowledge in statistics, computing and computer science. | ||||
3) A Comprehensive knowledge of analysis and modeling methods and their limitations. | ||||
4) An ability to design and apply analytical, modeling and experimental H 2 based researches, analyzes and interprets complex situations encountered in this process. | ||||
5) An ability to transmit the process and results of the work of information systems systematically and clearly in written and oral form in national and international environments. | ||||
6) An understanding of data collection, processing, use, interpretation and social, scientific and ethical values in all professional and professional activities. | ||||
7) An ability to take a leadership position in multi-disciplinary teams, develop information-based solution approaches in complex situations and to take responsibility. | ||||
8) An understanding of the impact of engineering solutions in a global, economic, environmental, and societal context. | ||||
9) An ability to communicate verbally and in writing in English at least at the level of B2 of CEFR. | ||||
10) An understanding the social and environmental aspects of IT applications. |
N None | S Supportive | H Highly Related |
Program Outcomes and Competences | Level | Assessed by | |
1) | An ability to develop and deepen their knowledge in the field of Information Technologies at the level of expertise based on their undergraduate level qualifications. | N | |
2) | An ability to apply scientific and practical knowledge in statistics, computing and computer science. | N | |
3) | A Comprehensive knowledge of analysis and modeling methods and their limitations. | N | |
4) | An ability to design and apply analytical, modeling and experimental H 2 based researches, analyzes and interprets complex situations encountered in this process. | N | |
5) | An ability to transmit the process and results of the work of information systems systematically and clearly in written and oral form in national and international environments. | N | |
6) | An understanding of data collection, processing, use, interpretation and social, scientific and ethical values in all professional and professional activities. | N | |
7) | An ability to take a leadership position in multi-disciplinary teams, develop information-based solution approaches in complex situations and to take responsibility. | N | |
8) | An understanding of the impact of engineering solutions in a global, economic, environmental, and societal context. | N | |
9) | An ability to communicate verbally and in writing in English at least at the level of B2 of CEFR. | N | |
10) | An understanding the social and environmental aspects of IT applications. | N |
Prepared by and Date | , |
Course Coordinator | İLKER BEKMEZCİ |
Semester | Fall |
Name of Instructor | Prof. Dr. İLKER BEKMEZCİ |
Week | Subject |
1) | 1. History of Data 2. Vendors of Big Data |
2) | Data Warehousing and Business Intelligence Insights |
3) | Designing & Querying on OLTP Systems |
4) | Designing ETL Layer |
5) | Sql On Hadoop |
6) | Real Time Analytics |
7) | Working with Unstructured Data |
8) | Massively Parallel Processing Products |
9) | Massively Parallel Processing Products |
10) | Data Visualization |
11) | Advanced Analytics |
12) | Advanced Analytics |
13) | Big Data Lake Analytics |
14) | Big Data Lake Analytics |
15) | Final Examination Period |
16) | Final Examination Period |
Required/Recommended Readings | None | ||||||||||||||||||
Teaching Methods | Classroom/Exercise/Online Courses | ||||||||||||||||||
Homework and Projects | Students are required to complete a portfolio to be able to enter the final exam | ||||||||||||||||||
Laboratory Work | None | ||||||||||||||||||
Computer Use | Required | ||||||||||||||||||
Other Activities | None | ||||||||||||||||||
Assessment Methods |
|
||||||||||||||||||
Course Administration |
|
Activity | No/Weeks | Hours | Calculation | ||||
No/Weeks per Semester | Preparing for the Activity | Spent in the Activity Itself | Completing the Activity Requirements | ||||
Course Hours | 14 | 2 | 1.5 | 49 | |||
Laboratory | 14 | 2 | 1.5 | 49 | |||
Homework Assignments | 9 | 2 | 1 | 27 | |||
Midterm(s) | 1 | 30 | 30 | ||||
Final Examination | 1 | 30 | 3 | 33 | |||
Total Workload | 188 | ||||||
Total Workload/25 | 7.5 | ||||||
ECTS | 7.5 |