The SQLite Crash Course
On average, students take 30 days to complete this course.
Learn how to use the SQLite database from scratch. This course will take you from installation and setup to writing complex SQL queries. We'll cover data types, insert commands, altering tables, advanced questions, sub-queries, joins, functions, views, group-by and having clauses, transactions, triggers, conditions, creating new constraints, using foreign-key constraints, the SQLiteOpenHelper class, and more.
Prerequisites & Requirements
This course has a few prerequisites (listed below). If you do not meet these requirements, we will not stop you from enrolling, but you may not be able to follow along with the material or get the most out of the course.
Fluency in written and spoken English.
A full-size laptop or desktop.
Admin/root privileges on your workstation.
An internet connection that is fast enough to stream high-res videos.
Welcome
1 LessonsIntroduction
2 LessonsTables
2 LessonsBasic Syntax
4 LessonsAltering Tables
2 LessonsAdvanced Syntax
3 LessonsFunctions and Views
3 LessonsGrouping
2 LessonsTriggers
1 LessonsAdvanced Constraints
3 LessonsWrapping Up
3 Lessons
Nina D. Fuchs
Login To Leave Review
- Price
50$
100$ - Instructor Nina D. Fuchs
- Duration 35 days
- Category Information Technology Courses
- Curriculum 11
- Lectures 27
- Enrolled 0