hi everyone welcome to the tutorial is cue light what is yes cue light SQLite is in in Cross’s library that implements is self-contained serverless zero configuration transactional SQL database engine it is one of the database which is zero configured that means unlike other databases we don’t have to configure anything in our system SQLite engine is not a standalone process like other databases you can link it statically or dynamically as per our requirement with our application the SQLite accesses it storage files directly so you can see that you I have the SQLite it will be something like this first of all we will see but why do we need a SQLite because SQLite doesn’t require a separate server or a process to operate another thing is we don’t have to configure anything it means it zero configuration and SQLite is very small and lightweight and it is usually less than 400 KB fully configured or less than 250 KB with optional features and it is self contained which means we don’t need any external dependencies and it is written in fancy and provides simple and easy to use a pas et SQLite is available on different operating system like Unix Mac Android iOS and also windows so we discussed why we have to go to why we have to go with SQLite and also we will see what are the limitations or drawbacks the few features like right outer join alter table full outer join views grant and revoke these features are not available in SQLite the standard SQLite commands to interact with the relational databases are they are similar to the SQL usually they are create select insert update delete and drop these comments can be classified into different groups based on the nature of their operation so something like we divided these into three different categories DD l DM l DQ l which means DT L is nothing but data definition language DM l is data manipulation language DQ l is data query language DD l data definition language is used to create or to initialize anything like command something like create alter drop create command is used to create a new table or to view a existing table to database Alphin command is used to modify the existing database object such as a table and drop command this is used to delete the entire table and when it comes to DM l data manipulation language the commands like insert update delete insert command is used to create a new record update command is used to modify the existing records delete command is used to delete the complete record so these records are the part of tables so dql nothing but data query language so this DQ l is used to query the data something like select the Select command is used to retrieve a certain number of records from the table it can be one or more tables so without wasting any time we will directly go and install our SQLite and we will do some practical example so once they are good with the example then we will be familiar with all the SQL like concepts thank you

Tags:






Youtube
Facebook
Google Plus
Twitter
TutorialDrive


Apache Zookeeper Tutorial

Apache Kafka Tutorial

Apache Kafka Security

Elasticserarch n Kibana

Java 8 Tutorial

Log4J Tutorial

Apache Storm Tutorial

SQLite Tutorial

Apache Ant Tutorial

Related Posts

blog

Apache Kafka Commands Cheat sheet

Spread the loveKafka Topics List existing topics bin/kafka-topics.sh –zookeeper localhost:2181 –list Purge a topic bin/kafka-topics.sh –zookeeper localhost:2181 –alter –topic mytopic –config retention.ms=1000 … wait a minute … bin/kafka-topics.sh –zookeeper localhost:2181 –alter –topic mytopic –delete-config retention.ms
Read more…

blog

What is Apache Maven | Apache Maven complete tutorial from scratch pdf

Spread the love In this post you will learn the complete tutorial of Apache Maven build tool What is Maven ? Apache Maven is a software project management and comprehension tool. Based on the concept
Read more…

blog

Practical Guide for Web Development in 2018

Spread the loveWelcome to my practical guide  for web development in 2018 in terms of  technology and career. Before we start I just want to  mention a few things, you don’t need to learn  everything that
Read more…