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

  • $8.00
  • 25 lessons
  • 4 hours of video content