Tutorialspoint

4th Of July Sale Flat 10% off, Use Code: FREEDOM10

Complete SQLite Course for Beginners

person icon Dermot Downey

4.4

Complete SQLite Course for Beginners

Improve your career by learning to work with SQLite databases

updated on icon Updated on Jul, 2024

language icon Language - English

person icon Dermot Downey

English [CC]

category icon Database Management,Development,SQLite

Lectures -19

Resources -3

Duration -34 mins

4.4

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Learn the SQL language and work with data using SQLite databases

Every year, SQL appears consistently as one of the most in-demand languages to learn. Knowing how to analyze data is one of the top tech skills companies look for, and it is one of the fastest ways for you to improve your career.

Whether you are a data scientist, business or financial analyst, or programmer, being able to import data into a database and run advanced queries on it to solve complex problems will put you ahead of the crowd.

In this course, you will learn to use SQLite databases, the world's most popular database system. The commands you will learn are directly relevant to the workplace and are used across multiple industries where data processing and business reporting are needed.

Using software that is 100% free, you will learn:

  • What databases are and how do they store information
  • How to create new databases and tables
  • How to import data into the database
  • How to run very precise searches on your data, and pull out just the results you need
  • How to run calculations on your data

SQLite works very well with all major programming languages, so in this course, you will also learn how Python can be used to query your database. You will learn how to easily begin working with data in your scripts and programs.

All of the commands we cover are included in downloadable guides, making it easy for you to take and read them when writing your own queries.

If you’ve ever felt that you want to know more about databases, SQL or SQLite, then this is the course for you. I look forward to helping you with improving your career!

Goals

  • Learn to work with SQLite databases

  • Learn the fundamentals of writing SQL queries

  • Learn SQL commands such as SELECT, DELETE, CREATE, DROP, JOIN, and many more

  • Learn how to use SQL to improve your career

  • Learn how to use databases in your Python programs

Prerequisites

  • Basic computer skills

  • No prior experience in SQL is needed - all will be taught in this course

  • Some knowledge of Python is helpful but not necessary

Complete SQLite Course for Beginners

Curriculum

Check out the detailed breakdown of what’s inside the course

All About SQLite Databases
15 Lectures
  • play icon What are Databases 01:13 01:13
  • play icon About SQLite Databases 02:26 02:26
  • play icon Managing Your SQLite Database 01:45 01:45
  • play icon Introducing the SQL Language 01:45 01:45
  • play icon Creating and Dropping Data Tables 02:15 02:15
  • play icon Searching for Information in Your Database 03:43 03:43
  • play icon Deleting Information from Your Database 01:46 01:46
  • play icon Using Subqueries 01:25 01:25
  • play icon Sorting Search Results 01:37 01:37
  • play icon Grouping Results by a Common Theme or Topic 01:13 01:13
  • play icon Inserting New Data into Your Database 02:03 02:03
  • play icon Updating or Modifying Existing Records 01:21 01:21
  • play icon Joining Data from Multiple Tables 04:24 04:24
  • play icon SQL Commands
  • play icon Sample SQLite Database
SQLite and Python Programming
4 Lectures
Tutorialspoint

Instructor Details

Dermot Downey

Dermot Downey

About me


Dermot has over 15 years experience in IT and network administration in the pharmaceutical and financial industries. He has also been an educator on topics such as IT security and Unix administration.


He holds certifications in Cisco networking, network security and Linux administration, and has supported Red Hat, Debian and AIX systems in professional enterprises.


He believes in having fun in your work and enjoying what you do. He is passionate about IT systems, and believes strongly in passing this passion and skillset on to the next generation of IT enthusiast.


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515