What is a Database by SQL Server instructor Peter Avila

What is a Database by SQL Server instructor Peter Avila
In this video, SQL Server instructor Peter Avila presents a simple explanation to what a database is and how to use them.
There are a few terms for SQL Server administrators to understand as they pertain to databases.
Miniworld:
An aspect of the real world. Anything from which a database can be made from.
Data:
The raw facts such as transaction details that describe the relevant aspects of the miniworld, including its entities, relationships, states and others.
Information:
We store all these facts so that we can ask the database questions against the data. Information is derived from the data and supports the decision-making process.
Once these terms are understood, then we can establish a database.
Database:
A repository of data that acts as a model of a miniworls in which data are organized in a way that makes it possible to retrieve useful information.
For instructor-led see our SQL Server training schedule.
For more SQL Server training see Peter’s tech blog articles.
Enjoy!
Peter Avila
SQL Server Instructor – Interface Technical Training
Phoenix, AZ
You May Also Like
A Simple Introduction to Cisco CML2
0 1250 0Mark Jacob, Cisco Instructor, presents an introduction to Cisco Modeling Labs 2.0 or CML2.0, an upgrade to Cisco’s VIRL Personal Edition. Mark demonstrates Terminal Emulator access to console, as well as console access from within the CML2.0 product. Hello, I’m Mark Jacob, a Cisco Instructor and Network Instructor at Interface Technical Training. I’ve been using … Continue reading A Simple Introduction to Cisco CML2
Agile Methodology in Project Management
0 160 0In this video, you will gain an understanding of Agile and Scrum Master Certification terminologies and concepts to help you make better decisions in your Project Management capabilities. Whether you’re a developer looking to obtain an Agile or Scrum Master Certification, or you’re a Project Manager/Product Owner who is attempting to get your product or … Continue reading Agile Methodology in Project Management
Detailed Forensic Investigation of Malware Infections – April 21, 2015
4 645 5How does an investigator hunt down and identify unknown malware? In this recording of our IT Security training webinar on April 21, 2015, Security expert Mike Danseglio (CISSP / CEH) performed several malware investigations on infected computers and identify symptoms, find root cause, and follow the leads to determine what’s happening. He demonstrated his preferred … Continue reading Detailed Forensic Investigation of Malware Infections – April 21, 2015