Life Coding - SQLite

This is a SQLite lecture provided by Living Coding (Open Tutorials), which will help you get started with the relational database SQLite.

(4.8) 22 reviews

839 students

DBMS/RDBMS
SQLite

This course is prepared for Basic Learners.

What you will learn!

  • Concepts and Understanding of SQLite

  • Database CRUD Basics (Select, Insert, Update, Delete)

Relational databases for beginners,
Easy, small, and lightweight SQLite!

This is an introductory course on SQLite, the world's smallest relational database.
Let's start exploring SQLite, a relational database that is small yet has all the features you need.


What you will learn

  • SQLite does not have a database server.
  • sqlitestudio is a tool for handling SQLite in a GUI manner.
  • SQL is a language for programmatically controlling relational databases.
  • A database is a grouping of related tables.
  • create table creates a table.
  • The primary key is the index that allows the fastest search by identifier.
  • If you specify an integer or primary key, it will be autoincremented.
  • select queries a table.
  • insert adds a row.
  • update modifies a row.
  • delete removes a row.

What is not covered

  • join
  • index
  • backup
  • programming linkage
  • foreign key

A good lecture to listen to together

For a smooth understanding, we recommend that you take this course after studying the DATABASE 1 course.


Class Copyright

This lecture follows the CC license and can also be viewed through the following Life Coding Open Tutorials .
I would like to thank Life Coding for sharing good knowledge.

Recommended for
these people!

Who is this course right for?

  • For those who want to get started with SQLite

  • Anyone who wants to try out a simple relational database

Need to know before starting?

  • Basic understanding of databases

Hello
This is egoing5162

301,291

Students

7,831

Reviews

1

Answers

4.9

Rating

44

Courses

Curriculum

All

7 lectures ∙ (43min)

Published: 
Last updated: 

Reviews

All

22 reviews

4.8

22 reviews

  • 송우근

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    • 강휘민

      Reviews 5

      Average Rating 5.0

      5

      100% enrolled

      정말 쉽게 설명 잘하시네요. 잘 들었습니다 감사합니다.

      • KYUNG TAE BAE

        Reviews 231

        Average Rating 5.0

        5

        43% enrolled

        SQLite에 대해 많이 배워갑니다! 좋은 강의 감사드려요~~

        • 한영욱

          Reviews 2

          Average Rating 5.0

          5

          71% enrolled

          재밌어요

          • 엘카이저

            Reviews 1

            Average Rating 5.0

            5

            100% enrolled

            초보자에게 좋은 쉬운 강의와 편리한 SQLite Studio 너무 좋네요. 저도 실무에 이걸 써야 겠어요.

            egoing5162's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!

            Free