database-basics
May 8, 2018 in Databases

Database Basics Explained

Database Basics Explained

Primary Key – A primary key field holds data that uniquely identifies each record in a table.<,/p>

There are two types of primary keys most commonly used:

  1. Single-field primary key – If you have a field that contains unique values such as Social Security Numbers in Employee Master Table, you can use that field as the primary key.
  2. Multiple-field primary key – In situations where the Employee worked for more than one company, Social Security Number alone will not guarantee the uniqueness of the records. In this situation, you would have to use a combination key (for example SSN and Subscriber ID)

Three Types of Joins

A join line between tables shows how the data is related. The type of join indicates which records the query selects or performs an action on.

There are three types of joins:

  1. Inner Join – only includes rows where the joined fields from both tables are equal.
  2. Left Outer Join – includes ALL records from the table on the left and only those records from the table on the right where the joined fields are equal.
  3. Right Outer Join – includes ALL records from the able on the right and only those records from the table on the left where the joined fields are equal.

Setting up Criteria

In order to view information for the particular field in the table, you must narrow down your search. There are a number of operations that can be performed to get results. Here are the few most commonly used:

  • Equals To
  • Not Equals To
  • Greater Than
  • Greater Than or Equals To
  • Less Than
  • Less Than or Equals To

Comments (7)

  1. נערות ליווי

    4 weeks ago

    This is the right website for anyone who wants to understand this topic. You understand so much its almost hard to argue with you (not that I really would want toÖHaHa). You certainly put a brand new spin on a subject that has been discussed for many years. Wonderful stuff, just wonderful! This is the right website for anyone who wants to understand this topic. You understand so much its almost hard to argue with you (not that I really would want toÖHaHa). You certainly put a brand new spin on a subject that has been discussed for many years. Wonderful stuff, just wonderful! נערות ליווי בקיסריה

  2. israelxclub.co.il

    1 week ago

    Im excited to discover this web site. I need to to thank you for ones time for this wonderful read!! I definitely savored every bit of it and I have you bookmarked to look at new information in your web site.

  3. Quality Wordpress links in the comments

    6 days ago

    Quality WordPress links in the comments from 5000 uniques. domains order here.

  4. Quality Wordpress links in the comments

    6 days ago

    Quality WordPress links in the comments from 5000 uniques. domains order here.

  5. נערות ליווי בתל אביב

    3 days ago

    I was pretty pleased to discover this great site. I need to to thank you for your time for this particularly fantastic read!! I definitely appreciated every part of it and I have you book marked to see new stuff on your blog.

  6. נערות ליווי בחיפה

    3 days ago

    I was pretty pleased to discover this great site. I need to to thank you for your time for this particularly fantastic read!! I definitely appreciated every part of it and I have you book marked to see new stuff on your blog

  7. נערות ליווי

    1 second ago

    I was extremely pleased to discover this page. I want to to thank you for ones time due to this wonderful read!! I definitely appreciated every part of it and I have you bookmarked to look at new information on your web site.

Comment Form