Instructor Led Sql You Training

Oracle Administration Overview -------- In this intensive course, you will be introduced to the architecture of the Oracle11g Server. In hands on exercises participants will learn to create and start up a database, enrol users, implement basic security measures and perform backup and recovery. You will also learn how to manage logical and physical storage structures and manage access to data in the database by  more...

SSAS 2008 R2 Sql Server Analysis Services Do you have data sitting in your corporate SQL Server database, but not know how to make use of it? If you already know SQL, maybe it s time to learn about multi-dimensional reporting using cubes. Speed up your reports, analyse your KPIs and improve your data-mining with SQL Server Analysis Services. This course concentrates on practical teaching and exercises, to allow you to create and modify  more...

SSRS 2008 R2 Sql Server Reporting Services SQL Server Reporting Services 2008 R2 is THE way to publish reports to your corporate intranet. Not only can you include tables of data, matrices (you may know these as pivot tables), charts, lists and subreports, but SSRS 2008 R2 also includes whizzy new report items like indicators, gauges and sparklines. On this three-day course you will use SQL Server 2008 R2 Business Intelligence Development  more...

Advanced SQL If you are comfortable creating queries in SQL, maybe it is time to move on to learn more advanced programming topics? This three day course assumes that you know how to use the main SQL keywords SELECT, FROM, WHERE, GROUP BY and ORDER BY, and shows you how to really progam in SQL Server. Learn how to write stored procedures, create 3 different types of function, use subqueries effectively - and  more...

Microsoft Access 2010 Basic Querying Have you got a corporate database from which you want to extract information? It might be Access, or it might be Sage or in SQL Server. This one-day course will not show you how to build new databases, but it will show you how to get information out of existing ones. The course explains how databases are constructed, then shows the ins and outs of creating queries and reports. Note that this  more...

SSRS 2005 In the current business environment organisations need to be able to transform data into clear, concise, user-friendly formats. This two-day SQL Server Reporting Services (SSRS) course shows you how to create, execute and manage reports. Using SQL Server 2005 Business Intelligence Studio you will create interactive reports and learn how to deploy and export them in various formats. You will  more...

Writing SQL You may have a fantastic database, but unless you can extract useful information from it, it may as well not exist! This two-day course shows you how to mine your database, from getting a mailing list of people meeting certain criteria through to compiling summary information for the board. Note that the SQL language varies slightly between different database providers; this course teaches the  more...

Fundamentals Of Databases Using MySQL 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 using MySQL. You will work with databases by identifying the  more...

SQL You have access to company databases and your job may require you to retrieve data from those databases. Retrieval of information from a database is dependent on precisely ordered logic and specific information. This course will help you to use - SQL: Structured Query Language as a tool to implement that logic, define instructions, and compose SQL queries to retrieve information from the  more...

SQL Level 2 In the course SQL: Fundamentals of Querying (Second Edition), you examined the fundamentals of 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. In this course, SQL: Advanced Querying, you will create advanced SQL queries, and manipulate  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...

Oracle BI Suite EE 10g R3 Build Repositories Oracle BI Suite EE 10g R3: Build Repositories What you will learn: This course provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Students begin by using the Oracle BI Server Administration Tool to construct a simple repository to address a fictitious company's business requirements. Students import schemas, design and build logical  more...

DB2 Visual Explain for SQL Application Performance Analysis About Wintrac Wintrac provides one stop shopping for all your IT training needs. Wintrac s course catalog of over two thousand courses includes courses on Mainframe training , COBOL Training and DB2 training This course gives a brief overview of DB2 SQL performance considerations, including establishing goals for Application SQL performance. We explore the capabilities of Visual Explain  more...

JDBC - Java Database Connectivity Using Rational Application Developer (RAD) JDBC is a Java technology for accessing SQL 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 are done using the RAD Development Environment, and the lab instructions  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...

JDBC - Java Database Connectivity JDBC is a Java technology for accessing SQL 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  more...

End to End Microsoft Business Intelligence (sql server) This five day course provides students with the knowledge and skills to develop Microsoft End to-End business solutions using SQL Server 2008 R2 in an integrated environment with Sql 2010 and Office 2010. The course introduces the students to Microsoft Unified Data Model, SQL 2008 R2 Analysis Services, Integration Services, Re-porting Services, Report Builder 3. 0, Sql 2010 Integration, Reporting  more...

