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.
If you like videos like this, it helps to tell Google+ with a click here [googleplusone]
Code From the Video
Great tutorial, thanks.
Thank you and you’re very welcome 🙂
Hello, thanks a lot for all of your tutos !
I have one question about this one and an other more general (by the way I’m french so if there is some sentences that aren’t int good English it is normal 🙂 )
My first question is : do you know how to use the auto completion in sqlite3 ? Because while I watched your video I see you typing really fast and I might know I to do the same 🙂
And secondly how did you learn all of this, because the is a huge collection of videos on your site. Do your learn all on the way of making your videos ? Or do you have some references to learn more ?
Thanks one more time !
You’re very welcome 🙂 There is no auto complete with SQLite. It probably seems like there is only because of how I edit the video. Sorry about the confusion.
I have always enjoyed learning. That is pretty much all I have ever done. Every job I ever had required me to learn constantly. I don’t have any other hobbies.
I got pretty good at making videos and teaching through practice and from taking the advice I received. I was terrible when I first started.
There isn’t anything particularly special about me. I’m just used to this stuff and I really enjoy teaching.
Thank you for stopping by my little site 🙂
Derek
Thank you so much. I love your videos. This series in sql was particularly inspiring to me. At first I was a bit suspicious about leaving all the java and compiler stuff and going into the “wierd world of command line” but I thought “you know what, I really trust this guy to be leading me in the best direction and compelling me to learning what actually matters” I dove deeply into this series sqlite and I am so glad I did 🙂
I’m very happy that you enjoyed it 🙂 Yes SQLite is a great little database tool
I have a question that I hope you may answer.
supose I have a table
CREATE TABLE desabafo (key int primary key, date datetime default current_timestamp, descricao text);
where descricao might be a rather long text and I would like to output it in .mode column and .headers on but I need to format it to say 15 characters per line in order to get a nice output. how would I accomplish this?(hope I explained myself clearly)
Sorry, but I’m not sure what your trying to do. Sorry about that
Just watched all 4 tutorials and followed along the source code. What a powerful tool for being so small. I’m following along with both your Java and Android lessons and I’m at the point where they both pause for SQL. Is there anything in particular I would miss if I substituted these android SQL tutorials for the Java ones?
I’m glad you are enjoying them. In Java I cover MySQL and in Android I cover SQLite. Both are very different from each other. I hope that helps 🙂
Ok, thanks so much. I’ll be sure to watch them both them. 8)
Grate stuff 🙂
Thank you 🙂
Thank you, Derek. Just want to let you know I watched all 4 tutorials on SQLite 🙂
You’re very welcome 🙂 I’m glad you enjoyed them.
Hey Derek,
Very nice tutorials on SQLite. Thanks for your time on this. I’m watching your android tutorials and it is a great learning experience. 🙂
Hey Naresh,
You’re very welcome 🙂 I’m glad you are finding the tutorials useful.
Really great tutorials on sqlite, moving at break-neck speeds although that may be because only been learning 7 days now. And once out found out what the ‘BLEEP’ a foreign key did #4 is sinking in… SLOWLY. Thanks.
Thank you 🙂 Yes I move quicker then most tutorials. I’m glad you like them.
I found the answer…
sqlite> SELECT test.date AS DATE,
…> MIN(test_score.score) AS WORST,
…> MAX(test_score.score) AS BEST
…> FROM test_score, test
…> WHERE test_score.test_id = test.test_id
…> and test_score.score >=0
…> group by test.date;
This also works:
…> and test_score.score not like ‘%-%’