Search results matching tag 'training'

Itzik Ben-Gan in Atlanta: May 13-17

Adam Machanic — Tue, 05 Feb 2013 21:10:00 GMT

This year Data Education is offering a few more classes with Itzik Ben-Gan, the world's foremost T-SQL instructor.

Our first offering has just been announced: Atlanta, May 13-17.

Neither Itzik nor his class needs much introduction, but click through for a full outline and other details.

We think that Atlanta is a great city, with an amazingly vibrant SQL Server community. Hope you'll be able to join us there!

By the way: if you're joining the class stick around town for a SQL Saturday event that is taking place, coincidentally, on May 18.

From Zero To SSIS Training: 4-8 Mar 2013 in Reston Virginia

andyleonard — Thu, 10 Jan 2013 16:00:00 GMT

Want to learn more about SSIS? I can help. In my course - From Zero To SSIS – I teach you how to effectively use SSIS to deliver data integration solutions.

This is not a market-y survey of the bells and whistles contained in SSIS. I focus on the tasks data integration and ETL developers will use to produce SSIS packages in the enterprise.

How do I know which tasks are used most?

I have been using SSIS since the early beta versions. For over two years, I managed a team of ETL developers at Unisys as we built Medicaid solutions for two state governments and maintained the Medicaid solution for another state. When we needed more people, I had a hard time finding experienced SSIS developers. I needed a way to bring less-experienced developers up to speed quickly. I found a way to train data integration developers to use SSIS to build enterprise-ready, metadata-framework-driven SSIS applications in less than one week. The experience served as the basis for this course which has been delivered publicly and privately to hundreds of students over the past two years.

You can learn more about – and register for – the course here.

Advanced registration is available until 1 Feb 2013: $2,749 USD

Registration after 1 Feb 2013: $2,999 USD

I hope to see you there!

