INDR 481 • Midterm + Final • Information Systems
833 TL a month, 3 instalments at no extra cost
Instructor

Ertuğrul Altun
BSCS
Marmara Üniversitesi Bilgisayar Bilimi ve Mühendisliği bölümünden 2019 yılında mezun oldum. C/C++, Java, JavaScript ve TypeScript dillerinde ileri seviye programlama yapıyorum. 2020 yılından beri Software Engineer olarak bir özel şirkette çalışmaktayım. Okuduğum süre içerisinde ve sonrasında Bilgisayar Mühendisliği alanında çeşitli konularda özel ders verdim.
Topics
Introduction to Information Systems, Hardware, Software
8 topic lessons
Introduction
Information Systems in Organizations
Soft Side of Implementing Change
Careers in Information Systems
Hardware
Servers
Software
Operating Systems
Database System, Big Data, Fundamentals of Database Design
9 topic lessons
Introduction to Database
Data Modelling
Manipulating Data
Big Data
What is Database Design?
Requirements Analysis
Conceptual Design
Logical Design
Physical Design
Entity-Relationship Model(ER Diagrams)
6 topic lessons · 5 questions
Introduction to ER Diagrams
Entities
Attributes
Relationship Types
Cardinality
ER diagrams with Table
Example 1
Example 2
Example 3
Exam-like 1
Exam-like 2
SQL Queries
7 topic lessons
SELECT
Arithmetic Expressions
Column Aliases
Where Clause
Comparison Operators
Logical Operators
ORDER BY
Displaying Data from Multiple Tables
4 topic lessons
Introduction to Joins
INNER JOIN
LEFT-RIGHT JOIN
CROSS-SELF JOIN
Customizing Output
9 topic lessons
Introduction
Case-Conversion Functions
Character Manipulation Functions 1
Character Manipulation Functions 2
Number Functions
Date Functions
Conversion Functions
IF()
CASE
Group Functions
3 topic lessons
Group Functions
GROUP BY
HAVING
Subqueries
3 topic lessons
Subqueries
Multiple-Row Subqueries
Multiple-Column Subqueries
Manipulating Data, Managing Tables
6 topic lessons
INSERT
UPDATE - DELETE
Database Transactions
CREATE TABLE
Constraints
ALTER TABLE
Keys and Normalizations
2 topic lessons
Keys
Normalizations
Past Midterm Exam Problems
14 questions
Fundamentals of Database Design
SQL Queries 1
SQL Queries 2
SQL Queries 3
Subqueries 1
Subqueries 2
Managing Tables
Creating Tables 1
Creating Tables 2
ER Model + Create Table 1
ER Model + Create Table 2
Normalization 1
Normalization 2
Normalization 3
View, Index, Set Operators
5 topic lessons
Creating View
Updating or Removing View
Indexes
UNION / UNION ALL
INTERSECT / MINUS
Controlling User Access
3 topic lessons
System Privileges
Roles
Object Privileges
Cloud Computing, E-commerce, Enterprise Systems
8 topic lessons
Networks
Communications
How the Internet Works
Cloud Computing
E-Commerce
E-Commerce Hardware/Software
Payment Systems
Enterprise Systems
Business Intelligence and Analytics
7 topic lessons
Analytics
Data Cubes
Data Cube Operations
Data Warehouse/Mining
Knowledge Management
Machine Learning
Expert Systems
Past Final Exam Problems
7 questions
SQL Queries 1
SQL Queries 2
SQL Queries 3
SQL Queries 4
SQL Queries 5
Subqueries 1
Subqueries 2