End to End Microsoft Business Intelligence This five day course provides students with the knowledge and skills to develop Microsoft End to-End business solutions using SQL Server 2008 R2 in an integrated environment with SharePoint 2010 and Office 2010. The course introduces the students to Microsoft Unified Data Model, SQL 2008 R2 Analysis Services, Integration Services, Re-porting Services, Report Builder 3. 0, SharePoint 2010  more...

Oracle Database 11g R2 - SQL Tuning This learning guide will equip database administrators and application developers to build efficient SQL statements and to tune database applications. When this effort is complemented by database server and PL/ SQL application tuning, then a highly efficient application execution environment is created. One will learn about the internals of SQL statement execution, how to monitor the performance  more...

PerformancePoint 2010 Designing Implementing Scorecards and Dashboards This four day course covers design theory, different types of dashboards, planning, deployment and security. Each of the first class objects such as Indicators, KPIs, Filters, Data Sources, and interconnecting them into scorecards and combining scorecards into dashboards is covered in depth. In addition peripheral knowledge that greatly enhances the design experience is provided including an  more...

Basic PowerBuilder Classic 12 Programming This course introduces students to the PowerBuilder Classic 12 development environment. Each component of the PowerBuilder Classic 12 IDE is covered in the context of using PowerBuilder to develop GUI-based client/ server business applications. Upon successful completion of this course, the student should be able to: Use the System Tree to create workspaces and targets. Use the Application  more...

COMPLETE IBATIS USING ECLIPSE There are plenty of persistence frameworks in the Java community. iBATIS is an open source a data mappera framework. Data mappers do not tie classes to tables or class fields to columns. Instead, a data mapper maps parameters and results of SQL statements to classes and fields. This makes iBATIS a simple and lightweight persistence framework. By removing the repetitive and error prone work,  more...

COMPLETE IBATIS USING RAD There are plenty of persistence frameworks in the Java community. iBATIS is an open source a data mappera framework. Data mappers do not tie classes to tables or class fields to columns. Instead, a data mapper maps parameters and results of SQL statements to classes and fields. This makes iBATIS a simple and lightweight persistence framework. By removing the repetitive and error prone work,  more...

SQL Server 2008 Integration Services This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and  more...

SQL Server 2008 Analysis Services In this course, you will learn how to use Microsoft SQL Server 2008 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2008 developer the tools to  more...

Microsoft SQL Server 2008 Reporting Services In this course, you will learn how to use SQL Server 2008 Reporting Services. Explore its basic architecture and gain a basic understanding of the components of SSRS 2008. Youa ™ll then explore tabular and list reports that employ datasets and data regions. As you progress youa ™ll learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL  more...

Introduction to Oracle9i -SQL The foundation for all Oracle professionals is the SQL language along with Oracle's SQL*Plus extensions. A detailed consideration of these languages includes such topics as creating and maintaining table definitions in the data dictionary, specifying data types, manipulating tables and developing sophisticated queries quickly and accurately. You can get a complete list of other Oracle classes  more...

Introduction to Oracle9 i- PL-SQL Language 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. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  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...

Oracle9i Network Administration This course uncovers the mystery of the Oracle database middleware contained within Oracle Net / SQL*Net. All of the configuration files are considered along with their contents and how these can be customized. The Oracle Net assistant is also covered and this tool is used for multi-threaded server configuration of the database, activating the Oracle Names Server and the Oracle Connection Manager.  more...

Oracle9i Parallel SQL Execution The objective of this course is to explore Oracle technology for execution of SQL statements in parallel. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  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 9i PL-SQL Application Tuning The objective of this course is to allow PL/ SQL developers to write efficient and tuned programs. Performance techniques, problem areas and troubleshooting tools are all presented. Please note: This course is alternately named Oracle9i Advanced PL/ SQL Programming. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  more...

Oracle 9i Advanced PL-SQL Programming The objective of this course is to allow PL/ SQL developers to write efficient and tuned programs. Performance techniques, problem areas and troubleshooting tools are all presented. Please note: This course is alternately named Oracle9i PL/ SQL Application Tuning. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  more...

