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 3794 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
Cable Testers and How to Use them in Network Environments
0 692 1This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader demonstrates how to use cable testers in network environments. Let’s look at some tools that we can use to test our different cables in our environment. Cable Testers Properly Wired Connectivity … Continue reading Cable Testers and How to Use them in Network Environments
How to use AWS CloudFormation templates to automate solutions inside Amazon AWS
0 380 0In the AWS Class here at Interface, we actually build fully automated solutions with AWS CloudFormations. Here’s an overview of using AWS templates using CloudFormation. CloudFormation is basically an “infrastructure-as-code tool” where you can go into a declarative document and define all the resources that you want and feed the document into the CloudFormation … Continue reading How to use AWS CloudFormation templates to automate solutions inside Amazon AWS