Instructor Led Queries Training Classes in United States

Get on Track with MS Access Intermediate Students will learn how to set table relationships, work with Lookup fields and subdatasheets, create join queries, create PivotTables and PivotCharts, and use hyperlink fields and data access pages.  more...

Get on Track with MS Access Advanced Learn advanced techniques such as: querying with SQL; using crosstab, parameter, and action queries; creating and running macros; importing, exporting, and linking database objects; optimizing, replicating, and synchronizing databases; and basic database security.  more...

Get on Track with MS Access Basics Understand the Fundamentals of a Relational Database, Learn Database Design Tricks and Shortcuts, Build Tables and Learn How to Use Predesigned Templates. Understand the Functions of the Queries, Design Forms and Build Reports  more...

Introduction to Microsoft Access ...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 and real-world examples. In addition to the classroom instruction and hands-on exercises, each participant  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...

Introduction to MS-Access Learn how to create an Access database and work with tables, forms, queries, and reports.  more...

Microsoft Access Introduction ...orms, use filters, enter and correct information, perform queries by using practical examples and create reports. Our classes are all instructor-led, hands-on learning. Each student has their own computer and is given a student manual with practice files to take home. A free repeat, within six months, is included as well as thirty days of technical support. Class is usually one day from 9am to  more...

Microsoft Access Intermediate ...queries, use calculated fields, adjust data types, set field properties, and perform database maintenance. You will also use input masks, use controls in forms, learn the lookup feature, work with Access and the Internet, and work further with queries and reports.Our classes are all instructor-led, hands-on learning. Each student has their own computer and is given a student manual with  more...

Business Objects Web Intelligence XI R1R2 Report Design ...s for your reporting needs, to retrieve data by building queries using Business Objects universes and to use Web Intelligence to enhance documents for easier analysis. After taking this course, you will be able to efficiently and effectively manage personal and corporate documents to access the information you need, when you need it. You will be able to design your own reports using Web  more...

Reporting on the Web with Cognos 8 ... Basic topics include Cognos Connection, designing simple queries, charts, grouping, filters, prompts, calculations and more. Intermediate topics include formatting, conditional formatting, multi-query reports, drill through reports and more. The course format includes lecture, instructor-led exercises and independent workshops. Intended Audience Report Authors and other users, who will  more...

Queries on the Web with Cognos 8 ...pics include Studios, Cognos Connection, designing simple queries, grouping, filters, prompts, charts, calculations, formatting reports, conditional formatting running reports, and more. The course format includes lecture, instructor-led exercises and independent workshops. Intended Audience Report authors and consumers who will create simple ad hoc queries and run reports using Query  more...

Microsoft SQL Server 2000 Database Development ...nstraints; DTS packages and transformations; transact SQL queries; creating views; creating and tuning indexes; building transactions & triggers and creating stored procedures; relational database concepts; SQL vocabulary; a terminology guide; key features of SQL Server; a comprehensive guide to the SQL Server tools, including Enterprise Manager and Query Analyzer; and database implementation  more...

PHP MySQL Training ...ng and Submission MySQL Administration Advabced SQL Queries Binary Data Cookies and Sessions in PHP Structured PHP programming MySQL Syntax Outline Setting Up Shop The Basic Tools you Need Windows v Mac Beyond the Basic Tools Creating a spopt for your Web site Your First Web Pages XHTML Anatomy of a Web Page Viewing the Source Code HTML  more...

Access Training - Chicago ...To Create Table Relationships Unit 9: Creating Select Queries How To Create Queries Quickly Unit 10: Controlling Queries Output How To Open / Switch Query To Design View How To Rearrange Fields How To Delete A Field How To Add A Field How To Sort The Query Output How To Filter The Query Output With Criteria How To Set Multiple Criteria How To Hide A Field  more...

Microsoft Access 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 will practice the critical skills necessary to create a database, and enter, find, edit, and report on the data it contains. Part II course  more...

XML Programming Using Java ...ML persistence using the JAXB. Write simple and complex queries into XML document content using XPath. Use XSLT for XML-to-XML transformations. Use the built-in template rules correctly to process the right source information. Use mode and priority to control template matching. Control exact production of text, HTML and XML elements, and whitespace. Derive source document content  more...

Linux System Administration ...nfig Answer some questions about the system using RPM queries Install zsh using RPM Troubleshoot and repair a package using RPM verification Upgrade the kernel using RPM Install the XFCE desktop environment using YUM Create and test a custom YUM repository Crate a custom YUM repository for installing software Setup CUPS print queues using: system-config-printer, lpadmin, and the CUPS web  more...

Maintaining a Microsoft SQL Server 2005 Database ...d, that students have completed: Course 2778, Writing Queries Using Microsoft SQL Server Transact-SQL.   Course 2779, Implementing a Microsoft SQL Server Database.   Course Outline Module 1: Installing and Configuring SQL Server 2005 This module explains how to plan for and install SQL Server 2005, how to manage a SQL Server 2005 installation, and how to use the SQL Server 2005  more...

Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 ...d, that students have completed: Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.   Course 2779, Implementing a Microsoft SQL Server 2005 Database.   Course 2780, Maintaining a Microsoft SQL Server 2005 Database.     Course Outline Unit 1: Building a Monitoring Solution for SQL Server Performance Issues This unit provides an opportunity for the student to  more...

Implementing a Microsoft SQL Server 2005 Database ...d, that students have completed: Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.   Course Outline Module 1: Creating Databases and Database Files This module explains how to create databases, filegroups, schemas, and database snapshots. Lessons Creating Databases.   Creating Filegroups.   Creating Schemas.   Creating Database Snapshots.   Lab 1:  more...

Core Data Access with Microsoft Visual Studio 2005 ...e Data Source Configuration Wizard   Exercise 5. Adding Queries to a Table Adapter (if time permits)   After completing this unit, students will be able to: Explain the differences between untyped DataSets and typed DataSets.   Explain how table adapters work in conjunction with data tables in a typed DataSet.   Describe the process for creating a typed DataSet by using Visual  more...

Designing the Data Tier for Microsoft SQL Server 2005 ...d, that students have completed: Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.   Course 2779, Implementing a Microsoft SQL Server 2005 Database.   Course 2780, Maintaining a Microsoft SQL Server 2005 Database.   Course Outline Session 1: Choosing Data Access Technologies and an Object Model This session explains how to choose data access technologies and  more...

Designing Microsoft SQL Server 2005 Server-Side Solutions ...d, that students have completed: Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.   Course 2779, Implementing a Microsoft SQL Server 2005 Database.   Course 2780, Maintaining a Microsoft SQL Server 2005 Database.   Course Outline Module 1: Selecting SQL Server Services to Support Business Needs This module explains how to translate business requirements  more...

Access 2003 Level II ... 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 applications.   Who should attend:  Microsoft Access 2003: Level  more...

Access 2003 Level III ...de working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft Office Specialist Certification for Microsoft Office Access 2003, and it is a prerequisite to taking more advanced courses in Microsoft  more...

Querying Microsoft SQL Server 2000 with Transact-SQL The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™ 2000.  more...

SQL - Structured Query Language ...wer business questions. Students will also learn advanced queries and how to add, update, and delete data, tables, views, and indexes. During this course, including computer lab time, students will be provided with the information necessary to complete the following objectives: Recognize proper syntax for an SQL statement. Use aggregate functions, column aliases, and mathematical  more...

Access Expert Level ...ills, particularly those related to creating more complex queries, customizing your forms and reports, and broadening the availability of your data. You will learn intermediate Access 2002 skills, including how to enhance your database designs by using the principles of table relationships and referential integrity, integrate data with other applications, modify a table design to control data  more...

