CMPE 232 • Midterm • Database 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.
599 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
Hardware and Software
4 topic lessons
Hardware
Servers
Software
Operating Systems
Relational Data Model and Database Design
9 topic lessons
Introduction to Database
Data Modelling
Manipulating Data
Big Data
Database Design
Requirements Analysis
Conceptual Design
Logical Design
Physical Design
Entity-Relationship Model (ER Diagrams)
6 topic lessons · 2 questions
Introduction to ER Diagrams
Entities
Attributes
Relationship Types
Cardinality
ER diagrams with Table
Example 1
Example 2
SQL Basics
26 topic lessons
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
Advanced SQL
9 topic lessons
Group Functions
GROUP BY
HAVING
Subqueries
Multiple-Row Subqueries
Multiple-Column Subqueries
Creating View
Updating or Removing View
Indexes
Keys and Normalizations
2 topic lessons
More on Keys
Normalizations
Past Midterm Problems
20 questions
Test Questions
ER Model
ER Model
ER Model
SQL Basics
SQL Basics
SQL Basics
SQL Basics
SQL Basics
SQL Basics
Advanced SQL
Advanced SQL
Advanced SQL
Advanced SQL
Advanced SQL
Advanced SQL
Advanced SQL
Normalization
Normalization
Normalization
Reviews
5 student reviews
Only students who have this course can review it.
Kerem Öğün
Bought the courseEndüstri Mühendisliği
Ömer Efe Kolukırık
Bought the courseMühendislik Programları
Baturalp Akdoğan
Bought the courseMühendislik Programları
Arda Yavuz
Bought the courseBilgisayar Mühendisliği
Atilla Abbas
Bought the courseYazılım Mühendisliği