5.00(1)

How To Create and Manage SQLite Databases From Scratch

Are you a Developer looking to learn how to create and manage databases using SQLite? Or maybe you’re new to databases and you just don’t know where to start… Then my Complete SQLite Databases Course is For You! Here is what you will learn in my complete SQLite Databases Course: In my complete SQLite Databases […]

Instructor dev
Updated May 12, 2024

About Course

  • Are you a Developer looking to learn how to create and manage databases using SQLite?
  • Or maybe you’re new to databases and you just don’t know where to start…
    Then my Complete SQLite Databases Course is For You!
    Here is what you will learn in my complete SQLite Databases Course:
    In my complete SQLite Databases course you will learn how to create a reliable SQLite database from scratch. You will learn:
  • How to create tables and insert records into them
  • Update and delete records in a database
  • SQLite shell commands
  • Useful functions available in SQLite
  • Different Datatypes available in SQLite
  • All of the complexities of Date in SQLite
  • Constraints on columns
  • Advanced Queries
  • Joining tables together
  • Subqueries
  • Creating views
  • Group By and Having clauses
  • Transactions
  • Triggers on tables

You will also learn how to manage existing SQLite databases and even do things that seem impossible in SQLite …

  • Like how to create views that can be used to insert, update and delete records
  • How to customize constraints so that you can apply them to your tables
  • Android Studio Specific Database Lessons
  • And so much more!

But that’s not all you receive by enrolling in this course
I have added multiple video lessons on how to implement SQLite in Android studio!
I will also be uploading and adding additional content with practice activities to give you a hands on learning experience
_________________________________________________________________________
Who is This Course For?
This course is perfect for any developer looking for a way to create a fast, light weight, and easy to use database in their applications
So whether you’re an Android Developer, iOS Developer, Python Developer, or any developer in-between..
This course is perfect for you!
_________________________________________________________________________
The benefits of this course are absolutely unlimited!
I believe the best way to learn is by DOING. That is why we have multiple mini projects in each and every section of our course! These hands on projects will allow you to not only learn by watching, but by DOING as well.
_________________________________________________________________________
With the right mindset, understanding, and application, you will instantly begin learning how to create SQLite Databases from scratch
When we learn something new – we add it to the course – at no additional cost to you! This is a course that will continue to add more and more to every aspect of your life.
_________________________________________________________________________
What I can’t do in this Course..
I can’t guarantee your success – this course does take work on your part. But it can be done!
I am also not responsible for your actions. You are responsible for 100% of the decisions and actions you make while using this course.

 

Show More

Course Content

Introduction and setup

  • Introduction and Concepts
    07:49
  • Setup and Environment
    09:45

Basic SQL for SQlite

Intermediate SQL for SQLite

Master SQLite

Implement SQLite in Android Studio

Student Ratings & Reviews

No Review Yet
No Review Yet
How To Create and Manage SQLite Databases From Scratch
$300.00
Instructor
Level
Intermediate
Enrolled
103
Lectures
25 Lessons

Want to receive push notifications for all major on-site activities?