This course provides practical knowledge and skills essential for creating, managing, and implementing SQLite databases, including integration with Android Studio.
NOTE:
To access your e-learning course with us, you need a Golem Karrierewelt customer account. To purchase your e-learning course, simply use the same e-mail address that you want to use to access the e-learning course. Your customer account is, of course, free of charge for you.
You will learn:
- Creating, updating, and deleting records in SQLite tables
- Executing advanced queries and joining tables
- Utilizing SQLite functions and managing data types
- Implementing SQLite in Android Studio
Requirements:
- No prior programming experience required
- Willingness to learn and experiment
Who is this course for?
This course is designed for any developer looking to create a fast, lightweight, and easy-to-use database in their applications. So whether you're an Android Developer, iOS Developer, Python Developer, or any developer in-between, this course is perfect for you!
After your purchase:
a.) Log in to your Golem Karrierewelt account and click on the relevant order. Then simply click on "view online" and off you go. b.) You will receive an order confirmation after your purchase. Simply click on "View order" and you will be redirected to the checkout page, which will then show you the "To my courses" button. Click on this button and off you go. c.) You can click on this link directly after purchase: "My e-learning courses" d.) Have you used the price advantage and purchased access for several people? Please inform all authorized persons that a free Golem Karrierewelt account is required to access the e-learning courses. Those entitled to access will automatically receive an invitation to their account from us and must activate it once in order to access the courses.
Course details:
In the course "How To Create and Manage SQLite Databases From Scratch" you will learn how to create and manage your own SQLite Database from scratch. You will learn how to create tables, insert records, update and delete records, and manage databases using SQLite. The course covers all essential tasks, from basic SQL commands and data types to advanced queries and implementing SQLite in Android Studio.
Course content - 5 sections - 25 lessons - 4 hrs. 11 min. total duration
1 Introduction and setup
1.1 Introduction and concepts
1.2 Setup and environment
2 Basic SQL for SQLite
2.1 Create tables
2.2 Insert into tables - basic query
2.3 SQLite commands
2.4 Data types
2.5 Date in SQLite
2.6 Constraints
2.7 Update and delete commands - alter tables
2.8 First challenge
3 Intermediate SQL for SQLite
3.1 Advanced query
3.2 Joins
3.3 Subqueries
3.4 Functions
3.5 Views
3.6 Second challenge
4 Master SQLite
4.1 Group by and having clauses
4.2 Transactions
4.3 Triggers
4.4 Conditions - create your own constraints
4.5 Create read and write views
4.6 Foreign key constraints
4.7 Leftovers
5 Implement SQLite in Android Studio
5.1 SQLiteOpenHelper class
5.2 Query the database in Android
