Welcome to part 4 of my SQLite3 Tutorial! I cover an enormous amount of information on SQLite3 here.

I cover all of the following: Review of most everything from previous SQlite3 tutorials, SQLite3 ENUMs, Composite Primary Keys, dates, data types, data affinities, joins, inner join, left join, natural join, cross join, ON, GROUP BY, select statements inside of select statements, views, triggers and more. If you missed the previous parts look here SQLite3 Tutorial, Part 2 & Part 3. Continue reading SQLite3 Tutorial 4 →

Welcome to part 3 of my SQLite3 Tutorial! Here I will cover a TON of commands for SQLite3. If you want a video that covers a ton on SQL you are in the right place.

All of the following are covered in the video and the code that follows: SELECT, FROM, WHERE, COLLATE, NOT NULL, DEFAULT, UNIQUE, CHECK, FOREIGN KEY, REFERENCES, ALTER, ADD COLUMN, RENAME, AND, OR, LIKE, NOT LIKE, ORDER BY, LIMIT, OFFSET, AS, UPDATE, DELETE, and more. I also cover a bunch of arithmetic, boolean, bitwise, relational and other operators. Continue reading SQLite3 Tutorial 3 →

Welcome to part 2 of my SQLite3 Tutorial. Today I’m going to talk about something that is always ignored in most database tutorials. I’ll show you how to alphabetize a multidimensional array. I’ll also show you the code you can use to generate insert statements so you can save yourself a ton of time.

If you missed part 1 you should watch it first here SQLite3 Tutorial. All of the code used in the video is available below. I hope you find it to be useful. Continue reading SQLite3 Tutorial 2 →

Welcome to my SQLite3 Tutorial! This tutorial is part of my Android Development Tutorial, so my Android tutorial is not over. I have many more videos on Android coming.

In this video I explain how to install SQLite3 on both Mac and Windows. I also cover how to use SQLite3 using the console. SQLite is an embedded relational database that doesn’t require a dedicated database management system. The database is part of your code and not an outside resource. The reason for creating SQLite was to provide a self contained database that was easy to use, could travel with the program using it and run on any machine with no other required software. Continue reading SQLite3 Tutorial →