Web site dạy SQLite database rất chi tiết


http://www.sqlitetutorial.net/

SQLite Tutorial

This SQLite tutorial teaches you everything you need to know to start using SQLite effectively. You will learn SQLite through extensive hands-on practices.

SQLite TutorialIf you have been working with other relational database management systems e.g., MySQL, PostgreSQL, Oracle, Microsoft SQL Sever, etc., and you heard about SQLite. And you are curious to know more about it.

If your friends recommended you use SQLite database instead of simple files to manage structured data in your applications. You want to get started with SQLite immediately to see if you can utilize it for your apps.

If you are just starting out learning SQL and want to use SQLite as the database system.

If you are one of the people described above, this SQLite tutorial is for YOU.

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 SQLite

You should go through this section if this is the first time you have worked with SQLite. Follow these 3-easy steps to get started with SQLite fast.

  1. First, we help you answer the first important question: what is SQLite? You will have a brief overview of SQLite before you start working with it.
  2. Second, we show you step by step how to download and install SQLite GUI tool on your computer.
  3. Third, we introduce you to an SQLite sample database and walk you through the steps of using the sample database for practicing.

Basic SQLite tutorial

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 SQL dialect in SQLite.

  • SQLite Select – query data from a single table using SELECT statement.
  • SQLite Order By – sort the result set in either ascending or descending order.
  • SQLite Select Distinct – query unique rows from a table using the DISTINCT clause.
  • SQLite Where  – filter rows of a result set using various conditions.
  • SQLite Limit – constrain the number of rows that you want to return. The LIMIT clause helps you get necessary data returned by a query.
  • SQLite IN – check if a value matches any value in a list of value or subquery.
  • SQLite Like – query data based on pattern matching using wildcard characters: percent sign (%) and underscore (_).
  • SQLite Glob – determine whether a string matches a specific UNIX-pattern.
  • SQLite Group By – combine set of rows into groups based on specified criteria. The GROUP BYclause helps you summarize the data for reporting purposes.
  • SQLite Having – specify the conditions to filter the groups summarized by the GROUP BY clause.
  • SQLite Inner Join – query data from multiple tables using inner join clause.
  • SQLite Left Join – combine data from multiple tables using left join clause.
  • SQLite Cross Join – show you how to use the cross join clause to produce a cartesian product of result sets of the tables involved in the join.
  • SQLite Self Join – join a table to itself to create a result set that joins rows with other rows within the same table.
  • SQLite Union – combine result sets of multiple queries into a single result set. We also discuss the differences between UNION and UNION ALL clauses.
  • SQLite Full Outer Join – show you how to emulate the full outer join in the SQLite using left join and union clauses.
  • SQLite Case – add conditional logic to the query.
  • SQLite Subquery – introduce you to the SQLite subquery and correlated subquery.

Mastering update data in SQLite

This section guides you how to update data in the table using insert, update, and delete statements.

Working with database objects

In this section, we show you how to create database objects such as tables, views, indexes using SQL data definition language.

  • SQLite Data Types – introduce you to the SQLite dynamic types system and its important concepts: storage classes, manifest typing, and type affinity.
  • SQLite Create Table – show you how to use the CREATE TABLE statement to create a new table in the database.
  • SQLite Primary Key – show you how to use PRIMARY KEY constraint to define the primary key for a table.
  • SQLite AUTOINCREMENT – explain how AUTOINCREMENT attribute works and why you should avoid using it.
  • SQLite Alter Table – show you how to use the ALTER TABLE statement to add a new row into an existing table and to rename a table. We also provide the steps for performing other actions such as drop a column, rename a column, etc.
  • SQLite Drop Table – guide you how to remove a table from the database.
  • SQLite Create View – introduce you to the view concept and show you how to create a new view in the database.
  • SQLite Index – teach you about the index and how to utilize indexes to speed up your queries.
  • SQLite Index For Expressions – shows you how to use expression based index to
  • SQLite VACUUM – optimize database file.
  • SQLite Trigger – manage triggers in SQLite database.

SQLite functions

SQLite aggregate functions

An aggregate function groups values of multiple rows into a single value that produces the measurement of the group e.g., minimum, maximum, average, total, etc. SQLite supports the following aggregate functions:

  • SQLite AVG – return the average value of a group of values.
  • SQLite COUNT – count the number of items in a set.
  • SQLite MAX – find the maximum value in a set of values.
  • SQLite MIN – find the minimum value in a set of values.
  • SQLite SUM – return the sum of values in a set.

SQLite Programming Interfaces

SQLite Java

This SQLite Java section teaches you step by step how to interact with SQLite database using Java JDBC API.

SQLite Python

This section guides you how to work with the SQLite database using Python sqlite3 module.

SQLite PHP

This section shows you how to use PHP PDO to interact with SQLite databases. We will walk you through the steps of setting up PHP project structure, connecting to the SQLite database, and performing the common database operations.

SQLite resources

If 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.

 

I re-post for me

Advertisements

Phản hồi

Mời bạn điền thông tin vào ô dưới đây hoặc kích vào một biểu tượng để đăng nhập:

WordPress.com Logo

Bạn đang bình luận bằng tài khoản WordPress.com Đăng xuất / Thay đổi )

Twitter picture

Bạn đang bình luận bằng tài khoản Twitter Đăng xuất / Thay đổi )

Facebook photo

Bạn đang bình luận bằng tài khoản Facebook Đăng xuất / Thay đổi )

Google+ photo

Bạn đang bình luận bằng tài khoản Google+ Đăng xuất / Thay đổi )

Connecting to %s