![]() 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. * Open source and free - Released under GPLv2 licence.Getting started with SQL :a hands-on approach for beginners Binary distribution is just the single, ready to use file. * Single executable file - no need to install or uninstall. ![]() * Configurable colors, fonts and shortcuts. ![]() * skinnable (interface can look native for Windows 9x/XP, KDE, GTK, Mac OS X, or draw widgets to fit for other environments, WindowMaker, etc), * Numerous small additions, like formatting code (uppercase keywords), fast navigation between windows and tabs in notebooks by shortcuts, history of queries executed in editor windows and more, * Pretty fast handling of tables with lots of data (tables data preview and SQL queries results are split and displayed in smaller pieces), * Exporting to various formats (SQL statements, CSV, HTML, XML), * Localizations, currently translated to: Mac OS X support is partially done, but dont expect to run SQLiteStudio on it yet - support for this system is planned, * Cross-platform - runs on Windows 9x/2k/XP/2003/Vista/7, Linux, Solaris, FreeBSD and should work on other Unixes (not tested yet). * Some features implemented on top of basic SQLite3/SQLite2 SQL statements, like editing all existing objects, or Foreign Keys transparent emulation, * All SQLite3 and SQLite2 features wrapped witin simple GUI, SQLiteStudio is a SQLite database manager with the following features:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |