Instructor Led Sql Database 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 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...

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 - Structured Query Language Students will learn what 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  more...

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

Java 2: Enterprise Connectivity Java 2: Enterprise Connectivity builds on the fundamentals of the Java Enterprise Edition (J2EE) technology including database connectivity, Java Server Pages, Servlets, and Enterprise Java Beans. Upon successful completion of this course, students will be able to: Understand the flow of documents and control on the World Wide Web (WWW). Describe the structure of Java Database Connectivity  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 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) ...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 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 ...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...

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...

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...

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...

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 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 - 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 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 ...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 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...

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...

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...

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...

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...

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...

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...

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 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...

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...

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...

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 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...

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...

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 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...

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...

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...

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...