Learn SQL fundamentals with interactive lessons on SELECT, INSERT, UPDATE, and DELETE. Practice filtering and grouping using WHERE, GROUP BY, HAVING, and ORDER BY. Explore table relationships through JOIN types.
The app offers a visual tree view for JSON editing, with plugins for array tables and jq processing. It includes format conversion between JSON, PLIST, YAML, and TOML, along with JSONPath search capabilities and node operations.
Manage multiple databases through project-based organization. Execute SQL queries, create and edit tables, and browse data visually. Export results to CSV or SQL format. Import and export files. Set up and manage indexes.
The app provides HTML5 webpage development tools and tutorials. It includes a code editor, file system management, and sample files for features like Canvas drawing and WebGL.