:{>

SSIS Training 15-19 Oct in Reston Virginia

andyleonard — Tue, 18 Sep 2012 11:00:00 GMT

Early bird registration is now open for Linchpin People’s SSIS training course From Zero To SSIS scheduled for 15-19 Oct 2012 in Reston Virginia!

Training Description

From Zero to SSIS was developed by Andy Leonard to train technology professionals in the fine art of using SQL Server Integration Services (SSIS) to build data integration and Extract-Transform-Load (ETL) solutions.

The training is focused around labs and emphasizes a hands-on approach. Most technologists learn by doing; this training is designed to maximize the time attendees spend working with SSIS.

Students must supply a laptop or other computing device configured with an instance of SQL Server 2008, 2008 R2, or 2012 and Integration Services.

Target Audience

The target audience for this training is database professionals, application developers, and business intelligence practitioners interested in acquiring or expanding their existing SSIS skill set.

Prerequisites

No experience with SQL Server or SQL Server Integration Services is required before attending this training.

It is helpful (but not required) that students possess some knowledge of and experience with relational databases. SQL Server knowledge / experience will be more helpful than experience with other technologies.

Training Objectives

At the conclusion of the training, attendees will have been exposed to:

- Using SSIS to develop data integration solutions.

- Using SSIS to load a data warehouse dimension.

- Troubleshooting real-world SSIS Data Flow Task errors.

- Deploying SSIS Solutions.

- Managing, monitoring, and administering SSIS in the enterprise.

Training Summary
Lesson 0: Introduction

- Training overview, expectations, and introductions.

Lesson 1: Creating Your First SSIS package

- Introduction to Business Intelligence Development Studio. Visual Studio tips and tricks, menu contents and locations.

Lesson 2: Introduction to the Data Flow Task

- Introduction to the Data Flow Task. Connection Manager and Data Flow Task basics - source and destination adapters.

Lesson 3: Data Flow Task 201

- Intermediate Data Flow Concepts. Building re-executable data loaders.

Lesson 4: Data Flow Task 202

- Advanced Data Flow Concepts. Building and tuning robust incremental loader.

Lesson 5: The Control Flow

- Containers, Precedence, and Work flow. Transactions, restart-ability, and blocking. Exercise: Sequence Containers.

Lesson 6: Loop Containers

- Using For Loop and Foreach Loop Containers.

Lesson 7: Data Flow Task 301

- Data Cleansing Basics. Building an incremental loader for real-world data.

Lesson 8: Data Flow Task 302

- Intermediate Data Cleansing. Managing real-world changes to data sources.

Lesson 9: Data Flow Task 303

- Advanced Data Cleansing. Loading uneven flat file sources

Lesson 10: Event Handlers, Logging, and Configurations

- A survey of SSIS event handlers focusing on OnError and OnInformation events. Using SSIS’s built-in logging facility to capture package execution details and statistics; and built-in package configurations to externalize variable values.

Lesson 11: Security, Deployment, and Execution

- SSIS Package deployment options and security implications.

- SSIS Package execution.

Lesson 12: Enterprise Data Flow Design

- Data Flow performance characteristics

- Data integration instrumentation

Lesson 13: ETL Design Patterns

- Leveraging less-documented features of SSIS along with the Parent-Child design pattern to achieve “hands-free” custom logging and creative custom configuration. ETL Instrumentation.

Lesson 14: Enterprise Execution Patterns

- Leveraging the Parent-Child design pattern and much of what we’ve learned over the past days to build a metadata-driven SSIS execution framework engine.

:{>

Using Resources the Right Way

BuckWoody — Tue, 04 Sep 2012 13:11:45 GMT

It’s an interesting time in computing technology. At one point there was a dearth of information available for solving a given problem, or educating ourselves on broader topics so that we can solve problems in the future. With dozens, perhaps hundreds or thousands of web sites and content available (for free, in many cases) from vendors, peers, even colleges and universities, it seems like there is actually too much information. Who has the time to absorb all this information and training? Even if you had the inclination, where to start?

In fact, it seems so overwhelming that I often hear people saying that they can’t find the training they need, or that vendor X or Y “doesn’t help their users”. On questioning these folks, however, I often find that they – and sometimes I - haven’t put in the effort to learn what resources we have.

That’s where blogs, like this one, can help. If you follow a blog, either by checking it often or perhaps subscribing to the Really Simple Syndication (RSS) feed, you’ll be able to spread out the search or create a mental filter for the information you need.

But it’s not enough just read a blog or a web page. The creators need real feedback – what doesn’t work, and what does. Yes, you’re allowed to tell a vendor or writer “This helped me because…” so that you reinforce the positives. To be sure, bring up what doesn’t work as well – that’s fine. But be specific, and be constructive. You’d be surprised at how much it matters. I know for a fact at Microsoft we listen – there is a real live person that reads your comments. I’m sure this is true of other vendors, and I also know that most blog authors – yours truly most especially – wants to know what you think.

In this blog entry I’d to call your attention to three resources you have at your disposal, and how you can use them to help. I’ll try to bring up things like this from time to time that I find useful, and cover in them in more depth like this. Think of this as a synopsis of a longer set of resources that you can use to filter whether you want to research further, bookmark, or forward on to a circle of friends where you think it might help them.

Data Driven Design Concepts

http://msdn.microsoft.com/en-us/library/windowsazure/jj156154

I’ll start with a great site that walks you through the process of designing a solution from a data-first perspective. As you know, I believe all computing is merely re-arranging data. If you follow that logic as well, you’ll realize

that whenever you create a solution, you should start at the data-end of the application. This resource helps you do that. Even if you don’t use the specific technologies the instructions use, the concepts hold for almost any other technology that deals with data. This should be a definite bookmark for a developer, DBA, or Data Architect.

When I mentioned my admiration for this resource here at Microsoft, the team that created it contacted me and asked if I’d share an e-mail address to my readers so that you can comment on it. You’re guaranteed to be heard – you can suggest changes, talk about how useful – or not – it is, and so on. Here’s that address: azuremigration@microsoft.com

End-to-End Example of a complete Hybrid Application – with Live Demo

https://azurestocktrader.cloudapp.net/Default.aspx

I learn by example. I also like having ready-made, live, functional demos that show the completed solution at work. If you’ve ever wanted to learn how a complex, complete, hybrid application that bridges on-premises systems with cloud-based databases, code, functions and more, this is it. It’s a stock-trading simulator, and you can get everything from the design to the code itself, or you can just play with the application. It’s running on Windows Azure, the actual production servers we use for everything else.

Using a Cloud-Based Service

https://azureconfigweb.cloudapp.net/Default.aspx

Along with that stock-trading application, you have a full demonstration and usable code sample of a web-based service available. If you’re a developer, this is a style of code you need to understand for everything from iPhone development to a full Service-Oriented Architecture (SOA) environment.

So check out these resources. I’ll post more from time to time as I run across them. Hopefully they’ll be as useful to you as they are to me. Oh, and if you have a comment on any of the resources, let them know. And if you have any comments about these or any of my entries, feel free to post away.

To quote a famous TV Show: “Hello Seattle – I’m listening…”

Join me for SSIS Training in London 12-14 Sep 2012

andyleonard — Sat, 18 Aug 2012 08:50:00 GMT

We still have a few seats available in the Learning SQL Server 2012 Integration Services class in London in mid-September. You can learn details here and register for the course here. I hope to see you there in September!

:{>

Did You Know? I’m delivering my first SQL Server 2012 class this week!

Kalen Delaney — Wed, 08 Aug 2012 04:14:00 GMT

This is actually just a very short post to get my name back up in the list on the right side of SQLBlog, because Adam’s configuration removes people who haven’t posted in 3 months. I’ve been extremely busy trying to get my new book finished, and then get my course updated for its first delivery this week. I’ll be teaching it again in Norway at the end of the month.

It’s a great class this week, and a couple of questions have inspired longer posts, which hopefully I be able to get to next week.

Hopefully I’ll also have an update on the timeline for the new book by next week.

My schedule is always available if you are interested in learning SQL Server 2012 Internals with me!

http://schedule.KalenDelaney.com

Thanks

~Kalen

Learn SSIS in London 12-14 Sep 2012!

andyleonard — Thu, 31 May 2012 13:30:00 GMT

My friends at TechniTrain, the students, and I had a blast during the March 2012 London delivery of From Zero To SSIS! We have decided to do it again in September 2012 with my new Learning SSIS 2012 3-day course!

Please find a course outline here. It is difficult to list everything I cover in the course, but the outline hits the high spots.

This material grew out of my experiences serving as a consultant on short-term engagements and as a manager (and enterprise ETL architect) for a team of forty data integration developers building concurrent, long-term projects in a global enterprise. The information is practical and actionable. I share my mistakes and pain points, hoping students will learn as much from my errors as I did. It is a hands-on course because I believe nothing reinforces hearing like doing. The course is not a survey of all the functionality included in SSIS 2012. Instead, it focuses a proportionate amount of time (and laboratory exercises) on the components of SSIS the data integration developer will use.

The course focuses on data integration development topics during the first section. Data integration topics include a lot of material about the SSIS Data Flow Task (Why? Because SSIS was built to move data.). I also cover Control Flow topics including work flow, Containers, Precedence Constraints, and Loop Containers. The second section covers the topics of Security, Deployment, Execution, Logging, Configurations, SSIS Design Patterns, and ETL Frameworks.

I hope to see you in London 12-14 Sep 2012! Should you have any questions about the course, please contact me by clicking the Email link in the upper right corner of this page.

You may register for the SSIS course here.

:{>

MicroTraining: Executing SSIS 2012 Packages 22 May 10:00 AM EDT (Free!)

andyleonard — Wed, 16 May 2012 12:00:00 GMT

I am pleased to announce the latest (free!) Linchpin People microtraining event will be held Tuesday 22 May 2012 at 10:00 AM EDT. The topic will be Executing SSIS 2012 Packages. In this presentation, I will be demonstrating several ways to execute SSIS 2012 packages.

Interested in learning about more microtraining from Linchpin People – before anyone else? Sign up for our newsletter!

:{>

SSIS Training Survey

andyleonard — Wed, 02 May 2012 14:42:15 GMT

Linchpin People is considering public training delivery for From Zero To SSIS! We would love to hear from you about your interest in this training. Please take this three-question survey to let us know of your interest and location preference.

:{>

Data Education: Great Classes Coming to a City Near You

Adam Machanic — Thu, 12 Apr 2012 01:24:00 GMT

In case you haven't noticed, Data Education (the training company I started a couple of years ago) has expanded beyond the US northeast; we're currently offering courses with top trainers in both St. Louis and Chicago, as well as the Boston area.

The courses are starting to fill up fast—not surprising when you consider we’re talking about experienced instructors like Kalen Delaney, Rob Farley, and Allan Hirt—but we have still have some room. We’re very excited about bringing the highest quality SQL training to the middle of the country.

If you’re interested in taking one of the courses (or more! multiple registration discount!), you're in luck: just enter the special discount codes for SQLblog.com readers:

KALENSQLBLOG will get you $250 off Kalen Delaney’s Internals course in St. Louis (May 7-11)
ROBSQLBLOG will get you $150 off Rob Farley’s T-SQL course in Chicago (May 14-16)
ALLANSQLBLOG will get you $250 off Allan Hirt’s Mission Critical course in Boston (June 18-20)

Without further ado, the course descriptions (full outlines at DataEducation.com) … hope to see many of you soon in a Data Ed classroom!

SQL Server 2005, 2008, and 2012 Internals and Query Tuning (May 7-11; St. Louis, MO): Kalen Delaney is back with her blockbuster internals course, now with information on SQL Server 2012. In this world-renowned five-day course, students will learn how to take a long, hard look at the SQL Server relational engine. After better understanding what’s happening internally, students will get the opportunity to investigate how internals can affect how you set up your databases for maximum performance and reliability. Query tuning within SQL Server 2005 and 2008, as well as parts of SQL Server 2012, will be discussed in depth.

(This course is geared toward both SQL Server DBAs and developers with some experience with application development and architecture.)

Advanced T-SQL Querying and Reporting: Building Effectiveness (May 14-16; Chicago, IL): You know this one will be good if MVP Rob Farley is flying all the way from his native Australia to our classroom in Chicago. This three-day course is a journey through the more advanced side of T-SQL, designed to help you create queries that are simply more effective. Rob Farley takes his students on a road trip of unlearning bad habits of querying and reporting, and into a deeper understanding of what makes a query effective. Common student feedback for this course includes “You’ve made me want to go back and rework every query I’ve ever written” and “I didn’t realize how much I didn’t understand about even the fundamental parts of T-SQL.”

(The T-SQL taught will be primarily for SQL Server 2012, but most of the principles taught will also apply equally to SQL Server 2005 and SQL Server 2008.)

This is Mission Critical: High Availability for SQL Server 2008 and 2012 (June 18-20; Boston, MA): This course is another perfect example of learning an in-depth topic straight from one of the world’s biggest experts in that area. In this three-day course, Windows, clustering, and SQL Server high availability/disaster recover expert Allan Hirt will dive into new features and enhancements within SQL Server 2012 (as well as 2008), including the enhanced multi-site failover clusters and AlwaysOn availability groups. Windows 8 Server and Server Core will also be discussed as they relate to highly available SQL Server deployments.

(This course is perfect for SQL Server DBAs eager to get an early understanding of SQL Server 2012 and what is means for creating and maintaining mission-critical database systems.

Let me know if you have any questions about these or other Data Education course offerings.