What you will learn
These are some of the main topics that you are going to learn during the course
-
Beginner to Advanced SQL commands
-
Date in SQLite
-
Functions
-
Subqueries
-
Joins
-
Transactions
-
Implementing SQLite in Android
-
Datatypes
-
Constraints
-
Advanced Queries
Course Description
Are you a Developer looking to learn how to create and manage databases using SQLite?
-
Or maybe you're new to databases and you just don't know where to start...
Then my Complete SQLite Databases Course is For You!
Here is what you will learn in my complete SQLite Databases Course:
In my complete SQLite Databases course you will learn how to create a reliable SQLite database from scratch. You will learn:
How to create tables and insert records into them
Update and delete records in a database
SQLite shell commands
Useful functions available in SQLite
Different Datatypes available in SQLite
All of the complexities of Date in SQLite
Constraints on columns
Advanced Queries
Joining tables together
Subqueries
Creating views
Group By and Having clauses
Transactions
Triggers on tables
You will also learn how to manage existing SQLite databases and even do things that seem impossible in SQLite ...
Like how to create views that can be used to insert, update and delete records
How to customize constraints so that you can apply them to your tables
Android Studio Specific Database Lessons
And so much more!
But that’s not all you receive by enrolling in this course
I have added multiple video lessons on how to implement SQLite in Android studio!
I will also be uploading and adding additional content with practice activities to give you a hands on learning experience
_________________________________________________________________________
Who is This Course For?
This course is perfect for any developer looking for a way to create a fast, light weight, 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!
_________________________________________________________________________
The benefits of this course are absolutely unlimited!
I believe the best way to learn is by DOING. That is why we have multiple mini projects in each and every section of our course! These hands on projects will allow you to not only learn by watching, but by DOING as well.
_________________________________________________________________________
With the right mindset, understanding, and application, you will instantly begin learning how to create SQLite Databases from scratch
When we learn something new - we add it to the course - at no additional cost to you! This is a course that will continue to add more and more to every aspect of your life.
_________________________________________________________________________
What I can't do in this Course..
I can't guarantee your success – this course does take work on your part. But it can be done!
I am also not responsible for your actions. You are responsible for 100% of the decisions and actions you make while using this course.
_________________________________________________________________________
It's time to take action! This course will not remain this price forever!
Click the "Buy Now" button, top right, Today!
Every hour you delay is costing you money...
See you in the course!
Sincerely,
Meisam
Course curriculum
-
2
Basic SQL for SQlite
- Create Tables FREE PREVIEW
- Insert into tables - Basic Query FREE PREVIEW
- SQLite commands
- Data types
- Date in SQLite
- Constraints
- Update and Delete commands - Alter tables
- First Challenge
-
3
Intermediate SQL for SQLite
- Advanced Query
- Joins
- Subqueries
- Functions
- Views
- Second Challenge
-
4
Master SQLite
- Group by and Having
- Transactions
- Triggers
- Conditions - Create your own Constraints
- Create Read and Write views
- Foreign key constraints
- Leftovers
-
5
Implement SQLite in Android Studio
- SQLiteOpenHelper Class
- Query your database in Android
About the Instructor
Meisam Mansourzadeh
Professional Android Developer
Meisam Mansourzadeh
What you will get with this course
-
How to create tables and insert records into them
-
Update and delete records in a database
-
SQLite shell commands
-
Useful functions available in SQLite
-
Different Datatypes available in SQLite
-
All of the complexities of Date in SQLite
-
Constraints on columns
-
Advanced Queries
-
Joining tables together
-
Group By and Having clauses
Who should take this course
- Android Developers Who want to master SQLite
- iOS developers who want to learn about databases
- Python developers who want to implement a reliable database in their applications
- Anybody in the software development who need a fast, light weight and easy to use database in their applications
Requirements
- A passion for learning
- In case you are following the course for implementing in android, basic knowledge of android app development would be helpful