Data Bases

Database_iStock_000020783950XSmall_0-300×300
12
Jan
Free

Alternatively referred to as a databank or a datastore, and sometimes abbreviated as a DB, a database is a large quantity of indexed digital information. It can be searched, referenced, compared, changed or otherwise manipulated with optimal speed and minimal processing expense.

A database is built and maintained by using a database programming language. The most common database language is SQL , but there are multiple “flavors” of SQL, depending on the type of database being used. Each flavor of SQL has differences in the SQL syntax and are designed to be used with a specific type of database. For example, an Oracle database  uses PL/SQL and Oracle SQL (Oracle’s version of SQL). A Microsoft database uses T-SQL (Transact-SQL).

Database components

A database is made up of several main components.

  • Schema – A database contains one or more shemas , which is basically a collection of one or more tables  of data.
  • Table – Each table contains multiple columns, which are similar to columns in a spreadsheet. A table can have as little as two columns and as many as one hundred or more columns, depending on the type of data being stored in the table.
  • Column – Each column contains one of several types of data or values, like dates, numeric or integer values, and alphanumeric values (also known as varchar).
  • Row – Data in a table is listed in rows, which are like rows of data in a spreadsheet. Often there are hundreds or thousands of rows of data in a table.

Course Content

Curriculum is empty

Instructor

0.0

0 rating

5 stars
0%
4 stars
0%
3 stars
0%
2 stars
0%
1 star
0%
Free
Join Payodhi
JOIN NOW

Join the Best Online Tutorial and Test Series.

Stay updated with all latest updates,upcoming test series, job notification & much more.
close-link