Hafta 114–20 Eyl
DBMS'e giriş ve SQL ile tablo tanımlama
Introduction to Database Management Systems. Advantages of DBMS SQL as Data Definition Language: Create tables/ define constraints Keys / domain constraints
DBMSSQLData Definition Languagekey / domain constraints
Hafta 221–27 Eyl
Integrity Kısıtları ve Schema Nesneleri Yönetimi
Entity Integrity Referential Integrity Managing Schema Objects (Tables) Create / Add / Alter / Drop /Rename/Modify/Set Unused Column/ Deferring Constraints/ Disabling Constraints/ Flush Back Tables SQL/DML: Insert LAB 1: 1. ORACLE Academy-Student License Agreement 2. Getting familiar with ORACLE. 3. Using SQLDeveloper 4. Creating tables by using Schema Manager and SQL Commands 5. Creating BankingDB
entity integrityreferential integritySQL DMLOracle SQL Developer
Hafta 328 Eyl – 4 Eki
SELECT ile veri çekme ve schema objects
SQL as Data Manipulation Language: Retrieving data using SELECT statement Column Aliasing/Quote Operator DISTINCT/LIKE/IN/ORDER BY LAB 2: 1. Managing Schema objects PARTII-SQL-II Practice 3-1 2. Creating CompanyDB and Foreign Keys (Referential Integrity)
SELECTDISTINCT/LIKE/INORDER BYforeign key
Hafta 45–11 Eki
SQL fonksiyonları, CASE/DECODE ve JOIN türleri
SQL/DML General Functions :NVL-NVL2 Conditional Expressions: CASE-DECODE JOIN types, INNER/OUTER JOIN LAB 3: 1. Practice 2-1: Retrieving Data Using the SQL SELECT Statement 2. Using DDL statements to Create and Manage Tables 3. Practice 3-1: Restricting and Sorting Data 4. Practice 5-1: Using Conversion Functions and Conditional Expressions 5. Self Study: Practice 7-1: Displaying Data from Multiple Tables Using Joins
NVL-NVL2CASE-DECODEINNER/OUTER JOINDDL
Hafta 512–18 Eki
SQL set operations ve subquery kullanımı
Set operations, subqueries ANY/ALL operations with multiple-row subqueries ANY/ALL operations with multiple-row subqueries LAB 4: 1. SELF STUDY: Practice 8-1: Using Subqueries to Solve Queries (Ex: 3, 4, 5, 6, 7)
set operationssubqueryANY/ALLLAB 4, Practice 8-1
Hafta 619–25 Eki
SQL'de grouping ve aggregate function'lar
Grouping and aggregate functions (SQL ) LAB QUIZ
SQLgroupingaggregate functionlab quiz
Hafta 726 Eki – 1 Kas
Correlated subquery'ler ve transaction yönetimi
Correlated subqueries Pairwise/Non-pairwise comparison subqueries Transaction Properties Transaction Management LAB 5: 1. Single row functions 2. Reporting Aggregated Data Using the Group Functions (Practice 6-1) 3. Using Sub-queries to Solve Queries(Practice 8-1) 4. Retrieving Data by Using Subqueries (Practice 7-1)
correlated subquerypairwise comparison subquerytransaction managementLAB 5
Hafta 82–8 Kas
Transaction kontrolü ve SQL DML lab
Transactions start-end /Commit/Rollback/Save Point Review for process management and Physical read/write in O/S SQL/DML: insert/delete/update Read consistency (select for update) LAB 6: 1. Row Locking, Select for update 2. Manipulating Data (Add, Delete, Update) 3. Controlling Transactions (Commit, Savepoint, Rollback) 4. Practice 4-1: Using Single-Row Functions to Customize Output 5. Practice 5-1: Using Conversion Functions and Conditional Expressions
commit/rollback/savepointrow lockingDMLread consistency
Hafta 99–15 Kas
View, sequence ve PL/SQL programlama
OTHER DATABASE OBJECTS . Views . Sequences LAB7:PL/SQL 1. PL/SQL Programming Language : Variables, DB values, Data Conversin Functions, iterations, Conditions, Strings, Worksheet, Cursors, Explicit cursors, Exceptions MIDTERM 1
ViewSequencePL/SQLcursor
Hafta 1016–22 Kas
Logical design, ER diagram ve PL/SQL
Logical Design: Requirement definition and analysis Introduction to ER Diagramming LAB8: PL/SQL: 1. PL/SQL:Cursor examples, Procedure, Function 2. Case Statement, Extract, Accept Creating Procedure, Creating Functions Creating named blocks for a stored procedure and functions Implicit/explicit cursor examples, Handle exceptions
ER diagramPL/SQLcursorstored procedure
Hafta 1123–29 Kas
ER diyagramı ve PL/SQL lab 9
ER-Diagramming Basics- Logical relational database design LAB 9: PL/SQL: 1.Creating other Schema Objects (view, sequence) 2. PL/SQLExercises Practicing on cursors, procedure, function(Market DB) Review Guide for PL/SQL (FormulaDB) Handling Exceptions
ER diagramPL/SQLcursor, procedure, functionexception handling
Hafta 1230 Kas – 6 Ara
Oracle Forms ve Oracle Reports laboratuvarı
Samples for ER Diagrams LAB 10: 1. Oracle Forms: Creating A Data Block Form 2. Creating a List Of Values (LOV), Check Box, List Item, Radio Button 3. Representing Data values Using Other Item Types (List Item, Radio Button) 4. Master - Detail Relationships. Form Triggers: Form Triggers with Master - Detail Relationships 5. Oracle Reports
Oracle FormsList of Values (LOV)Master-Detail RelationshipsOracle Reports
Hafta 137–13 Ara
Normalization (1-5 normal form) ve Oracle lab'ı
Normalization (1-5 Normal Forms) Normalization Examples LAB 11: 1. Oracle Forms & Reports Example (Online Supermarket) 2. Oracle Forms & Reports Example (Student DB) TAKE HOME: Study for LabExam-Hospital DB Example MIDTERM 2
normalizationnormal formOracle Forms & ReportsMidterm 2
Hafta 1414–20 Ara
SQL/DCL ile kullanıcı erişim kontrolü
Controlling user Access in SQL/DCL LAB 12: 1. Controlling User Access 2. Managing Objects with Data Dictionary Views. LAB EXAM
SQL/DCLcontrolling user accessdata dictionary viewsLAB 12