MS Access 2016 SQL Comprehensive

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.

這本書主要是為大學、技術學院或技術學校的培訓/教育環境而設計的。其目標是從Access 2016 SQL的零基礎開始，提升至熟練專業的水平。為此，書中包含了31個章節的319個練習題，學生可以在課堂時間內完成。每個章節後還有十個問題，教師可以用於課堂討論或測試生成。整本書共有320個案例問題。最後，書中還包含了60個案例研究，每個章節末尾有兩個，供學生作為作業或加強每個章節所學技能之用。

這本書是作者在大學教學二十一年和在數據庫實踐二十五年的結晶。在數百個實驗室和學生的數千個問題和評論之後，Pindaro撰寫了這本書，以幫助學生成為SQL專家。目前，無論職位、行業還是工作職能，似乎每個人都需要SQL技能。

對於教師而言，Pindaro試圖使這本書盡可能友好。首先，他親自在課堂上測試了這本書，以了解實際培訓環境中實驗室的運作情況。其次，他提供了大量關於真實業務場景的案例研究和問題，讓學生能夠體會到SQL在工作和業務中的威力。第三，他準備了一本單獨的小冊子，教師可以作為Word或PDF文件（在確認教師身份後）獲得，其中包含案例研究的解決方案並提供代碼建議的提示。目標是學習如何將數據庫應用於真實的業務任務中。作者在過去的二十五年中一直在從事數百個商業數據庫和運營系統的工作。Pindaro對數據庫的激情始於1991年的DBase III，繼續到自1993年初以來的所有Access版本，並在MS SQL Server、MySQL、Oracle和IBM DB2上工作了多年。他仍然熱愛它們。在超過二十五年的時間裡，他仍然從事數據、業務分析、數據集成和可視化的工作。