From Serebra Learning Corporation
Exchanging Data with Excel 2007 
In
Excel 2007, there are a number of options for importing data and sharing data with other applications. Excel 2007 includes built-in functionality for importing text files and creating database queries to retrieve data from a variety of databases. Other applications, such as
Access,
Word, and
Outlook, can also import
Excel data. Using
XML in conjunction with Excel enables you to further manage
more...
Microsoft Windows Server 2003 Designing Security Part 3 
This multi-part curriculum will focus closely on the exam requirements. However to fully prepare for certification it should be used in conjunction with other learning/training resources in addition to ample real-world experience. The principal areas covered are the conceptual logical and physical designs for network infrastructure security data access control strategies and physical design for
more...
Microsoft Windows Server 2003 Designing Security Part 2 
This course focuses on the requirements of
Microsoft Exam 70-298. However to fully prepare for the certification it should be used in conjunction with other learning/training resources in addition to ample real-world experience. The principal areas covered are the conceptual logical and physical designs for network infrastructure security data access control strategies and physical design for
more...
Building XML-Based Web Applications Part 3: XSL and Data Islands 
This is the third course in a five part series that presents a detailed treatment of
Styling within
XML concentrating on
XSL. The evolution from
CSS to XSL is covered in detail. XSL transformation mechanisms are dealt with along with linking technologies XML filtering and sorting language constructs and creating new XML elements and a coverage of
XSLT. The course then covers treatment of Data
more...
Database Technologies Part 2: Introduction to SQL 


The second in a two-part series this course will teach students the fundamental skills and knowledge needed to acquire a foundation-level understanding of
SQL. Building on the basic relational database skills and knowledge acquired in the first course this course teaches students the essential SQL statements and associated variations needed to perform fundamental data access and manipulation on a
more...
From 123-CBT Computer Based Training
Oracle8 Performance Tuning Managing Memory and Disk I O 

... performance based on a smaller cache size.
Identify the data access methods that can cause extremes of hit ratios.
Select the appropriate guidelines in evaluating the cache hit ratio.
Match the buffer pool names with their functions.
Identify the initialization parameters used when creating multiple buffer pools.
Perform the steps to define the number of buffers for an instance using the
more...
Oracle8 Performance Tuning Strategies and Techniques 

...terprise
Manager (
OEM) tuning tools.
Use the available data access methods to tune the logical design of the database.
List the primary steps for operating system tuning.
Identify similarities between operating system and database tuning.
C ontent
Emphasis
Skills-Based
A udience
Database administrators, system administrators, applications designers and developers, and
more...
C Programming - Part 4 

...tisfied to delete a node in a given situation. Match the data access methods with their features. Identify the code used to create a linked list index. Identify the code used to write the linked list index to disk. Identify the code used to handle the insertion of a node in an existing linked list index. Identify the code used to handle deletions of records from an existing linked list
more...
Visual InterDev 6 0 Accessing Remote Data 

...ipulate database records by using
SQL, stored procedures, data access models and cursors.
Implement business rules by using triggers.
Identify the components of
Remote Data Services (
RDS).
Identify the methods of navigating and manipulating data by using the components of Remote Data Services (RDS).
Identify the benefits of using
COM components.
Create a COM component in
Visual more...
Visual InterDev 6 0 Accessing Remote Data 

...ipulate database records by using
SQL, stored procedures, data access models and cursors.
Implement business rules by using triggers.
Identify the components of
Remote Data Services (
RDS).
Identify the methods of navigating and manipulating data by using the components of Remote Data Services (RDS).
Identify the benefits of using
COM components.
Create a COM component in
Visual more...
Access XP Expert User 

Course
Overview This course covers the more complex aspects of working with data using
Access 2002. Assuming the learner is already proficient in
Access, the course covers advanced features of database queries, and enhancing forms and reports. Learn To Create an update query. Create a delete query. Create an append query. Create a form in
Design view.
more...
Database Technologies Relational Database Fundamentals 

...data design. This course will also cover the evolution of data access and the role that databases and associated enabling technologies play in today's corporate environments. Students should leave this course with a solid foundation in the 'what' and 'why' of relational databases, plus an introduction to the 'how' of data modeling and design. Learn To: o
Identify database concepts,
more...
Visual Basic NET-Web Based Development Part 3 

...T and guides the learner through database connections and data access. Learn To: o To identify features of
ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of
SQL Server security authentication. o To mtch connection string parameters with their functions. o To identify characteristics of a
more...
Visual Basic NET-Web Based Development Part 3 

...T and guides the learner through database connections and data access. Learn To: o To identify features of
ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of
SQL Server security authentication. o To mtch connection string parameters with their functions. o To identify characteristics of a
more...
Windows 2000 Implementing Security Part 1 

... To identify risks to data and data access on a network. To identify potential security threats to data on a network. To identify measures used to assess the security standard of a network. To identify guidelines for selecting a centralized administrative model.
more...
Windows 2000 Implementing Security Part 1 

... To identify risks to data and data access on a network. To identify potential security threats to data on a network. To identify measures used to assess the security standard of a network. To identify guidelines for selecting a centralized administrative model.
more...
Essentials of Management Negotiating Skills 

In "
Essentials of
Management:
Negotiation Skills" you will learn about the basic types of negotiations and the skills required to use them. You will also learn how to prepare effectively for negotiation by setting your goals and limits and applying logic. Because negotiation is essentially about communication, you learn about the value of mutual benefit and positional negotiation and other
more...