Buy A Guide to SQL, 10th Edition PDF ebook by author Mark Shellman; Hassan Afyouni; Philip J. Pratt – 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 A Guide to SQL, 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.
eBook Details:
Full title: A Guide to SQL, 10th Edition
Edition: 10th
Copyright year: 2021
Publisher: Cengage Learning
Author: Mark Shellman; Hassan Afyouni; Philip J. Pratt
ISBN: 9780357419830, 9780357419830
Format: PDF
Description of A Guide to SQL, 10th Edition:
Master today’s SQL programming principles and learn how to effectively apply your SQL skills with Shellman/Afyouni/Pratt/Last’s A GUIDE TO SQL, Tenth Edition. This edition’s leading approach combines straightforward instruction and extensive hands-on exercises with a strong foundation and emphasis on today’s actual business applications. This edition introduces basic SQL commands in the context of an intriguing, ongoing case in which a business uses SQL to manage orders, items, customers and sales reps. This edition emphasizes how to apply fundamental principles and strengthen your programming practices, regardless of the database environment. You work with examples from the latest versions of MySQL, the world’s most popular open source, free database, as well as Oracle and Microsoft SQL Server.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 A Guide to SQL, 10th Edition PDF ebook:
Table of ContentsPrefaceAbout the AuthorsModule 1: Introduction to KimTay Pet Supplies and StayWell Student Accommodation DatabasesIntroductionWhat Is a Database?The KimTay Pet Supplies DatabaseStayWell Student Accommodation DatabaseModule SummaryKey TermCase ExercisesModule 2: Database Design FundamentalsIntroductionDatabase ConceptsFunctional DependencePrimary KeysDatabase DesignNormalizationDiagrams for Database DesignModule SummaryKey TermsReview QuestionsCase ExercisesModule 3: Creating TablesIntroductionCreating and Running SQL CommandsCreating a DatabaseCreating a TableUsing Data TypesUsing NullsAdding Rows to a TableViewing Table DataCorrecting Errors in a TableSaving SQL CommandsCreating the Remaining Database TablesDescribing a TableModule SummaryKey TermsReview QuestionsCase ExercisesModule 4; Single-Table QueriesIntroductionConstructing Simple QueriesSortingUsing FunctionsNesting QueriesGroupingNullsSummary of SQL Clauses, Functions, and OperatorsModule SummaryKey TermsReview QuestionsCase ExercisesKimTay Pet SuppliesStayWell Student AccommodationModule 5: Multiple-Table QueriesIntroductionQuerying Multiple TablesComparing Joins, IN, and EXISTSSet OperationsALL and ANYSpecial OperationsModule SummaryKey TermsReview QuestionsCase ExercisesKimTay Pet SuppliesStayWell Student AccommodationModule 6: Updating DataIntroductionCreating a New Table from an Existing TableChanging Existing Data in a TableAdding New Rows to an Existing TableAutocommit, Commit, and RollbackTransactionsChanging and Deleting Existing RowsChanging a Value in a Column to NullChanging a Table’s StructureDropping a TableModule SummaryKey TermsReview QuestionsCase ExercisesKimTay Pet SuppliesStayWell Student AccommodationModule 7: Database AdministrationIntroductionCreating and using ViewsUsing a View to Update DataDropping a ViewSecurityIndexesSystem CatalogIntegrity Constraints in SQLModule SummaryKey TermsReview QuestionsCase ExercisesModule 8: Functions, Procedures, and TriggersIntroductionUsing SQL in a Programming EnvironmentUsing FunctionsConcatenating ColumnsStored Procedures Using MySQLError HandlingUsing Update ProceduresSelecting Multiple Rows with a ProcedureUsing PL/SQL in OracleUsing T-SQL in SQL ServerUsing a TriggerModule SummaryKey TermsReview QuestionsCase ExercisesKimTay Pet SuppliesStayWell Student AccommodationAppendix A: SQL ReferenceAppendix B: How Do I ReferenceAppendix C: The 10 Commandments of Writing QueriesIndex