Oracle Database 10g - Advanced PL-SQL Programming & Tuning This Oracle 10g courseware training guide book will teach experienced PL/ SQL developers to write efficient programs. Advanced techniques which not only improve execution speed but also enhance the functionality of the programs are also discussed. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  more...

Program With PL-SQL COMPLETE LIBRARY This Oracle 10g courseware training guide book will consider the grammar, syntax and benefits of using the PL/ SQL language within an Oracle database environment. The Oracle PL/ SQL language provides for programming logic features not contained within SQL. This course is taught using the following two volumes. Each volume may be presented as a standalone course. However, It is also frequently  more...

Oracle Database 10g - Program With PL-SQL Part II This Oracle 10g courseware training guide book will consider grammar, syntax and benefits of using the PL/ SQL language within an Oracle database environment. The Oracle PL/ SQL language provides for programming logic features not contained within SQL. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  more...

Oracle Database 10g - Program With PL-SQL Part I This Oracle 10g courseware training guide book will consider the grammar, syntax and benefits of using the PL/ SQL language within an Oracle database environment. The Oracle PL/ SQL language provides for programming logic features not contained within SQL. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  more...

Oracle Database 10g- SQL Tuning This Oracle 10g courseware training guide book will equip developers to build efficient SQL statements and to tune applications from the standpoint of an application developer. When this effort is complemented by database server and possibly PL/ SQL application tuning, then a highly efficient environment has been built. You can get a complete list of other Oracle classes at  more...

Oracle Database 10g- Introduction to SQL - Complete Library This Oracle 10g courseware training guide book will provide an introduction to the SQL database language within the context of an Oracle database. This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  more...

Oracle Database 10g - Introduction To SQL - Part II This Oracle 10g courseware training guide book will consider advanced subjects and techniques pertaining to the SQL database language. 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. You can get a complete list of other Oracle classes at  more...

Oracle Database 10g- Introduction To SQL - Part I This Oracle 10g courseware training guide book will provide an introduction to the SQL database language within the context of an Oracle database. This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  more...

Oracle Business Intelligence - Create Reports Interactive Dashboards Oracle Business Intelligence (BI), formerly known as Siebel Business Analytics, empowers business users with sophisticated data analytic capabilities without any knowledge of database structures or the SQL database language. This training course will guide students through all of the features available from the product to allow one to build sophisticated database requests and to format resulting  more...

Oracle Database 11g R2 - PLSQL Fundamentals II - Develop Program Units This Oracle 11g courseware training guide book will equip students to develop database server-side PL/ SQL program units within an Oracle database. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  more...

Oracle Database 11g- Advanced PL SQL Programming & Tuning This Oracle 11g courseware training guide book will give attention to three fundamental pillars of effective implementation of PL/ SQL applications. The PL/ SQL programming language is at the core of most Oracle database applications. First, we will explore the advanced features of the language which allow powerful and effective database applications to be built. Next, we will discuss performance  more...

Oracle Database 11g R2 -PL and SQL Fundamentals - Complete Library This Oracle 11g courseware training guide book will 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  more...

Oracle Database 11g R2- PL and SQL Fundamentals I This Oracle 11g courseware training guide book will 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. You can get a complete list of other Oracle classes at  more...

Hands-On Oracle for Non-Programmers This class is designed specifically for the needs of end-users, testers, technical support and other personnel supporting or working with an Oracle database. You will benefit from this class if you but need to interact with Oracle but are not faced with the day-to-day task of programming. Through classroom lecture and demonstration and ample hands-on workshops, you will learn how to query the  more...

Oracle8i Advanced PLSQL Programming This class will complete a developers training curriculum concerning Oracle PL/ SQL. Advanced PL/ SQL constructs such as records, tables, LOBs, dynamic PL/ SQL and File input/ output are discussed. The Oracle facilities to tune, trace, and debug your PL/ SQL programs are provided. The concept of packages is further explored and explained with using suggested methods and techniques. Intersession  more...

