We love eBooks
    Baixar Testing Oracle PL/SQL with SQL Developer (English Edition) pdf, epub, eBook

    Testing Oracle PL/SQL with SQL Developer (English Edition)

    Por Richard Thrust

    Sobre

    In this tutorial we will look at PL/SQL automated unit testing techniques using the SQL Developer test repository. You will learn:

    1. How to download and install Oracle XE 11g,
    2. How to download and install SQL Developer,
    3. How to perform all the DBA tasks required to support this tutorial,
    4. How to install the unit test repository,
    5. Testing techniques like: Boundary value analysis, Equivalence partitioning and Static testing,
    6. An overview of code coverage metrics and code complexity metrics,
    7. To create unit tests for a procedure, how to group tests in a test suite and how to execute a test suite,
    8. About the test reports that come with the SQL Developer unit test repository,
    9. To unload and load test suites and learn to execute test suites from the command line,

    After completing this self-contained tutorial you will have gained the knowledge to automate PL/SQL testing using the test repository.
    This is an important step forward in automating the testing of PL/SQL. Learn it today.

    Tutorial Table of contents

    Introduction
    Chapter 1 – Creating a test environment
    1.1 Download and install Oracle XE
    1.2 Download and install SQL Developer
    1.3 DBA tasks to set up the database
    1.4 Installing the unit test repository
    1.5 SQL Developer compiler options
    1.6 In conclusion
    Chapter 2 – Unit testing techniques
    2.1 Testing Methods
    2.2 Boundary Value Analysis
    2.3 Equivalence Partitioning
    2.4 State transition Testing
    2.5 Static Testing
    2.6 Sample Code – Unreachable Example
    Chapter 3 – Code Coverage Metrics
    3.1 Code Coverage
    3.2 Statement Coverage
    3.3 Branch Coverage
    3.4 Number of lines of code metric
    3.5 McCabe’s Cyclomatic Index Metric
    Chapter 4 – Unit testing with SQL Developer
    4.1 SQL Developer tweaks
    4.2 The sample code we will test
    4.3 Creating our first simple test
    4.4 Creating more test cases
    4.5 Executing test cases
    4.6 Creating a test suite
    4.7 Executing a test suite
    4.8 In summary
    Chapter 5 - SQL Developer Unit Test Reports
    5.1 The Unit Test Repository Reports
    5.2 All suite Runs
    5.3 All Test Implementations
    5.4 All Test Runs
    5.5 Suite Runs Code Coverage
    5.6 Suite Test Implementation Runs
    5.7 Suite Test Runs
    5.8 Test Implementation Runs
    5.9 Test Runs Code Coverage
    5.10 User Test Runs
    5.11 Conclusions about the test reports
    Chapter 6 - Manipulating Test Suites
    6.1 Loading and unloading test suites
    6.2 Executing test suites from the command line
    6.3 A Custom report on the repository
    Chapter 7 – In Conclusion
    7.1 Repository Benefits
    7.2 Repository Dis-advantages
    7.3 In summary
    Appendices
    Software Testing Related Standards
    Bonus Material related to this eBook
    More titles from Richard Thrust

    Baixar eBook Link atualizado em 2017
    Talvez você seja redirecionado para outro site

    eBooks por Richard Thrust

    Página do autor

    Relacionados com esse eBook

    Navegar por coleções eBooks similares