강의

멘토링

커뮤니티

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) 31 reviews

918 learners

  • Egoing Lee
DBMS/RDBMS
SQLite

Reviews from Early Learners

What you will gain after the course

  • 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

310,637

Learners

8,470

Reviews

1

Answers

4.9

Rating

44

Courses

Curriculum

All

7 lectures ∙ (43min)

Published: 
Last updated: 

Reviews

All

31 reviews

4.9

31 reviews

  • gubbeul님의 프로필 이미지
    gubbeul

    Reviews 1

    Average Rating 5.0

    5

    71% enrolled

    • psykang10130601님의 프로필 이미지
      psykang10130601

      Reviews 2

      Average Rating 5.0

      5

      71% enrolled

      • leaf님의 프로필 이미지
        leaf

        Reviews 27

        Average Rating 5.0

        5

        100% enrolled

        Thank you.

        • rhdmsggg님의 프로필 이미지
          rhdmsggg

          Reviews 1

          Average Rating 5.0

          5

          71% enrolled

          Simple! Concise! Accurate!

          • donghunha7417님의 프로필 이미지
            donghunha7417

            Reviews 2

            Average Rating 5.0

            5

            100% enrolled

            Free

            Egoing Lee's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!