Search results matching tag 'data education'

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.

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.

Data Education: Food For Your Brain

Adam Machanic — Tue, 16 Aug 2011 13:20:00 GMT

I've written here before about Data Education, the training company I recently launched, building off my previous company Boston SQL Training. Things have moved along quickly, and I and the rest of the Data Education staff are very happy to announce a jam-packed fall and winter course roster. We'll be announcing even more classes later in the year, but I wanted to give you a run-down of what we're currently offering. (Note that several of these are currently in the Early Bird stage, which means there are steep discounts already available. For any that aren't, I'd like to offer SQLBlog readers a nice shiny $400 discount. Just enter the code SQLBLOG when registering.)

Without further ado:

The BI Master: TEO LACHEV

Teo will be in Boston next month (September 19-23) sharing his impressive and encyclopedic knowledge of all things SSAS and PowerPivot. Considering he's literally written the books on the subject, this is one BI class you don't want to miss. (Class to include discussion and labs on OLAP, data mining, PowerPivot apps, data analysis, and best practices, plus much more.)

The Entity Framework Guru: JULIE LERMAN

This is one boot camp you can't afford to miss, plus world-renowned .NET expert Julie Lerman won't make you do push-ups. (I don't think.) Instead, she'll spend five days (October 3-7) telling you everything you need to know about Entity Framework 4.1, including CodeFirst. This one will be somewhat intensive and very, very thorough. (Class to include discussion of Code First A-Z, E.F 4.1 DbContext/DbSet, EF in the cloud, EF performance tricks, plus much more.)

The PowerShell Virtuoso: ALLEN WHITE

You'd have to live under a rock to not know that PowerShell is the thing to know these days. We're bringing in Allen White for a three-day course (November 14-16) to teach you Everything You Ever Needed to Know About PowerShell in a SQL Server World: writing scripts, managing scripts, and managing your environment. No knowledge of PowerShell required! (Class to include discussion and labs on SMO, backup and recovery, automating, and importing/exporting CSV and XML files, plus much more.)

The T-SQL Super Star: ITZIK BEN-GAN

Yep, we got him: Itzik Ben-Gan is coming to the East Coast (January 23-27) to present his wildly popular Advanced T-SQL Querying, Programming, and Tuning class. Itzik will talk logical query processing. He'll talk islands and gaps. He'll talk nested iterations using recursive queries. And then he’ll talk about so, so much more. There's a reason he sells out classes and fills rooms at conferences, you know. (Class to include discussion and labs on query tuning, aggregating and pivoting data, TOP and APPLY, programmable objects, plus much more.)

Also, I wanted to point out a few other things we're doing at Data Education, all of which I think my fellow SQL fanatics might appreciate:

Twitter: We have a very active Twitter stream going (@dataeducation). Every weekday, we tweet the best in database blogs and articles. And sometimes we throw in a Chuck Norris joke. Just because.

Blog: The Data Education blog has been up and running for a while. I wrote most of the initial posts (including such fun as bitemporal data and assigning server-level permissions using module signing, but we have guest posts and Important SQL People profiles coming up very shortly. Plus we just posted a rather intriguing behind-the-scenes look at Denali; apparently size does matter. (Interested in becoming a guest blogger? Get in touch!)

Question of the Week: In light of the fact that a Friday is made even better by a $25 Amazon gift card, we've launched our new Question of the Week feature. Each Monday, we post a brainteaser. You get until Thursday at midnight to prove your riddle know-how. The questions have been fairly easy so far. Prepare for much trickier challenges. (Yes, that's a threat!)

Enjoy, and we'll see you in class!

Two Days of Advanced Performance Techniques - July 14-15, New York City

Adam Machanic — Wed, 18 May 2011 16:19:00 GMT

I am pleased to announce that I will be delivering two days of training in New York City, July 14 and 15.

This seminar focuses on achieving "next-level" performance--going beyond that which you can gain via normal tuning methodologies. The vehicles for this performance improvement are two technologies that I've been pushing on this blog and in other venues for a long time: SQLCLR and parallelism. The seminar will be based on the in-depth materials that I used for my full-day sessions PASS conference in 2009 and 2010. These seminars were both quite well-received, but I have tweaked and tuned the content to make it even better and more focused on the bottom line goal of achieving maximum performance.

Full information on the seminar is available on the Data Education web site. There is also an early bird discount currently in effect. Use the discount code "EARLYBIRD" to save $100 on the $1050 registration fee.

I would like to take this opportunity to mention that Data Education is a new training venture that I've recently launched. This will be the company's second public training event (our first featured Kalen Delaney in the Boston area). The company is an evolution of Boston SQL Training, a company that I started a couple of years ago with the goal of bringing extremely high-quality SQL Server training events to the Boston area. The new name, Data Education, reflects our desire to focus beyond Boston and on a broader technology spectrum. We plan to eventually move into training on data-related programming (Entity Framework and similar), other DBMS platforms, NoSQL technologies, and wherever else the database industry moves.

Currently, aside from my course in New York we've announced an Analysis Services and PowerPivot course featuring Teo Lachev, which will take place in the Boston area September 19-23. Several other courses will be announced shortly, so stay tuned and consider following us on Twitter (@DataEducation).

If you've read this far, I would greatly appreciate your taking part in a quick and informal poll: in the comments section below, please let me know what geographic location would be interesting to you for an advanced SQL Server course, and what topic areas you're not seeing enough of.

Thanks, everyone, and I'm looking forward to seeing you in New York!