Course Information

Course Name	Turkish	Bilgi Yönetimi ve Teknolojisi
	English	Data Management and Technologies
Course Code	MHN 503	Credit	Lecture (hour/week)	Recitation (hour/week)	Laboratory (hour/week)
Semester	-	3	3	-	-
Course Language		Turkish
Course Coordinator		Mehmet Yasin Ulukuş
Course Objectives		1. Learn how to create a database from scratch 2. Learn how to code in SQL 3. Use SQL to perform data analysis 4. Learn the basics of NoSQL 5. Use MongoDB to create databases 6. Learn methods to analyze data with Power BI and gain insights 7. Learn to create Data Models and use the DAX Formula language 8. Learn ways to visualize data using Power BI
Course Description		This course introduces the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. It also allows working with large data sets in a data warehouse environment to create dashboards and introduces a variety of business intelligence solutions.
Course Outcomes		1. Create, design, and operate with SQL databases 2. Write complex SQL queries across multiple tables 3. Create, design, and operate with MongoDB 4. Create reports and dashboards with Microsoft PowerBI 5. Write advanced Dax calculations in Microsoft Power BI
Pre-requisite(s)
Required Facilities
Other
Textbook
Other References