How To Create and Manage SQLite Databases From Scratch
Learn SQLite through database creation, queries and the features used to manage application data.
$67.81 Buy this course
- Format
- Course
- Lessons
- 25
- License
- PLR
What's in the PLR package
- SQLite – Meisam Mansourzadeh.zip 6.3 GB
- Sales copy (Word document) Description 13 KB
Download links unlock in your account right after purchase.
Curriculum
- Video lesson: Introduction and ConceptsFree preview8m
- Lesson: Setup and Environment
- Lesson: Create Tables
- Lesson: Insert into tables – Basic Query
- Lesson: SQLite commands
- Lesson: Data types
- Lesson: Date in SQLite
- Lesson: Constraints
Show 17 more
- Lesson: Update and Delete commands – Alter tables
- Lesson: First Challenge
- Lesson: Advanced Query
- Lesson: Joins
- Lesson: Sub queries
- Lesson: Functions
- Lesson: Views
- Lesson: Second Challenge
- Lesson: Group by And Having Clauses
- Lesson: Transactions
- Lesson: Triggers
- Lesson: Conditions – Create your own Constraintsmp4
- Lesson: Create Read and Write views
- Lesson: Foreign key constraints
- Lesson: Leftovers
- Lesson: SQLiteOpenHelper Class
- Lesson: Query the database in Android
What you'll learn
- Creating reliable SQLite databases from the ground up
- Inserting, updating, and deleting records in your database
- Utilizing SQLite shell commands and various useful functions
- Understanding different data types and constraints in SQLite
- Executing advanced queries, including joins and subqueries
- Creating views and handling transactions effectively
- Implementing triggers and customizing constraints
- Specialized lessons for integrating SQLite with Android Studio
About this course
Learn SQLite through database creation, queries and the features used to manage application data. This course starts with the environment and basic tables, then develops more involved querying, transactions, constraints and Android integration.
Build and query a SQLite database
The curriculum covers creating tables, inserting records, shell commands, data types and dates. Update, delete and alter operations lead into joins, subqueries and functions. Later lessons address views, grouping, transactions and triggers.
- Create tables and work with records.
- Use constraints and foreign keys to organize relationships.
- Explore joins, subqueries, GROUP BY and HAVING.
- Understand transactions, triggers and read/write views.
- Review SQLiteOpenHelper and querying a database in Android.
Challenge sections provide points for applying the concepts as the course progresses. The material is intended for developers interested in lightweight databases, including people working in mobile or Python-related development. Its combination of SQL topics and an Android section gives learners a view of both database operations and an application context.
With PLR, you can modify, rebrand and resell this SQLite training. Position it around the database operations and integration topics actually covered to offer a clear practical course in your developer education catalog.
Who this course is for
- This course is perfect for any developer—whether you are into Android, iOS, or Python development—seeking to implement fast, lightweight, and user-friendly databases in your applications.
License rights
| Right | PLR |
|---|---|
| Selling the course | |
| Product may be sold separately | YES |
| Product may be bundled with other products | YES |
| Product can be a bonus for another product | YES |
| Can be sold as a physical product | YES |
| Can be sold as a digital product | YES |
| Passing on rights | |
| Can offer Resale Rights | NO |
| Can offer Master Resale Rights | NO |
| Can offer Private Label Rights | NO |
Show all 23 rights Show fewer rights
| Right | PLR |
|---|---|
| Memberships, bonuses and lists | |
| Can be added to paid membership sites | YES |
| Can add bonuses to the Product for sale | YES |
| Can be used to build a list | YES |
| Rebranding and editing | |
| You may put your own name on the sales letter | YES |
| You may rename the product | YES |
| You may edit the sales material | YES |
| You may edit the content of the product | YES |
| You may use the source code/material to create new products | YES |
| You may use the name(s) of the author/creator/seller of the Product | YES |
| Can translate the course into other languages | YES |
| Not allowed with any license | |
| Can be used for YouTube or other free video sites | NO |
| Can be added to free membership sites | NO |
| Can be given away for free | NO |
| Can be used or sold on Uthena | NO |
| Can be used or sold on Soofos, Udemy, Skillshare or other course marketplaces you don't own | NO |
Questions
What do I receive with a PLR or MRR license?
Downloadable package available; online curriculum listed. Check the file list and curriculum below for contents. PLR and MRR include a license key. Sales copy, editable formats and extras depend on the supplied package; check the listed contents.
What does lifetime access mean?
You can follow the course online for as long as it is available on Uthena. Downloadable files are guaranteed for 12 months from your purchase, so download them and keep your own copy.
Can I cancel my order?
Yes, within 7 days of your purchase: request a refund from your Uthena account. After 7 days an order can no longer be cancelled.
What if I want to speak to someone?
Email info@uthena.com, or support@uthena.com about an order, or use the contact form. We reply within two business days.
Related courses
-
Programming Courses -
Programming Courses Mastering Software Automation Testing for Quality, Risk & Reliability
Peter Alkema $79.00 PLR -
Programming Courses Mastering Linux Automation: Shell Scripting Concepts & Operations
Peter Alkema $79.00 PLR -
Programming Courses Mastering Linux Administration: Roles, Security, Uptime, Strategy
Peter Alkema $79.00 PLR
