CMPE 232 • MidtermDatabase Systems

TED Üniversitesi CMPE 232 (Database Systems) Midterm sınavına hazırlık paketi.

İşlenen konular: Hardware and Software, Relational Data Model and Database Design, Entity-Relationship Model(ER Diagrams), SQL Basics, ADVANCED SQL, Keys and Normalizations.

1799 TL

599 TL a month, 3 instalments at no extra cost

20 past exam questions with solutions
56 topic lessons · 4 h 27 min
5.0 rating
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

Hardware

Free

Servers

Software

Operating Systems

Introduction to Database

Data Modelling

Manipulating Data

Big Data

Database Design

Requirements Analysis

Conceptual Design

Logical Design

Physical Design

Introduction to ER Diagrams

Free

Entities

Attributes

Relationship Types

Cardinality

ER diagrams with Table

Example 1

Free

Example 2

Free

CREATE TABLE

Constraints

ALTER TABLE

SELECT

Arithmetic Expressions

Column Aliases

Where Clause

Comparison Operators

Logical Operators

ORDER BY

Introduction to Joins

INNER JOIN

LEFT-RIGHT JOIN

CROSS-SELF JOIN

Functions

Case-Conversion Functions

Character Manipulation Functions 1

Character Manipulation Functions 2

Number Functions

Date Functions

Conversion Functions

IF()

CASE

INSERT

UPDATE - DELETE

Database Transactions

Group Functions

GROUP BY

HAVING

Subqueries

Multiple-Row Subqueries

Multiple-Column Subqueries

Creating View

Updating or Removing View

Indexes

More on Keys

Normalizations

Test Questions

ER Model

Free

ER Model

ER Model

SQL Basics

SQL Basics

SQL Basics

SQL Basics

SQL Basics

Free

SQL Basics

Advanced SQL

Advanced SQL

Advanced SQL

Advanced SQL

Advanced SQL

Advanced SQL

Advanced SQL

Normalization

Normalization

Normalization

Reviews

5

5 student reviews

Only students who have this course can review it.

Kerem Öğün

Bought the course

Endüstri Mühendisliği

4 days ago

Ömer Efe Kolukırık

Bought the course

Mühendislik Programları

5 days ago

Baturalp Akdoğan

Bought the course

Mühendislik Programları

9 days ago

Arda Yavuz

Bought the course

Bilgisayar Mühendisliği

7 months ago

Atilla Abbas

Bought the course

Yazılım Mühendisliği

8 months ago

Frequently asked questions about CMPE 232 Midterm

Frequently asked questions about Unicourse

1799 TL