- Code
- CMP 217
- Name
- Databases
- Semester
- 3
- Lecture hours
- 3.00
- Seminar hours
- 0.00
- Laborator hours
- 1.00
- Credits
- 3.50
- ECTS
- 5.00
- Description
-
This course provides the necessary theoretical and practical foundations for relational database management systems. It also covers data analysis and modeling using entity-relationship techniques, relational theory and normalization, and the SQL language.
- Objectives
-
Get ready to acquire some seriously marketable programming skills! You can’t consider yourself a complete end to end developer until you can code in SQL. Today, data has become the hottest topic in technology and a company’s biggest asset is their data. All databases require the language SQL to store and retrieve data. The great thing is, for this course, you do not need any prior experience in programming what so ever. SQL is a different animal and we’re going to demystify the language from scratch and prepare you with plenty of progressively challenging assignments so that by the time you’ve completed the course, you can call your self an Oracle SQL Master! Oracle is the most popular relational database in the world!
- Java
- Tema
- 1
- Introduction to Database Systems, Database System Concepts
- 2
- Entity-Relationship Model
- 3
- Enhanced Entity Relationship Model
- 4
- Relational Data Model
- 5
- Relational Algebra I
- 6
- Relational Algebra II
- 7
- Normalizing a database
- 8
- Midterm
- 9
- Introduction to SQL
- 10
- DML data manipulation instructions
- 11
- More DML instructions, DDL table creation instructions
- 12
- Introduction to MySQL, database design in MySQL
- 13
- Tables in MYSQL
- 14
- Retrive data from tables using MySQL statements
- 15
- Database Programming
- 16
- Final Exam
- 1
- The student manages to create a simple database
- 2
- The student manages to make simple queries in the database
- 3
- The student is introduced to the basic components of an RDBMS
- Quantity Percentage Total percent
- Midterms
- 1 15% 15%
- Quizzes
- 2 10% 20%
- Projects
- 0 0% 0%
- Term projects
- 0 0% 0%
- Laboratories
- 0 0% 0%
- Class participation
- 1 5% 5%
- Total term evaluation percent
- 40%
- Final exam percent
- 60%
- Total percent
- 100%
- Quantity Duration (hours) Total (hours)
- Course duration (including exam weeks)
- 16 4 64
- Off class study hours
- 14 4 56
- Duties
- 0 0 0
- Midterms
- 1 2 2
- Final exam
- 1 2 2
- Other
- 0 0 0
- Total workLoad
- 124
- Total workload / 25 (hours)
- 4.96
- ECTS
- 5.00