SQLite Introduction - Beginners Guide to SQL and Databases
Offered By: Caleb Curry via YouTube
Course Description
Overview
Learn the fundamentals of SQLite and database management in this comprehensive 22-minute tutorial. Explore the basics of SQLite3, its applications in web development, and essential database operations. Master dot commands, file execution, Data Definition Language (DDL), and Data Manipulation Language (DML). Discover how to select, update, and delete data efficiently. Dive into advanced concepts like foreign keys and creating joins to enhance your database skills. Perfect for beginners looking to gain practical knowledge in SQL and database management.
Syllabus
- What + why SQLite3
- What about Websites
- Getting Started
- Dot Commands
- Execute a File
- DDL
- DML
- Selecting Data
- Update
- Deleting Data
- Foreign Keys
- Creating a Join
Taught by
Caleb Curry
Related Courses
Introduction to DatabasesMeta via Coursera Web Development
Udacity Introduction to Data Science
University of Washington via Coursera Datenmanagement mit SQL
openHPI Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX