Using SQL with C++
1h 27mIntermediate2021-08-12
Authors

Bill Weinman
Tech Advocate, Entrepreneur, Programming Expert
Course details
C++ is a powerful language for database applications, and it can be an excellent tool to use with SQL. In this course, instructor Bill Weinman gets you started on leveraging the power of C++ in SQL, starting with the basics, like connecting to a database, performing simple queries, and reading rows from a table. He also explains how to use prepared statements and bind variables, as well as how to build a wrapper class to streamline the SQL interface. Finally, he shows you how to build a specialized application class so you can create an application using what you learned. If you’re an experienced C++ developer looking to learn how to use C++ with SQL, this course is for you.
Skills covered
C++SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
Introduction
- Use SQL with C++
- Using the exercise files
- What do you need for this course
Common Interfaces
- Setup for Xcode on a Mac
- Setup for Visual Studio on Windows
Basic Concepts
- Hello World
- Queries
- Using a callback
- Prepared statements
- Challenge
- Solution
A CRUD Class
- The essential four operations
- SQL wrappers
- Adding CRUD methods
- Using the module
- Challenge
- Solution
Conclusion
- Thank you