Online Use Sql eLearning Training
From Serebra Learning Corporation
SQL Functions in Oracle 9i
To describe how to use SQL functions for data retrieval Junior database administrators, application developers, and database operators
more...
SQL Functions in Oracle Database 10g
To describe how to use SQL functions for data retrieval Database administrators, application developers, and database operators
more...
Oracle8i DBA--SQL*Loader, Oracle Export and Import, and NLS
...ansfer tools of Oracles. The course will teach you how to use SQL*Loader to load data into an Oracle database. The course will also teach you how to use the Oracle Export and Import Utilities. Next the course will detail explain the NLS feature of Oracle8i. The course initiates the learner into hands-on learning by helping the learner to type-in the commands to perform administrative
more...
Oracle SQL: Data Retrieval Techniques
This course is the second in a three-part Oracle series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition how to
more...
From 123-CBT Computer Based Training
Oracle9i Database Admin Manage Data Storage

...ts, identify the concepts associated with SQL*Loader, and use SQL*Loader to load data into tables. Identify the uses of the export and import utilities, the export modes, and the export paths. Reorganize data using export and import, identify the features and process of transportable tablespaces and the restrictions while using them. Audience The intended audience for
more...
SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries

...erate in medium to very large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. The general categories include: system administrators, database administrators, application developers, system analysts, and software engineers. Students are
more...
SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data

...erate in medium to very large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. The general categories include: system administrators, database administrators, application developers, system analysts, and software engineers. Students are
more...
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks

...29 operate in medium to large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). Learners are expected to have experience with using the Microsoft Windows 2000 operating system. Learners are also expected to have an understanding of basic relational database concepts and have knowledge of basic Transact-SQL syntax. In addition,
more...
SQL Server 2000 Design Implement Databases Part 4 Managing Indexes

...29 operate in medium to large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). Students are expected to have experience with using the Microsoft Windows 2000 operating system, understand database concepts and Transact-SQL syntax. Students should also be familiar with the role of the database administrator. In addition,
more...
SQL Server 2000 Design Implement Databases Part 3 Managing Objects

...29 operate in medium to large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). Students are expected to have experience with using the Microsoft Windows 2000 operating system, understand database concepts and Transact-SQL syntax. Students should be familiar with the role of the database administrator. In addition, students
more...
SQL Server 2000 Design Implement Databases Part 2 Managing Data

Course Overview This is the second course in a five part series that will teach students how to work with SQL Server data. Learn To Identify the SQL Server 2000 system-supplied data types. Add a user defined data type. Match the parts of a data row with their features. Identify characteristics of entity modeling. Identify features of attributes. Identify requirements for logical
more...
SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server

Course Overview This is the first course in a five part series that presents students with both theoretical and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases. Learn To Identify the features and functions of SQL Server 2000. Match the components of the client-server communication process with their features. Identify
more...
SQL Server 2000 Database Admin Part 4 Managing Data

...erate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and
more...
SQL Server 2000 Database Admin Part 3 Security Data Recovery

...erate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and
more...
SQL Server 2000 Database Admin Part 2 Manag Databases

...erate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and
more...
SQL Server 2000 Database Admin Part 1 Install SQL Server 2000

...erate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and
more...
IBM DB2 Universal Database V6 1--App Development

...amming, and dynamic SQL programming. L earn To: Use SQL functions in DB2 Applications. Use different application objects in DB2, such as schema, user-defined types, user-defined functions, and stored procedures. Use SQL within an application. Use dynamic SQL within an application. C ontent Emphasis Skills-Based A udience This course is intended for application
more...
IBM DB2 Universal Database V6 1--App Development

...amming, and dynamic SQL programming. L earn To: Use SQL functions in DB2 Applications. Use different application objects in DB2, such as schema, user-defined types, user-defined functions, and stored procedures. Use SQL within an application. Use dynamic SQL within an application. C ontent Emphasis Skills-Based A udience This course is intended for application
more...
Oracle SQL Specifics Creating and Managing Database Objects

...ontrol transactions.
Control DBA and user access.
Use SQL*Plus commands.
C ontent Emphasis
Skills-Based
A udience
Application Developers, System Analysts, Database Administrators, Technical Support Personnel. Prior knowledge of SQL and first course in this series, Oracle SQL Specifics: Retrieving and Formatting Data (Course 60116).
T otal Learning Time
6 - 8
more...
SQL and PL SQL Data Retrieval Techniques

... to enhance the power of SQL queries. In addition, how to use SQL*Plus commands to build on basic SQL statements and create customized queries that retrieve the information and display it in a format specified by the user will be covered. L earn To: Retrieve rows from multiple tables by using an equijoin, a non-equijoin, an outer join, and a self join. Write SQL statements that
more...
From Teach Me IT
Implementing an Oracle8 Data Warehouse

...ository with Oracle8
Partition VLDB tables with Oracle8
Use SQL*Loader
Implement Oracle products available for moving data into the warehouse
Index a data warehouse
Manage indexes in a data warehouse
Describe OLAP databases
Describe the storage mode supported by OLAP services
Describe the data warehouse tools used for querying data
Describe the Oracle Express Suite of tools used for
more...
Getting Started with SQL Server 2000

...escribe the SQL Server 2000 database engine architecture
Use SQL Query Analyzer and command-prompt utilities to interact with SQL databases
Describe the syntax elements used in T-SQL statements and the methods of executing T-SQL statements
Create a logical data model
Plan, create, and manage a SQL Server database
Define data types
Create and manage a table
Define the different types of
more...
VB 6.0 Database Basics

VB 6.0 Database Basics course is the first course of the three courses in the VB Databases curriculum. This curriculum prepares the students for the Microsoft Certified Professional Designing and Implementing Desktop Applications with Microsoft Visual Basic6.0 (70-176) exam. This course teaches students database basics and database creation through a VB application. Also, this course teaches the
more...
