강의

멘토링

로드맵

Programming

/

Database

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.9) 28 reviews

894 learners

  • Egoing Lee
DBMS/RDBMS
SQLite

Reviews from Early 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 begin our exploration of SQLite, a relational database that's compact yet has all the features you need.


What you 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 can be searched most quickly 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 integration
  • 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 express my gratitude to Life Coding for sharing valuable 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

307,349

Learners

8,204

Reviews

1

Answers

4.9

Rating

44

Courses

Curriculum

All

7 lectures ∙ (43min)

Published: 
Last updated: 

Reviews

All

28 reviews

4.9

28 reviews

  • rhdmsggg님의 프로필 이미지
    rhdmsggg

    Reviews 1

    Average Rating 5.0

    5

    71% enrolled

    Simple! Concise! Accurate!

    • donghunha7417님의 프로필 이미지
      donghunha7417

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      • a502391837146님의 프로필 이미지
        a502391837146

        Reviews 1

        Average Rating 5.0

        5

        71% enrolled

        • ljw28694847님의 프로필 이미지
          ljw28694847

          Reviews 1

          Average Rating 5.0

          5

          100% enrolled

          • dkswhd830129님의 프로필 이미지
            dkswhd830129

            Reviews 1

            Average Rating 5.0

            5

            71% enrolled

            Free

            Egoing Lee's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!