SQLite Fundamentals - Up and Running course is designed to let you learn the nitty gritties of SQLite.
SQLite is a small, fast, self-contained, high reliability, full featured SQL database engine. On top of that SQLite is FREE!
In this course, we will first introduce you to the Fundamentals of SQLite i.e. what is SQLite, its features and limitations as well why you might choose to use it .
We then move on to how to get SQLite to run on your computer. In this section, we will introduce you to a sample database that we will be using throughout the course as well as install SQLite Studio which is a Graphical User Interface (GUI) that we will be using to drive the SQLite database side by side with Command Prompt or more commonly, the terminal.
The next section is Basic SQLite Statements. Here you will learn the important statements or commands as well as clauses that are required to work with SQLite. Some of the statements we cover are: the SELECT Statement, WHERE, ORDER BY, DISTINCT and LIMIT clauses. After every lesson, we have Quizzes so as to reinforce the knowledge and make sure that you understood it.
The last section is SQLite Database Objects and Aggregate Functions. Here, we talk about the SQLite Data Types and the related statements such as the SQLite Create Table Statement.
Each and every lesson has live examples that you can also try on your own. The examples are done on both the terminal as well as on the Graphical User Interface.
At the end of the course, you will be a SQLite master who is able to run SQLite, and at the very least perform CRUD [Create, Read, Update and Delete] operations on a SQLite Database.
So what are you waiting for? Enroll now and get up and running with SQLite!
- Will power to learn and complete the exercises.
- Basic computer skills to be able to install the software and tools we will use in the course.