Instructor Led Databases Training in United States

Predictive Analytics and Data Mining - Model Development ...her posses a large database or have access to one. These databases contain so much data that it becomes very difficult to understand just what that data is telling us. There is hardly a transaction that does not generate a computer record somewhere. All this data has meaning with respect to making better business decisions or understanding customer needs and preferences. But how do you  more...

GAGEtrak Calibration Management Software Training ...AGEtrak SQL Server edition can accommodate the largest of databases and the addition of many more users. We offer a variety of training options to assure that you get the most out of your GAGEtrak software: personalized web training, two-day regional training and on-site training. Our talented instructors will guide you through the planning, preparation, setup and successful operation of  more...

FileMaker Pro Part II Students will learn how to create more complex field definitions and calculations, how to work with many-to-many relationships, lookups, and table data summaries, how to work with complex scripts, understand table relationships, summarize data, and create buttons and scripts.  more...

FileMaker Pro Part I Learn the core features and functions of FileMaker Pro. View, edit, sort, and search for records, create databases, import data, and design layouts. Work with table relationships, simple scripts, and complex find requests. Save data and reports as PDF and Microsoft Excel files.  more...

Microsoft Access - Part I This introductory course covers the basic functions and features of Access. Learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Prerequisite: Intro to Windows or equivalent. Next Course of AACTTion: Access - Part II (Save 10% when registering for both)  more...

Microsoft Excel - Part III Work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. Learn about data validation and database functions such as DSUM. Work with PivotTables and PivotCharts, import and export data, and query external databases. Learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.  more...

Adobe Lightroom Photographic Workflow: Organize, Process, and Output ...Topics: Browser vs DAM: understanding Lightroom's catalog databases Lightroom's Library module: view, organize, sort and rate your images. Develop your images with finesse and repeatability Nondestructive retouching. Copy your retouching to other images Get images from camera to client: shortcuts and tips to prepare images for their final destination. Manage color: what are ICC profiles and  more...

GP Essentials for IT - Beyond the Basics Topics of this class include: Basic SQL Management, SQL 2005 & 2008 Overview, Configuration of reporting Services a How to Make SQL reports visible in GP, Overview of SQL Report Builder, Disaster recovery, SQL Maintenance Plans, Recommended File maintenance for GP SQL Databases.  more...

SQL Server Programming and Database Administration Beginner to Advanced ... For the basics level no prior experience with SQL Server Databases is expected. Some Computer Systems and Software Programming background is helpful to understand these topics. You may register for all three modules (Basic, intermediate and Advanced) at once or a specific module that suits your requirements. Hands on Lab exercises ensure that you practice and thoroughly understand all the  more...

Introduction to SQL Gain a solid working knowledge of the most powerful and widely used database programming language.  more...

Crystal Reports XI ...ur job responsibilities require you to obtain output from databases. It is also the first course in the Crystal Reports XI series. In this course, you will build basic list and group reports that work with almost any database. This course is designed for a person who needs output from a database. In some cases, database programs have limited reporting tools, and/ or they may not have access to  more...

OpenOffice The Free and Powerful Alternative to Microsoft ...r word processing, spreadsheets, presentations, graphics, databases and more. It stores all your data in an international open standard format that can easily be shared with virtually all other applications. Participants will get a hands-on, broad-brush overview of the complete OpenOffice suite including simplified download and installation instructions. This class is applicable to all  more...

Microsoft Excel 2007 Level III Advanced builds on the skills and concepts taught in Excel 2007: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases.  more...

MicrosoftOffice 2010 Transitioning from Office 2003 identify the features that are common to all applications in the Microsoft Office suite. modify documents using Microsoft Office Word 2010. present spreadsheet data using Microsoft Office Excel 2010. create Microsoft Office PowerPoint 2010 presentations. work with databases using Access 2010. manage tasks using the new features in Microsoft Office Outlook 2010. share files in Microsoft  more...

Access 2007 Level I Introduction ...e job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. Course Content: Lesson 1: Exploring the Microsoft ® Office Accessa 2007 Environment Examine Database Concepts Explore the User Interface Use an Existing  more...

FileMaker Advanced Training Class ...Students will develop a system of automated inter-related databases, and will share databases over a network or the Internet. This class is suitable for FileMaker Pro versions 8, 8. 5, 9, 10 and 11. Prerequisites: Before taking this course, students should have completed the Learning FileMaker Pro: Intermediate course. In addition, they should be familiar with the basic functions of their  more...

Learning FileMaker Pro Introduction Overview: Students will use FileMaker Pro 11 to create and use databases to store and organize information so that it is available for efficient retrieval. This class is suitable for FileMaker Pro versions 7, 8, 8. 5, 9, 10 and 11. Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.  more...

Oracle Database 11g R2 RAC and Grid Infrastructure for Administrators ...AC environment. Students will learn to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL, and SQL*Plus. Students will study the new connection architecture and how to make those connections highly available. Backup and recovery issues relative to cluster database environments will also be studied. The primary focus of this course is on  more...

