Database Training

Introduction to Visual Basic This hands on Visual Basic training course provides a thorough introduction to the use of Visual Basic 6. The main goal of the course is to enable the participant to create business applications with Visual Basic that utilize multi-tier application design strategy for maintainability and reusability. The hands on exercises are focused on solving commonly encountered business problems. The course more...

Advanced Visual Basic Programming ...ent, and techniques for connecting client applications to databases. Students start by interacting directly with the Win32 API to provide grounding in important Visual Basic programming principles.Students are then shown how to design and use class hierarchies. In the course's hands on exercises, students gain direct experience creating Visual Basic programs that both use existing components more...

SQL Programming ...database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and more...

Relational Database Design Concepts ...database design class develops relational database design skills and techniques. Practical methodologies such as E-R diagrams and normalization forms are emphasized. Attention is placed on designing for data integrity and efficiency at the same time. During hands on lab sessions students are required to design multiple database models from business requirements and specifications. Through hands more...

Microsoft SQL Server 2000 Administration ...his class will allow the student to understand relational database concepts and the Structured Query Language (Transact-SQL) in the Microsoft SQL Server environment as well as identify and configure all major aspects of a Microsoft SQL Server RDBMS. You will learn about tables and constraints; DTS packages and transformations; transact SQL queries; creating views; creating and tuning indexes; more...

The Process Consultant: FROM FACILITATION TO INTERVENTION ...es and fix them to reduce waste > Set up a best practices database for effective management practices > Implement processes for management excellence, e.g. mentoring > Use generic level processes for aligning the organization > Use different styles of intervention and facilitation according to need > Follow a consistent process for intervening > Design processes according to the unique needs more...

Macromedia Flash 8 - Introduction Two Day Training Course ...ment that allows programmers to create highly interactive database driven technologies. Flash 8 sees the arrival of a host of exciting new features, including an improved script editor (with a visual interface); a revamped library interface; a new Undo feature; powerful run-time effects; and breakthrough motion-graphics capabilities to name but a few. In this two day beginners course, we more...

Macromedia Flash 8 - Introduction One Day Training Course ...ment that allows programmers to create highly interactive database driven technologies. Flash 8 sees the arrival of a host of exciting new features, including an improved script editor (with a visual interface); a revamped library interface; a new Undo feature; powerful run-time effects; and breakthrough motion-graphics capabilities to name but a few. In this one day beginners course, we more...

Infitech Certified DBA Developer ...urse will help you acquire advanced skills for becoming a Database Application Programmer. Infitech Solution offers the following syllabus in its DBA Developer course - Oracle DBA Oracle 9i Database Performance Tuning Oracle Fundamentals OCP Track Oracle Developer Track PL / SQL Oracle Forms Course Duration The duration of the DBA Developer course is 80 Hours. more...

Macromedia Dreamweaver 8: ColdFusion Application Development Macromedia Dreamweaver 8: ColdFusion Application Development provides students with the knowledge and hands-on practice they need to build and manage dynamic websites using Dreamweaver 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, data-powered more...

Act Crm ...Email 18 Independent Activity # 2 19 Customizing Your Act Database 20 Preferences 20 Fields 21 Layouts 22 Day 2 Overview 24 Independent Activity # 3 25 Mail Merge 26 Create and Test the Act Document Template - adt 26 Merge the Contacts using the Template 28 Edit and Create the Email Template - gmt 30 Email Merge 31 Independent Activity # 4 32 Sales Opportunities 33 Create Sales Stages 33 Enter more...

Timeslips Advanced ...earch- to find specific text within specific areas of the database. (conflict checker) Grouping Custom Fields- ability to track your own custom information. Categories- grouping related tasks and expense activities together during billing for accounting purposes. Replacement Slips- replaces a group of slips of a given type with one entry on the bill. Reporting Timeslips Reports- more...

Administering a Microsoft SQL Server 2000 Database This course provides students with the knowledge and skills required to install configure administer and troubleshoot the client-server database management system of Microsoft SQL Server™ 2000. Course 2072 is a revision of Course 832 System Administration for Microsoft SQL Server 7.0 . The course content is being revised to reflect changes in the product.  more...

