From the introduction to Self-Guided SQL – I continue to define my use of A.I. every day as the tools evolve and I face new situations but this still sums it up well. There is one thing that will not change as long as I continue to create and share content and that is that […]
Python and SQLite
I’m starting another review of my recently published book, Self-Guided SQL: Build Your SQL Skills with SQLite, looking for anything I might have missed, and one thought I had was adding more material on how to access SQLite from programming environments. A couple of months ago, I uploaded a video on how to create a […]
Read Time:
3 Min
Using Console Commands in SQLite
The SQLite console, also known as the command line interface or CLI, is a powerful tool for working with SQLite databases. While many people, myself included, often prefer a graphical environment, there are a lot of things that can be done quickly in the console with its collection of commands. There are dozens of commands […]
Read Time:
26 Min
How To Navigate the SQLite Command Line
(The following is adapted from a chapter of the upcoming book, Self-Guided SQL: Build Your SQL Skills with SQLite. You can download the sample databases referenced on the Github project page.) Database software often comes with different types of interfaces including graphical, menu-based browsers and text-only console programs. While browser programs are easier to navigate, […]
Read Time:
19 Min
Excerpt: Self-Guided SQL (Upcoming Book)
If you work with big data, SQL is an essential skill. It’s also a great introductory language for those wanting to learn programming. The good news is that it’s easy to learn and you don’t have to spend big money to do it.
Read Time:
10 Min