We may earn an affiliate commission when you visit our partners.
Kenny Kerr
Learn everything you need to know to make great use of this incredible little database engine with modern C++.
Read more
Learn everything you need to know to make great use of this incredible little database engine with modern C++.
Read more
Learn everything you need to know to make great use of this incredible little database engine with modern C++.
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/85xhls/sqlite
Here's a deal for you
We found an offer that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
What's inside
Syllabus
Introduction
Getting Started with SQLite
Mastering SQLite Resources
SQLite Connections and Exceptions
Read more
Syllabus
Introduction
Getting Started with SQLite
Mastering SQLite Resources
SQLite Connections and Exceptions
Read more
Taking Command of SQLite Statements
Distinctive SQLite Features
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Ideal for C++ developers who wish to use the SQLite database engine efficiently and productively
Might require additional resources to fully understand the C API, as the course primarily focuses on wrapping the API in a modern C++ abstraction
Save this course
Save SQLite with Modern C++ to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in SQLite with Modern C++ with these
activities:
Review Relational Database Concepts
Show steps
Reinforce your understanding of the relational data model and SQL to facilitate a smoother transition into SQLite.
Browse courses on
Relational Database
Show steps
-
Review the concepts of tables, rows, and columns.
-
Recall the principles of data normalization.
-
Revisit common SQL commands such as SELECT, INSERT, UPDATE, and DELETE.
Emulate Windows file and directories' operations in C++
Show steps
Review the core C++ and Windows API concepts required for the course.
Browse courses on
File Management
Show steps
-
Create C++ project using your preferred IDE.
-
Implement functions for creating, writing, and reading files.
-
Implement functions for creating, moving, and deleting directories.
-
Test your implementation thoroughly.
Explore SQLite's C API Tutorial
Show steps
Become familiar with the basics of the C API for SQLite.
Show steps
-
Follow the official SQLite C API tutorial.
-
Experiment with the API by creating and executing queries.
-
Review the documentation for the API functions you use.
Three other activities
Expand to see all activities and additional details
Show all six activities
Create a Library Management System
Show steps
Apply your knowledge of SQLite and C++ to build a practical project.
Browse courses on
SQL
Show steps
-
Design the database schema for the library.
-
Implement the necessary C++ classes and functions to interact with the database.
-
Develop a user interface for the system.
-
Test and debug your implementation.
Explain SQLite's Virtual Table Interface
Show steps
Reinforce your understanding of SQLite's VTI by explaining it to others.
Browse courses on
SQL
Show steps
-
Research the SQLite Virtual Table Interface (VTI).
-
Identify a use case for a custom VTI.
-
Implement the VTI using C or C++.
-
Create a blog post or tutorial explaining the VTI and its implementation.
Build a SQLite Command-Line Tool
Show steps
Create a tool that allows you to interact with SQLite databases from the command line.
Browse courses on
SQL
Show steps
-
Design the command-line interface and its functionality.
-
Implement the necessary code to parse commands and execute queries.
-
Add support for common SQL commands.
-
Extend the tool with additional features.
Review Relational Database Concepts
Show steps
Reinforce your understanding of the relational data model and SQL to facilitate a smoother transition into SQLite.
Browse courses on
Relational Database
Show steps
Show steps
Show steps
- Review the concepts of tables, rows, and columns.
- Recall the principles of data normalization.
- Revisit common SQL commands such as SELECT, INSERT, UPDATE, and DELETE.
Emulate Windows file and directories' operations in C++
Show steps
Review the core C++ and Windows API concepts required for the course.
Browse courses on
File Management
Show steps
Show steps
Show steps
- Create C++ project using your preferred IDE.
- Implement functions for creating, writing, and reading files.
- Implement functions for creating, moving, and deleting directories.
- Test your implementation thoroughly.
Explore SQLite's C API Tutorial
Show steps
Become familiar with the basics of the C API for SQLite.
Show steps
Show steps
Show steps
- Follow the official SQLite C API tutorial.
- Experiment with the API by creating and executing queries.
- Review the documentation for the API functions you use.
Three other activities
Expand to see all activities and additional details
Show all six activities
Create a Library Management System
Show steps
Apply your knowledge of SQLite and C++ to build a practical project.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Design the database schema for the library.
- Implement the necessary C++ classes and functions to interact with the database.
- Develop a user interface for the system.
- Test and debug your implementation.
Explain SQLite's Virtual Table Interface
Show steps
Reinforce your understanding of SQLite's VTI by explaining it to others.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Research the SQLite Virtual Table Interface (VTI).
- Identify a use case for a custom VTI.
- Implement the VTI using C or C++.
- Create a blog post or tutorial explaining the VTI and its implementation.
Build a SQLite Command-Line Tool
Show steps
Create a tool that allows you to interact with SQLite databases from the command line.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Design the command-line interface and its functionality.
- Implement the necessary code to parse commands and execute queries.
- Add support for common SQL commands.
- Extend the tool with additional features.
Career center
Learners who complete SQLite with Modern C++ will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
A Database Administrator (DBA) is responsible for the day-to-day administration and maintenance of an organization's database system. This includes installing, configuring, and monitoring the database, as well as providing technical support to users. This course can help you build a strong foundation in SQLite, which is a popular database engine used in a wide range of applications. By learning how to use SQLite effectively, you can gain the skills necessary to become a successful DBA.
Data Analyst
Data Analyst
A Data Analyst is responsible for collecting, cleaning, and analyzing data to identify trends and patterns. This information is then used to make informed decisions about business operations. This course can help you develop the skills necessary to become a successful Data Analyst. By learning how to use SQLite, you can gain the ability to manage and analyze large datasets, which is a critical skill for Data Analysts.
Software Engineer
Software Engineer
A Software Engineer is responsible for designing, developing, and maintaining software applications. This course can help you build a strong foundation in SQLite, which is a popular database engine used in a wide range of applications. By learning how to use SQLite effectively, you can gain the skills necessary to become a successful Software Engineer.
Data Scientist
Data Scientist
A Data Scientist is responsible for using data to solve business problems. This includes collecting, cleaning, and analyzing data, as well as developing and deploying models to make predictions. This course can help you develop the skills necessary to become a successful Data Scientist. By learning how to use SQLite, you can gain the ability to manage and analyze large datasets, which is a critical skill for Data Scientists.
Database Architect
Database Architect
A Database Architect is responsible for designing and implementing database systems. This includes creating the database schema, as well as optimizing the database for performance and reliability. This course can help you build a strong foundation in SQLite, which is a popular database engine used in a wide range of applications. By learning how to use SQLite effectively, you can gain the skills necessary to become a successful Database Architect.
Systems Administrator
Systems Administrator
A Systems Administrator is responsible for maintaining and troubleshooting computer systems. This includes managing hardware and software, as well as providing technical support to users. This course can help you build a strong foundation in SQLite, which is a popular database engine used in a wide range of applications. By learning how to use SQLite effectively, you can gain the skills necessary to become a successful Systems Administrator.
Web Developer
Web Developer
A Web Developer is responsible for designing and developing websites. This includes creating the website's layout, as well as writing the code that makes the website function. This course can help you build a strong foundation in SQLite, which is a popular database engine used in a wide range of applications. By learning how to use SQLite effectively, you can gain the skills necessary to become a successful Web Developer.
Information Security Analyst
Information Security Analyst
An Information Security Analyst is responsible for protecting an organization's computer systems from unauthorized access and attacks. This includes monitoring the network for suspicious activity, as well as developing and implementing security policies. This course may help you build a strong foundation in SQLite, which is a popular database engine used in a wide range of applications. By learning how to use SQLite effectively, you may gain the skills necessary to become a successful Information Security Analyst.
Business Analyst
Business Analyst
A Business Analyst is responsible for analyzing business problems and developing solutions. This includes gathering requirements from stakeholders, as well as developing and implementing business processes. This course may help you build a strong foundation in SQLite, which is a popular database engine used in a wide range of applications. By learning how to use SQLite effectively, you may gain the skills necessary to become a successful Business Analyst.
Technical Writer
Technical Writer
A Technical Writer is responsible for creating documentation for software and hardware products. This includes writing user manuals, technical specifications, and release notes. This course may help you build a strong foundation in SQLite, which is a popular database engine used in a wide range of applications. By learning how to use SQLite effectively, you may gain the skills necessary to become a successful Technical Writer.
Project Manager
Project Manager
A Project Manager is responsible for planning, executing, and closing projects. This includes setting project goals, developing project plans, and managing project resources. This course may help you build a strong foundation in SQLite, which is a popular database engine used in a wide range of applications. By learning how to use SQLite effectively, you may gain the skills necessary to become a successful Project Manager.
Computer Programmer
Computer Programmer
A Computer Programmer is responsible for writing, testing, and debugging code. This code is used to create software applications and websites. This course may help you build a strong foundation in SQLite, which is a popular database engine used in a wide range of applications. By learning how to use SQLite effectively, you may gain the skills necessary to become a successful Computer Programmer.
Network Administrator
Network Administrator
A Network Administrator is responsible for managing and maintaining an organization's computer network. This includes configuring and troubleshooting network hardware and software, as well as providing technical support to users. This course may help you build a strong foundation in SQLite, which is a popular database engine used in a wide range of applications. By learning how to use SQLite effectively, you may gain the skills necessary to become a successful Network Administrator.
Computer Support Specialist
Computer Support Specialist
A Computer Support Specialist is responsible for providing technical support to users. This includes troubleshooting hardware and software problems, as well as installing and configuring software. This course may help you build a strong foundation in SQLite, which is a popular database engine used in a wide range of applications. By learning how to use SQLite effectively, you may gain the skills necessary to become a successful Computer Support Specialist.
Data Entry Clerk
Data Entry Clerk
A Data Entry Clerk is responsible for entering data into a computer system. This data may include customer information, sales data, or other types of information. This course may help you build a strong foundation in SQLite, which is a popular database engine used in a wide range of applications. By learning how to use SQLite effectively, you may gain the skills necessary to become a successful Data Entry Clerk.
For more career information including salaries, visit:
OpenCourser.com/course/85xhls/sqlite
Reading list
We've selected ten books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
SQLite with Modern C++.
Classic in the field of software development. It provides practical advice on how to write better code and be a more effective programmer.
Save
Classic in the field of software design. It describes a set of design patterns that can be used to solve common problems in software development.
More accessible introduction to design patterns than the previous one. It uses a visual approach to help you understand how design patterns work.
Classic in the field of computer science. It covers a wide range of topics, from algorithms to data structures to programming languages.
Classic in the field of algorithms. It covers a wide range of algorithms, from sorting to searching to graph algorithms.
Guide to professional software development. It provides advice on how to write clean code, work effectively with others, and be a successful software developer.
Classic in the field of software engineering. It discusses the challenges of software development and provides advice on how to manage software projects effectively.
Classic in the field of open source software development. It discusses the differences between the traditional cathedral model of software development and the bazaar model of open source development.
Save
Is the definitive guide to the C++ programming language. It is written by the creator of C++, so you can be sure that the information is accurate and up-to-date.
Save
Classic in the field of C++ programming. It provides a comprehensive overview of the language and its features.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/85xhls/sqlite
Share
Similar courses
Here are nine courses similar to
SQLite with Modern C++.
Modern Web Animations
OpenCourser.com/course/qksfer/modern
Modern Web Animations
C++ Fundamentals Including C++ 17
OpenCourser.com/course/lih102/c++
C++ Fundamentals Including C++ 17
Using ASP.NET Core Web API and NoSQL Databases
OpenCourser.com/course/kishbx/using
Using ASP.NET Core Web API and NoSQL Databases
ASP NET Core,MVC,C#,Angular, ChatGPT & EF Crash Course
OpenCourser.com/course/dqvyyo/asp
ASP NET Core,MVC,C#,Angular, ChatGPT & EF Crash Course
Introduction to C# Programming and Unity
OpenCourser.com/course/2n9vh9/introduction
Introduction to C# Programming and Unity
Beginning C++ Programming - From Beginner to Beyond
OpenCourser.com/course/b02t9u/beginning
Beginning C++ Programming - From Beginner to Beyond
Unreal Engine 5 C++ Developer: Learn C++ & Make Video Games
OpenCourser.com/course/xfzbc1/unreal
Unreal Engine 5 C++ Developer: Learn C++ & Make Video...
API in C#: The Best Practices of Design and Implementation
OpenCourser.com/course/4xlrsh/api
API in C#: The Best Practices of Design and Implementation
Unreal Engine 5.2 : Exploring Lyra for Game Development
OpenCourser.com/course/erpcap/unreal
Unreal Engine 5.2 : Exploring Lyra for Game Development
Time
153 hours
Level
Intermediate
Via
Pluralsight
Instructor
Kenny Kerr
Language
English
Good to know
Ideal for C++ developers who wish to use the SQLite database engine efficiently and productively
Might require additional resources to fully understand the C API, as the course primarily focuses on wrapping the API in a modern C++ abstraction
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser