Complete SQLite Course for Beginners
Improve your career by learning to work with SQLite databases
Database Management,Development,SQLite
Lectures -19
Resources -3
Duration -34 mins
30-days Money-Back Guarantee
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 Complete SQLite Course for Beginners](https://d3mxt5v3yxgcsr.cloudfront.net/courses/13595/course_13595_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
All About SQLite Databases
15 Lectures
-
What are Databases 01:13 01:13
-
About SQLite Databases 02:26 02:26
-
Managing Your SQLite Database 01:45 01:45
-
Introducing the SQL Language 01:45 01:45
-
Creating and Dropping Data Tables 02:15 02:15
-
Searching for Information in Your Database 03:43 03:43
-
Deleting Information from Your Database 01:46 01:46
-
Using Subqueries 01:25 01:25
-
Sorting Search Results 01:37 01:37
-
Grouping Results by a Common Theme or Topic 01:13 01:13
-
Inserting New Data into Your Database 02:03 02:03
-
Updating or Modifying Existing Records 01:21 01:21
-
Joining Data from Multiple Tables 04:24 04:24
-
SQL Commands
-
Sample SQLite Database
SQLite and Python Programming
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Dermot Downey](https://www.tutorialspoint.com/assets/profiles/287099/profile/200_3085537-1718776860.jpg)
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](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual 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 Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)