Oracle8i Differences for Developers This course will prepare application developers to take advantage of new features in Oracle's flagship server product, Oracle8i (version 8. 1. 5 and above). Through lecture and extensive hands-on workshops, you will learn how to critical new features regarding PL/ SQL, Java, OO support, partitioning, materialized views, query enhancements, security enhancements and more. You can get a complete  more...

Oracle8i Application Tuning This course will provide you with the skills necessary to tune Oracle applications. Particular attention is paid to tuning SQL statements, PL/ SQL programs and 3GL programs that access Oracle data. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  more...

Introduction to Oracle8i for Sybase Developers This class is the starting point for all developers with Sybase experience entering the world of Oracle application development. You will leverage your existing Sybase skills to rapidly learn the critical aspects of Oracle development including working with SQL*Plus, writing PL/ SQL programs, creating stored procedures, calling Oracle Supplied Packages, creating Java procedures and creating  more...

Introduction to Oracle8i for Developers This class is the starting point for all developers entering the world of Oracle application development. You will learn the critical aspects of Oracle development including SQL, SQL*PLUS, stored procedures, and triggers. Hands-on workshops constitute approximately 50% of the class. Overviews of relational concepts and Oracle architecture are also provided. You can get a complete list of  more...

Introduction to Oracle9i for Sybase Developers This class is the starting point for all developers with Sybase experience entering the world of Oracle application development. You will leverage your existing Sybase skills to rapidly learn the critical aspects of Oracle development including working with SQL*Plus, writing PL/ SQL programs, creating stored procedures, calling Oracle Supplied Packages, creating Java procedures and creating  more...

Oracle9i Advanced PLSQL Programming This hands-on class is designed for PL/ SQL developers writing or supporting complex enterprise systems and provides a critical continuation of learning for the PL/ SQL developer. This course is the next step for persons who have knowledge of PL/ SQL basics. You will learn how to build systems that incorporate many new 9i features such as ANSI CASE statement, extracting DDL with DBMS_METADATA and  more...

Introduction to Oracle9i for Developers class is the starting point for all developers entering the world of Oracle application development. You will learn the critical aspects of Oracle development including SQL, SQL*PLUS, stored procedures, and triggers. Hands-on workshops constitute approximately 50% of the class. Overviews of relational concepts and Oracle architecture are also provided. You can get a complete list of other Oracle  more...

Oracle9i SQL Tuning for Developers DBAs This course will provide you with the skills necessary to tune Oracle SQL statements. An introduction to application tuning (e. g. avoiding blocking), PL/ SQL tuning and Oracle Programmer tuning is also provided. Particular attention is paid to understanding Oracle architecture, cost-based optimization and to testing various SQL formulations with EXPLAIN and trace to find the best performing  more...

ADO DOTNET for Web Applications Using C# This three-day intensive course teaches the essential elements of ADO. NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications for the Web. The course includes a major case study demonstrating the use of ADO. NET and ASP. NET in a realistic setting. It is current to .NET 2. 0, Visual Studio 2005  more...

Oracle9i PL-SQL Application Tuning The objective of this course is to allow PL/ SQL developers to write efficient and tuned programs. Performance techniques, problem areas and troubleshooting tools are all presented. Please note: This course is alternately named Oracle9i Advanced PL/ SQL Programming. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  more...

ADONET Using Visual Basic This three-day intensive course teaches the essential elements of ADO. NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO. NET in a realistic setting. It is current to .NET 2. 0, Visual Studio 2005 and SQL Server 2005.  more...

ADONET Using C# This three-day intensive course teaches the essential elements of ADO. NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO. NET in a realistic setting. It is current to .NET 2. 0, Visual Studio 2005 and SQL Server 2005.  more...

Developing Web Pages using WSAD v5.0 This course will integrate a combination of instructor-led discussions and interactive workshops to demonstrate the capabilities of IBMa ™s WebSphere Studio v5. 0 product for building HTML and JSP documents. This course will focus on the common set of frameworks and services utilized within this integrated tool platform. The topics presented in this course include; development and deployment  more...

Developing Web Pages using WSAD v5.1 This course will integrate a combination of instructor-led discussions and interactive workshops to demonstrate the capabilities of IBMa ™s WSAD v5. 1 product for building HTML, JSP documents and JavaServer Faces. This course will focus on the common set of frameworks and services utilized within this integrated tool platform. The topics presented in this course include; development and  more...

