Instructor Led SQL Training

DB2 9.7 Administration on Unix, Linux and Windows This course is designed to teach you how to perform database administration tasks using DB2 9. 7. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. Please contact info@meritforge. com for further queries. After completing this course, you should be able to: * Administer a DB2 database  more...

Oracle Administration ... Audits a Fine-grained auditing DATABASE TUNING SQL Statement Tuning Optimizer modes Hints Plan stability and stored outlines SQL tuning diagnostic tools Interpret results from SQL tuning diagnostic tools Tuning using 11g Advisors a Tuning the SGA Backup and Recovery Export/ Import, Cold/ Hot Backups Recovery from Instance Failure and Media Failure. Backup and Recovery  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  more...

Advanced SQL ...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 much more! For a full list of course  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 ...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 also learn how to create ad hoc reports using the Report Builder and Report Model  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 ...inked, 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 fundamental concepts of databases, creating a preliminary database design, applying normalization techniques, and familiarizing yourself with relational database management systems.  more...

SQL ... 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 database. Upon successful completion of this course, students will be able to: Connect to the SQL Server database and execute a simple query Include a search condition in a simple query Use  more...

SQL Level 2 ...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 and index  more...

SQL - Structured Query Language ...SQL is and how it can help them query a database to answer 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  more...

SQL Database Design & Implementation ...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 completion of this course, students will be  more...

Java 2: Enterprise Connectivity ...to connect 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  more...

Microsoft SQL Server 2005 DBA Program Objective: This course is targeted for those who have good knowledge and hands-on experience on using SQL Server 2000 database environment as it mainly focuses on database administrative tasks that an administrator generally needs to perform in a production environment for maintaining SQL Server 2005 databases and components related to the SQL Server environment. Pre-requisites: SQL Server  more...

Oracle Application Developer 9i & 10g Oracle 9i Application Developer Track: SQL (5 days), PL/ SQL (5days), Forms (5Days), Reports (5 days) Oracle 10g Application Developer Track: SQL (5 days), PL/ SQL (5 days), Forms (5 days), Reports (5 days)  more...

Oracle BI Suite EE 10g R3 Build Repositories ...Prerequisites: a Dimensional modeling a Basic SQL a Data warehouse design a Database design a Oracle BI Suite EE 10g R3: Create Reports and Dashboards a Oracle BI 10g: Analytics Overview - Course Objectives: a Use time series functions to support historical time comparison analyses a Build the Physical, Business Model and Mapping, and  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) ...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 include detailed directions on using  more...

Fast Track to Hibernate Using Hibernate For Java Database Access ...guage, designed as a minimal object-oriented extension to SQL, provides an elegant bridge between the object and relational worlds. Hibernate also allows you to express queries using native SQL or Java-based Criteria and Example queries. Hibernate is now the most popular OR mapping solutions for Java, and it has become a de facto standard in Java OR mapping. JBoss has integrated Hibernate  more...

JDBC - Java Database Connectivity ...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 instructions include detailed directions on  more...

End to End Microsoft Business Intelligence (sql server) ... 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 Services Content Types, PerformancePoint Services, Dashboard  more...

End to End Microsoft Business Intelligence ... 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 Integration, Reporting Services Content Types, PerformancePoint Services,  more...

Oracle Database 11g R2 - SQL Tuning ...inistrators 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 of such execution, and how one can  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 ...Use the Query Painter to interactively construct and edit SQL statements. Use the Database Painter to define extended attributes and manage database tables. Use the Menu Painter to create traditional and contemporary menus. Debug PowerBuilder applications. Package a PowerBuilder application for distribution. Discuss the alternative deployment types, including pcode, machine code, and  more...

COMPLETE IBATIS USING ECLIPSE ...ns. 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, iBATIS helps remove developers from focusing on low level JDBC code. This hands-on course will expose developers to the iBATIS open source framework while also teaching awareness of some  more...

COMPLETE IBATIS USING RAD ...ns. 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, iBATIS helps remove developers from focusing on low level JDBC code. This hands-on course will expose developers to the iBATIS open source framework while also teaching awareness of some  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 ...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 build data cubes and forecasting solutions. This  more...

Microsoft SQL Server 2008 Reporting Services ...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 Server 2008 Business Intelligence  more...

Introduction to Oracle9i -SQL ...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 at  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 ...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 such is applicable even for SQL  more...

Oracle9i Network Administration ... 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. You can get a complete list of  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 ...rested 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 ease-of-use features of Oracle Discoverer then  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...

Develop Oracle 9i PL-SQL Program Units An essential component of client/ server application development is the creation of database server-side program units. This course discusses the subjects of database triggers and stored procedures. Advanced topics such as using system-supplied packages, programming for superior performance, object oriented encapsulation of logic into packages and many others are discussed in detail. You can get  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 ...onsider 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 combined for this presentation as the "complete  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 - Implement Parallel SQL & Partitioning For Data Warehouses This Oracle 10g courseware training guide book will equip database professionals with the advanced skills needed to administer data warehouses. As the size of databases and data warehouses increases, one cannot rely upon the default features of the Oracle database to sufficiently process such massive volumes of information. One must employ advanced features intended for such environments. In fact,  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 ...ee 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 tuning techniques which allows these applications to run efficiently.  more...

Oracle Database 11g R2 -PL and SQL Fundamentals - Complete Library ...aining 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 Oracle database. You  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...

Oracle Database 11g R2- SQL Fundamentals - Complete Library This Oracle 11g courseware training guide book will prepare students for the Oracle certification exams (OCP). This course book can be used as a user guide tutorial for ongoing reference long after the course is completed. This training course reference book is a common starting point in the Oracle database curriculum for administrators, developers and business users. You can get a complete  more...

Oracle Database 11g R2 -SQL Fundamentals II This Oracle 11g courseware training guide book will prepare students for the Oracle certification exams (OCP). This course book can be used as a user guide tutorial for ongoing reference long after the course is completed. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp  more...

Oracle Database 11g SQL Fundamentals I This Oracle 11g courseware training guide book will prepare students for the Oracle certification exams (OCP). This course book can be used as a user guide tutorial for ongoing reference long after the course is completed. This training course book is a common starting point in the Oracle database curriculum for administrators, developers and business users. You can get a complete list of other  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 ...te 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 communication and  more...

Oracle8i PL-SQL Programming This class is for those entering the world of Oracle application development either having previous Oracle or other relational database experience. You will learn the critical aspects of Oracle development including cursors, stored procedures and functions, triggers, error handling and tuning basics. Hands-on workshops constitute approximately 50% of the class. You can get a complete list of  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 ...ical 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 triggers. Differences between Oracle and Sybase are noted throughout. Hands-on workshops constitute approximately 50% of the class. An overview of Oracle architecture is also provided. You can get a  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 ...ical 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 triggers. Differences between Oracle and Sybase are noted throughout. Hands-on workshops constitute approximately 50% of the class. An overview of Oracle architecture is also provided. You can get a  more...

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

Oracle9i Advanced PLSQL Programming ...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 using datetime data to support time  more...

Oracle9i PL-SQL Programming This class is for those entering the world of Oracle application development either having previous Oracle or other relational database experience. You will learn the critical aspects of Oracle development including cursors, stored procedures and functions, triggers, error handling and tuning basics. You can get a complete list of other Oracle classes at  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 ...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 option. This  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 ...tting. It is current to .NET 2. 0, Visual Studio 2005 and SQL Server 2005. The course opens with an overview of ADO. NET and its relation to previous Microsoft data access technologies, including ADO. It includes a discussion of ADO. NET architecture, main interfaces and classes, and programming with both the connected and disconnected models. The database for the case study is introduced.  more...

ADONET Using C# ...tting. It is current to .NET 2. 0, Visual Studio 2005 and SQL Server 2005. The course opens with an overview of ADO. NET and its relation to previous Microsoft data access technologies, including ADO. It includes a discussion of ADO. NET architecture, main interfaces and classes, and programming with both the connected and disconnected models. The database for the case study is introduced.  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 ...S & 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 performance considerations. You can get a  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 ...y 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 Transact-SQL programming language  more...

