Advanced Kotlin Database Development
1h 7mAdvanced2022-10-20
Authors
Alexey Soshin
Solutions Architect and Author
Course details
Kotlin is the preferred language for Android development, but its popularity in web development is on the rise, since it’s a modern programming language that is interoperable with Java and easier to learn than Scala. To develop a Kotlin backend application of any complexity, you need to interact with databases extensively. In this course, Alexey Soshinl teaches you how to get started. He shows you how to set up the connection using the Exposed library, define and populate tables, and write and debug custom queries. He also provides a challenge after each chapter so you can test your knowledge as you work through the course.
Skills covered
KotlinAdvancedDatabase DevelopmentDatabase ManagementProgramming LanguagesOpen SourceSoftware Development
Concepts
Introduction
- Hello
- What you should know
- GitHub video
Setup and Basic CRUD Operations
- Connecting to your database
- Opening a transaction
- Using data types
- Creating and dropping tables
- Inserting a new entry
- Querying all entries
- Querying a single entry
- Updating an entry
- Deleting entries
- Challenge - Create and populate a second table
- Solution - Create and populate a second table
Advanced Features and Operations
- Preparing the data
- Using functions on columns
- Creating foreign keys
- Speeding up queries with indexes
- Preserving uniqueness
- Ordering and limiting
- Using enumerated columns
- Working with dates
- Joining tables
- Aggregating results
- Customizing enumerations
- Challenge - Produce a report
- Solution - Produce a report
Testing and Logging
- Logging queries
- Suspended transactions
- Testing code that uses Exposed
- Writing custom queries
- Logging long queries
Conclusion
- Next steps