What is a Database by SQL Server instructor Peter Avila

Home > Videos > SQL Server > What is a Database by SQL Server instructor Peter Avila

What is a Database by SQL Server instructor Peter Avila

3 0 30 Peter Avila
Added by October 25, 2017

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.

Microsoft SQL Server Training Classes

 

For more SQL Server training see Peter’s tech blog articles.

Enjoy!
Peter Avila
SQL Server Instructor – Interface Technical Training
Phoenix, AZ

Videos You May Like

A Simple Introduction to Cisco CML2

0 3901 0

Mark 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 731 1

This 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

Data Models in Business Analysis

0 200 0

This video is from our PMI-PBA Business Analysis for IT Analysts and Project Managers (PMI-PBA)® Certification now available at Interface Technical Training. Also see Steve’s PMP Project Management Certification Course: Project Management Professional (PMP®) Certification Video Training PMBOK® 6th Edition  Video Transcription: Data Models are part of the elicitation analysis in PMI-PBA. This is the way … Continue reading Data Models in Business Analysis

Write a Comment

Share your thoughts...

Please fill out the comment form below to post a reply.