Transcript Document

Course presentation
Databases
Evgeny Khaymin
Institute of Mathematics, Information and
Space Technologies
Teachers
Institute of Mathematics,
Information and Space Technologies
Evgeny Khaymin, Senior Lecturer of the Applied
informatics and Informatization of Education
Department
Contacts:
[email protected]
Course overview
Module "Database" is dedicated to the study how
to design, implement and use databases to
maintain and manipulate data. Student will receive
knowledge in areas such as Database model, Entire
Relationship Databases and the basis of SQL.
Education and working
methods
The educational workload:
• Lectures – 42 h.,
• workshop – 64 h.,
• independent work – 83 h.
The work load of the course – 7 ECTS
Forms and methods of monitoring and evaluation of
learning outcomes:
• 1. tests;
• 2. checking homework;
• 3. defense labs.
Final examination – Exam
Learning skills
The
knowledge:
1. The fundamental database concepts ;
2. The basis of Standard Query Language.
The skills:
1. Developing and creating an entity
relationship diagram for modeling a
database;
2. Writing and implementing basic queries
formatted for specific output.
The
competence:
1. The ability to optimize information ;
2. To demonstrate conceptual design
principles;
3. To describe Business
Intelligence/Decision Support Systems.
Evaluation with different
parts to be considered
1. Fundamental Database concepts:
1.1. Data vs Information. Advantages and
disadvantages of using Databases.
1.2. Different database engines, models and
providers.
1.3. Analyzing data, entities, attributes and
relationships in databases.
Evaluation with different
parts to be considered
2. Database design:
2.1. Proper database design. Data types; entire
relationship diagram for modeling database.
2.2. The general methods of design using 3NF. The
main principles of E-R diagram.
Evaluation with different
parts to be considered
3. The basis of Standard Query Language
(SQL):
3.1. The basic characteristics of SQL. Changing and
updating the tables using the SQL.
3.2. Writing and implementing single table
queries and queries for specific output.
Evaluation with different
parts to be considered
4. Optimization of information and parts of
Business Intelligence:
4.1. Relating tables in database. Using indexes and
foreign keys.
4.2. Online Analitical Processing (OLAP) and data
mining. Constructing data warehouse. The
reqiurements for a data mart.
References
•
•
•
•
•
•
•
•
1. Foster Provost, Tom Fawcett // Data Science for Business: What you need
to know about data mining and data-analytic thinking, O'Reilly Media,
2013.
2. Carlos Coronel, Steven Morris, Peter Rob // Database Systems: Design,
Implementation, and Management, Cengage Learning; 10 edition, 2012.
3. Jeffrey A. Hoffer, V.Ramesh, Heikki Topi // Modern Database
Management, Prentice Hall; 11 edition, 2012.
4. Ben Forta // Sams Teach Yourself SQL in 10 Minutes, Sams Publishing; 4
edition, 2012.
5. Steven Feuerstein, Bill Pribyl. Oracle PL/SQL Programming: Covers
Versions Through Oracle Database 11g Release 2 (Animal Guide). O'Reilly
Media; Fifth Edition, 2009.
6. SQL in DB. http://www.sql.ru
7. Oracle Academy. https://academy.oracle.com/oa-web-overview.html
8. Microsoft SQL Server. http://www.microsoft.com/sqlserver/ru/ru/