Vi ste ovdje
Overview/Description
To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected...
Overview/Description
Excel 2010 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Tables can be used to logically present data in an easy to read fashion and table styles provide a way to make your workbooks more attractive and professional looking. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines, a new feature of Excel 2010 are small charts within a cell that provide a visual...
Overview/Description
Microsoft Outlook 2007 allows for easy creation and management of all contacts. It provides an easy to use interface for creating contacts, along with business cards, that can also be used for sending e-mail, making meeting requests and journal entries, as well as assigning tasks. Outlook also offers multiple views to easily manage and track tasks. In addition, it allows you to create and store notes for later reference. This course explores how to create and manage contacts, tasks, and notes. It also demonstrates how to customize the Outlook interface using Outlook Today...
Overview/Description
To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected Duration (hours)
1.9
Lesson ObjectivesUsing...
Overview/Description
To recognize the steps for improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL, language enhancements, and a variety of performance enhancements
Target Audience
PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers
Prerequisites
The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL
Expected Duration (hours)
1.3
Lesson ObjectivesOracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements...
Overview/Description
In today's fast-paced world, information is sent and received more rapidly than ever before. But how do you ensure that the messages you are sending are effective, acceptable, and will be taken seriously? The use of proper e-mail etiquette is the cornerstone for ensuring your message gets across quickly, appropriately, and concisely. This course covers the basic requirements for using e-mail to communicate effectively. Specifically, you will be introduced to tried-and-true guidelines for e-mailing effectively, fundamental elements every e-mail should contain, and the...
Overview/Description
E-mail has become the most used communications medium in corporate networks today, with this high usage, comes an ever increasing need to understand the security considerations involved and how the end user can help in making sure E-mail security is maintained. Social networking, and the use of social media websites has added another level of complexity to network security as users are able to open security holes if the wrong type of information is made public. This course examines the ethical use of E-mail, guidelines for using E-mail safely, and how to deal with issues...
Overview/Description
Putting emotional intelligence to work is an emerging trend in the corporate world. Developing the best talents in executives, managers, and employees throughout the organization has become vital to workplace success. Intellectual knowledge is no longer enough; you must also have the interpersonal competence that comes with emotional intelligence. In this course, you'll learn the value of emotions and how they can affect your workplace for better or for worse. You'll gain an understanding of how emotional forces can influence performance and decision making, learn how...
Overview/Description
There are a number of methods for accessing and using external data with Excel 2010. Creating new or using existing data connections, you can access data from the Internet, Access and SQL Server databases, and Analysis Services. You can also import and export XML data, use Microsoft Query and the Query Wizard to create your own queries, and work from text files. This course explores the concept of data connections, including how to use existing connections to access data and how to create your own. In addition, this course covers how to create a web query to access online...
Overview/Description
Being able to collaborate with other users to efficiently disseminate information and complete projects is crucial in today's business environment. Excel 2010 provides numerous tools geared specifically toward collaboration, including Excel Web App and integration with SharePoint that allows for data to be easily exported. Excel 2010 data can also be linked to or embedded in other Office 2010 files, and other Office 2010 data can be linked to or embedded into Excel 2010 to create robust and professional content. This course explores the new Excel Web App, including...