In order to be successful as a database developer, you need to speak the right language. I'm not talking about SQL or some programming language, I'm talking terminology. It is important to familiarize yourself with the most common terms as these terms allow us to communicate with other people in our field. Data - The role of a database is to store data. Data is the plural form of the word datum. If we had to define datum, we would say it is an individual fact or piece of information. This means that data is a collection of facts and information. Database - A collection of data. Database Management System (DBMS) - A software that it is capable of storing and interacting with that data. The software is also capable of presenting this data in some way that is user friendly. Even if our data is stored all over the computers secondary memory (SSD or HDD), the database will take the data and present it to us in an organized fashion, such as in a table. MySQL is an example of a DBMS. In all reality, the distinction between a database and a DBMS is so small that most people use the terms interchangeably. Relational Database Management System (RDBMS) - A relational database is a type of DBMS. This means that all RDBMS are DBMSs, but not all DBMSs are RDBMSs. There are many other types of databases. A relational database presents our data in tables. Relation - This is a fancy pants word that means table. Table - A way to present data that has columns and rows. Columns say what data needs to be inserted and each row will insert data for every column. A database will often have numerous tables. A row can also be called a record. Where a specific column and row intersect is called a field, or a cell. Sometimes, we can fill out all of the information out for a row, but leave certain fields empty. If we do this, the field is said to be null. Null - The absence of a value. Database Design - Because our data is stored in tables, we have to go through an important process known as database design. In order for a database to work the way we intend for it to work, we have to design things. What data should we store, what tables do we create? What columns go in what tables? How are tables related? How do we ensure that our database is up to date? How do we protect our data? All of these questions bring up the concept of data integrity. This is the key term we will start with in the next video. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! www.patreon.com/calebcurry Subscribe to my newsletter: eepurl.com/-8qtH Donate!: bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: CalebCurry.com Facebook: www.facebook.com/CalebTheVideoMaker Google+: plus.google.com/+CalebTheVideoMaker2 Twitter: twitter.com/calebCurry Amazing Web Hosting - www.dreamhost.com/r.cgi?1487063 (The best web hosting for a cheap price!)

Be the first to comment