SQLite with Modern C++

By Kenny Kerr
Learn everything you need to know to make great use of this incredible little database engine with modern C++.
Course info
Rating
(104)
Level
Intermediate
Updated
Feb 18, 2015
Duration
2h 32m
Table of contents
Introduction
Introduction 2m Why SQLite? 1m SQLite Architecture 1m Summary 1m
Getting Started with SQLite
Introduction 0m Downloading the SQLite Amalgamation 3m Building the SQLite Shell 2m Creating Your First SQLite Database 3m Including SQLite in a C++ Project 3m First Look at the SQLite API 8m Summary 1m
Mastering SQLite Resources
Introduction 1m Handling Resources 10m Modeling SQLite Connection Handles 3m Summary 1m
SQLite Connections and Exceptions
Introduction 1m Turning Errors into Exceptions 7m Modeling Connections 8m Connections and Encoding 6m Summary 1m
Taking Command of SQLite Statements
Introduction 1m Handling Statements 4m Preparing Statements 4m Executing Statements 3m Reading Row Values 4m Rows and Strings 7m Range-based Reader 6m Binding Arguments 11m Binding Arguments Automatically 4m Productivity Improvements 5m Summary 1m
Distinctive SQLite Features
Introduction 1m Type System 7m Primary Keys 9m Transactions 7m Profiling 2m Backup 8m Vacuum 3m Summary 1m
Description
Course info
Rating
(104)
Level
Intermediate
Updated
Feb 18, 2015
Duration
2h 32m
Description

This course introduces C++ developers to the SQLite database engine, an embeddable and completely self-contained database engine written entirely in C. The benefit for C++ developers is that there is no configuration or distribution headaches. The drawback is that the API is provided in C. This course will show developers how to effectively and efficiently wrap the C API in a modern C++ abstraction that adds no runtime cost but greatly improves reliability and productivity.

About the author
Kenny Kerr
About the author

Kenny Kerr is a computer programmer and recognized expert in Windows operating system development and programming languages.

More from the author
Windows Runtime Internals
Advanced
2h 40m
Jul 30, 2015
The Essentials of the Windows Runtime
Intermediate
2h 48m
Sep 2, 2014
More courses by Kenny Kerr

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT