Book 5

SQL and Programming

Contents at a Glance

  1. Chapter 1: Database Development Environments
    1. Microsoft Access
    2. Microsoft SQL Server
    3. IBM Db2
    4. Oracle 18c
    5. SQL Anywhere
    6. PostgreSQL
    7. MySQL
  2. Chapter 2: Interfacing SQL to a Procedural Language
    1. Building an Application with SQL and a Procedural Language
  3. Chapter 3: Using SQL in an Application Program
    1. Comparing SQL with Procedural Languages
    2. Difficulties in Combining SQL with a Procedural Language
    3. Embedding SQL in an Application
    4. Using SQL Modules with an Application
  4. Chapter 4: Designing a Sample Application
    1. Understanding the Client’s Problem
    2. Approaching the Problem
    3. Determining the Deliverables
    4. Building an Entity-Relationship Model
    5. Transforming the Model
    6. Creating Tables
    7. Changing Table Structure
    8. Removing Tables
    9. Designing the User Interface
  5. Chapter 5: Building an Application
    1. Designing from the Top Down
    2. Coding from the Bottom Up
    3. Testing, Testing, Testing
  6. Chapter 6: Understanding SQL’s Procedural Capabilities
    1. Embedding SQL Statements in Your Code
    2. Introducing Compound Statements
    3. Following the Flow of Control Statements
    4. Using Stored Procedures
    5. Working with Triggers
    6. Using Stored Functions
    7. Passing Out Privileges
    8. Using Stored Modules
  7. Chapter 7: Connecting SQL to a Remote Database
    1. Native Drivers
    2. ODBC and Its Major Components
    3. What Happens When the Application Makes a Request
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.145.97.248