Myers and Douglas assert that learners of SQL “have problems with language features, program concepts and the legacy of their prior learning”. After marching through all of the material, and multiple DBMSs covered in this textbook, learners will certainly move beyond beginner to higher levels of competency. Database processing is a heavyweight, with 605 pages. Getting started is a lightweight at 116 pages. In other words, ADbC explores the structured part of SQL that learners need to learn and experience in addition to the syntax of the language.ĭatabase engineers interested in learning the ins and outs of SQL with different database management systems should dive into Kroenke & Auer’s latest textbook, which takes a deep dive into all things relational database, and compares and contrasts Microsoft Access, MySQL, Microsoft SQL Server, and Oracle Database, and provides examples, exercises, and projects for each DBMS. In addition to having a handy guide, learners can learn about the various statements in Getting started and then execute them in the ADbC interactive SQL module to get instant feedback from a computer tutor about their misunderstandings or misconceptions.ĪDbC also provides modules on database design: entity-relationship (ER) notations and ER database transformations, functional dependencies, normalization, and denormalization transactions: concurrency and recovery and security: access control, security matrix, row-level security, SQL injection, database inference, and database auditing. ADbC is “a set of interactive modules designed to support the teaching of database concepts”. ĭata analysts interested in going deeper into SQL should review the animated database courseware (ADbC) site. Data carpentry develops and teaches workshops for “learners who have little to no prior computational experience.” Learners who have gotten a start with Getting started learning SQL on their own can expand their understanding during the tutor-assisted data carpentry workshops as they work more with SQL and SQLite on domain-specific assignments in the life, physical, and social sciences. This book pairs well with the data carpentry approach for universal data literacy, which also uses SQLite. Appendix A details SQL operators and functions. Chapter 9 covers database design with the CREATE TABLE statement, and chapter 10 summarizes the SQL statements for managing data: INSERT, DELETE, TRUNCATE TABLE, UPDATE, and DROP TABLE. The book utilizes the popular SQLite database management system (DBMS) and its sidekick SQLite Studio, rather than the typical use of Microsoft Access in introductory database books. Chapter 4 introduces the SELECT statement, and most of the remaining chapters describe the various clauses that go with it. This book offers a fresh and friendly approach for nontechnical people to learn SQL. The answer, in my opinion, is an unqualified yes, if it has the scope and pedagogy of this one. Nield T., O’Reilly Media, Inc.,Sebastopol, CA,2016. 134 pp.Type:Bookĭoes the world really need another book on structured query language (SQL)? A quick search on Amazon returned 17,355 results for books with “SQL” in the title. Getting started with SQL :a hands-on approach for beginners
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |