Using SQL with C++

Using SQL with C++

1h 27mIntermediate2021-08-12

Authors

Bill Weinman

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
40,000 Toman