Udemy
UdemyDBMS in simple Way
4.5(381)5k studentsBEGINNEREnglish
Korshub's take
DBMS fundamentals, explained without the jargon
Database management systems exist to solve one core problem: storing and retrieving data conveniently and efficiently. This course builds that idea from the ground up, starting with what data actually means, recorded facts with implicit meaning, before moving into how databases organize interrelated data.
A short history section traces database systems back to 1960s commercial computing, using a university tracking instructors, students, departments, and courses as a running example, before the course moves into practical design work.
Who it's for
Beginners studying databases for the first time who want a plain-language foundation before tackling more advanced SQL or database design coursework.
Key takeaways
- How to design a database structure with appropriate data tables
- Proper specification of data within a schema
- How to create a normalized database file
- An introduction to query processing, PL/SQL programming, and data security
About this course
The primary goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient. By data, we mean known facts that can be recorded and that have implicit meaning. For example, consider the names, telephone numbers, and addresses of the people you know.
In the language of computers, we define data as the collection of information. The facts that can be recorded and which have implicit meaning known as ‘data’. On the other hand, Database is a collection of interrelated data. DBMS or the database management systems are a study of such topics. In the following section, we will introduce the Function of DBMS and purpose of having a database management system.
Database systems arose in response to early methods of computerized management of commercial data. As an example of such methods, typical of the 1960s, consider part of a university organization that, among other data, keeps information about all instructors, students, departments, and course offerings. One way to keep the information on a computer is to store it in operating system files.
At the end of this Course (Subject) you will be able to:
1. Design the database structure with appropriate data tables.
2. Aware of proper specifications of data.
3. Create normalized database file.
4. Understand Query Processing & Pl/SQL Programming.
5. Apply Security mechanism on data
Advertisement
