Ch.7 Reading.pdf - Chapter 7 Database Fundamentals THE...

This preview shows page 1 - 5 out of 41 pages.

Chapter 7 Database Fundamentals THE FOLLOWING COMPTIA IT FUNDAMENTALS+ (ITF+) FC0-U61 EXAM OBJECTIVES ARE COVERED IN THIS CHAPTER: 5.1 Explain database concepts and the purpose of a database Usage of database Create Import/input Query Reports Flat file vs. database Multiple concurrent users Scalability Speed Variety of data Records Storage Data persistence 5.2 Compare and contrast various database structures Structured vs. semi-structured vs. non-structured Relational databases Schema Tables Rows/records 503
Fields/columns Primary key Foreign key Constraints Non-relational databases Key/value databases Document databases 5.3 Summarize methods used to interface with databases Relational methods Data manipulation Select Insert Delete Update Data definition Create Alter Drop Permissions Database access methods Direct/manual access Programmatic access User interface/utility access Query/report builders Export/import Database dump 504
Backup “Data is the new oil.” You might have heard that phrase or one similar to it such as, “Data is the new currency” or “Data is the new bacon.” The person who coined the last phrase clearly rates bacon highly—perhaps a bit too much—but the point remains the same: In today’s world, data is an incredibly valuable commodity. An entire service industry has been built upon storing and managing data. Some companies have an entire business model revolving around acquiring and selling data to other interested companies. And, of course, you can’t forget about data analysis and modeling. Companies have so much data today that they often don’t know what to do with it. So, they employ teams of data scientists and analysts to mine the data, looking for a brilliant insight to unleash their company’s growth. All of this data needs to be stored somewhere, and that somewhere is a database. This chapter introduces you to database fundamentals. Much like Chapter 6, “Software Development,” this chapter won’t teach you everything there is to know—that can take years of study—but it will give you a fundamental understanding of why databases are used, the different types of databases, and how to work with databases. If this is a topic that interests you, dive deeper! Database administration can be a lucrative career path for those who are interested in it. Understanding Databases If someone asked you what a database does, you would probably answer, “It stores data.” You’d be absolutely correct. There are many different types of databases out there for different situations, but they definitely all store data. The differences are in how they store it and, more importantly, how a user extracts data from the database. 505
Databases are used in a variety of business settings. Banking, online retailers, government agencies, non-profits, and even bloggers use databases to store data that’s important to them or their customers. Databases can be stored on local workstations (Microsoft Access), stored on servers (Oracle, Microsoft SQL, or MySQL), or accessed via the cloud (Amazon Web Services, Microsoft Azure, Google, and

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture