Date and Time:
Wed, 02/26/2014 - 12:00pm - Wed, 03/26/2014 - 1:30pm
Presented by Craig Pelkie
February 26th, March 5th, 12th, 19th, and 26th @ 12pm ET
Microsoft SQL Server is one of the most widely used database management systems. It is frequently deployed along with the IBM i in many companies. In this eLearning course, you'll see how you can effectively use SQL Server with the IBM i.
This course meets once a week for five weeks (about an hour per session), and includes weekly labs. By working through the labs, you will develop the skills required to effectively work with Microsoft SQL Server in conjunction with your IBM i. Each lab takes between 2 to 4 hours to complete. Please see below for pre-requisites and required software.
Session 1: Install, Configure and Connect to SQL Server – February 26th at 12pm ET
To get started, you'll see how you can install SQL Server on your PC for development and testing. You'll learn how to use the IBM i Database providers, supplied with every IBM i, to connect your IBM i to SQL Server. You'll also get a high-level overview of some of the major features of SQL Server, with particular emphasis on how those features relate to working with the IBM i database. In the lab, you will create and run a query within SQL Server to prove that you have a connection to your IBM i.
Session 2: Work with Linked Servers – March 5th at 12pm ET
In this session, you'll learn how to create a linked server on SQL Server to connect to your IBM i. You'll see how to replicate data from your IBM i to SQL Server or from SQL Server to your IBM i, using the linked server. You'll also learn about some of the tools that are provided with SQL Server to manage its configuration and usage and how to use scripting tools within SQL Server to create script files. You will also use the SQLCMD command line tool and the SQL Server Agent to create scheduled jobs that you can use to run the scripts that you develop.
Session 3: The SQL Server model database, logins, and schemas – March 12th at 12pm ET
In this session, you will learn about the model database that is included with SQL Server, and what you need to know about creating and working with user-defined databases. You’ll see how to define and work with schemas within a database and how to control authorization to database objects.
Session 4: Work with the SQL Server Import and Export Wizard – March 19th at 12pm ET
In this session, you'll learn how to work with the SQL Server Import and Export Wizard to quickly develop data transfer applications. You will work with the DtExecUI and DtExec programs to run a saved data transfer application, and you’ll learn how you can use the SQL Server Agent to run data transfers on a schedule.
Session 5: How to use the Microsoft JDBC driver on the IBM I – March 26th at 12pm ET
Although you can create a Linked Server in SQL Server to connect to your IBM i, there may be a requirement to connect from your IBM i to SQL Server, so that programs on the IBM i can access SQL Server.
In the final session, you'll learn how to configure and use the Microsoft JDBC driver on your IBM i to connect to your SQL Server. You will work with a sample Java application that runs on your IBM i to read and modify data on the SQL Server. Once you know how to install, configure, test and debug a JDBC connection from your IBM i to SQL Server, you will be able to use tools in RPG (for example, Scott Klement’s JDBCR4 programs) to access SQL Server through the JDBC driver. You do not need to know the Java programming language to benefit from this session; the complete sample code is included, along with instructions on how to install and run the program on your IBM i.
You should have an IBM i programming background to take this course. You do not need to have previous experience with SQL Server. This course assumes that you have access to a Windows PC (Windows 8, Windows 7, Windows Vista, Windows XP) or Windows Server (Windows Server 2012 R2, Windows Server 2012, Windows Server 2008R2, Windows Server 2008, Windows Server 2003R2), and that you will be able to install and configure software on that PC.
The following software is used in this course. You are responsible for obtaining, installing, and configuring the software on your PC; iPro Developer and Craig Pelkie (the instructor for this course) cannot provide any of the required software for you. The software that is used is available at no-charge from both Microsoft and IBM. The course labs include complete instructions that show what you need to obtain and how to install and configure it.
The required software includes:
IBM i Access for Windows database providers, including the ODBC Driver, OLE DB Provider and .NET Provider. You need to install the current Service Pack for your version of IBM i Access for Windows. You can use any of the following versions:
- iSeries Access for Windows V5R3
- System i Access for Windows V5R4
- System i Access for Windows V6R1
- IBM i Access for Windows V7R1
Your IBM i can be running any V5Rx version of OS/400 or the i 6.1 or 7.1 operating system. You will need an IBM i user profile that has sufficient authority to create and manage libraries and database objects on the IBM i. If you are running an older version of OS/400 (for example, V5R1 or V5R2), you need to obtain and install at least the iSeries Access for Windows V5R3 version on your PC.
Microsoft SQL Server 2012 Express Version or Microsoft SQL Server 2012 Enterprise Edition Trial Version
You can install the SQL Server 2012 Express Edition, which is available at no-charge and does not have a time limit. Some of the SQL Server features described in this course (for example, the SQL Server Agent) are not included in the Express Edition.
You can download a 180-day no-charge evaluation copy of the SQL Server 2012 Enterprise Edition from Microsoft. This Enterprise Edition includes all of the tools that are described in the course.
This course describes features that are available in the SQL Server 2012 product. Many of the features that are shown in this course are available in previous versions for SQL Server (SQL Server 2008 R2, SQL Server 2008, SQL Server 2005), but are not available in earlier versions. This course does not provide details about features that are available or missing in earlier versions.
For more information
You can direct questions about how to register for this course to your iPro Developer sales associate. Technical questions or other questions about the course content can be directed to Craig Pelkie (firstname.lastname@example.org).
This course meets once a week for five sessions. Sessions are recorded and are viewed on your PC. You will need Internet access to view the sessions, and headphones or speakers to listen to the session. A chat application is available during the session so that you can ask questions. Each weekly meeting is approximately 1 hour in duration. All of the meetings are recorded, so if you are unable to attend the meeting at the scheduled time or if you want to review the meeting later, you can access the recorded version of the session at your convenience.
A course web page is your main point of access to the course materials. Each week before the meeting, materials for that week are posted to the course web site and you receive a reminder email advising you to download the materials.
The PDF files that are available for download include the presentation that is shown during the session, labs, and other documents that will help you work through the examples. Although you are not required to work through the labs, you will get the most benefit from the course if you can find time on a weekly basis to complete the labs. All of the labs require the use of the software that you will download and install on your PC. Each lab takes from 2 to 4 hours to complete.
Need assistance with your registration? Contact our customer service team at email@example.com or by phone at 800-650-1804 or 913-967-1719. Group discounts and invoiced orders available upon request.