INTRODUCTION TO ORACLE 10G SQL PROGRAMMING In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 10g Structured Query Language (SQL). Students will also be introduced to Oracle 10g database features and tools. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  more...

MSOLAP and MDX Indepth knowledge of Database Management and SQL Server 2000. You can get a complete list of other Datawarehousing classes at http://www.wintrac.com/courses/coursesdata.asp  more...

Data Warehousing DW Advanced SQL Queries and Performance PLATFORM: Multi-platform: DB2 UDB for z/ OS & OS/ 390, DB2 UDB for Linux/ UNIX/ Windows, Oracle and SQL Server. After briefly reviewing DW and BI terms and concepts, the lecturer will develop an understanding of how to use the statistics, analytic and OLAP features in a BI environment. The main features of this presentation are examples, intensive handson exercises, best practices and  more...

Data Warehouse Fundamentals This data modelling techniques course is designed to answer questions, such as the following: What is data warehousing? What is a data mart? What are the data modelling options? What is Extract, Transform and Load (ETL)? What are the terms and concepts specific to data warehousing and OLAP design? How to plan and implement a data warehouse with high availability, simplified  more...

T-SQL 2005 WITH ADVANCED TOPICS In this course, you'll start by learning about the basic features that are available in SQL Server, including how to design and create a database and how to build queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You'll learn about the new enhancements to the  more...

WRITING T-SQL QUERIES IN SQL SERVER 2005 In this course, youa ™ll learn how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and  more...

EXTENDED FEATURES IN MICROSOFT SQL SERVER 2000 - LEVEL 3 SQL Server 2000 includes a rich set of tools that go beyond the basics of querying and manipulating data. Microsoft added many very useful capabilities in SQL Server that most developers never discover. Learn about the advanced features available to you for maintaining, analyzing, searching and distributing your data. Integrate your data safely with Internet and cross-platform applications.  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...

INTRODUCTION TO MICROSOFT SQL SERVER 2000 a LEVEL 1 Learn about the features that are available in SQL Server; how to design and create a database; and how to build basic queries using Transact-SQL, the language of SQL Server. This introductory course teaches you the fundamentals and gives you a taste of the potential of Microsoft SQL Server 2000. Even developers who've already used Oracle, Sybase, DB2 or other relational database management  more...

MICROSOFT SQL SERVER 7.0 - LEVEL 3 (sql) Level 3 covers how to use ADO and how to begin building client/ server applications with Visual Basic / SQL Server. You'll also learn how to scale your Visual Basic / SQL Server applications to n-tier and the Internet. You can get a complete list of other Sql server classes at http://www.wintrac.com/courses/coursesSQL.asp  more...

MICROSOFT SQL SERVER 7.0 - LEVEL 2 The first part of this course focuses on querying. Youa ™ll learn how to create a basic query using SELECT statements and then move into more advanced types of queries. Then, you'll learn techniques for making the best use of Microsoft SQL Server. Youa ™ll learn how to optimally configure Microsoft SQL Server and use techniques for backing up your data. This course also focuses on topics  more...

MICROSOFT SQL SERVER 7.0 - LEVEL 1 Level 1 is for developers coming from Microsoft Access or Visual Basic development backgrounds who have applications that theya ™re hoping to upsize to SQL Server. Learn some of the issues with installation and configuration, database design issues, how to import non-Jet data, and how to either share data between SQL Server and Jet, or completely upsize data to SQL Server. This introductory  more...

SQL SERVER 2005 REPORTING SERVICES DEVELOPER 1 WORKSHOP This two-day, interactive workshop is designed for new users of Microsoft SQL Server Reporting Services 2005. Some of the topics covered include a review of the software features, administrative tasks, report design, creation of presentation quality reports, and report deployment. The course incorporates a number of hands-on exercises to reinforce the learning process. You can get a complete  more...

SQL SERVER 2005 REPORTING SERVICES In this course, you will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports. You will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. You'll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the  more...

