Introduction to Database Systems
Details
Course Description:
The course includes overview of the database development process, entity relationship diagrams, relational analysis including normalization, physical database design, SQL, object-oriented databases, client-server and internet database environment, XML, transaction
processing and concurrency control, data warehousing and data mining.
Outline
Day 1
- Introduction to Databases
- Database Development Process
- Entity Relationship Diagram
- Exercises
- Overview of Project Requirements
Day 2
- Relational Analysis
- Physical Database Design
- SQL
- Hands-on Exercises
Day 3
- Object-oriented database modeling
- Object-oriented database development
- Overview of Commercial and Open Source Relational Databases
- Overview of Commercial and Open Source Object Databases
- Hands-on Exercises
Day 4
- Client/Server Systems and Internet Database Environment
- XML Databases
- Transaction Processing and Concurrency Control
- Hands-on Exercises
Day 5
- Data Warehousing
- Data and Database Administration
- Distributed Databases
- Project Presentation
The UP System Information Technology Foundation (UPSITF) Inc. is a non-government organization focused on the application of Information and Communication Technology for development. It partners with UP Information Technology Development Center in providing various services such as, but not limited to, Education Development, IT Human Capital Development, Research & Development, Software Engineering, ICT Policy Development and Planning, and IT Project Management.
The Foundation’s flagship project Youth on Information Technology or popularly known as Y4iT is an annual event organized by UPSITF, in cooperation with UP Information Technology Development Center (UP ITDC) and Y4iT Volunteer Corps (VolCorp), that attracts at least 25,000 attendees every year.
Dr. Jaime D.L. Caro, Executive Director of UPSITF, said that for the past ten years, Y4iT has served as a hub for computer enthusiasts and technopreneurs to share ideas and talk about the latest breakthroughs in IT. Drawing thousands of attendees from all over the country, the congress, according to Caro, has inspired individuals to engage with one another and build on ideas that are both innovative and relevant to the community. ...