Implementing a Microsoft SQL Server 2005 Database Training ... implementing a database. Learning Objectives Create databases and database files Create data types and tables Use XML-related features in Microsoft SQL Server 2005 Plan, create, and optimize indexes Implement data integrity in Microsoft SQL Server 2005 databases by using constraints Implement data integrity in Microsoft SQL Server 2005 by using triggers Implement views Implement  more...

Implementing a Microsoft SQL Server 2008 Database Training ...implementing a database. Learning Objectives Create databases and database files Create data types and tables Use XML-related features in Microsoft SQL Server 2008 Plan, create, and optimize indexes Implement data integrity in Microsoft SQL Server 2008 databases by using constraints Implement data integrity in Microsoft SQL Server 2008 databases by using triggers Implement views  more...

Querying and Processing SQL Server Data with SQL Statements Training This two-day, hands-on course covers everything database administrators and developers need to know to query SQL Server databases using SELECT statements ranging from simple to complex, and use INSERT, UPDATE and DELETE statements to modify and maintain data. Creating and using of VIEWS is also covered, along with accessing data through stored procedures and user-defined functions.  more...

Complete C using VS 2010 Training Intertech's Complete C# course is designed to expose experienced software developers to the C# programming language and the core APIs of the .NET platform. The course will begin by exposing attendees to the syntax and semantics of the C# programming language and Object Oriented Programming (OOP) concepts. Students will gain an understanding of the .NET type system (classes, structures, enums,  more...

CNET Training Intertecha ™s Complete C# starts by teaching students C# syntax and semantics as well as the concepts of Object Oriented Programming (OOP). In the class, students learn classes, enums, structures, delegates, and interfaces (the .NET type system). Students also learn, file Input/ Output and metadata. This course also covers ASP. NET, Windows Forms, and ADO. NET. Learning Objectives: During  more...

Access (classroom training) in San Francisco at AcademyX Access Introduction is taught by AcademyX, (www.academyx.com, 415-392-8024), the San Francisco's only Internet-focused, instructor-led training company in the Bay Area. This course is for the new user of Access and assumes no experience with relational databases. The topics cover the critical skills you need to get started creating databases in Access and working with the data by using tables,  more...

Microsoft Office 2007 ...Databases in Access Table Design and relating tables Queries to extract specific data Customized input forms Reports Export/ Import into other Microsoft Office Applications Excel Spreadsheet Creating Formulas, Formatting, Shortcuts, Copy/ Cut/ Paste, Printing Charting Logical Functions, Financial Functions Printing Techniques Outlook Distribution Groups, Contacts Management,  more...

LINQ Training .NET 3. 5 introduces significant updates to the C# and VB programming languages, many of which are specifically used to enable Language Integrated Query (LINQ). Intertecha s Complete LINQ begins by detailing each of these new language features (including extension methods and lambda expressions). Once the foundation has been laid, attendees will learn to build query expressions using LINQ query  more...

VBNET Training Intertecha s Complete VB course is designed to expose experienced software developers to the VB programming language and the core APIs of the .NET platform. The course will begin by exposing attendees to the syntax and semantics of the VB programming language and Object Oriented Programming (OOP) concepts. Students will gain an understanding of the .NET type system (classes, structures, enums,  more...

Perl Training This course introduces users, programmers and system administrators to the popular interpreted language called Perl (Practical Extraction and Report Language). Although Perl is hailed as the system administrator's language and is the standard de facto language for writing dynamic web pages, this practical course will be useful for anyone working with UNIX text files, databases and processes.  more...

Fast Track to Hibernate Hibernate is now one of the most popular open source Object-Relationaal Mapping (ORM) solutions for Java, with support for relationships and inheritance, and powerful object-based querying with the SQL-like Hibernate Query Language (HQL). Hibernate supports the new Java Persistence API (EJB 3) specification, which it heavily influenced, with the Hibernate Annotations and Hibernate Entity Manger  more...

Microsoft Access 2007 - Starting a Database ...articipants with a basic introduction to Microsoft Access databases, covering simple tables, queries, forms, and reports. Participants will create their own database for a fictitious customer listing and run reports for basic analysis and mailing address labels. The differences between Access and Excel will also be discussed. ~~~~~~~~~~~~~~~~~~ About the Location Classes are located at  more...

Microsoft Access 2003 - Beginning ...des participants with an introduction to Microsoft Access databases, covering tables, queries, forms, and reports. Participants will create their own database to track customer data and run reports for basic analysis. The class will cover best-practices for creating tables and table relationships (including lookup menus), query features such as criteria and sorting, and a primer on building  more...

Fast Track to Java 5 - Java 6 and OO Development Using Rational Application Developer (RAD) ...orking with the Java Collections Framework, and accessing databases with JDBC. This course is suitable for environments using either Java 5 or Java 6. The material includes coverage of all the new Java capabilities, such as Generic Collection classes, and clearly points out which capabilities are supported in which Java release. All labs are doable in any of the supported Java environments.  more...

Fast Track to Hibernate Using Hibernate For Java Database Access Hibernate is an open source object/ relational (OR) persistence and query service for Java. Hibernate lets you develop persistent classes following common Java idioms - including association, inheritance, polymorphism, composition and the Java collections framework. The Hibernate Query Language, designed as a minimal object-oriented extension to SQL, provides an elegant bridge between the  more...

Fast Track to Java 5 Java 6 and OO Development ...orking with the Java Collections Framework, and accessing databases with JDBC. This course is suitable for environments using either Java 5 or Java 6. The material includes coverage of all the new Java capabilities, such as Generic Collection classes, and clearly points out which capabilities are supported in which Java release. All labs are doable in any of the supported Java environments.  more...

JDBC - Java Database Connectivity ...databases. It is a core part of J2EE, and it works with every major database product. This hands-on course covers all the details that you will need to use JDBC to access the information in your databases using Java. It also talks about real world issues in using JDBC. All labs can be done with the Eclipse IDE or a simple editor, and the lab instructions include detailed directions on both  more...

Microsoft Access - Introduction Students will learn the basic skills necessary to begin using MS Access. They will design and create databases, tables, queries, forms, and reports.  more...

Advanced Business Intelligence Architecture Issues Lead the Field: Learn the key topics you need to know about to build business intelligence that masters modern challenges with current capabilities Intended Audience: a Business intelligence and data warehouse practicioners with at least 6 months of experience a This includes Program and Project Managers, Architects, Data Modelers, Business Analysts and Tool Specialists a The class  more...

ASPNET Using VB DOTNET This course provides a practical, hands-on coverage of developing Web applications using ASP. NET and VB. NET. It also introduces Web services. This five-day version of the course includes extensive coverage of powerful new features in ASP. NET 2. 0, such as personalization, Web parts, master pages, themes and skins, and new data binding. A shorter four-day version of the course covering ASP. NET  more...

Windows Presentation Foundation Using C# This course introduces Windows Presentation Foundation or WPF (a Avalona ), the new .NET technology from Microsoft for building rich Windows applications. It was originally part of .NET 3. 0, previously called a WinFXa by Microsoft. WPF includes an XML-based markup language for defining program elements, Extensible Application Markup Language (XAML). WPF applications can be created using only  more...

Windows Presentation Foundation Using C# This course introduces Windows Presentation Foundation or WPF (a Avalona ), the new .NET technology from Microsoft for building rich Windows applications. It was originally part of .NET 3. 0, previously called a WinFXa by Microsoft. WPF includes an XML-based markup language for defining program elements, Extensible Application Markup Language (XAML). WPF applications can be created using only  more...

Maintaining a Microsoft SQL Server 2005 Database ...y.   Perform administrative tasks.   Backup databases.   Restore databases.   Monitor SQL Server.   Troubleshoot SQL Server.   Transfer data.   Maintain high availability.   Prerequisites Before attending this course, students must have: Basic knowledge of the Microsoft Windows operating system and its core functionality.    more...

PHP 4 Introduction PHP 4: Introduction explores all of the major elements of PHP programming. With PHP, you can build dynamic, data-driven Web sites that use a variety of databases. Easy-to-understand code samples are used to demonstrate the many elements and techniques used in PHP programming.  more...

Quattro Pro 10 - Charts And Databases Quattro Pro 10 will introduce students to creating charts to graphically represent their data and the database features of Quattro Pro including sorting, locating, extracting, manipulating, and calculating data, and presenting it in meaningful reports. You can get a complete list of other Desktop Application Software classes at  more...

Notes 6 Databases (e-mail groupware) ...Databases . This course was designed for individuals who will use Notes databases on the job to share information stored in a central location, and who may or may not use Notes as their email package. The topics in this course cover the critical skills necessary to open existing databases and to create, modify, delete, search for, and organize documents within those databases. You can get a  more...

FileMaker Pro 5.5 Basic Skills For (Windows) FileMaker Pro is a powerful database program that allows tremendous flexibility in the entry and manipulation of information. In this course, you will learn the basics of FileMaker Pro so that you can create and use databases to organize your information. You can get a complete list of other Desktop Application Software classes at  more...

FileMaker Pro 5.5 Relational Databases (Windows) In this course, you will learn powerful techniques for developing complex database systems containing multiple linked database files. You will learn about the various relationship types, link databases together, use field formatting options, and will create buttons and scripts to create a system that is ultimately easy and efficient for an end user to work with. You can get a complete list of  more...

Access 2002 (XP) - Level 2 ...the basic skills you need to design and create relational databases with Access. At this point, you're about knee-deep in Access. You're able to get started and work through many of the essential and straightforward tasks related to your work. You might be hopeful that no one will ever ask for anything too complicated! This course takes you to the next step. By the end of it, you'll be a  more...

Access 2002 (XP) - Level 1 This course is for the new user of Access and assumes no experience with relational databases. The topics cover the critical skills you need to get started creating databases in Access and working with the data by using tables, queries, forms, and reports. You can get a complete list of other Desktop Application Software classes at  more...

FileMaker Pro - Introduction Windows You have probably used a computer to gather, process, and share information. For example, you may have searched for product information on the Internet, totaled expenses using a spreadsheet application, or typed and printed a memo using a word processing application. You may now need to store a large amount of information in an organized manner so that you can quickly and easily sort the  more...

Enterprise Linux Security Administration This highly technical course focuses on properly securing machines running the Linux operating systems. A broad range of general security techniques such as user/ group policies, and file integrity checking are covered. Advanced security technologies are taught such as Kerberos, SELinux, and the hardening of popular applications such as Apache, databases, and email systems. At the end of the  more...

Introduction to Oracle9i - Advanced SQL Essential advanced features within the Oracle SQL language are considered within this course. Building indexes, specifying declarative constraints, managing security privileges for tables and using SQL to satisfy some of the most complex query requests are all among the topics considered within this course. This course largely focuses on SQL features that are unique to the Oracle database and as  more...

Oracle 9i Discoverer For Power Users Experienced Oracle Discoverer users are interested in knowing how the advanced features of the Oracle SQL language can be incorporated into Discoverer queries. Within this course users will learn how to enhance their queries through the use of correlated subqueries, functions, processing of hierarchies and other advanced SQL techniques. When these advanced techniques are combined with the  more...

Oracle Database 10g - Data Modeling This Oracle 10g courseware training guide book will consider the logical design of relational databases using a methodology known as semantic data modeling and related practical techniques. (This same course is also known by the name RELATIONAL DATABASE DESIGN). This course is one common starting point for the entire database curriculum. You can get a complete list of other Oracle classes  more...

Oracle Database 10g - Implement Parallel SQL & Partitioning For Data Warehouses ...ills needed to administer data warehouses. As the size of databases and data warehouses increases, one cannot rely upon the default features of the Oracle database to sufficiently process such massive volumes of information. One must employ advanced features intended for such environments. In fact, these features are at the same time, among the most powerful tuning options available within the  more...

Oracle Database 10g - Implement Parallel ...ills needed to administer data warehouses. As the size of databases and data warehouses increases, one cannot rely upon the default features of the Oracle database to sufficiently process such massive volumes of information. One must employ advanced features intended for such environments. In fact, these features are at the same time, among the most powerful tuning options available within the  more...

Oracle Database 11g- Data Warehousing & Oracle Warehouse Builder This Oracle 11g courseware training guide book will highlight the features within the Oracle database specifically intended to support data warehouses and data mining operations. It is presented as a two-volume set. The first volume considers data warehousing concepts and the requirements to initially configure a data warehouse installation. The second volume discusses how the Oracle Warehouse  more...

Programming Languages for Lotus Domino Designer R5- LotusScript ...ements to operate on the Domino object classes, including databases, views, documents, fields, and ACL settings. This course is not a beginning programming class or a mere overview presentation of the LotusScript implementation in Domino and the Notes Client. You will spend a good portion of the course coding in LotusScript and debugging code that will have immediate application beyond the  more...

Advanced SQL Queries for Oracle9i Databases This course will provide experienced Oracle developers the advanced skills necessary to design and code the complex queries and applications required to solve enterprise business problems. You will learn to incorporate many advanced techniques such as the data warehouse functions CUBE and ROLLUP, DECODE, inner and outer joins, CONNECT BY (hierarchical queries), SET operations, correlated  more...

Relational Database Design Oracle9i Architecture Design This course is one common starting point for the entire database curriculum. The objective of this course is to consider the logical design of relational databases using a methodology known as semantic data modeling and related practical techniques. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  more...

OpenOffice Base 2.3 Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer-based applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and design and modify databases  more...

Lotus Notes 6.5- Databases ...Databases. This course was designed for individuals who will use Notes databases on the job to share information stored in a central location, and who may or may not use Notes as their email package. The topics in this course cover the critical skills necessary to open existing databases and to create, modify, delete, search for, and organize documents within those databases. You can get a  more...

Notes 7- Databases You have already worked on personal computers. Now, you would like to share information stored in a central location with other users. In this course, you will use Notes databases to do just that. You can get a complete list of other Desktop Application Software classes at http://www.wintrac.com/courses/coursesdesktop.asp  more...

FileMaker Pro 6.0 Level 2 (Windows) ...ven designing some yourself. You may have created several databases to track information like contacts, inventory, or other information that you can't adequately manage using a spreadsheet or word processing application. However, you may be faced with a project where a single FileMaker database cannot handle the information you need to manage. For example, you may want to link customers with  more...

Microsoft Office Access 2003- Level 2 ...ou need to work with a Microsoft ® Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other  more...

Relational Database Design (Second Edition) For many new or intermediate database developers, it's difficult to know where to start when designing a relational database. It's easy to make the mistake of assuming that the functionality of a database will take shape over time, or the design will fall into place as you build the database. This course covers the steps to effectively plan and design functional, efficient databases. You can  more...

FileMaker Pro 7.0- Level 2 (Windows) ...robably been using FileMaker Pro for a while, maintaining databases that other people have designed, and even designing some yourself. You may have created several databases to track information like contacts, inventory, or other information that you can't adequately manage using a spreadsheet or word processing application. However, you may be faced with a project where a single FileMaker  more...

FileMaker Pro 7.0 -Level 1 (Windows) You have probably used a computer to gather, process, and share information. For example, you may have searched for product information on the Internet, totalled expenses using a spreadsheet application, or typed and printed a memo using a word processing application. You may now need to store a large amount of information in an organized manner so that you can quickly and easily sort the  more...

Microsoft Office Access 2007- New Features You have worked with Microsoft ® Office Access 2003 (or earlier), and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your databases. In this course, you will be introduced to the new features available in Microsoft ® Office Access 2007. You can get a complete list of other Desktop  more...

Microsoft Office Access 2007- Level 1 (Second Edition) ...and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft ® Office Accessa 2007 relational database application. You  more...

Microsoft Office Access 2007- Level 2 (Second Edition) ...needed to work with Microsoft ® Office Accessa 2007 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other  more...

Microsoft Office Access 2007- Level 4 (Second Edition) In previous levels, you were introduced to the various features of Microsoft ® Office Accessa 2007 that dealt with local database management. However, effective database management calls for mastering the advanced administrative and collaborative features of Access. In this course, you will exchange data with other applications, automate business processes by using VBA code, and secure and  more...

IBM Lotus Notes 8- Databases You have worked on personal computers. Now, you would like to share information stored in a central location with other users. In the IBM? Lotus Notes? 8: Databases course, you will use Notes databases to create, edit, and enhance database documents. You will also create blogs in the Notes database to facilitate discussion among the users. You can get a complete list of other Desktop  more...

FileMaker Pro 9- Level 1 You have probably used a computer to gather, process, and share information. For example, you may have searched for product information on the Internet, totalled expenses using a spreadsheet application, or typed and printed a memo using a word processing application. You may now need to store a large amount of information in an organized manner so that you can quickly and easily sort the  more...

FileMaker Pro 9- Level 2 ...robably been using FileMaker Pro for a while, maintaining databases that other people have designed, and even designing some yourself. You may have created several databases to track information such as contacts, inventory, or other information that you can't adequately manage using a spreadsheet or word processing application. However, you may be faced with a project where a single FileMaker  more...

AutoCAD Electrical 2010 Fundamentals AutoCAD Electrical 2010 Fundamentals (3 days) covers the indispensable core topics for working with AutoCAD Electrical. In this training guide, students learn how to use many of the powerful electrical drawing creation tools in AutoCAD Electrical. Students learn to create schematic drawings, panel drawings, and PLC-I/ O circuits using automated commands for symbol insertion, component tagging,  more...

AutoCAD Electrical 2008 Fundamentals AutoCAD Electrical 2008 Fundamentals covers the indispensable core topics for working with AutoCAD Electrical. In this course, students will learn to use many of the powerful electrical drawing creation tools in AutoCAD Electrical. Students will create schematic drawings, panel drawings, and PLC/ IO circuits using automated commands for symbol insertion, component tagging, wire numbering, and  more...

PROGRAMMING DATABASES WITH MICROSOFT SQL SERVER 2000 - LEVEL 2 This course shows you how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL (T-SQL), the programming language of SQL Server. You'll also learn how to take advantage of SQL Server's tools for maintaining, securing, and tuning your databases. You can get a complete list of other Sql server classes at  more...

AquaLogic BPM Programming BPEL Integration ...tion of SOA components, defining external SOA components (Databases, Web services, EJBs, AquaLogic Service Bus, etc), development of Web services, using messaging-enabled services, utilization of JMS, depict the role of the AquaLogic Service Bus, using the message brokers, SOA security integration, building publisher and subscriber applications, durable and non-durable event processing, using  more...

Advanced Technology Tour ...l explanation of client/ server architectures, relational databases, object orientation, GUI application development and networks is considered. This course may be presented in either a vendor-specific manner, such as from the perspective of Oracle Corporation, or a vendor-independent manner, presenting these technologies in a fashion applicable to Microsoft, IBM and others. You can get a  more...

Lotus Domino 7- Administration Basics During this course you will install and configure the Lotus Domino Server and Domino Administrator. When you finish the course, the Server will be ready to serve Domino databases to Notes clients and browsers and to delivery mail within a single Domino Domain. This course places special emphasis on security and replication, two core features of Domino. You can get a complete list of other  more...

IBM Lotus Notes 8 You have worked on personal computers. Now, you would like to share information stored in a central location with other users. In the IBM? Lotus Notes? 8: Databases course, you will use Notes databases to create, edit, and enhance database documents. You will also create blogs in the Notes database to facilitate discussion among the users. You can get a complete list of other Desktop  more...

Relational Database Design ( Enterprise Architecture) This course is one common starting point for the entire Sideris database curriculum. The objective of this course is to consider the logical design of relational databases using a methodology known as semantic data modeling and related practical techniques. You can get a complete list of other Enterprise Architecture classes at  more...

Programming Fundamentals of Visual FoxPro 7.0 - Level 1 ... will learn to plan, create, and modify tables, views and databases and create forms. You will use the Application Wizard and Builder to build applications quickly. Create information from your data with queries and reports. Understand the fundamentals of programming including operators, expressions, program flow, branching and looping. Be productive working with code using IntelliSense,  more...

T-SQL 2008 ...mplex data structures and processes, and how to make your databases more scalable through partitioning. SQL Server 2008 includes a rich set of tools that go beyond the basics of querying and manipulating data. You will learn how to take advantage of the user-friendly management console that integrates both authoring and administrative tasks. You will learn how to take advantage of SQL Server's  more...

MICROSOFT SQL SERVER 2005 SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. You'll learn how to take advantage of the new, user-friendly management console that integrates both authoring and administrative tasks. You'll learn how to take advantage of SQL Server's tools for analyzing and tuning your databases. You'll also learn about integration services, implementing  more...

MICROSOFT SQL SERVER 2005 ADDITIONAL TOPICS Developing a database, getting the database to work with your applications, and getting it to production is just the beginning, but can often be where the story ends. This course examines other SQL Server 2005 essential application, support, and maintenance topicsa features you can use for high-availability, stability, reliability, and scalability of databases, plus enhancements for processing  more...

MICROSOFT SQL SERVER 2005 ADMINISTRATOR SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. In this course, youa ™ll learn about the administrative features that are available in SQL Server. This course also examines other SQL Server 2005 essential application, support, and maintenance topics a features you can use for high-availability, stability, reliability, and scalability  more...

Microsoft SQL Server 2008 for Developers ...the principals of database design are used in creating of databases and then how to apply server tables to them. The course continues with SQL Server Management Studio and how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. Learn how to make your databases more scalable through partitioning and how to use .NET languages like Visual C# and  more...

An Overview of XML This seminar will introduce XML and explain its implications for IT. You will: Learn what XML is and where it is useful Understand the parts of an XML document and what makes it well formed Understand how schemas impose structure on an XML document Understand how Style Sheets can transform an XML document Be introduced to certain core XML languages, such as  more...

Java Servlets This practical, application-oriented course teaches Java Servlets technology and shows how to use it to develop simple to complex web applications. It is intended for experienced Java (J2SE) programmers who want to build web applications or J2EE components and systems. The course begins with an overview of server-side Java programming and web protocols. Then students learn the Java Servlets  more...

COMPLETE LINQ .NET 3. 5 introduces significant updates to the C# and VB programming languages, many of which are specifically used to enable Language Integrated Query (LINQ). This course begins by detailing each of these new language features (including extension methods and lambda expressions). Once the foundation has been laid, students will learn to build query expressions using LINQ query operators and the  more...

Lotus Notes 7 Content Authors ...is course gives you experience using other kinds of Notes databases so that you can become an active contributor to the knowledge shared by your organization. During this course you will learn how to use your personal Journal database and participate in a Discussion with other users. The emphasis of this course is how to author database content using the full range of formatting tools.  more...

JDBC Programming ...9 constructs whenever possible in order to be relevant to databases from all vendors. The course software also includes an optional overlay of workspace and project files to support use of the Eclipse IDE in the classroom. (This requires that the instructor be experienced in use of Eclipse and able to walk students through basic tasks in the IDE.) You can get a complete list of other Java  more...

Lotus Notes 7 Content Editors ...gned for Notes users who have been given Editor access to databases and who are responsible for final document approval, production, and cataloging. As a database Editor, you are must be more security-aware than content authors. This course teaches you how to interrelate Notes documents and how to utilize Microsoft Office files in Notes documents. The course also demonstrates how to set up  more...

Lotus Domino 6-5 to 7 Administrator Update This course explains the benefits of upgrading to Notes and Domino 7 and describes how to plan for and upgrade an existing installation to Domino 7. You will learn the proper sequence to install the software and update the databases to avoid problems and service disruptions. This course thoroughly explores the many new features that make it easier to monitor and control Domino servers and  more...

Lotus Domino 8 Administration Basics During this course you will install and configure the Lotus Domino Server and Domino Administrator, and a Notes client to test the installation. When you finish the course, the Server will be ready to serve Domino databases to Notes clients and browsers and to delivery mail within a single Domino Domain. This course places special emphasis on database services, security, replication, and  more...

Lotus Domino 7 to 8 Administrator Update This course explains the new features benefits of upgrading to Notes and Domino 8 and describes how to plan for and upgrade an existing installation. You will learn the proper sequence to install the software and update databases to avoid problems and service disruptions. This course covers new administration tools and messaging features. It also explores the many new features that make it  more...

Ruby on Rails Training ...enefits of a best-practice MVC architecture Work with databases easily using ActiveRecord Create a user authentication system Use object oriented concepts like inheritance and polymorphism Build a comprehensive automated testing suite for your application Add plugins to easily enhance your application's functionality Implement caching to alleviate database  more...

Oracle Database Administrator Certification The Oracle Certified Professional Program establishes a highly recognized standard of excellence in today's I.T. market. This course provides a comprehensive foundation for designing, building and working with relational databases, enabling students to understand and use commercially available relational DBMS products effectively. Arthur McNeil provides the Oracle Database training  more...

Microsoft MCDBA ...ionals who implement and administer Microsoft SQL Server databases. The certification is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure SQL Server. The  more...

Implementing a Microsoft SQL Server 2005 Database ...pleting this course, students will be able to: Create databases and database files.   Create data types and tables.   Use XML-related features in Microsoft SQL Server 2005.   Plan, create, and optimize indexes.   Implement data integrity in Microsoft SQL Server 2005 databases by using constraints, triggers, and XML schemas.   Implement views.   Implement stored procedures and  more...

Core Data Access with Microsoft Visual Studio 2005 ...g this workshop, students will be able to: Connect to databases and read data.   Query and update databases by using commands.   Perform transactional operations.   Perform disconnected operations programmatically.   Perform disconnected operations by using Visual Studio 2005 wizards.   Perform XML operations on disconnected data.   Read and write XML data.   Process XML data  more...

Databases The following list is of all the courses and classes we provide. Learn how to create and manage databases using both Access and FileMaker. You will also learn how to manage information efficiently with Crystal reports and SQL You will learn all of the code that you will need to use these databases everyday.  more...

Databases The following list is of all the courses and classes we provide. Learn how to create and manage databases using both Access and FileMaker. You will also learn how to manage information efficiently with Crystal reports and SQL You will learn all of the code that you will need to use these databases everyday.  more...

Access 2003 Level I ...ss responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications. Prerequisites: To ensure the successful completion of Microsoft Access 2003: Level 1, we recommend completion of one of the following  courses, or equivalent knowledge from another source: Windows 2000: Introduction Windows XP: Introduction  more...

Access 2003 Level II ...lls you need to work with a Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other  more...

Access 2003 Level III ...lities. Course Objective: You will create complex Access databases using forms, reports, and macros. Who should attend: This course is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft Office Access 2003 database program. The Level 3 course is for the individual whose job responsibilities include working with heavily related tables; creating  more...

Microsoft SQL Server 2000 for Experienced Database Professionals This three-day course will teach database professionals who are already proficient in the implementation and maintenance of enterprise databases about the core architecture of Microsoft SQL Server™ 2000 and how it works. The primary focus of this course is to give experienced database professionals a jump-start to better understanding SQL Server 2000. This is not an advanced course or a  more...

Updating Your Database Administration Skills to Microsoft SQL Server 2005 This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support configure and maintain enterprise SQL Server 2005 databases and servers.  more...

Updating Your Database Development Skills to Microsoft SQL Server 2005 This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design build query and develop enterprise SQL Server 2005 databases and servers.  more...

Introduction to GIS Technologies ...n with other information technologies, such as enterprise databases and Internet applications, is also investigated. This is a survey course and provides an overview of the certificate program as a whole. Students with prior GIS knowledge and experience may waive this course in favor of another. What You Will Achieve Understanding the context of GIS and related technologies Knowing the  more...

Java Servlets ...eveloped using servlets and JDBC for access to relational databases. The course develops the important concept of the separation of programmatic and declarative development: use of configuration and context information in lieu of hard-coded values, resource locations, etc., to make the Web application as portable and easy to administer as possible. The course introduces JavaBeans as a standard  more...

Spatial Databases and Database Development ... GIS data is unique in that, unlike traditional data and databases, GIS data includes geographic location information as a key component of data. This requires special consideration for management and handling of this data. This course provides an introduction to spatial data and issues related to their management. Spatial data models are investigated along with prominent data types and  more...

Advanced Java Programming ...tivity 1. Database and SQL Fundamentals Relational Databases and SQL Database, Schema, Tables, Columns and Rows SQL Versions and Vendor Implementations DDL Creating and Managing Database Objects DML Retrieving and Managing Data Sequences Stored Procedures Using SQL Terminals 2. JDBC Fundamentals What is the JDBC API? JDBC Drivers Making a Connection Creating and Executing a  more...

Citrix MetaFrame Secure Access Manager 2.2: Administration If your organization turns to you to deliver secure, personalized access to applications and information...from anywhere, this course was designed for you. Learn how to install, secure, administer and configure Citrix MetaFrame Secure Access Manager to provide access to applications, internal and external data, documents, web content and services in a workplace that is tailored to each user s  more...

Object and Data Modeling Workshop ...project and how to transition from relational transaction databases to a data warehouse. Use the Rational ROSE modeling tool to model business requirements. What you will learn: Principles of Object Oriented Analysis Benefit of Object Oriented Analysis Determining how much modeling to do when the project is for a front-end to an existing legacy system Objects, classes,  more...

Updating Your Database Administration Skills to Microsoft SQL Server 2005 ...pport, configure, and maintain enterprise SQL Server 2005 databases and servers. Audience This course is intended for experienced database administrators and database developers who are responsible for the supporting, configuring, and maintaining enterprise SQL Server 2005 databases and servers. At Course Completion After completing this course, students will be able to: ? Describe the  more...

Updating Your Database Development Skills to Microsoft SQL Server 2005 ...sign, build, query and develop enterprise SQL Server 2005 databases and servers. Audience This course is intended for experienced database developers and database administrators, who are responsible for the design, build, query, and develop enterprise SQL Server 2005 databases and servers. At Course Completion After completing this course, students will be able to: ? Use the Development  more...

Introduction to Programming ..., who want to add advanced functionality to documents and databases.   ? Web designers who want to understand how programs and scripts can make Web sites more dynamic.   At Course Completion After completing this course, students will be able to: ? Describe a typical computer system and its critical components.   ? Describe the software development process, its purpose, critical steps, and  more...

Linux Networking Services ...ecture, Components, and Configuration Configuration Files Databases Text Files Network Access Masquerading sendmail Controlling access Configuring SMTP AUTH and Configuring SMTP STARTTLS Lab 17 - Configure Sendmail Install the sendmail SMTP server on the system and configure it to serve domains Configure sendmail to accept remote network connections Configure virtual hosts on sendmail  more...

Oracle Database 10g: New Features for Administrators ...at students need to understand if applications running in databases support the related features. Hands-on practice sessions give students an opportunity to examine many of the new features for themselves.   Who Should Attend:   Technical Consultant PL/SQL Developer Database Administrators Support Engineer Prerequisites: Administration experience with Oracle9i Database Course  more...

Oracle9i DBA Fundamentals II ...ents will examine loading and transporting techniques for databases, and the utilities used to perform these activities. Students are also introduced to networking concepts and configuration parameters, and solutions for common network problems. In hands-on exercises, students configure network parameters, enabling database clients and tools to communicate with the Oracle database server. This  more...

Programming a Microsoft SQL Server 2000 Database This course provides students with the technical skills required to program a database solution by using Microsoft SQL Server 2000. This course helps you prepare for the fol-lowing Microsoft Certified Professional exams: 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.  more...

WebSphere v5 Performance Tuning Tools and Methodology Workshop This course provides an introduction to various best of breed performance tuning tools such as JProbe, Resource Analyzer and Introscope. The course shows how to best use these tools to identify and resolve WebSphere application performance problems. After completing this course, the student should be able to: Understand the performance testing methodology Identify potential bottlenecks in  more...

Introduction to Oracle9i: SQL ...ers the concepts of both relational and object relational databases and the powerful SQL programming language. Students will create and maintain database objects and to store, retrieve, and manipulate data. Retrieval of data is accomplished by using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval, and also write SQL and SQL*Plus script files using the  more...

Introduction to Relational Databases Technology Introduction to Relational Databases (ITP410)  more...

Microsoft Windows Server 2003 MCSA Boot Camp ...Hosts include domain controllers, Internet Web servers, databases, e-mail servers, and client computers. Deploy and manage IPSec policies. Troubleshoot IPSec. Plan and implement security for wireless networks. Deploy, manage, and configure SSL certificates, including uses for HTTPS, LDAPS, and wireless networks. Considerations include renewing certificates and obtaining self-issued  more...

Microsoft Windows Server 2003 MCSE Boot Camp ...Hosts include domain controllers, Internet Web servers, databases, e-mail servers, and client computers. Deploy and manage IPSec policies. Troubleshoot IPSec. Plan and implement security for wireless networks. Deploy, manage, and configure SSL certificates, including uses for HTTPS, LDAPS, and wireless networks. Considerations include renewing certificates and obtaining self-issued  more...

Administering a Microsoft SQL Server 2000 Database ...n install an instance of SQL Server.   Manage files and databases, including determining resource requirements.   Choose a login security method, configure login security, plan and implement database permissions, and describe how to help protect SQL Server in an enterprise network.   Perform and automate administrative tasks and create custom administrative tools.   Back up databases  more...

Microsoft MCITP: Database Administrator ... or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security -or server automation and monitor and troubleshoot SQL Server activity. MCITP: Database Administrator candidates should meet the following prerequisites: - At least two or more years dedicated  more...