Accelerated Microsoft Business Intelligence(SQL 2008) This four-day, comprehensive course provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 in an integrated environment with SharePoint and Office 2007. The course introduces the students to Microsoft Unified Data Model, SQL 2008 Analysis Services, Integration Services, Reporting Services, Report Builder 2. 0, SharePoint 2007  more...

DB2 for Domino 7 Administrators and Developerslotus One of the most dramatic features of Domino 7 is its ability to use DB2 as an alternate data store. While this opens up expansive vistas for both Domino and DB2 shops, it requires Domino administrators and developers not only to learn how to work with DB2 but how it works with Domino 7. During this course you will learn the essentials of DB2 installation, configuration, and security. You will  more...

Query Management Facility (QMF) for End-Users - Windows The concepts of DB2 are briefly presented and discussed. The Structured Query Language (SQL) is presented as the means to access DB2 data. Several guided, hands-on, practice sessions give each attendee an opportunity to use QMF Windows to build "custom:" reports from DB2 data using the extensive powers of the QMF Windows FORMs panels. Use the QMF Windows "field pull down feature" for  more...

DB2 File-Aid This course teaches the use of File-AID and manipulating DB2 Tables and other DB2 Objects. The class attendees are guided through the File-Aid menu structures and capabilities. Record selection, browsing, and editing DB2 tables are discussed in detail. Use File-Aid to analyze SQL statements. You can get a complete list of other DB2 classes at  more...

DB2 SQL Performance Tuning w QMF This course offers students a lecture/ lab intensive environment on DB2's Data Server Technology. The class covers the concepts of both performance tuning of SQL, Objects and Advanced SQL in a DB2 database and the use of SQL. The student will learn how to write simple to complex queries along with being able to modify database objects through SPUFI and QMF. Advanced technique such as ROLLUP, CUBE,  more...

DB2 Concepts and Facilities First, the concepts of DB2 are presented and discussed. The major features of the Structured Query Language (SQL) are presented as the means to access DB2 data (and to create and secure DB2 components). Several of the "special features" of SQL are presented. Optionally, guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data. QMF and/ or SPUFI are  more...

DB2 for z-OS Database Administration This course begins with a review the concepts and components of DB2 for OS/ 390. DB2 commands and SQL will be used to focus on DB2 administration activities. The relationships between object components will be presented along with communication and security aspects. Design issues of referential Integrity, table check constraints, user defined data types and functions, and triggers are  more...

DB2 for z-OS Application Programming - Advanced DB2 performance guidelines are discussed in detail. The SQL statement EXPLAIN PLAN is used to help to evaluate the efficiency of SQL statements. Advanced Programming Performance considerations are presented to "tuned" programs to perform "better" that their "untuned" counter parts. You can get a complete list of other DB2 classes at  more...

DB2 for z-OS Application Performance Tuning Review overall DB2 SQL Performance Considerations. Discuss the "behavior" of the DB2 Optimizer. Explore DB2 SQL performance issues as revealed by using the EXPLAIN feature. The major columns PLAN_TABLE and DSN_STATEMNT_TABLE are analyzed in detail. The results of the DB2 EXPLAIN process are reviewed to obtain insights into the Way(s) that the Optimizer chooses the access path to access  more...

DB2 for z-OS SQL Advanced Review SQL - Basic Select, Scalar Functions, Joins, SubQueries, Unions, and Insert/ Update/ Selects. Learn / practice features of the current version of DB2 and look into the next version of DB2. Review and practice Advanced SQL features. You can get a complete list of other DB2 classes at http://www.wintrac.com/courses/coursesDB2.asp  more...

Programming Visual FoxPro 7.0 Applications - Level 2 In Level 2, you will learn to incorporate common coding standards, understand how to create and manipulate variable arrays, and understand and apply recursive programming techniques. You will use the IntelliSense Manager to customize IntelliSense, work with the FoxPro Data Manipulation Language, and understand the FoxPro SQL Implementation. Optimize queries with the Rushmore(tm) technology in  more...

T-SQL 2008 In this course, you will learn about the features that are available in SQL Server like how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then you will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You will learn how to use the Transact-SQL programming language for  more...

