Buy Concepts of Database Management, 10th Edition PDF ebook by author Lisa Friedrichsen; Lisa Ruffolo; Ellen Monk – published by Cengage Learning in 2021 and save up to 80% compared to the print version of this textbook. With PDF version of this textbook, not only save you money, you can also highlight, add text, underline add post-it notes, bookmarks to pages, instantly search for the major terms or chapter titles, etc.
You can search our site for other versions of the Concepts of Database Management, 10th Edition PDF ebook. You can also search for others PDF ebooks from publisher Cengage Learning, as well as from your favorite authors. We have thousands of online textbooks and course materials (mostly in PDF) that you can download immediately after purchase.
Note: e-textBooks do not come with access codes, CDs/DVDs, workbooks, and other supplemental items.
- Full title: Concepts of Database Management, 10th Edition
- Edition: 10th
- Copyright year: 2021
- Publisher: Cengage Learning
- Author: Lisa Friedrichsen; Lisa Ruffolo; Ellen Monk
- ISBN: 9780357422212, 9780357422212
- Format: PDF
Description of Concepts of Database Management, 10th Edition:
Strengthen your understanding of database management today with the hands-on, thorough presentation found in CONCEPTS OF DATABASE MANAGEMENT, 10th Edition. Real cases, practical examples and helpful screenshots with concise explanations clarify database design, data integrity, normalization, concurrent updates, data security and big data. Completely updated content reflects Microsoft Access 2019, Office 365 standards and SQL Server 2019, while exploring SQL in a database-neutral environment. Detailed coverage presents the relational model (including QBE and SQL), normalization and views as well as database administration and management. You also examine advanced topics, such as distributed databases, data warehouses, stored procedures, triggers, data macros and Web Apps. Trust this contemporary introduction to help you master today’s database techniques to advance your career in any field.Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Table of Contents of Concepts of Database Management, 10th Edition PDF ebook:
Brief ContentsContentsPrefaceModule 1: Introduction to Database ManagementIntroductionJC Consulting Company BackgroundSelecting a Database SolutionStoring DataIdentifying Database Management SystemsAdvantages of a Properly Designed Relational DatabaseBig DataPreparing for a Career in Database Administration and Data AnalysisIntroduction to the Pitt Fitness Database CaseIntroduction to the Sports Physical Therapy Database CaseSummaryKey TermsModule Review QuestionsJC Consulting Case ExercisesPitt Fitness Case ExercisesSports Physical Therapy Case ExercisesModule 2: The Relational Model: Introduction, QBE, and Relational AlgebraIntroductionExamining Relational DatabasesCreating Simple Queries and Using Query-By-ExampleUsing Simple CriteriaUsing Compound CriteriaCreating Computed FieldsSummarizing with Aggregate Functions and GroupingSorting RecordsJoining TablesUsing an Update QueryUsing a Delete QueryUsing a Make-Table QueryOptimizing QueriesExamining Relational AlgebraSummaryKey TermsModule Review QuestionsJC Consulting Case Exercises: QBEJC Consulting Case Exercises: Relational AlgebraPitt Fitness Case ExercisesSports Physical Therapy Case ExercisesModule 3: The Relational Model: SQLIntroductionGetting Started with SQLCreating a TableSelecting DataUsing Compound Conditions: AND CriteriaUsing Compound Conditions: OR CriteriaUsing the BETWEEN OperatorUsing the NOT OperatorCreating Calculated FieldsUsing Wildcards and the LIKE OperatorUsing the IN OperatorSorting RecordsUsing Aggregate FunctionsGrouping RecordsWriting SubqueriesJoining Tables with the WHERE ClauseUsing the UNION OperatorUpdating Values with the SQL UPDATE CommandInserting a Record with the SQL INSERT CommandDeleting Records with the SQL DELETE CommandSaving Query Results as a TableDeveloping Career Skills: SQLSummaryKey TermsModule Review QuestionsJC Consulting Case ExercisesPitt Fitness Case ExercisesSports Physical Therapy Case ExercisesModule 4: The Relational Model: Advanced TopicsIntroductionCreating and Using ViewsUsing IndexesExamining Database Security FeaturesEnforcing Integrity RulesChanging the Structure of a Relational DatabaseUsing SQL JOIN CommandsUsing the System CatalogUsing Stored Procedures and TriggersCareer Skills: Database AdministratorsSummaryKey TermsModule Review QuestionsJC Consulting Case ExercisesPitt Fitness Case ExercisesSports Physical Therapy Case ExercisesModule 5: Database Design: NormalizationIntroductionCase Study: Faculty/Student Advising AssignmentsData Modification AnomaliesFunctional DependenceKeysFirst Normal FormAtomic ValuesAlgorithmsCreating FieldsUpdating FieldsCreating the 1NF TableUsing Atomic Values for QuantitiesFinding Duplicate RecordsSecond Normal FormBenefits of NormalizationThird Normal FormFourth Normal FormBeyond Fourth Normal FormSummaryKey TermsModule Review QuestionsJC Consulting Case ExercisesPitt Fitness Case ExercisesSports Physical Therapy Case ExercisesModule 6: Database Design: RelationshipsIntroductionUser ViewsDocumenting a Relational Database DesignSetting Keys and IndexesEntity-Relationship (E-R) DiagramsThe Entity-Relationship Model (ERM)Exploring One-to-Many Relationships in AccessWorking with One-to-Many Relationships in Query Datasheet ViewOther Relationship TypesSummaryKey TermsModule Review QuestionsJC Consulting Case ExercisesPitt Fitness Case ExercisesSports Physical Therapy Case ExercisesModule 7: Database Management Systems Processes and ServicesIntroductionCreate, Read, Update, and Delete DataProvide Catalog ServicesSupport Concurrent UpdatesRecover DataProvide Security ServicesProvide Data Integrity FeaturesSupport Data IndependenceSupport Data ReplicationSummaryKey TermsModule Review QuestionsJC Consulting Case ExercisesPitt Fitness Case ExercisesSports Physical Therapy Case ExercisesModule 8: Database Industry CareersIntroductionCareers in the Database IndustryRole of a Database AdministratorDatabase Policy Formulation and EnforcementDatabase Technical FunctionsDatabase Administrative FunctionsProfessionals Reporting to the DBAResponsibilities of a Data AnalystResponsibilities of a Data ScientistDatabase Industry CertificationsSummaryKey TermsModule Review QuestionsJC Consulting Case ExercisesPitt Fitness Case ExercisesSports Physical Therapy Case ExercisesModule 9: Database Industry TrendsIntroductionDatabase ArchitecturesPersonal Computer RevolutionClient/Server ArchitectureData WarehousesDistributed DatabasesSelecting a Relational Database SystemNoSQL Database Management SystemsObject-Oriented Database Management SystemsBig DataData FormatsData Visualization ToolsSummaryKey TermsModule Review QuestionsJC Consulting Case ExercisesPitt Fitness Case ExercisesSports Physical Therapy Case ExercisesAppendix A: Comprehensive Design Example: Douglas CollegeAppendix B: SQL ReferenceAppendix C: FAQ ReferenceAppendix D: Introduction To MySQLAppendix E: A Systems Analysis Approach to Information-Level RequirementsGlossaryIndex