Skip to Content
Networking All-in-One For Dummies
book

Networking All-in-One For Dummies

by Doug Lowe
February 2016
Beginner
912 pages
20h 9m
English
For Dummies
Content preview from Networking All-in-One For Dummies

Chapter 3

Using SQL Server 2014

In This Chapter

arrow Looking at relational databases and SQL

arrow Installing SQL Server 2014

SQL Server 2014 is the latest and greatest version of the most common database server used on Microsoft networks.

This chapter introduces you to the basics of installing and running SQL Server 2014. It begins with a basic introduction to relational databases and SQL. Then it shows you how to manage a SQL Server database by using SQL Server 2014 Management Studio.

Note: The information in this chapter applies to previous versions of SQL Server as well.

What Is a Database?

A database is simply an organized collection of information. Here are some examples of databases from everyday life:

  • Your personal address book
  • The shoebox that contains your tax records for the year
  • Your baseball card collection
  • All those parking tickets conveniently stuffed into your car’s glove compartment
  • The phone book (well, from everyday life in the good ol’ days anyway)
  • That pile of score cards that has been accumulating in the bottom of your golf bag for 15 years

You can think of each of these databases as a collection of records. In database lingo, a record consists of all the useful information that you can gather about a particular thing. In your address book, each record represents ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Networking All-in-One For Dummies, 7th Edition

Networking All-in-One For Dummies, 7th Edition

Doug Lowe

Publisher Resources

ISBN: 9781119154723Purchase book