Advanced Kotlin Database Development

Focused View

Alexey Soshin

1:07:01

104 View

01 - Introduction

01 - Hello.mp4

00:37

02 - What you should know.mp4

00:52

03 - GitHub video.mp4

01:40

02 - 1. Setup and Basic CRUD Operations

01 - Connecting to your database.mp4

05:02

02 - Opening a transaction.mp4

01:47

03 - Using data types.mp4

03:28

04 - Creating and dropping tables.mp4

03:50

05 - Inserting a new entry.mp4

02:37

06 - Querying all entries.mp4

01:10

07 - Querying a single entry.mp4

02:42

08 - Updating an entry.mp4

03:18

09 - Deleting entries.mp4

01:20

10 - Challenge Create and populate a second table.mp4

00:40

11 - Solution Create and populate a second table.mp4

03:03

03 - 2. Advanced Features and Operations

01 - Preparing the data.mp4

00:46

02 - Using functions on columns.mp4

02:31

03 - Creating foreign keys.mp4

02:44

04 - Speeding up queries with indexes.mp4

02:09

05 - Preserving uniqueness.mp4

00:49

06 - Ordering and limiting.mp4

01:53

07 - Using enumerated columns.mp4

02:54

08 - Working with dates.mp4

02:25

09 - Joining tables.mp4

02:31

10 - Aggregating results.mp4

01:35

11 - Customizing enumerations.mp4

01:44

12 - Challenge Produce a report.mp4

00:39

13 - Solution Produce a report.mp4

01:30

04 - 3. Testing and Logging

01 - Logging queries.mp4

01:11

02 - Suspended transactions.mp4

01:38

03 - Testing code that uses Exposed.mp4

03:32

04 - Writing custom queries.mp4

01:56

05 - Logging long queries.mp4

01:02

05 - Conclusion

01 - Next steps.mp4

01:26

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Android Development

Kotlin

Alexey Soshin

Instructor's Courses

Author of two editions of "Kotlin Design Patterns and Best Practices" book. Author of "Pragmatic System Design" and "Web Development with Kotlin" video courses. Contributor to "97 Things Every Java Programmer Should Know" book. GitHub: https://github.com/AlexeySoshin StackOverflow: https://stackoverflow.com/users/5985853/alexey-soshin Articles: https://alexey-soshin.medium.com/

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.