Sling Academy
Home/Kotlin/Kotlin - Interacting with Databases

Kotlin - Interacting with Databases

This series of tutorials walks you through the following:

  • SQLite Integration
    • Creating tables, inserting, querying, and updating records.
  • Room Database (for Android)
    • ORM for SQLite with Kotlin.
  • JDBC (Java Database Connectivity)
    • Interacting with relational databases.
  • NoSQL Databases
    • Basic integration with Firebase or MongoDB.

1 Setting Up SQLite in a Kotlin Project

2 Creating SQLite Tables Programmatically in Kotlin

3 Inserting Records into SQLite Tables Using Kotlin

4 Querying SQLite Databases: Retrieving Data with Kotlin

5 How to Update Records in SQLite Using Kotlin

6 Deleting Records from SQLite Tables in Kotlin

7 Working with SQLite Transactions in Kotlin

8 Kotlin: Using SQL Queries with Placeholders in SQLite

9 How to Handle SQLite Exceptions in Kotlin

10 Best Practices for SQLite Integration in Kotlin

11 Introduction to Room Database for Android (Kotlin)

12 Kotlin - Setting Up Room in an Android Project

13 Creating Room Entities and Data Classes in Kotlin

14 Kotlin - Defining DAO (Data Access Objects) for Room

15 Kotlin - Using Room for Database Queries and Insertions

16 Kotlin: Updating and Deleting Records with Room Database

17 Kotlin: Working with LiveData and Room for Real-Time Updates

18 Using Room Database Migrations in Kotlin

19 Kotlin: How to Handle Relationships in Room (One-to-Many, Many-to-Many)

20 Kotlin: Optimizing Room Queries with Indexed Columns

21 Kotlin - Best Practices for Room Database in Android Projects

22 Introduction to JDBC in Kotlin

23 Setting Up JDBC in a Kotlin Application

24 Kotlin: Connecting to Relational Databases Using JDBC

25 Executing SQL Statements with JDBC in Kotlin

26 Kotlin: How to Use Prepared Statements for Safe Database Access

27 Fetching Data with JDBC ResultSets in Kotlin

28 Kotlin: Updating and Deleting Records Using JDBC

29 Working with Transactions in JDBC for Kotlin

30 Kotlin: How to Close Database Connections Properly in JDBC

31 Integrating Kotlin Coroutines with JDBC for Async Operations

32 Introduction to NoSQL Databases in Kotlin

33 Setting Up Firebase Realtime Database in a Kotlin Project

34 Kotlin: Using Firebase Firestore for Data Storage and Retrieval

35 Kotlin: How to Work with Collections and Documents in Firestore

36 Handling Realtime Data Updates with Firebase and Kotlin

37 Introduction to MongoDB in Kotlin Projects

38 Connecting to MongoDB with Kotlin Using `KMongo`

39 Performing CRUD Operations in MongoDB with Kotlin

40 Querying MongoDB Collections Programmatically with Kotlin

41 Best Practices for NoSQL Databases in Kotlin Applications

42 Using Database Libraries like Exposed for Kotlin

43 Building a Multi-Database Application with Kotlin

44 Testing Database Interactions in Kotlin Applications

45 Real-World Use Cases for Database Integration in Kotlin Projects