Accelerated Microsoft Business Intelligence SQL 2008 This four-day, comprehensive course provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 in an integrated environment with SharePoint and Office 2007. The course introduces the students to Microsoft Unified Data Model, SQL 2008 Analysis Services, Integration Services, Reporting Services, Report Builder 2. 0, SharePoint 2007  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 CORE 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 features that are available in SQL Server, how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Youa ™ll learn about the new enhancements to the Transact-SQL programming language  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 2005 DEVELOPER 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 the skills necessary to transition from other development backgrounds to SQL Server 2005. Even developers who have already used Oracle, MySQL, DB2, or other relational database management systems will find this course to useful in achieving a more thorough  more...

SQL SERVER 2005 ANALYSIS SERVICES In this course, you will learn how 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. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to  more...

MICROSOFT SQL SERVER 2005 INTEGRATION SERVICES This course will enable technology professionals with little or no ETL experience and minimal exposure to SQL Server 2005 and Visual Studio 2005 to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development  more...

Microsoft SQL Server 2008 for Developers In this course, you'll see an overview tour of SQL Server 2008 including its editions, components, and tools. Then you will learn about the steps to install, and/ or upgrade to SQL Server 2008 and configuring the server. You will see how 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  more...

MS SYSTEMS - ADVANCED TRAINING SAS STRUCTURED QUERY LANGUAGE WORKSHOP This three day workshop uses the 'HANDS ON' approach to teach the participanys the essential concepts of Structured Query Language (SQL) using SAS. You can get a complete list of other sas classes at http://www.wintrac.com/courses/coursessas.asp  more...

PHP and MySQL Training In this PHP training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. The class also covers SQL basics. You can get a complete list of other PHP classes at http://www.wintrac.com/courses/coursesPHP.asp  more...

DB2 for zOS SQL and Application Programming First, the concepts of DB2 are presented and discussed. The Structured Query Language (SQL) is presented as the means to access DB2 data (and to create and secure DB2 components). Several guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data. QMF and/ or SPUFI are used to execute SQL statements. Referential Integrity concepts and implementation are  more...

DB2 for zOS and SQL First, the concepts of DB2 are presented and discussed. The Structured Query Language (SQL) is presented as the means to access DB2 data (and to create and secure DB2 components). You can get a complete list of other DB2 classes at http://www.wintrac.com/courses/coursesDB2.asp  more...

DB2 for zOS Application Programming First, the concepts of DB2 are presented and discussed. The Structured Query Language (SQL) is presented as the means to access DB2 data (and to create and secure DB2 components). Several guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data. QMF and/ or SPUFI are used to execute SQL statements. Referential Integrity concepts and implementation are  more...

Query Management Facility QMF for End-Users The concepts of DB2 are briefly presented and discussed. The Structured Query Language (SQL) is presented as the means to access DB2 data. Several guided, hands-on, practice sessions give each attendee an opportunity to use QMF to build "custom:" reports from DB2 data using the extensive powers of the QMF FORMs panels. You can get a complete list of other DB2 classes at  more...

DB2 SQL Performance Tuning This course offers students a lecture/ lab intensive environment on DB2's Data Server Technology. The class covers the concepts of both performance tuning of SQL, Objects and Advanced SQL in a DB2 database and the use of SQL. The student will learn how to write simple to complex queries along with being able to modify database objects through SPUFI and QMF. Advanced technique such as ROLLUP, CUBE,  more...

UDB DB2 SQL This course offers students a lecture/ lab intensive environment on DB2's Data Server Technology. The class covers the concepts of Basic SQL, Objects and Advanced SQL in a DB2 database and the use of the Gui interfaces for executing SQL. The student will learn how to write simple to complex queries along with being able to modify database objects through SPUFI, QMF or the Command Console. Advanced  more...

PureXML for DB2 for z-OS V9 This course introduces the features and capabilities of pureXML as a new feature in DB2 for z/ OS Version NINE. The SQL/ XML capabilities are presented to access XML data with Select, Insert, Update, and Delete. You can get a complete list of other DB2 classes at http://www.wintrac.com/courses/coursesDB2.asp  more...

