GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • For Individuals
  • For Businesses
  • For Universities
  • For Governments
  • Degrees
  • Categories
  • Computer Science
  • Software Development

This view

  • Original page
  • New address

GeezerVison is showing www.coursera.org — SQLite for Rust

Pragmatic AI Labs

SQLite for Rust

Build in-demand skills with a full year of Coursera Plus, now $239. Save now.

Pragmatic AI Labs

SQLite for Rust

This course is part of Rust for Data Engineering Specialization

Noah Gift
Alfredo Deza

Instructors: Noah Gift

Included with •Learn more

3 modules
Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

5 hours to complete
Flexible schedule
Learn at your own pace

3 modules
Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

5 hours to complete
Flexible schedule
Learn at your own pace

What you'll learn

  • Drive SQLite from Rust with rusqlite — connections, prepared statements, parameterized queries, and transaction-wrapped bulk inserts

  • Build typed CSV and JSON ingestion paths with the csv crate and serde_json, and round-trip data back out as exports or SQL dumps

  • Ship a clap v4 CLI (fscrawl) that walks a filesystem with walkdir, stores metadata in SQLite, and exposes crawl / query / export / db-dump

Skills you'll gain

  • Performance Tuning
  • Command-Line Interface
  • Data Import/Export
  • JSON
  • Data Processing
  • Database Development
  • Data Science
  • Data Persistence
  • Database Administration
  • Transaction Processing
  • Data Modeling
  • Data Engineering

Tools you'll learn

  • SQL
  • Database Systems
  • Databases
  • Rust (Programming Language)
  • SQL Server Reporting Services
  • Database Software
  • Database Application

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

3 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business
 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Rust for Data Engineering Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate

There are 3 modules in this course

Use SQLite from Rust to build production-grade data tooling — the embedded, single-file SQL engine that ships in every Android phone, every iOS device, and most web browsers. You'll start with the basics of SQLite as a serverless library, then drive it from Rust with the rusqlite crate: opening file-backed and in-memory databases, running INSERT, SELECT, UPDATE, DELETE through prepared statements, and surfacing errors as `Result` rather than swallowing them. Module 2 turns the database into a real ETL stage: stream CSV with the csv crate and serde, ingest JSON with serde_json into typed columns or JSON1 blobs, and round-trip data back out as exports or full SQL dumps. The capstone builds **fscrawl** — a clap v4-driven CLI that walks a directory, upserts file metadata into SQLite, and exposes crawl, query, export, and db-dump subcommands. By the end you can ship a typed, transactional, embedded-SQL CLI tool from a single Rust binary.e.g. This is primarily aimed at first- and second-year undergraduates interested in engineering or science, along with high school students and professionals with an interest in programming.

Covers what this course covers, prerequisites, how to follow along, embedded vs client-server, and SQLite's role in data engineering.

What's included

17 videos6 readings1 assignment

17 videos•Total 47 minutes
  • Course Introduction•2 minutes
  • Lesson 1.1 Introduction•0 minutes
  • What is SQLite•4 minutes
  • Overview of Client-Server Databases•4 minutes
  • Create Your First SQLite Database•4 minutes
  • Lesson 1.1 Conclusion•1 minute
  • Lesson 1.2 Introduction•1 minute
  • The rusqlite Crate•4 minutes
  • Creating Your First Connection•4 minutes
  • Creating an In-Memory Database•4 minutes
  • Basic SQL Operations in Rust•5 minutes
  • Lesson 1.2 Conclusion•1 minute
  • Lesson 1.3 Introduction•1 minute
  • Mapping SQLite Errors•4 minutes
  • execute_batch for Multi-Statement SQL•4 minutes
  • Introduction to Transactions•6 minutes
  • Lesson 1.3 Conclusion•1 minute
6 readings•Total 60 minutes
  • Key Terms•10 minutes
  • Reflection•10 minutes
  • Key Terms•10 minutes
  • Reflection•10 minutes
  • Key Terms•10 minutes
  • Reflection•10 minutes
1 assignment•Total 5 minutes
  • SQLite Foundations•5 minutes

Covers the csv crate + serde, bulk inserts, what we will build, csv::Reader::from_path, and deserialize::<MyRow>().

What's included

14 videos6 readings1 assignment

14 videos•Total 35 minutes
  • Lesson 2.1 Introduction•1 minute
  • Parsing CSV Files in Rust•5 minutes
  • Bulk Inserting CSV Rows•4 minutes
  • Using Serde for Deserialization•4 minutes
  • Lesson 2.1 Conclusion•1 minute
  • Lesson 2.2 Introduction•1 minute
  • Deserializing JSON Using Serde•5 minutes
  • Inserting Serialized JSON Records•4 minutes
  • Verifying and Exporting JSON•4 minutes
  • Lesson 2.2 Conclusion•1 minute
  • Lesson 2.3 Introduction•1 minute
  • Dumping Database Contents•4 minutes
  • Use SQLite3 for Backups•1 minute
  • Lesson 2.3 Conclusion•1 minute
6 readings•Total 60 minutes
  • Key Terms•10 minutes
  • Reflection•10 minutes
  • Key Terms•10 minutes
  • Reflection•10 minutes
  • Key Terms•10 minutes
  • Reflection•10 minutes
1 assignment•Total 5 minutes
  • Data Ingestion and Export•5 minutes

Covers what fscrawl will do, the layering, designing for testability, #[derive(Parser)], and subcommand enum.

What's included

6 videos4 readings1 assignment

6 videos•Total 16 minutes
  • Lesson 3.1 Introduction•1 minute
  • Using Clap for the CLI•4 minutes
  • CLI Interaction with sqlite3•4 minutes
  • Walking a Directory with Rust•4 minutes
  • Lesson 3.1 Conclusion•1 minute
  • Course Conclusion•2 minutes
4 readings•Total 31 minutes
  • Key Terms•10 minutes
  • Reflection•10 minutes
  • Before You Go•1 minute
  • Next Steps•10 minutes
1 assignment•Total 15 minutes
  • Final Graded Quiz•15 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructors

Noah Gift
Noah Gift
Pragmatic AI Labs
64 Courses•13,839 learners

Offered by

Pragmatic AI Labs

Explore more from Software Development

  • P

    Pragmatic AI Labs

    DuckDB From Zero

    Course

  • D

    Duke University

    Data Engineering with Rust

    Course

  • P

    Pragmatic AI Labs

    Rust for Data Engineering

    Specialization

  • P

    Pragmatic AI Labs

    Rust CLI From Zero

    Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

What brings you to Coursera today?

Start my career

Change my career

Grow in my current role

Explore topics outside of work

  • cplus logo

    Give yourself skills that last, now $239

    Save now
  • Coursera for Teams

    Gift your team new skills

    Save 40% now

Frequently asked questions

To access course materials, assignments, and earn a Certificate, you'll need to purchase the Certificate experience when you enroll in a course. Eligible learners may also have the option to start with a Free Trial. Some courses may also offer a Full Course, No Certificate option. This lets you access course materials, submit required assessments, and receive a final grade, but you won't be able to earn or purchase a Certificate.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

More questions

Visit the learner help center

Financial aid available,

You are visitor 01402520 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.