WRITING T-SQL QUERIES IN SQL SERVER 2005 ... ™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 programmers can now use  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 ...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 systems will find this course useful for getting  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 ...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 course teaches you the fundamentals and gives you a taste of the potential of Microsoft SQL  more...

SQL SERVER 2005 REPORTING SERVICES DEVELOPER 1 WORKSHOP ...teractive 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 list of other  more...

SQL SERVER 2005 REPORTING SERVICES ...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 course will employ shared data sources,  more...

Accelerated Microsoft Business Intelligence(SQL 2008) ... 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 Integration, Reporting Services Content Types, Business Data Catalog, and Business  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 ...esented 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 changing field values Use  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 ...e 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, set operators and creation of user-defined datatypes discussed. You can get a complete list of  more...

DB2 Concepts and Facilities ... 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 used to execute SQL statements. DB2 database  more...

DB2 for z-OS Database Administration ...s 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 covered in detail. Program design  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 ...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 DB2 data.  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 ...Pro Data Manipulation Language, and understand the FoxPro SQL Implementation. Optimize queries with the Rushmore(tm) technology in Visual FoxPro. Use the Visual FoxPro Database Container to enforce data integrity and edit data with Updatable Views. You will recognize and solve the design issues involved in multi-user programming, increase the flexibility and maintainability of your applications  more...

T-SQL 2008 ..., 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 error  more...

Accelerated Microsoft Business Intelligence SQL 2008 ... 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 Integration, Reporting Services Content Types, Business Data Catalog, and Business  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,  more...

MICROSOFT SQL SERVER 2005 ADDITIONAL TOPICS ...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 large amounts of data, handling complex data structures, implementing asynchronous messaging, and working with XML. You can get a  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  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  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  more...

SQL SERVER 2005 ANALYSIS SERVICES ...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 build data warehousing and decision support system  more...

MICROSOFT SQL SERVER 2005 INTEGRATION SERVICES ... 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 Studio (BIDS) and working with Control Flow and  more...

Microsoft SQL Server 2008 for Developers ...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 Studio and how to build effective views,  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 ...resented 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 covered. You can get a complete  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 ...resented 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 covered. You can get a complete  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 ...e 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, set operators and creation of user-defined datatypes discussed. You can get a complete list of  more...

UDB DB2 SQL ...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 technique such as ROLLUP, CUBE, set operators and creation of user-defined  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 ...ourse 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 triggers, INTERSECT and EXCEPT, TRUNCATE Statement, MERGE Statement, Native SQL Stored Procedures, Optimistic Concurrency Control, Automatic Object Creation, Skip Locked Data, REOPT  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 ...ng with collections of objects, retrieving data stored in SQL Server, and creating XML content. Subsequent topics introduce new LINQ-oriented language features, LINQ to Objects, LINQ to DataSets, LINQ to SQL, LINQ to XML, and LINQ to Entities. By the time youa ™ve completed the course, youa ™ll have a good understanding of now only how to construct LINQ queries to work with data, but  more...

Microsoft LINQ Using Visual C# 2008 ...ng with collections of objects, retrieving data stored in SQL Server, and creating XML content. Subsequent topics introduce new LINQ-oriented language features, LINQ to Objects, LINQ to DataSets, LINQ to SQL, LINQ to XML, and LINQ to Entities. By the time youa ™ve completed the course, youa ™ll have a good understanding of now only how to construct LINQ queries to work with data, but  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 ...Use the Query Painter to interactively construct and edit SQL statements. Use the Database Painter to define extended attributes and manage database tables. Use the Menu Painter to create traditional and contemporary menus. Debug PowerBuilder applications. Package a PowerBuilder application for distribution. Discuss the alternative deployment types, including pcode, machine code, and  more...

Oracle Database 11g SQL Fundamentals 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. The primary objective of this course is to consider advanced subjects and techniques pertaining to the  more...