Diploma in Database and Content Organisation
- Offered bySwayam
Diploma in Database and Content Organisation at Swayam Overview
Duration | 15 weeks |
Start from | Start Now |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Go to Website |
Credential | Certificate |
Diploma in Database and Content Organisation at Swayam Highlights
- Earn a diploma from IGNOU
- Learn from expert faculty
Diploma in Database and Content Organisation at Swayam Course details
- Professionals already working with databases who want to deepen their understanding of database organization, optimization, and maintenance
- Understand the fundamental principles of databases, including relational database management systems (RDBMS), data modeling, and database architecture
- Develop the skills to design, create, and implement databases tailored to specific organizational needs, considering factors such as data integrity, normalization, and performance optimization
- Learn to write and execute SQL queries to retrieve, update, and manipulate data stored in databases effectively
- Gain proficiency in managing data storage and retrieval processes, including indexing, data partitioning, and transaction management
- This course introduces you to the concepts of Database, Content Organization and some emerging trends. In any Information Storage and Retrieval System (ISAR), databases occupy the central position
- Creation of efficient databases leads to successful retrieval of information contained in that database
- A database is an organized collection of related data. In modern library environment, electronic databases are used to support a wide-range of information management operations and services
- Knowledge in database concepts and applications becomes essential for the success of information professionals in present society
Diploma in Database and Content Organisation at Swayam Curriculum
Week - 1
DBMS –Introductory Concepts
Elements of DBMS
Week - 2
Types of Databases and Data Models
Relational Databases and Overview of DB Design
Week – 3
Anomalies and Normalization
File Organization - I
File Organization - II
Week – 4
Search Strategy - I
Search Strategy - II
Week – 5
Content Organization and Formats
Indexing and Indexing Tools
Types of SQL Commands and Introduction to MySQL
Week - 6
Introduction to MySQL Commands - I
Introduction to MySQL Commands – II
Introduction to MySQL Commands – III
Week – 7
Introduction to MySQL Commands – IV
Introduction to MySQL Commands - V
Database Recovery
Week – 8
Transaction Management, Concurrency Control and Deadlock
Textual DBMS Major features
CDS/ISIS for Windows An Introduction
Week - 9
Use of Content Designators in WINISIS
Common Communication Format (CCF) in WINISIS
Steps in Developing Databases in WINISIS
Week -10
Steps in WINISIS: FDT and Worksheet
Steps in WINISIS: Pickup Lists in Worksheet
Steps in WINISIS: Basic Formatting Language