Access 2016 SQL Comprehensive
Purchasing Alternatives
Help is here: If something is not working with links, payments, or downloads, do not hesitate to email us at demerp@alphapresspublishing.com and we will respond ASAP with instructions and solutions.
Download the sample database for MS Access 2016 SQL Comprehensive
Book Description
This book is primarily intended for a training/educational environment in a College, University, or technical school. The goal is to start from point zero in Access 2016 SQL and arrive at the level of a skilled professional. To that purpose it contains 319 exercises in 31 chapters which the student can complete during class time. It also contains ten questions after each chapter which the instructor can use for in class discussions or test generation. There are 320 case questions in total in the book. Finally, it contains sixty case studies, two at the end of each chapter, for additional work as homework or for sharpening the skills learned through each chapter.
The book is the result of the author’s twenty-one years of teaching at the University level and twenty-five years of practice on databases. After hundreds of labs and thousands of questions and comments from the students, Pindaro wrote this book to assist the students in becoming SQL experts. Currently, no matter the position, industry, or job function, it looks like everyone is asking for SQL skills.For the instructor, Pindaro tried to make this book as friendly as possible. First, he personally tested the book in class to see how the labs work in the real training environment. Second, he has provided a multitude of case studies and questions on real business scenarios so that the students can appreciate the power of SQL for work and business. Third, he has prepared a separate booklet the instructor can receive as a word or pdf file (upon confirmation of instructor status) that includes the solutions to the case studies and provides hints for the code proposed.
The goal is to learn how to use databases for real business tasks. The author has worked on hundreds of business databases and operational systems for the last twenty-five years. Pindaro's exciting relationship with databases started with DBase III back in 1991, continuing with all versions of Access since early 1993, and working with MS SQL Server, MySQL, Oracle, and IBM DB2 for a number of years. He is still in love with all of them. After more than twenty-five years, he still works with data, business analytics, data integration, and visualization.
The goal is to learn how to use databases for real business tasks. Pindaro has worked on hundreds of business databases and operational systems for the last 19 years. Pindaro's exciting relationship with databases started with DBase III back in 1991, continuing with all versions of Access since early 1993, and working with MS SQL Server, MySQL, Oracle, and IBM DB2 for a number of years. He is still in love with all of them. After twenty years, he still works with data, information processing, integration, and dissemination.
Book Table of Contents
CHAPTER 1 SQL FOUNDATION FOR BUSINESS.. 1
CHAPTER 2 CREATE, EDIT, AND DELETE TABLES USING SQL.. 23
CHAPTER 3 CREATE, EDIT, AND DELETE INDEXES USING SQL.. 36
CHAPTER 4 CREATE, EDIT, DELETE RELATIONSHIPS USING SQL.. 47
CHAPTER 5 THE SELECT STATEMENT.. 62
CHAPTER 6 THE OR and AND OPERATORS.. 77
CHAPTER 7 SORTING RECORDS: THE ORDER BY CLAUSE.. 86
CHAPTER 8 WORKING WITH WILDCARD CHARACTERS.. 96
CHAPTER 9 THE LIKE OPERATOR.. 104
CHAPTER 10 EQUALITY AND INEQUALITY PREDICATES.. 117
CHAPTER 11 THE BETWEEN OPERATOR.. 126
CHAPTER 12 THE IN OPERATOR.. 136
CHAPTER 13 THE DISTINCT PREDICATE.. 146
CHAPTER 14 THE TOP PREDICATE.. 155
CHAPTER 15 CALCULATED FIELDS.. 166
CHAPTER 16 CONCATENATED FIELDS.. 180
CHAPTER 17 THE GROUP BY CLAUSE.. 193
CHAPTER 18 AGGREGATE FUNCTIONS.. 207
CHAPTER 19 CROSSTAB QUERIES.. 221
CHAPTER 20 PARAMETER QUERIES.. 239
CHAPTER 21 CONDITIONAL DATA MANIPULATION... 250
CHAPTER 22 UNION OPERATIONS.. 267
CHAPTER 23 DUPLICATE, ORPHANED, and UNRELATED RECORDS.. 283
CHAPTER 24 WORKING WITH NULLS.. 296
CHAPTER 25 TYPE CONVERSION FUNCTIONS.. 307
CHAPTER 26 WORKING WITH STRINGS.. 319
CHAPTER 27 WORKING WITH DATES.. 338
CHAPTER 28 UPDATE SQL STATEMENTS.. 369
CHAPTER 29 DELETE STATEMENTS.. 381
CHAPTER 30 WORKING WITH JOINS.. 398
CHAPTER 31 WORKING WITH SUB-QUERIES.. 417
APPENDIX I THE SAMPLE DATABASE.. 434
INDEX OF TERMS.. 435