Modeling Business Requirements to Create a Database Using Microsoft Visual Studio .NET Enterprise Architect This intensive three-day course provides students with the knowledge and skills to model business requirements in order to create a baseline database design. It focuses on the use of Object Role Modeling (ORM) and the ORM modeling tool in Microsoft Visual Studio .NET Enterprise Architect. Students will also learn the database modeling process and how ORM relates to Entity Relationship (ER) more...

EJB Training: Enterprise Java Beans (EJB) Development using IBM Rational Application Developer V6 - 4.5 days - UK ... and bean-managed persistence Perform EJB to relational database mappings for persistent data Use container-managed relationships to represent relationships between persistent entities Integrate your application with messaging using message driven beans Leverage container services for transaction management Leverage container services for EJB security Apply best practices in EJB more...

BEA WebLogic Integration Training: Developing Integration Solutions - 5 days - UK ...gic Platform 8.1's control architecture to integrate with databases, JMS servers, legacy systems, trading partners, file and email systems, Web services and other technologies Build and deploy real-world workflows supporting human intervention and back-end integration Create and consume secure, reliable, loosely-coupled, coarse-grained and asynchronous Web services using a variety of more...

BEA WebLogic Server 8.1: J2EE Programming with Servlets and JSP Training - 5 days - UK ...naming services, distributed transactions, and multi-tier database access, as they map to the widely used Model-View-Controller application architecture. This BEA WebLogic training course on JSPs and Servlets also covers the deployment of Web applications, using XML-based configuration files and the BEA WebLogic Server Administration Console. Additionally, you are introduced to the concepts more...

Competitive Edge Business Coaching Alliance Business Coaching provides a critical adaptive edge to countless entrepreneurs, executives, and professionals. Coaching provides feedback, insights, and guidance from an outside vantage point to leverage resources and drive the business. Now you can get an edge on your competition by staying current as a leader and visionary in your specialty. The Competitive Edge Business Coaching Alliance gives more...

Filemaker Pro 6 or 7 Introduction to Creating Databases ...database management tool for the Macintosh and PC. Its popularity lies in the simplicity with which beginners can start creating databases. Nevertheless, as of FileMaker Pro 7, this database management application has joined the league of industial-sized databases and offers a wide range of features on top of its still very intuitive user interface. This course is aimed at users who want to be more...

Macromedia Flash MX One Day Introduction ...ment that allows programmers to create highly interactive database driven technologies. In this one day beginners course, we focus on using Flash MX for the creation of visually attractive vector and animation based websites and page elements. We look at creating artwork in Flash MX as well as importing artwork and images into Flash files. We also work with text, creating navigation systems, more...

Adobe Acrobat Professional form fields and data management ...m data. The data can be stored in PDFs or integrated with databases. Data can be submitted online though any common CGI language. All this means document producers can create correctly formatted, secure forms that can be widely distributed then filled in and submitted using the free Adobe Reader. This approach is being pioneered by many government agencies for tasks ranging from tax more...

Microsoft Word Training - Intermediate Microsoft Word is the world's number one word processing application. Word documents are so ubiquitous that they are almost an IT standard in themselves. But Microsoft Word is a whole lot more than a simple word processor. It is a communication tool that allows you to share information in attractive and presentable formats. You can create comments and revisions in the proofing stage of document more...

Introduction to Excel ...d by others. You will learn how to use Excel as a simple database for searching and sorting data and, if you wish, how to use it in conjunction with Word to produce address labels. Using a number of graded exercises you will build and reinforce the skills so that by the end you will be able to tackle a wide range of projects of your own. Depending on your previous experience you can expect more...

Word and Excel 2002 (XP) Essentials This is a continuation of Microsoft Excel 2002 (XP) Level 1. The IF function is reviewed and expanded on. Linking cells, worksheets, workbooks and Excel to Word is practiced. Database management is covered in detail, including sorting, data form, subtotal command, filtering and pivot tables. Other functions covered in Level 2 are: VLOOKUP, COUNT, ROUND, CHOOSE, CONCATENATE, WEEKDAY, DATEVALUE, more...

Microsoft Excel - private, one on one training - INTERMEDIATE level Duration Details: This training seminar consists of 3 hours of private training on January 25th, 2007. 3 hour block of time between 9:00am and 12:00pm What can be learned at this seminar: NOTE: This is PC based training - Versions Offered: 97, 2000, 2002, 2003. VIEWING WORKSHEETS Customizing View Options Displaying and Customizing Toolbars Hiding Workbooks and Worksheets Freezing more...

