INDR 481 • Midterm + FinalInformation Systems

2499 TL

833 TL a month, 3 instalments at no extra cost

21 past exam questions with solutions
80 topic lessons · 6 h 14 min
Access for the whole term

Instructor

Ertuğrul Altun

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

Course introduction

Introduction

Information Systems in Organizations

Soft Side of Implementing Change

Careers in Information Systems

Hardware

Servers

Software

Operating Systems

Introduction to Database

Data Modelling

Manipulating Data

Big Data

What is Database Design?

Requirements Analysis

Conceptual Design

Logical Design

Physical Design

Introduction to ER Diagrams

Free

Entities

Free

Attributes

Relationship Types

Cardinality

ER diagrams with Table

Example 1

Example 2

Example 3

Exam-like 1

Exam-like 2

SELECT

Arithmetic Expressions

Column Aliases

Where Clause

Comparison Operators

Logical Operators

ORDER BY

Introduction to Joins

INNER JOIN

LEFT-RIGHT JOIN

CROSS-SELF JOIN

Introduction

Case-Conversion Functions

Character Manipulation Functions 1

Character Manipulation Functions 2

Number Functions

Date Functions

Conversion Functions

IF()

CASE

Group Functions

GROUP BY

HAVING

Subqueries

Multiple-Row Subqueries

Multiple-Column Subqueries

INSERT

UPDATE - DELETE

Database Transactions

CREATE TABLE

Constraints

ALTER TABLE

Keys

Normalizations

Fundamentals of Database Design

SQL Queries 1

Free

SQL Queries 2

Free

SQL Queries 3

Free

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

Creating View

Updating or Removing View

Indexes

UNION / UNION ALL

INTERSECT / MINUS

System Privileges

Roles

Object Privileges

Networks

Communications

How the Internet Works

Cloud Computing

E-Commerce

E-Commerce Hardware/Software

Payment Systems

Enterprise Systems

Analytics

Data Cubes

Data Cube Operations

Data Warehouse/Mining

Knowledge Management

Machine Learning

Expert Systems

SQL Queries 1

SQL Queries 2

SQL Queries 3

SQL Queries 4

SQL Queries 5

Subqueries 1

Subqueries 2

Frequently asked questions about INDR 481 Midterm + Final

Frequently asked questions about Unicourse

2499 TL