Module 1: Introducing SQL Server 2012 This module provides an overview of SQL Server 2012. Lessons Overview of SQL Server 2012 SQL Server 2012 Editions and Components After completing this module, students will be able to: Describe SQL Server 2012. List SQL Server 2012 Editions and Components. Module 2: Installing SQL Server 2012 This module […]
Implementing the Language Functionality Enhancements Use the new regular expression support functions to find sub patterns and count the occurrences of patterns Track dependencies at the element level Find and fix exception handlers that do not pass the exception upward to the calling program or environment Dispatch an over ride-able object type method using the […]
Introduction Course Objectives Course Agenda Describing the Human Resources (HR) Schema PL/SQL development environments Available in this course Introduction to SQL Developer Introduction to PL/SQL PL/SQL Overview Benefits of PL/SQL Subprograms Overview of the Types of PL/SQL blocks Creating and Executing a Simple Anonymous Block Generating Output from a PL/SQL Block Declaring PL/SQL Identifiers Different […]