![]() 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. Supports multiple windows for iPadOS 13 or later.Getting started with SQL :a hands-on approach for beginners.In Data Editor, supports export data to Insert Statement or Update Statement if possible.In Data Editor or Query Results, supports export data to CSV, JSON or Markdown.Supports show a summary of the differences between two databases.Supports generate SQL text that can let you transform a database content into another.This feature may help you get more insight about your SQLite databases' data storage information, which may let you see if there're any chances to let SQLite working in a more effective way in your device. Supports show size of each table's index.Supports show size of each table's content.Supports show records count of each table.Supports drag and drop to import or export SQLite databases and SQL files in iPad.Supports let SQLiteFlow(macOS) connect databases in this app.Supports display each table's name and records count.View, edit or add table fields, indexes, foreign keys, checks.Edit blob data as hex or show it as preview if possible.Sort records by tapping on column title.View table data with a convenient filter.Supports open external SQL files, CSV files and Filter files. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |