Instructor Led 6 Database Training in United States

CE030-DB2 Family Fundamentals This course provides you with information about the functions of IBM's DB2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms. DB2 9 runs under the z/ OS, Linux, UNIX, and Windows operating systems, to name a few. The course includes discussion of how the DB2 products provide services. The focus is on the services DB2 provides and  more...

CL462- DB2 9 for LUW Advanced Database Administration for Experts This course is designed to teach you how to: Fully use the advanced technical functions and features of DB2 LUW. Perform advanced monitoring using the DB2 administrative views and routines in SQL queries. Use the db2diag. log file messages to direct your investigation of problems using db2pd, INSPECT, db2support, and DB2 traces. Use DB2's health monitoring and Health Center to review the health  more...

Data Integration for Data Mining with Talend Open Studio OS This course covers the many data integration procedures necessary to create a Customer Analytic Record (CAR) suitable for data mining operations. Talend OS is an Open Source tool; the client version is available for free download. The Talend company charges for the client/ server version of the tool and any support required for its installation and use. Data integration tools like Talend perform  more...

SQL Fundamentals Training SQL Database Fundamentals is a SQL training course, designed to provide essential skills and hands-on experience to be proficient at Structured Query Language (SQL) database. The class will introduce students to the fundamental and powerful concepts of Structured Query Language, the most widely used database technology in todaya ™s production environment. We will explore the inner workings of  more...

Web Development with PHP and MySQL Training Web Development with MySQL/ PHP is a training course designed to provide essential skills and hands-on experience in developing dynamic web applications using MySQL and PHP. The class will introduce students to PHP programming language and MySQL database administration, SQL database language and web development principles. Upon completion of the course we expect students to be able to create  more...

Web Development with PHP and MySQL Web Development with PHP/ MySQL is a PHP training course designed to provide essential skills and hands-on experience in developing dynamic web applications using PHP and MySQL. The course will introduce students to PHP programming language and MySQL database administration, SQL database language and web development principles. Upon completion of the course we expect students to be able to create  more...

MCITP Enterprise Support Technician MCITP Enterprise Support Technician Overview The Microsoft Certified IT Professional (MCITP) credential is the premier certification to highlight a professional's area of expertise, such as database administration, database development, business intelligence, messaging, or support. Who's It For? A Microsoft Certified IT Professional: Enterprise Support Technician (MCITP: Enterprise  more...

Ask an Expert- Brad Marquardt Free Conference Call 3 pm August 27th CST Ask and Expert-Brad Marquardt "It's not about the technology" Alicia Marie interviews Brad on why technology isna t working in your business or being embraced by your employees. He explains that your business vision and defining a business process before choosing your technology is paramount. Brad has been in business for over 20 years working with business owners in the technology  more...

Microsoft Excel 2010 Intermediate One day hands-on Microsoft ® Office Excel 2010 Intermediate class provides you the training in how to apply basic skill sets along with some intermediate to advanced functions to manage and audit numerical reports. You will work with various functions to perform specific types of calculations, customize charts, work with pictures or shapes in a worksheet, customize formatting for specific  more...

Advanced Website Development with MySQL, PHP and Ajax (5 Days) This is a five-day hands-on instructor-led training. Students will learn to use MySQL, PHP programming language, Advance JavaScript & Ajax. Students will work with MySQL databases by identifying the fundamental concepts of databases, creating a preliminary database design, applying normalization techniques, and familiarizing yourself with relational database management systems. Using various  more...

Fundamentals of Databases Using MySQL (1 Day) Storing and accessing data are part of a person's day-to-day activities. One of the most efficient and powerful ways of managing data is by using databases. Information can be stored, linked, and managed using a database application such as MySQL 5. 1. In the Fundamentals of Databases Using MySQL course, you will work with the databases utilizing MySQL. This course will also help students who are  more...

Database Design Specialist Training (3 Days) This is a three-day course that teaches students how to plan, design and implement a relational databases using MySQL. You will learn about the theory behind relational databases, relational database nomenclature, and relational algebra. The course includes sections on Structured Query Language (SQL) and optimizing databases through normalization. You will apply your knowledge with hands-on labs  more...

Introduction to SQL Language course (2 Days) In the course SQL: Fundamentals of Querying, you performed basic SQL querying. Because of various business conditions and requirements, in addition to querying the database, you may need to restructure and index tables. You may also need to manipulate the data in the tables using advanced queries. In this course, SQL: Advanced Querying, you will create advanced SQL queries to manipulate and index  more...

Fundamentals of Databases Using MySQL 1 Day Storing and accessing data are part of a person's day-to-day activities. One of the most efficient and powerful ways of managing data is by using databases. Information can be stored, linked, and managed using a database application such as MySQL 5. 1. In the Fundamentals of Databases Using MySQL course, you will work with the databases utilizing MySQL. This course will also help students who are  more...

Introduction to SQL Language 2 Days In the course SQL: Fundamentals of Querying, you performed basic SQL querying. Because of various business conditions and requirements, in addition to querying the database, you may need to restructure and index tables. You may also need to manipulate the data in the tables using advanced queries. In this course, SQL: Advanced Querying, you will create advanced SQL queries to manipulate and index  more...

Microsoft Access 2010 Intermediate Your training has provided you a solid foundation of basic and intermediate skills in Microsoft ® Office Accessa 2010. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working  more...

Microsoft Access 2010 Basic Most organizations maintain and manage large amounts of information. One of the most efficient 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  more...

Microsoft Access 2010 Advanced In previous levels, you were introduced to the various features of Microsoft ® Office Accessa 2010 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...

Advanced Website Design with MySQL PHP and Ajax (5 days) This is a five-day hands-on instructor-led training. Students will learn to use MySQL, PHP programming language, Advance JavaScript & Ajax. Students will learn to use the features of PHP for creating dynamic websites. You will acquaint skills in using PHP by working with its common script elements to create forms, address the stateless nature of HTTP by setting cookies and session variables and  more...

Microsoft Excel 2010 Intermediate (1 Day) Microsoft ® Office Excel 2010 a Intermediate teaches students how to apply basic skill sets along with some intermediate to advanced functions to manage and audit numerical reports. Students will work with various functions to perform specific types of calculations, customize charts, work with pictures or shapes in a worksheet, customize formatting for specific types of data, and look at  more...

Informatica Power Center Administration The course will be aimed at providing "hands on training for administering the Informatica Power Centre administration tasks. This instructor-led course provides the skills and knowledge to beginners and practioners, to be able to successfully carry out Informatica PowerCenter Administration. In addition to gaining tremendous insight into the administration activities, students will be  more...

Actuate Reporting Training The course will be aimed at providing detailed insight into Actuate reporting where you would learn the basics to design simple reports to create complex ones. The Actuate reporting is based on the desktop report design component called erdPRO. You can design reports from database tables, views or stored procedures. Each report has Heading, Body and Footer section.  more...

Adobe Dreamweaver CS5 Level 3 Course Description You know to create professional looking web pages. Now, you may need to vary the content on the pages dynamically. In this course, you will use Adobe ® Dreamweaver ® CS5 to create and administer database-driven sites. Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Professional  more...

Deltek MPM Training Using Deltek MPM In The Real World Duration: 3 days (Optional additional day to include cost/ schedule integration using the Deltek MPM Microsoft Project Interface). Students will experience extensive hands-on use of Deltek MPM as they step through the typical project management life cycle of setting up the MPM database and structures, initial project budget and schedule planning, ongoing  more...

ACT Customization and Administration Training Class This class is ideal for either a corporate ACT Administrator responsible for customizing a shared database on a network or a single user looking for a greater degree of ACT! customization fields and layout) and productivity. This class will review database design principles, as well as tips & tricks for easy customization. Installation and maintenance of ACT on a network will also be covered.  more...

Call Center Call Quality Assurance Certification The Quality Assurance call center training workshop is designed to meet the needs of the Director, Manager or Quality Analyst responsible for delivering a "best in class" quality monitoring and coaching program. Attendees will leave with the framework for their center ready for implementation. The QA and Monitoring Workshop will provide participants with an understanding of the elements that are  more...

Using the Model for Construction - Developing a Quantity Takeoff Cost Estimate LearnVirtual is an online training program that allows you to learn right from your desk! This 3 week series will review steps to use your model for the construction phase of a project. We will review how to assign database components to construction elements, how to develop quantity takeoffs for cost estimates and how to track change orders or RFI's. This class reviews how to do material  more...

Using the Model for Construction - Tracking Managing Change Orders LearnVirtual is an online training program that allows you to learn right from your desk! This 3 week series will review steps to use your model for the construction phase of a project. We will review how to assign database components to construction elements, how to develop quantity takeoffs for cost estimates and how to track change orders or RFI's. This class will review how to setup a  more...

Using the Model for Construction - Assigning Data to Building Components LearnVirtual is an online training program that allows you to learn right from your desk! This 3 week series will review steps to use your model for the construction phase of a project. We will review how to assign database components to construction elements, how to develop quantity takeoffs for cost estimates and how to track change orders or RFI's. In this class you'll learn about how to  more...

Drupal 6 training Drupal 6 content management system syllabus This class will show you how to put a Drupal site together where you can publish blogs, forums, and Ecommerce. No knowledge of databases or programming knowledge is needed.  more...

Comprehensive ASP Training In this ASP training course, students will learn to create dynamic websites using ASP and then learn advanced features of ASP to create sophisticated, efficient and easily managed database-driven websites.  more...

Comprehensive Dreamweaver Training This Macromedia Dreamweaver training class teaches students who are new to Dreamweaver to use the tool to build sophisticated database-driven websites using the server-side language of their choice (PHP, ASP, ColdFusion, or ASP.NET).  more...

Introduction to PHP Training In this PHP training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice.  more...

Java Servlets and JDBC Training This practical, application-oriented Java training 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 also provides in-depth coverage of database programming using JDBC and introduces the JDBC architecture  more...

Comprehensive Introduction to Oracle SQL on Oracle 10g This course is a common starting point in the Sideris Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide a comprehensive introduction to the SQL database language within the context of an Oracle database. This course can be tailored for application designers and developers, database administrators, and business users and  more...

Oracle Designer Data Modeling This Oracle training course considers all the features of building complex logical data models using sophisticated modeling techniques. Numerous real-world' problems and special situations are presented along with solutions. Classic structures and common models are also given to assist participants in rapidly completing a data model. Traditional modeling techniques as well as newer object-oriented  more...

Comprehensive Introduction to Programming with PL/SQL on Oracle 10g The Oracle PL/SQL language provides for programming logic features not contained within SQL. The grammar, syntax and benefits of using the PL/SQL language within an Oracle database environment are considered. This course can be tailored for Application designers and developers or Database administrators.  more...

Introduction to Perl/CGI Training In this Perl training course, students will learn to use Perl to create dynamic database-driven websites.  more...

Comprehensive PHP Training In this PHP training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice and to use advanced features of PHP to create sophisticated, efficient and easily managed websites.  more...

Comprehensive MySQL Training This MySQL training course gives a comprehensive introduction to the MySQL database. Students will learn everything from installing MySQL to optimizing MySQL databases.  more...

Advanced ASP Training In this advanced ASP training course, students will learn advanced features of ASP to create sophisticated, efficient and easily managed database-driven websites.  more...

FileMaker Pro Introduction This class is ideal for those who have been using FileMaker Pro without training or have never used FileMaker Pro before who want to acquire a solid foundation for creating FileMaker Database Solutions. Students will learn: Best practices for developing database solutions; Working with Data; Finding and Sorting Records; Printing and Previewing Data; Save data as a PDF; send to Excel; Importing/  more...

FileMaker Pro Intermediate This course is designed for individuals who have used FileMaker Pro to create simple databases and now want to develop more sophisticated solutions. Students will learn basic to moderately complex Scripts, Calculations, and Functions. By the end of the course, students will: learn and use common Calculation Functions and Custom Functions; Scripts to automate tasks; using the Script Debugger and  more...

Fundamentals of ClearQuest 7 Training Course Number: RPCO-310 Duration: 0. 5 day Format: Courseware Purchase, Group On-Site Training, Group Virtual Training, Public Virtual Training, Small Group Workshop Course Description This course is designed to cover the main topics needed by a new user of ClearQuest. Course Objective Upon completion of the course, students will be able to: a Explain the defect tracking  more...

Macromedia Dreamweaver Introduction/Intermediate Welcome to Sonic Training!. (http://www.sonictraining.com 877-760-0078) Macromedia (Dreamweaver, Flash, Fireworks), Adobe (Photoshop, InDesign, Illustrator), Database (SQL, Access, Filemaker Pro, Goldmine), Programming (HTML, CSS, XML, Access VBA, Excel VBA), MS Office (Excel, Access, PowerPoint, Word, Outlook, Project) instructor-led, classroom training at our location or your company location.  more...

Macromedia Dreamweaver Fundamentals -- Introduction & Intermediate Welcome to Sonic Training!. (http://www.sonictraining.com 877-760-0078) Macromedia (Dreamweaver, Flash, Fireworks), Adobe (Photoshop, InDesign, Illustrator), Database (SQL, Access, Filemaker Pro, Goldmine), Programming (HTML, CSS, XML, Access VBA, Excel VBA), MS Office (Excel, Access, PowerPoint, Word, Outlook, Project) instructor-led, classroom training at our location or your company location.  more...

Macromedia Flash / Actionscript -- Introduction & Intermediate What's in Flash MX: Basic + CBT: This ILT series course teaches students the fundamentals of using Flash MX to design animations for the Web. This course introduces students to creating and editing shapes, applying colors and line styles, combining shapes, importing bitmaps, and converting bitmaps to vector shapes. Course activities also cover adding and formatting text, using layers to arrange  more...

Adobe Photoshop Introduction (Beginning) Class You are starting to familiarize yourself with image editing using Photoshop. You would like to learn about the tools and features available to you in Photoshop CS2. In this course, you'll work with some of the tools and features to edit images using Photoshop CS2. Course Objective: You will use Photoshop CS2 tools for painting, retouching, and enhancing images. In addition, you will work with  more...

Adobe Indesign Introduction (Beginning) Class You are starting to familiarize yourself with print layout and design using InDesign. You would like to learn about the tools and features available to you in InDesign CS2. In this course, you'll work with some of the tools and features to create eye-catching printed documents using InDesign CS2. Course Objective: You will utilize Adobe InDesign CS2 to create and deliver eye-catching printed  more...

HTML & CSS - Fundamentals -- Introduction & Intermediate Course Description Overview: Students will learn about how to create Web documents using HMTL 4.01. Performance-based objectives Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to: Understand what HTML is, how it is used, and how it came to be. Use a text  more...

Microsoft Access 2003 - Introduction / Intermediate Course Description Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer 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 be introduced to the concept of the relational  more...

Microsoft Excel 2003 - Introduction / Beginning Course Description Performance-Based Objectives Upon successful completion of this course, students will be able to: create and apply templates. create and modify charts. work with graphic objects. calculate with advanced formulas. sort and filter data. use Excel with the Web. SEE DAY TWO BELOW FOR ADDITIONAL TOPICS Welcome to Sonic Training!. (http://www.sonictraining.com  more...

Illustrator and Quark Training Course Description Adobe Illustrator is a sophisticated graphics program capable of creating complex and attractive illustrations and type effects. You might need to create logos, advertisements, and other illustrations in Illustrator. If you have little or no experience with Illustrator, it can be overwhelming to start creating complex illustrations. In this course, you'll start by drawing and  more...

Xml Document Design (xml, Xhtml, Xsl, Xpath, Xlink, Xslt) Course Description Prerequisites: students should be able to demonstrate basic HTML and Internet knowledge. Students will create and apply styling to XML documents in a series of hands-on labs that focus on the development of coding conventions and compliance with the rules for well-formed XML. What's in XML Document Design: Student Guide: XML Document Design is an 18-hour, instructor lead  more...

Filemaker Pro & ACT! & Goldmine Training Course Description 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  more...

Hyperion Tools training At BI Technologies, we offer a simple explanation of why were in business. We provide training in all BI tools and data warehousing. We are specialized in Hyperion Products. Hyperion products are leading BI tools which have potential Job opportunity for wide range of people. We provide hands-on with real time project examples. We have both Crash courses and Long length courses as per our  more...

Teradata Training At BI Technologies, we offer a simple explanation of why were in business. We provide training in all BI tools and data warehousing. We are specialized in one of the high end database Teradata training. We have Teradata Certified Masters with vast knowledge and real time experience. We have both Crash courses and Long length courses as per our client needs. Below is the brief information  more...

SQL SERVER DBA SQL Server comprehensive training program contains both Database Administrator and Business Intelligence Developer concepts. The first part of the program focuses on database administration which includes SQL Server 2008 installation, configuration, and maintenance. This also covers the market demand concepts such as T-SQL, SQL Server Replication, Log Shipping, Database Mail, Database Mirroring  more...

LiveCycle - Creating XML-based PDF Forms Training in Los Angeles or Live Online Save $200 Adobe LiveCycle | Creating XML-Based Forms is a is a 2 day class with an option for an extra day for creating database connectivity. This course introduces and teaches techniques for developing XML-Based interactive PDF forms using Adobe LiveCycle Designer. Through significant amounts of thoroughly guided hands-on practice, by the end of the course you will know how to create static and  more...

Adobe Dreamweaver Training Coldfusion Application Development Dreamweaver CS3 Training: Coldfusion Application Development class provides students with the knowledge and hands-on practice they need to build and manage dynamic websites using Dreamweaver CS3 and ColdFusion. In this course, you ll learn how to connect to a database, search and display results, and build a page to update the database. If you ve always dreamed of building a more advanced,  more...

LiveCycle - Creating XML-based PDF Forms with Database Connectivity Training in Los Angeles or Live Online Save $200 This course expands on developing XML-Based interactive PDF forms using Adobe LiveCycle Designer and helps you create database connectivity. Through guided hands-on practice, the course you will know how to create static and interactive forms which include input validation, localized fields, and accessibility information.  more...

Advanced Visual Testing Software Students will learn to use the AVTS software to setup a comprehensive device testing program. The software will be explained from the database setup to creating visual testing programs. Relay systems, devices, and tests will be explained in detail. Each student will create a system database, make relay setting sheets and create tests with visual connections and testing information.  more...

Adobe ColdFusion Introduction Adobe ColdFusion Introduction Course Objectives This ColdFusion course is designed to teach experienced web developers how to create dynamic, database-driven web applications using ColdFusion. Students in this course will learn dynamic site building fundamentals and database concepts, and then progress to topics including creating data-driven pages, building complete applications,  more...

Crystal Reports Training Crystal Reports 2008 enhances report building and report processing techniques with many new value-added features. In this Crystal Reports 2008 Training course, students will create a basic report by connecting to a database and modifying its presentation.  more...

QA training Main Course content. Training Offered from www. Learningdom. com QA Training BA Training SQL/ PLSQL training PL-SQL Training DBA Training BA Training Csharp Training Unix Training Java Training Manual Testing Training WinRunner Training Quick Test Professional Training Quality Center Training Load Runner Training Why choose  more...

OpenOffice Basics Learn the basics of OpenOffice. org through a one-day seminar, including Writer, Calc, Math, Impress and Draw. This course also introduces the parallels between OpenOffice. org and MS Office, as well as some of the more useful plug-ins that can help increase productivity. This seminar will be instructor-led and, depending upon the classroom location, hands-on exercises will be available.  more...

Online Unix shell scripting training Unix Shell Scripting 1. IntroductionThe first shell script 2. Shell programming features 3. Functions 4. I/ O and Text processing 5. Shell Environment 6. AWK programming 7. SED Programming 8. UNIX Administration using Korn shell 9. Advanced Korn Shell Techniques 10. Accessing the database  more...

Introduction to Microsoft Access Introduction to Access familiarizes participants with the fundamental tools and concepts of Microsoft Access. At the end of class, students will be able to use Access tables, queries, form and reports to organize and extract information in a database. The class is taught as a hands-on "laboratory" lead by an experienced instructor. During class, students use a workstation to work with actual files  more...

Intermediate Microsoft Access Intermediate Access is more focused on "front-end" design issues such as the creation of complex forms and queries. The class is taught as a hands-on "laboratory" lead by an experienced instructor. During class, students use a workstation to work with actual files and real-world examples. In addition to the classroom instruction and hands-on exercises, each participant recieves a booklet and class  more...

Oracle Financial Training Class Room Online We are Proudly Announcing Our 31st batch Of Oracle Financial Training a) Oracle Financial ( http://www. sicherglobal. com/ orfcombo11i. htm ) Offering 1st Session Free to commence from April 26 th / 2009. Online & Class Room Training. Training provided by Certified Working Professional & Industry Top-notch Consultants Excellent infrastructure with high-end servers & Easy access to our  more...

Selenium WebDriver Training WhiteBoxQA is offering QA - White Box Testing with JUnit and Selenium. Who Can Attend Software testers, programmers, test leaders, quality specialists and those who would like to learn Programming and Testing technologies. A familiarity with software development concepts is assumed. Familiarity with Web technologies and object concepts is helpful. We will be teaching from basics till  more...

Planning Scoping and Executing Integrated Audits Audit departments have been trying for decades to implement audit objectives that fully integrate enterprise risks with IT risks. For many, however, the lack of adequate planning and scoping has rendered the effective execution of integrated audits an elusive goal. In this pragmatic three-day seminar you will review an integrated auditing methodology that includes valuable risk-based scoping  more...

IT Audit School This four-day course is designed for financial, operational, business, and IT auditors who need to update their technical and operational knowledge to audit information technologies and business application systems. You will cover the concepts of information technology as they relate to key risks in the IT environment, and explore such IT areas as operating systems, database management systems,  more...

IT Auditing and Controls Internal or operational auditors in today's complex organization must understand information systems and be able to function within a technical environment. This intensive, three-day seminar outlines the concepts of information technology you need to know in order to understand the audit concerns in the IT environment. You will learn the necessary controls for application systems -- the  more...

Introduction to Excel Class Training Our Introduction to Excel course teaches Excel basics. Learn time saving techniques to navigate, create new models, create basic formulas (Sum, Average, Count), format and print your data, make charts and use Excela ™s database features (sort, filter, subtotal). The introduction to Excel training includes a printed 40-page user guide. Students also receive online access to our video library  more...

Excel VBA The Excel VBA training teaches the strengths and weaknesses of recording macros, how to use and pass variables, if/ then statements and loops like for/ next and do/ while. You will also learn how to call functions, how to write your own functions, how to create forms, how to use workbook events to add buttons to toolbars, and how to connect to a database. No other school offers students access to  more...

Advanced Excel Class Advanced Microsoft Excel Training covers advanced formulas and functions (Vlookup, If/ Then, Index/ Match, DSum, arrays, formula auditing techniques), what-if data-analysis techniques (pivot tables, scenarios, forecasting), database features (validations, extract unique values), advanced macros (with light VBA programming) and collaboration techniques. Advanced Excel Training Objectives: *  more...

Introduction To Excel Learn Excel basics in our introduction to Excel course. Learn time saving techniques to navigate, create new models, create basic formulas (Sum, Average, Count), format and print your data, make charts and use Excela ™s database features. No other school offers students access to a video library for you to review the class at your leisure!  more...

Crystal Reports Training Levels 1 and 2 Webinars on Crystal Reports advanced topics as well as 2, 3 and 4 day classes at your location using your data on your schedule. We use expert instructors and our certified training material. Satisfaction is guaranteed. Up to 12 students per class. After class support. Our manuals through Crystal XI are available for purchase. We can deliver and customize our webinars for your group.  more...

The Essentials of Data Mining and Predictive Modeling for Internet and Direct Marketers DESCRIPTION "Data Mining and Predictive Modeling" are intertwined buzzwords that wea ve all heard. And perhaps youa re not quite sure what they mean or how they differ. While this is an incredibly important question to answer, the even more vital question is, "How do I make them meaningful?" This course addresses all of these questions in detail. Though frequently thought of in terms of  more...

Advanced Data Mining and Predictive Modeling for Internet and Direct Marketers DESCRIPTION "Advanced" data mining and predictive modeling dives into the more sophisticated data mining and modeling techniques that an increasing number of enterprises are employing to generate huge impacts on their bottom lines, whether it be through the internet or through direct marketing channels. Long gone are the days when data was scarce. In the modern world, wea re drowning in data  more...

Data Modeling for Business Analysts DATA MODELING FOR THE BUSINESS ANALYST This 2-day Data Modeling for BAs focuses on the concepts of data modeling and various effective techniques used to gather the necessary information needed to create the data model. The workshop is designed to provide each participant with practical exercises for interpreting and creating logical data models. The relationship of the data model to more  more...

Web Technologies and Architectures Overview A survey of web-specific technologies and architectures, including: conventional web technologies, Java technologies (including independent, J2EE and model 2 technologies), Microsoft technologies, database accessibility, XML technologies, and web service integration. Audience:Developers and managers seeking a high-level understanding of Web Application Architectures and design alternatives.  more...

Oracle Database 11g Administration I The overall objective of this course is to allow the student to gain the skills necessary for day-today administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification. Audience:The primary target audience for this course is Oracle database administrators. Oracle web  more...

Oracle Database 11g Administration II The overall objective of this course is to bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database within a large-scale enterprise. Audience:The primary target audience for this course is Oracle database administrators. Oracle web server and application  more...

Oracle Database 11g New Features For Administrators The purpose of this course is to present some of the most advanced features available to database administrators which were either introduced with the Oracle 11g release or have been substantially improved with that release. Audience:The primary target audience for this course is Oracle database administrators. Oracle web server and application server administrators, as well as others who must  more...

Oracle Database 11g PL SQL Fundamentals - Complete Coverage The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. This course equips students to develop database server-side PL/SQL program units within an Oracle  more...

Oracle Database 11g PL SQL Fundamentals I The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. Audience:All Oracle professionals, both business and systems professionals. Among the specific groups  more...

Oracle Database 11g PL SQL Fundamentals II The objective of this course is to equip students to develop database server-side PL/SQL program units within an Oracle database. Audience:All Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are Application designers and developers and Database administrators.  more...

Oracle Database 11g SQL Fundamentals - Complete Coverage The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. Even professionals experienced in  more...

Oracle Database 11g SQL Fundamentals I This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. Audience:All Oracle professionals, both business and systems professionals. Among the specific groups  more...

Oracle Database 11g SQL Fundamentals II The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course. This enhanced and  more...

Relational Database 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. Audience:The target audience for this course is all database professionals concerned about the design and implementation of databases. Among the  more...

Microsoft Visual Basic NET This hands-on introduction to the Visual Basic programming language provides a solid foundation in all language fundamentals including windows, controls, database access, and classes. Audience:Application developers seeking to become familiar with the Visual Basic .NET language and the Microsoft .NET Studio.  more...

Introduction to IBM DB2 Universal Database for Sybase Developers Provides the student that has prior SQL or Sybase ASE experience with the necessary basic skills and fundamental knowledge of IBM DB2 UDB. It includes information on the overall architecture of DB2 UDB, basic to advanced DB2 UDB SQL syntax, creating and using SQL Stored Procedures, and an overview of basic administrative tasks including creation of databases, tables, views, indexes, the extraction  more...

ADO NET Using C An intensive course that presents the essential elements of ADO.NET to enable the programmer to utilize the tremendous database manipulation powers available with .NET development and be prepared to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting. Audience:C# .NET Application Developers seeking to integrate  more...

Understanding ADO NET In this course, you will learn how to retrieve and manipulate data using Microsoft's new ADO.NET library. Understand how to work with the new ADO.NET object model, including the DataReader, DataAdapter, and DataSet. See how to apply constraints and relationships to disconnected data. Learn how to update data, including how to handle stored procedures, parameters, and return values. Understand how  more...

Applying ADO NET In this advanced course, you will become familiar with strongly typed DataSets and learn their advantages and see how to leverage the power of XML through serialization, Diffgrams,and the XMLDataDocument object. You will understand migrating and interoperability issues with ADO, as well as handling errors. Learn valuable techniques for building both Web and Windows applications. Audience:Database  more...

ADO NET Using Oracle and C This course presents the essential elements of ADO.NET and how to build effective Oracle database applications. The course includes coverage of the Oracle Data Provider for .NET (ODP.NET). There is a practical discussion of data binding and its use in both Windows Forms and Web Forms (ASP.NET) applications. Students will gain a familiarity with creating a Data Access Layer, as it applies to  more...

Oracle 9i DBA Fundamentals I This class will develop the fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management and  more...

Oracle 9i DBA Fundamentals II Presents the fundamentals of setting up Oracle Net Services, configuring the shared server architecture, and backup and recovery. This class covers the different ways an Oracle9i instance and database can fail and the best options for recovery. Students will learn how to perform backup and recovery with and without RMAN. Students will learn how to minimize points of failure and reduce the Mean  more...

Introduction To Oracle 9i This class will develop database-programming skills using SQL and PL/SQL. Students will learn the Oracle9i architecture, relational design concepts, simple and complex query skills, PL/SQL programming skills, proper software engineering techniques for database programming, Oracle problem solving, and performance tuning skills. Audience:Analysts, developers, designers, administrators, and managers  more...

Oracle 9i PL SQL Programming Students will learn the fundamentals of the PL/SQL programming language. Stored procedures, functions, packages and triggers implement complex business rules in Oracle. Students will learn programming, management and security issues of working with PL/SQL program units. Numerous exercises and labs will introduce students to the new PL/SQL features in Oracle9. Audience:Database administrators,  more...

Oracle 9i Advanced PL SQL Programming This class will focus on developing advanced PL/SQL programming skills. Topics will include the built-in packages that come with Oracle, the creation of triggers and advanced stored procedure features. The class will also cover object-relational concepts, performance tuning and dynamic SQL. The Oracle9 release has greatly enhanced the features and functionality of PL/SQL. Numerous exercises and  more...

Oracle 9i SQL Programming This class will develop database programming skills using SQL. Relational and object concepts will be covered. Students will learn complex SQL programming skills, features, and tools. Audience:Database administrators, application developers, and system administrators.  more...

Oracle 9i Server Performance Tuning This class teaches DBAs how to tune an Oracle9i server. Participants will learn the different areas that impact performance, how to detect performance issues, verify the performance problem, determine what to tune, understand the ramifications of making changes, and then verify the results. Tuning Oracle memory areas, contention and waits, physical I/O, checkpoints, undo segments, temporary  more...

Advanced SQL Server 2000 Administration Gain a hands-on, in-depth look at SQL Server 2000 by examining relevant internal data structures and learning practical troubleshooting techniques. Diagnose and prevent potentially disastrous situations and learn how to make optimal use of the features of SQL Server 2000 for normal administrative tasks. Real-world benefits include learning how to perform mission-critical administrative tasks more  more...

Sybase Administrators Performance and Tuning for ASE 12 5 1 This course teaches database administrators how to tune an Adaptive Server for optimal performance. It explores Adaptive Server architecture in depth, and includes sections on designing databases for performance, managing Adaptive Server system resources (CPUs, disks, I/O), choosing appropriate locking schemes, optimizer statistics, SMP features, relevant data structures, and parallel processing.  more...

DB2 -- Fast Track to Programming Students will gain hands-on experience with the newest features of IBM ' s DB2 Version 9. Students will learn to create tables and manipulate data, tables and other database objects using ANSI-standard SQL and SQL Procedural Language extensions. Coverage includes the special features and functions of the DB2, such as control of transactions, stored procedures, triggers, and cursors. Good  more...

DB2 -- Performance and Tuning This course provides experienced SQL developers with a fast-paced transition to DB2 performance and tuning. Following a review of the DB2 architecture, environment, and data structures, course coverage includes index internals, block index MDC ' s, access methods, and how to write effective SQL predicates. ' Explain ' tables and tools are covered in detail as well as additional performance tools.  more...

Sybase System and Database Administration For ASE 12 5 1 Through a combination of lectures and hands-on labs, you will identify the major tasks of Sybase system and database administration. You will practice these tasks using your own Adaptive Servers (12.5) in a safe and controlled environment. Emphasis is given to resource management (memory, disk, and CPU) with a goal of creating a reliable Adaptive Server environment. The course also presents  more...

SQL Server 2000 System and Database Administration Learn all aspects of administering a SQL Server 2000 from installation to configuration, to maintaining a fast, high performance database server. Audience:Those responsible for SQL Server 2000 database administration.  more...

Introduction To Sybase ASE 12 5 1 Learn to create tables and manipulate data, tables and other database objects using ANSI-standard SQL and Sybases Transact-SQL extensions, and gain hands-on experience using Adaptive Server databases. You will also learn the special features and functions of the Adaptive Server, such as automatic recovery of transactions, stored procedures, triggers, and cursors. In addition, you will learn to use  more...

Introduction To MySQL Learn to create tables and manipulate data, tables and other database objects using ANSI-standard SQL and SQL extensions, and gain hands-on experience using MYSQL databases. You will also learn the special features and functions of the MYSQL, such as automatic recovery of transactions, stored procedures, triggers, and cursors. In addition, you will learn to use good programming techniques and  more...

SQL Server 2000 Performance and Tuning You need to know how to tune queries and stored procedures for optimal performance. This course thoroughly covers SQL Server 2000 Query Optimizer. You will learn techniques to write high performance queries, allowing the optimizer to use the most efficient query plan, and diagnose and correct performance problems with already existing queries. Additionally, you will learn to interpret optimizer  more...

SQL Server 2005 Administration Learn about the features of SQL Server; how to design and create a database; and how to build basic queries using Transact-SQL. Learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. Learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and  more...

SQL Server 2005 Analysis Services Learn to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. Includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support  more...

SQL Server 2005 Integration Services In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. Audience:Technology professionals with little or no ETL experience and minimal exposure to SQL Server 2005.  more...

SQL Server 2005 T-SQL Learn how to build basic queries using Transact-SQL, the language of SQL Server. Learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. Learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and how programmers can now use .NET languages like C# and  more...