LESSON 24Embedding SQL in Application Programming

This lesson covers, in very broad strokes, practical applications of SQL. We focus on examples showing embedded SQL in applications in the Microsoft Windows environment and the Java environment. All of the principles involved are just as applicable to other software platforms. You will learn the following:

• How various commercial products—Personal Oracle, Open Database Connectivity (ODBC), Java Database Connectivity (JDBC), and Microsoft’s .NET—relate to SQL

• How to set up your environment for SQL

• How to create a database using Oracle

• How to use SQL inside applications written in Visual Basic .NET and Java

After reading this material, you will know where to start applying your new SQL skills. ...

Get Sams Teach Yourself SQL in One Hour a Day, Fifth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.