Official government website of the Government of the Kingdom of Saudi ArabiaHow is it achieved?

The Saudi official educational websites' links end with edu.sa

Check the domain's scope in the browser's address bar before sharing your data.

Trusted government websites use a protocol HTTPS

Check that the site uses HTTPS protocol to encrypt the connection.

Digital Government Authority Registered with the Digital Government Authority with no: 20260416249

What are you looking for?

Colleges

Advanced databases

The course describes advanced database concepts starting with an overview of basic concepts and then moving on to advanced topics. The course focuses on the relational database model and explains the concepts and applications of Entity Relationship Diagrams (ERD), normalization, query optimization, indexed retrieval, NoSQL databases, and distributed database systems. Upon completion of the course, the student will be familiar with advanced topics in databases.
Credit hours: 4
Prerequisites: IT 131
Objectives of the course :

• Describe and specify the requirements for designing databases.
• Developing a database system and analyzing problems and solving them during development.
• Explaining solutions and operating any database management system (DBMS).
• Conducting surveys to collect requirements and select the appropriate database management system for a specific unit under development.
• Database examination and planning for the design phase.
• Planning for the development phase.
• Writing code for applications using the SQL language.
• Writing code to create indexes, views, triggers, assertions, and sequence objects.
• Analysis of the cost of processing queries in distributed databases.
• Recognizing the types of non-relational databases (NoSQL).
• Complete system testing and verification of its correctness.

Course outputs :

1.1 Describe the features of distributed database management systems, their structure, and their management.
1.2 Understanding indexing and query processing in detail and the nature of NoSQL systems or data mining concepts, taking into account recent developments.
2.1 The distinction between the main terms and their use: system catalog, data dictionary, transaction management, data concepts, databases, database management systems, and descriptive data.
2.2 Evaluation and determination of how well the application meets the needs of the organization during the phase of gathering the project requirements.
2.3 Application of triggers, confirmations, offers, and improved query processing.
3.1 Participation and assistance in creating an effective information technology project plan within the team.

Additional information:

Last update date of the page content:

survey_v2

Cookies

This website uses special cookies to ensure ease of use, improve your browsing experience, and clarify the terms and policies related to About user privacy. By continuing to browse this website, you acknowledge that you accept the use of cookies and the terms of the Privacy Policy