SQLite Archives - Essential SQL

Tag Archive

Tag Archives for " SQLite "

What is SQLite3?

SQLite3 Review SQLite3 is a compact free database you can use easily create and use a database. Though SQLite3 is not a full-featured database, it supports a surprisingly large set of the SQL standard, and is ideal for those just starting to learn SQL as well for developers that need a simple database engine to […]

Query Results Using Boolean Logic

In today’s lesson you’re going to learn how to query results using the WHERE clause. The objectives of today’s lesson are to: Learn to use more than one compare condition at a time using Boolean logic Comprehensive example with Select, Where, and Order By Using Multiple Conditions to Query Results In previous lesson’s we learned how […]

How to Filter Query Results

In today’s lesson you’re going to learn how filter the results returned from your queries using the WHERE clause. This clause is important as only those records matching the where clause’s conditions are returned in the query results. The objectives of today’s lesson are to: Learn about various condition types, such as Equality, Range, and […]

How to sort results using SQLite

In this lesson you are going to explore how to sort your query results by using SQL’s ORDER BY statement. Using this phrase allows us to sort our result in ascending or descending order. In addition you can limit your query to a specified number of results. The lesson’s objectives are to: learn how to […]

Learn to Write Simple Queries with SQLite

In this series of lessons you’re going to learn how to query the sample database using the SQL Select statement. Once you have read this blog and viewed the series of videos you’ll be able to: Identify all the tables in a SQLite database. Understand how to list a table’s columns. Use the SQL Select statement […]

How to Install SQLite and the Sample Database

This is the first in a series of lessons devoted to teaching you SQL. We are going to install SQLite and then move on to the fundamentals , which means learning the command line. Do worry it is not as hard as it seem, and really, the payoff is huge. For once you learn SQL […]