ISE 311 • MidtermInformation Technologies

Yeditepe Üniversitesi ISE 311 (Information Technologies) Midterm sınavına hazırlık paketi.

İşlenen konular: Entity-Relationship Model(ER Diagrams), Introduction to SQL and the SELECT Statement, Restricting and Sorting Data, Using Single-Row Functions to Customize Output, Using Conversion Functions and Conditional Expressions, Reporting Aggregated Data Using the Group Functions, INSERT-UPDATE-DELETE, Create and Manage Tables, Using Set Operators.

1999 TL

666 TL a month, 3 instalments at no extra cost

7 past exam questions with solutions
37 topic lessons · 2 h 58 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 to ER Diagrams

Free

Entities

Attributes

Relationship Types

Cardinality

ER diagrams with Table

Example 1

Free

Example 2

Free

Example 3

Exam-like 1

Exam-like 2

Keys

Free

SELECT

Arithmetic Expressions

Column Aliases

Where Clause

Comparison Operators

Logical Operators

ORDER BY

Introduction

Case-Conversion Functions

Character Manipulation Functions 1

Character Manipulation Functions 2

Number Functions

Date Functions

Conversion Functions

IF()

CASE

Introduction to Joins

INNER JOIN

LEFT-RIGHT JOIN

CROSS-SELF JOIN

Aggregate Functions

GROUP BY

HAVING

INSERT

UPDATE - DELETE

CREATE TABLE

Constraints

ALTER TABLE

UNION / UNION ALL

INTERSECT / MINUS

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Frequently asked questions about ISE 311 Midterm

Frequently asked questions about Unicourse

1999 TL