Introduction to RDBMS

3 minutes
Share the link to this page
Copied
  Completed

Transcript

Today we are going to discuss about RDB Ms. So our Eb M S stands for relational database management systems. We have a lot of database management systems. Oracle is one of the best relational database systems we have SQL lite, SQL Server post SQL, Microsoft Access IBM DB two and SQL lite and a lot of database available in the market. So it's totally dependent upon which database you are using or which database you're going to use. In this series, I am going to use the SQL database.

Make sure the SQL statements execute on all databases because it says standard and make sure the the Select update, delete insert and where Also some other clauses in the database or commands in the SQL. These commands execute on all the major different relational databases. Okay, so now you know very well about the databases, relational databases now, how, why you need a database because when you need to store the data on permanent basis, you need the database. So that's why we store all the information in the database and how you store the database. How you store the data in the database, you always have different roles and also columns in database how Suppose if you have ID This is a column if you have name this is a column if you have city This is a column if you have country. So, this is your table first of all of our tables, couples roles and records how getting insert updating sort of possible you have, you want to store the data in the database How so?

You always provide one the name for couples chikezie in the city or suppose Karachi in the country. USA okay. You have one that means you have one record, that is your one rules. These are the Same things one couple one rows or one record or suppose this table has a name, user. So user is a table name has some columns, ID name city and country and we have inserted one record. So in this way your database was so i think is enough for when in the next lecture we are going to cover some other topics like syntax.

So then questions

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.