SQL Database Design & Implementation This course teaches you how to use the Transact-SQL language to query and program Microsoft SQL Server 2000 in a Windows Server Server environment. This course also assists you in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition. Upon successful  more...

Java 2: Enterprise Connectivity ...onnect to a database, retrieve meta data, and execute SQL queries. Understand how Java Server Pages (JSP) can be used, and how it compares to Common Gateway Interface (CGI) and Active Server Pages (ASP). Use JSP objects to manipulate data on the World Wide Web. Understand the elements of the JSP language set, and utilize JSP Action elements and Directives. Describe the Java Servlet  more...

Access Level 1 ...ases in Access and working with the data by using tables, queries, forms, and reports. You will practice the critical skills necessary to create a database and enter, find, edit, and report on the data it contains. Upon successful completion of this course, students will be able to: follow the steps required to properly design a database. create tables to hold data and then establish  more...

Advanced Java Programming ...s.  Use prepared statements to produce reusable database queries and optimize execution time.   Use callable statements to access database procedures.   Use scrollable and updatable results sets for more robust solutions.  Use commit, rollback, and savepoint to build transactional systems.  Use batch processing for efficient handling of large datasets.   Use the Java 5.0 Core API and  more...

Introduction to SQL Training using Standard SQL This SQL training course is designed for students new to writing SQL queries.  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...

Introduction to SQL Training using MySQL This MySQL training course is designed for students new to writing SQL queries using MySQL.  more...

Introduction to SQL Training using SQL Server This SQL Server training course is designed for students new to writing SQL queries using SQL Server.  more...

Introduction to SQL Training using Oracle This Oracle training course is designed for students new to writing SQL queries with Oracle.  more...

Linux Networking Services ... Views with BIND 9 Address Match Lists & ACLs Restricting Queries Restricting Zone Transfers Running BIND in a chroot jail Dynamic DNS Concepts Allowing DDNS updates Using DDNS with "nsupdate" Common Problems Lab 4 - Advanced BIND Configuration Configure and test dynamic DNS for the domain Restrict zone transfers generally Allow zone transfers of the zone to a specific host Restrict the  more...

Managing and Maintaining a Microsoft Windows Server 2003 Environment ...emplate   Managing User and Computer Accounts   Using Queries to Locate User and Computer Accounts in Active Directory   Lab: Managing User and Computer Accounts Creating User Accounts   Creating Computer Accounts   Using Queries to Locate Objects   Modifying User and Computer Properties   After completing this module, students will be able to Create user accounts.    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...

Querying Microsoft SQL Server 2000 with Transact-SQL The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2000.  more...

Managing a Microsoft Windows Server 2003 Environment ... User and Computer Accounts in Active Directory Saving Queries Resetting User and Computer Accounts Moving Domain Objects Lab A: Managing User and Computer Accounts Searching for and Moving User Accounts Searching for and Moving Computer Accounts Searching for and Enabling User Accounts After completing this module, students will be able to: Modify user and computer  more...

Managing Microsoft Systems Management Server 2003 ...e 6: Querying and Reporting Data You can create and run queries to locate objects in a Microsoft Systems Management Server (SMS) site database that match your query criteria. Queries are most useful for extracting information related to resource discovery, inventory data, and status messages. Reports allow systems administrators to easily organize and display information about the computers  more...

Microsoft MCITP: Database Developer Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) is the premier certification for database designers and developers. This credential demonstrates that you can design a secure, stable, enterprise database solution by using Microsoft SQL Server 2005. Database developers design and implement relational database models (logical and physical) and database storage  more...

Microsoft MCITP: Database Administrator ...ual and logical levels - Experience writing Transact-SQL queries - Ability to define high-availability solutions (RAID, replication, mirroring, etc.) - Experience automating administrative tasks - Experience defining database security solutions - Experience monitoring and troubleshooting the database server - Experience designing and executing database deployments - Experience defining  more...