iTa'LeEm
Test Course Restore
0%
Previous
Course data
WELCOME
Announcements
Announcements
Course Info
Important Matters, Must READ!
Getting Started with Oracle
Link to download Oracle 10g XE
Minicollege.sql
UPDATED_Minicollege dataset
Group Project
Group Registration
Group Project Guidelines
Submission 1 - Database Design Document - Group Project
Submission 2 - SQL Implementation Scripts - Group Project
Submission 3 - Final Report - Group Project
MIDTERM EXAM
WEEK 1: INTRODUCTION TO DATABASE AND ENVIRONMENT
Lecture 1 - Intro to DB and Environment
WEEK 2: DATABASE PLANNING, DESIGN AND ADMINISTRATION
Pre-Class activity: EXPLORE! Learn basic DB concepts using Generative AI
Lecture 2 - DB Plan Design Admin
WEEK 3: RELATIONAL MODEL AND RELATIONAL ALGEBRA
Lecture 3 - Relational Model and Relational Algebra
Lecture 3a - Relational Model
SELF-PACED LEARNING: RELATIONAL ALGEBRA
Mini Quiz
WEEK 4: ERD and ENHANCED ERD MODELING
Lecture 4 - ERD and Enhanced ERD Modeling
In class exercise: ER and ERD Clinic Database
Slides with annotations in class
ASSIGNMENT: ER and ERD E-Commerce Database
WEEK 5: SQL - DATA MANIPULATION (INTRODUCTION)
Basic Concepts on SQL Programming
Lecture 5 - Data Manipulation (Introduction)
Mini Quiz : SQL Basic Retrieval
WEEK 6: SQL - DATA MANIPULATION (INTERMEDIATE)
Lecture 6 - Data Manipulation (Intermediate)
SQL Programming OUTER JOIN: What and How?
WEEK 7: SQL - DATA MANIPULATION (ADVANCED)
Lecture 7 - Data Manipulation (Advanced)
WEEK 8: DATA DEFINITION
Lecture 8 - Data Definition
Class Assignment: Advanced SQL and Data Definition
Sales Company SQL script
WEEK 9: NORMALIZATION
Lecture 9 - Normalization
Slides with additional details _ Lecture 9 - Normalization
WEEK 10: LOGICAL DATABASE DESIGN
Lecture 10 - Logical DB Design
WEEK 11: TRANSACTIONS
Lecture 11 - Transactions
Intro to Database Transactions
WEEK 12: ADMINISTRATION AND SECURITY
Lecture 12 - Administration and Security
WEEK 13: XML
Lecture 13 - XML
Lecture Notes_ XML (Prof. Mira)
Notepad++
Video Tutorial: XML for Beginner
XML Documents
XML Exercise
WEEK 14: NoSQL
JSON Files
Lecture 14 - NoSQL
Link to Download MongoDB
QUIZ 1
QUIZ 2
QUIZZES
Exercises
Next
iTa'LeEm
Side panel
2022/2023 Academic Session
2021/2022 Academic Session
2020/2021 Academic Session
2019/2020 Academic Session
English (en)
Bahasa Melayu (ms)
English (en)
العربية (ar)
Log in
Course Navigation
Test Course Restore
Site Navigation
Home
Skip to main content
Course info
Home
Courses
Miscellaneous
Test Course Restore
Summary
Test Course Restore
Skill Level
:
Beginner