• No products in the cart.

5

10

ratings 

About the course. In contrast to many other relational database management systems, SQLite is embedded in the program’s end rather …

UDesign Membership
Course Access

Unlimited Duration

Students Enrolled

2090

Total Video Time

3 hours, 20 minutes

Posted by
About the course. In contrast to many other relational database management systems, SQLite is embedded in the program's end rather than being a client/server database. SQLite is a popular choice and the most used database, making its adequate knowledge compelling. Get every you need to create and manage SQLite databases by taking this one course. Prerequisite. None. What does this course provide? This course contains:  
  •   An introduction to the concepts of SQLite.
  •  A guide to set up the environment for your works.
  •   A walk-through of the primary database function (create, insert, delete, update table).
  •   SQLite basic commands.
  •   SQLite date, data types, and constraints.
  •   Advanced query in SQLite.
  •   How sub-queries are structured.
  •   How to write functions and create views.
  •   What transactions are and how they are carried out.
  •   What triggers are and how to add them to your database.
  •   Apply conditions to create your constraints.
  •   Step by step to create read and write views.
  •   How to declare and work with foreign key constraints. Who is this course for? This course is recommended for anyone who wants to master the use of SQLite databases.
Profile Photo
Hoz map
5 5
29085

Students

About Instructor

Course Currilcum

  • 01 Introduction and Concepts 00:07:00
  • 02 Setting up the environment 00:09:00
  • 03 Create tables 00:06:00
  • 04 Insert into tables Basic Query 00:09:00
  • 05 SQLite Commands 00:11:00
  • 06 Datatypes in SQLite 00:09:00
  • 07 Date in SQLite 00:12:00
  • 08 Constraints in SQLite 00:09:00
  • 09 Update and Delete Commands Alter Tables 00:07:00
  • 10 First Challenge 00:05:00
  • 11 Advaced Query in SQLite 00:08:00
  • 12 Joins in SQLite 00:13:00
  • 13 Subqueries 00:08:00
  • 14 Functions 00:08:00
  • 15 Views 00:08:00
  • 16 Second Challenge 00:09:00
  • 17 Group by and Having 00:05:00
  • 18 Transactions 00:05:00
  • 19 Triggers 00:14:00
  • 20 Conditions Create your own Constraints 00:08:00
  • 21 Create Read and Write views 00:13:00
  • 22 Foreign key constraints 00:11:00
  • 23 Leftovers 00:06:00

Course Reviews

5

5
10 ratings
  • 5 stars10
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. 5

    Perfect, thank you

  2. Timothy MayheadMarch 22, 2021 at 5:05 pm

    5

    Great lecture so far!

  3. 5

    It was helpful

  4. Jennifer SproatMarch 22, 2021 at 5:05 pm

    5

    This course what I was looking for. The instructor is great and content is engaging

  5. 5

    Really informative.

  6. Murray SullivanMarch 22, 2021 at 5:05 pm

    5

    Thank you really helpful materials

  7. Noelia MakepeaceMarch 22, 2021 at 5:05 pm

    5

    The course was very good. It is very useful for the beginners and advanced.

  8. 5

    The instructor is very clear and the course itself is easy to understand and follow. I’ve really learned a lot. Thank you.

  9. 5

    Comprehensive outlines of the course. Really enjoyed it, thank you

  10. 5

    Enjoyed the lesson

X