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. ...