SQLite For Beginners - Learn SQL from Scratch
3.9 (55 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,670 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQLite For Beginners - Learn SQL from Scratch to your Wishlist.

Add to Wishlist

SQLite For Beginners - Learn SQL from Scratch

Complete Guide for Beginners to Learn and Master SQL, SQLite DB and Relational Database Concepts
3.9 (55 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,670 students enrolled
Last updated 3/2017
English
English
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand the primary concepts of RDBMS
  • Learn and master SQL commands
  • Learn to install and use SQLite in your projects
View Curriculum
Requirements
  • Basic knowledge of Web Programming will be helpful for the students
Description

The ULTIMATE course for learning SQLite from scratch is finally here! Boost your database skills with this one of a kind severless database system.

SQLite is a unique database for embedded systems and is currently the most popular database on the market for browsers, embedded systems and even mobile phones. Easily summed up in three words, SQL is small, fast and reliable.

SQLite was designed by D. Richard Hipp in 2000 for an aboard guided missile destroyers that needed the program to be operated without installing a database management system or requiring a database administrator. It comes with numerous benefits over traditional relational database systems such as:

Manifest typing – SQL uses Manifest typing instead of static typing, which makes datatypes a property of the value itself, and not of the column in which the value is stored.

Readable source code – Codes in SQLite are commented and explained extremely well making the language quite readable.

Zero-Configuration – SQLite does not need to be installed multiple times and neither does it require any setup.

Serverless – SQL runs directly from the database files, without requiring a dedicated server.

Variable-length records – SQLite uses only the amount of disk space needed to store the information in a row, with very little overheads.

Single Database File – SQLite runs on a single ordinary disk file and does not need multiple files. It can also read all the files from the database it runs on.

Stable Cross-Platform Database File – A database file written on one machine can be copied to and used on a different machine with a different architecture.

SQL language extensions – It offers multiple enhancements to the SQL language that are not found in other database engines such as EXPLAIN keywords and Manifest typing language.

Public domain – SQLite is in the public domain, which means it is free of cost to use and manipulate as one sees fit.

This tutorial is the perfect resource to learn SQLite. We will breakdown the database from start to end to help you not only learn what it is and how it works, but instead master all the functions and keywords you need to become a professional.

The course will give you a detailed introduction and will help you progress from installing the system to learning the different important commands that are required to work with the database. You will also learn about constraints, joins and subqueries with detailed examples. At the end of this course, you will not only be familiar with SQLite but also how you can install it, work complex commands, generate a report and even manipulate data and tables.

Enroll now to get started with this amazing ‘lite’ serverless database engine!

Who is the target audience?
  • Anyone who want to learn SQL, Relational Databases and SQLite
Students Who Viewed This Course Also Viewed
Curriculum For This Course
20 Lectures
01:53:48
+
Introduction
1 Lecture 01:46
+
Introduction and Installation of SQLite
3 Lectures 09:28
+
SQLite Commands Databases and Clauses
10 Lectures 50:29


SQLite Database Part 1
04:20

SQLite Database Part 2
04:38

SQLite Database Part 3
03:22

SQLite Arithematic Operator
03:02

SQLite Comparison Operator
03:52

SQLite Logical Operator
09:41

SQLite Bitwise Operator
03:06

SQLite Clause
07:05

Section 3
11 questions
+
SQLite Constraints Joins and Subqueries
3 Lectures 24:47
SQLite Constraints
07:44

SQLite Joins
10:18

SQLite Subqueries
06:45

Section 4
12 questions
+
SQLite Functions
1 Lecture 08:11
SQLite Functions
08:11

Section 5
4 questions
+
SQLite Miscellaneous Functions
2 Lectures 19:07
SQLite Miscellaneous Part 1
12:48

SQLite Miscellaneous Part 2
06:19

Section 6
5 questions
About the Instructor
Eduonix Learning Solutions
4.2 Average rating
47,743 Reviews
781,089 Students
188 Courses
1+ Million Students Worldwide | 200+ Courses

Eduonix creates and distributes high quality technology training content. Our team of industry professionals have been training manpower for more than a decade. We aim to teach technology the way it is used in industry and professional world. We have professional team of trainers for technologies ranging from Mobility, Web to Enterprise and Database and Server Administration.

Eduonix-Tech .
4.3 Average rating
45,776 Reviews
758,802 Students
146 Courses