Course curriculum

    1. 1 - Introduction and Concepts

    2. 2 - Setup and Environment

    3. 3 - Create Tables

    4. 4 - Insert into tables: Basic Query

    5. 5 - SQLite commands

    6. 6 - Data types

    7. 7 - Date in SQLite

    8. 8 - Constraints

    9. 9 - Update and Delete commands: Alter tables

    10. 10 - First Challenge

    11. 11 - Advanced Query

    12. 12 - Joins

    13. 13 - Sub queries

    14. 14 - Functions

    15. 15 - Views

    16. 16 - Second Challenge

    17. 17 - Group by And Having Clauses

    18. 18 - Transactions

    19. 19 - Triggers

    20. 20 - Conditions: Create your own Constraints

    21. 21 - Create Read and Write views

    22. 22 - Foreign key constraints

    23. 23 - Leftovers

    24. 24 - SQLiteOpenHelper Class

    25. 25 - Query the database in Android

About this course

  • Free
  • 25 lessons
  • 0 hours of video content

Discover your potential, starting today