Course Overview
RDBMS & ER Model Training Courses
What is ER
The Entity Relationship model works around the real world entities and the relationships among them. The ER model was developed by Peter Chen in the year 1976. This model is very much useful for designing databases. ER Model is a way of graphically representing the logical relationship of the entities in order to create a database. Entity here refers to real world object and entity set refers to a collection of similar entity types. The properties of entities are called attributes and each attribute has a value for them. The association between the entities are called relationship.
What is RDBMS
RDBMS stands for Relational Database Management System. RDBMS forms the fundamental for SQL and for most of the modern databases like MS SQL Server, IBM DB2 and others. RDBMS is based on relational model where data is represented by means of rows or tuples. Relational databases is a collection of organized set of tables where each table has its own primary key.
Pre Requisites for taking this course
Person who is taking this course should have basic knowledge about SQL and database concepts.
Target Audience for this course
The target audience of this course are
- Database developers
- Database administrators
- Professionals
- And anyone who wants to get a certification in RDBMS and ER Model
Course Objectives
After completion of this course you will be able to
- Know about the concept of data and database
- Understand the difference between DBMS and RDBMS
- Learn about the database management system and its benefits
- Know in detail about the components of ER model
- Describe the ER diagram and find out the various relationships
- Understand what is SQL server, its features, models and architecture
Course Description
Section 1: RDBMS Concepts
Introduction to Database
A database is a collection of similar data which is organized in a way that is easy to access, manage and update. Data here means any piece of information and facts that are recorded. Database is actually a store place where data in stored and various operations can be performed on the data. This chapter contains a brief introduction to Database.
Disadvantages of File based systems
File processing system are good only when there is limited number of data and files. It becomes more difficult when the data is growing very fast and at a huge rate. The disadvantages of file processing system are discussed under the following topics
- Data Mapping and Access
- Data Redundancy
- Data Dependence
- Data Inconsistency
- Data Sharing
- Data Isolation
- Security
- Integrity
- Atomicity
- Concurrent Access
What are Database Systems?
To overcome all the disadvantages of file processing system the database system was developed. In database the files are called as tables and the contents of the files are called as records of the tables. The column values are knows as attribute and the information are known as record. Each record in a database system has a unique key known as the primary key. These keys are used to access the data faster. Thus this chapter deals with the introduction and features of database system along with an example. The components of the database system are
- Users
- Database Application
- DBMS
- Database
Database Management Systems (DBMS)
A DBMS is a software that lets you to create, define and manipulate database. DBMS is actually a tool which lets you to perform various operations on the data in the database. The data stored in DBMS is easy to retrieve, manipulate and generate new information. The characteristics of the DBMS are explained in detail in this lesson. The other topics included in this chapter are
- Functions of DBMS
- Characteristics of DBMS
- Users of DBMS
- Advantages and Disadvantages of DBMS
Database Models
Data models are the logical structure of a database. A data model helps to put the real world requirement into a design. The data models define the relationship between the data and how they are processed and stored in the system. Based on the levels of data considered for modelling, the data model is divided into three types – Object based, Physical and Record Based. The object data model and Record based model are based on the data at the application and user level. They are further divided into the following categories
- Object Based – Entity Relationship Data Model, Object Oriented Data Model
- Record Based – Hierarchical Data Model, Network Data Model, Relational Data Model
Database Models- Relational Data Model
Relational data model is the most commonly used data model for data storage and processing. This model is very simple. The other topics explained in this chapter are
- Concepts – Table, Tuple, Relation Instance, Relation Schema, Relation Key, Attribute Domain
- Constraints – Key Constraints, Domain Constraints and Referential Integrity Constraints
- Advantages and Disadvantages of Relational Data Model
Relational Database Management Systems
Relational Database Management Systems is a program which allows you to create, update and manage a relational database. In RDBMS the data is in the form of tables, fields and records. RDBMS is based on the relational model. Most of the RDBMS uses SQL to access the database. The most popular RDBMS are MS SQL Server, DB2, Oracle and MySQL. This section also explains what is a table, field, record, column and NULL value in RDBMS with examples.
Entities and Tables
An entity is a collection of tables and a table contains information about an object, person or a thing. The relationship and the differences between the entities and tables are listed in this chapter
Section 2: ER Model and Normalization
Data Modelling
Data Modelling is the first and foremost step in database design and OOPS. Data Modelling helps the designers to first create a conceptual model of how data can be related to each other. Data modelling is the representation of the data structures in the form of a table. Data models are used for various purposes like conceptual models to physical data models.
Entity Relationship: One-to-many
When more than one instance of an entity is associated with a relationship then it is One-to-Many entity relationship. This chapter contains pictorial representation of this relationship with an example.
Normalization
Normalization is a set of rules or guidelines used when designing a database in order to avoid the redundancies or anomalies. Normalization helps to remove all the anomalies in a database and helps in equal distribution of data effectively and efficiently. This chapter deals with the different types of Normal forms as mentioned below
- First Normal Form
- Second Normal Form
- Third Normal Form
- Boyce-Codd Normal Form
- Forth Normal Form
- Fifth Normal Form
These normal forms are explained in detail with examples
Relational Operators
Relational algebra in DBMS is a query language which uses certain operators to perform the query. These operators are called relational operators. The relational set operators are used in DBMS to join or delete the records. The basic relational operators which are discussed in this chapter are
- Select
- Project
- Union
- Set Different
- Cartesian Product
- Rename
The notation, example and output for each operation is discussed in detail in this chapter
Section 3: Overview of SQL Server
Introduction to SQL Server
SQL Server is a RDBMS which was developed by Microsoft for use in the enterprise environment. SQL Server runs on transact SQL which is a set of programming extensions. This chapter gives a brief introduction to SQL Server.
Features of SQL Server
This section explains the core features of SQL Server in detail.
Components of SQL Server
SQL Server is made up of four main components which are
- Database engine – This is used to create and drive relational databases
- SQL Server Analysis Services (SSAS) – It helps to organize data inside a relational database
- SQL Server Reporting Services (SSRS) – This component is used for reporting
- SQL Server Integration Services (SSIS) – This performs the ETL process and helps to format the raw data from source systems
These components are explained in detail under this chapter
Two- tier & Three- tier models
The two tier architecture is a client server architecture. There is no intermediate and direct communication takes place. The two tier architecture includes the Data Tier and Client Tier. The advantages and disadvantages of two tier structure is also listed in here
Three tier structure has three layers – Client layer, Business Layer and Data Layer. Each layer is explained in detail in this section. The advantages and disadvantages of three tier structure is given. The two tier and three tier model is explained using pictorial representation.
System databases under SQL Server 2005
The SQL Server consists of five databases which are
- master database
- msdb database
- model database
- Resource database
- tempdb database
Here you will learn about all these databases in detail
Logical Database Components
Logical components are the ones which are used to connect to the database. Any object that helps the user to get access to the database is called a logical component. The logical component consists of the following
- Tablespaces
- Database Objects
- Collation
- Database’s Schema Objects
- Login, users and Groups
In this lesson you will see these logical components in detail
Relational database architecture
Relational database consists of several tables and each table has a unique name. The rows in relational database represents the relationship among the set of values. This lesson explains the basic structure of relational database along with examples.
Section 4: Overview of SQL Server (Lab Guide)
Overview of SQL Server
Under this section you will see a detailed explanation of SQL Server, the components of SQL Server and some practical lab exercises of SQL Server. It will let you have some real time experience of working with SQL Server.
FAQ’S General Questions
- What is the benefit of learning SQL ?
The benefits you get from learning SQL depends on your job. There are four main professionals who are highly benefited by learning SQL. They are Product Managers, Data Analysts, Data Scientists and Data Managers. For product managers it helps them to know more about their product. For data analysts it helps them to solve the scalability issues. By learning SQL Data Scientists can expand their accessible data sources. For data engineers SQL is a must to deal with relational and analytic databases.
- What are the main advantages of SQL for a developer ?
SQL is everywhere now and it has a lot of benefits in it. But for developers there are few important reasons why SQL is very important. They are
- SQL is Portable
- SQL is constant for long time
- SQL can make you a better developer
- It will help you to make better performance in an application
- Learning SQL will give you a job security
- SQL will help you to simplify troubleshooting
Testimonials
Cynthia
This is a great course on ER Model and SQL. I am working as a database developer and I had only little knowledge in RDBMS and SQL while taking this course. This course helped me to gain a lot of knowledge about the subject. It gave some practical exercises which I was able to use in my work place. This course helped me to improve my performance and work like an expert. Highly recommended course.
Andrea
This is an interesting as well as a rewarding course at a very nominal price. Explains ER Model and the concepts of RDBMS in a clear and well defined manner. The contents are well structured with all the important sections. The sections were neatly explained with few interesting examples. It is really helpful to solve the real time problems using these examples. The flow of the course from one section to another is interlinked making the learning process easy. Overall a good course on ER Model and RDBMS concepts.