ISE 311 • Midterm • Information 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.
666 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
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
Introduction to SQL and the SELECT Statement
4 topic lessons
Keys
SELECT
Arithmetic Expressions
Column Aliases
Restricting and Sorting Data
4 topic lessons
Where Clause
Comparison Operators
Logical Operators
ORDER BY
Using Single-Row Functions to Customize Output
6 topic lessons
Introduction
Case-Conversion Functions
Character Manipulation Functions 1
Character Manipulation Functions 2
Number Functions
Date Functions
Using Conversion Functions and Conditional Expressions
3 topic lessons
Conversion Functions
IF()
CASE
Joins
4 topic lessons
Introduction to Joins
INNER JOIN
LEFT-RIGHT JOIN
CROSS-SELF JOIN
Reporting Aggregated Data Using the Group Functions
3 topic lessons
Aggregate Functions
GROUP BY
HAVING
INSERT-UPDATE-DELETE
2 topic lessons
INSERT
UPDATE - DELETE
Create and Manage Tables
3 topic lessons
CREATE TABLE
Constraints
ALTER TABLE
Using Set Operators
2 topic lessons
UNION / UNION ALL
INTERSECT / MINUS
Past Midterm Problems
7 questions
Question 1
Question 2
Question 3
Question 4
Question 5
Question 6
Question 7