Crystal Reports Introduction-2 Days ...database programs have limited reporting tools, or the user may not have sufficient programming or SQL knowledge to create some reports. This course is intended to introduce the use of Crystal reports to produce reports from almost any database data (for example, Microsoft Access). This course is classroom style instruction: Instructor-led, hands-on training. Pre-Requisites: Basic Windows more...

Microsoft Access 2002 (XP) Level I This course covers table creation, relationships, extracting information using queries, designing forms and creating reports. Duration Details: Starts: January 15, 2007 Time: 06:30 pm - 09:30 pm Days Held: Mon, Wed Hours: 12 Weeks: 2 more...

MS Excel 2003 Formulas for Finance This course features an overview of the financial, math, and database calculations supplied in Excel's core function collection and add-in libraries. Participants will also be introduced to creating their own user-defined functions with Visual Basic in order to extend Excel's supplied standard functionality. Duration Details: January 18, 2007 9:00am - 4:00pm more...

MS Excel 2003 Formulas for Statistical Analysis This class is an overview of calculations using selected advanced functions drawn from the statistical, database, and mathematic functions in Excel's core collections and add-in libraries. Participants will also be introduced to creating user-defined functions with Visual Basic in order to extend Excel's supplied standard functionality. Duration Details: January 25, 2007 9:00am-4:00pm more...

Microsoft Excel 2002 (XP) Level II ...ls, worksheets, workbooks and Excel to Word is practiced. Database management is covered in detail, including sorting, data form, subtotal command, filtering and pivot tables. Other functions covered in Level 2 are: VLOOKUP, COUNT, ROUND, CHOOSE, CONCATENATE, WEEKDAY, DATEVALUE, YEAR, MONTH, and RAND. Pre-requisite - Microsoft Excel 2002 (XP) Level 1. Duration Details: Starts: January 30, more...

Microsoft Excel 2002 (XP) Level II ...ls, worksheets, workbooks and Excel to Word is practiced. Database management is covered in detail, including sorting, data form, subtotal command, filtering and pivot tables. Other functions covered in Level 2 are: VLOOKUP, COUNT, ROUND, CHOOSE, CONCATENATE, WEEKDAY, DATEVALUE, YEAR, MONTH, and RAND. Pre-requisite - Microsoft Excel 2002 (XP) Level 1. Duration Details: Starts: February 6, more...

Act! Intermediate-1 Day March 12th, 2007 9am to 4pm This course will introduce you to the advanced features of contact management. You will probably get the most out of this course if you want to learn how to modify templates and reports, perform complex lookups, customize a database, automate procedures, exchange data, perform database maintenance, and link to the Internet. This course is classroom style instruction: more...

Crystal Reports Introduction-2 Days ...database programs have limited reporting tools, or the user may not have sufficient programming or SQL knowledge to create some reports. This course is intended to introduce the use of Crystal reports to produce reports from almost any database data (for example, Microsoft Access). This course is classroom style instruction: Instructor-led, hands-on training. Pre-Requisites: Basic Windows more...

Access Introduction-2 Days ...vides the first step in learning how to use this powerful database program. The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data. Forms and Reports are briefly introduced using the Wizards provided. This course is classroom style instruction: Instructor-led, hands-on training. Course Prerequisite: Required: more...

Access Introduction-2 Days ...vides the first step in learning how to use this powerful database program. The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data. Forms and Reports are briefly introduced using the Wizards provided. This course is classroom style instruction: Instructor-led, hands-on training. Course Prerequisite: Required: more...

Access Intermediate Level 1-3 Days ...ctive is to learn enough about Access to start developing databases. The Introduction course begins this process by seeing how to create tables and queries. This course illustrates how to create a relational database and how to design forms and reports. This course is classroom style instruction: Instructor-led, hands-on training. Course Prerequisite: Required: Solid understanding of all more...

Access Advanced Level 1-3 Days March 26-28, 2007 9:00am to 4:00pm This course takes an in-depth look at macros, securing a shared database and using functions. This course is classroom style instruction: Instructor-led, hands-on training. Course Prerequisite: Required: Solid understanding of all Access Introduction & Intermediate Level I topics. Certificates offered: * courseware (notes on all topics covered, along with more...