DB2 UDB for zOS Version Nine - Technical Introduction Describe the new features and enhancements of DB2 UDB for z/ OS Version Nine. Evaluate the usefulness of the new features and enhancements of DB2 UDB for z/ OS Version Nine. This course cover a Technical Introduction to the following NEW SQL Features of DB2 UDB for z/ OS Version Nine, including the following - pureXML, New Data Types (bigger BINARY, VARBINARY, BIGINT, DECFLOAT), INSTEAD OF  more...

Oracle Developer 6i Form Triggers Objects This course builds upon the introductory topics of the Oracle Developer 6i Form Builder course to allow developers to customize applications using complex PL/ SQL triggers and object oriented programming techniques. Topics include mouse awareness, writing internal timers, building reusable objects and using reusable object libraries, incorporating PL/ SQL libraries and accessing built-in program  more...

Oracle Business Intelligence Create Reports Interactive Dashboards Oracle Business Intelligence (BI), formerly known as Siebel Business Analytics, empowers business users with sophisticated data analytic capabilities without any knowledge of database structures or the SQL database language. This training course will guide students through all of the features available from the product to allow one to build sophisticated database requests and to format resulting  more...

Microsoft LINQ Using Visual basic 2008 In this course, youa ™ll learn to use the exciting new .NET Framework 3. 5 feature, Language Integrated Query (LINQ) to easily create complex data-independent queries. In addition, youa ™ll learn about the new language features added to Visual Basic in Visual Studio 2008 in order to make LINQ possible. Youa ™ll start by working through a quick overview of LINQ, and how it applies to  more...

Microsoft LINQ Using Visual C# 2008 In this course, youa ™ll learn to use the exciting new .NET Framework 3. 5 feature, Language Integrated Query (LINQ) to easily create complex data-independent queries. In addition, youa ™ll learn about the new language features added to Visual C# in Visual Studio 2008 in order to make LINQ possible. Youa ™ll start by working through a quick overview of LINQ, and how it applies to  more...

DB2 for Domino 7 Administrators and Developers One of the most dramatic features of Domino 7 is its ability to use DB2 as an alternate data store. While this opens up expansive vistas for both Domino and DB2 shops, it requires Domino administrators and developers not only to learn how to work with DB2 but how it works with Domino 7. During this course you will learn the essentials of DB2 installation, configuration, and security. You will  more...

DB2 for Domino 8 Administrators and Developers An exciting feature of Domino is its ability to use DB2 as an alternate data store. While this opens up expansive vistas for both Domino and DB2 shops, it requires Domino administrators and developers not only to learn how to work with DB2 but how it works with Domino. During this course you will learn the essentials of DB2 installation, configuration, and security. You will learn how to  more...

Basic PowerBuilder 7 Programming This course introduces students to the PowerBuilder 7 development environment. Each component of the new PowerBuilder 7 IDE is covered in the context of using PowerBuilder to develop GUI-based client/ server business applications. Upon successful completion of this course, the student should be able to: Use the Application Painter to define application objects. Use the Window Painter to  more...

Basic PowerBuilder 8 Programming This course introduces students to the PowerBuilder 8 development environment. Each component of the PowerBuilder 8 IDE is covered in the context of using PowerBuilder to develop GUI-based client/ server business applications. Upon successful completion of this course, the student should be able to: Use the System Tree create workspaces and targets. Use the Application Painter to create  more...

Basic PowerBuilder 9 Programming This course introduces students to the PowerBuilder 9 development environment. Each component of the PowerBuilder 9 IDE is covered in the context of using PowerBuilder to develop GUI-based client/ server business applications. Upon successful completion of this course, the student should be able to: Use the System Tree to create workspaces and targets. Use the Application Painter to create  more...

Basic PowerBuilder 10 Programming This course introduces students to the PowerBuilder 10 development environment. Each component of the PowerBuilder 10 IDE is covered in the context of using PowerBuilder to develop GUI-based client/ server business applications. Upon successful completion of this course, the student should be able to: Use the System Tree to create workspaces and targets. Use the Application Painter to create  more...

Basic PowerBuilder 11 Programming This course introduces students to the Powerbuilder 11 development environment. Each component of the PowerBuilder 11 IDE is covered in the context of using Powerbuilder to develop GUI-based client/ server business applications. Upon successful completion of this course, the student should be able to: Use the System Tree to create workspaces and targets. Use the Application Painter to  more...