Hướng dẫn làm task validate queries and answers năm 2024
This SQLite tutorial teaches you everything you need to know to start using SQLite effectively. In this tutorial, you will learn SQLite step by step through extensive hands-on practice. Show
This SQLite tutorial is designed for developers who want to use SQLite as the back-end database or to manage structured data in applications, including desktop, web, and mobile apps; SQLite is an open-source, zero-configuration, self-contained, stand-alone, transaction relational database engine designed to be embedded into an application. Getting started with SQLiteYou should go through this section if this is the first time you have worked with SQLite. Follow these 4-easy steps to get started with SQLite fast.
This section presents basic SQL statements that you can use with SQLite. You will first start querying data from the sample database. If you are already familiar with SQL, you will notice the differences between SQL standard and the SQL dialect used in SQLite. Section 1. Simple query
Section 2. Sorting rows
Section 3. Filtering data
Section 4. Joining tables
Section 5. Grouping data
Section 6. Set operators
Section 7. Subquery
Section 8. More querying techniques
Section 9. Changing dataThis section guides you on how to update data in the table using insert, update, delete, and replace statements.
Section 10. Transactions
Section 11. Data definitionIn this section, you’ll learn how to create database objects such as tables, views, and indexes using SQL data definition language.
Section 12. Constraints
Section 13. Views
Section 14. Indexes
Section 15. Triggers
Section 16. Full-text search
Section 17. SQLite tools
SQLite ResourcesIf you want to know more information about SQLite, you can go through a well-organized SQLite resources page that contains links to useful SQLite sites. |