Microsoft SQL Server Training Classes in Mentor, Ohio

Learn Microsoft SQL Server in Mentor, Ohio and surrounding areas via our hands-on, expert led courses. All of our classes either are offered on an onsite, online or public instructor led basis. Here is a list of our current Microsoft SQL Server related training offerings in Mentor, Ohio: Microsoft SQL Server Training

We offer private customized training for groups of 3 or more attendees.
Mentor  Upcoming Instructor Led Online and Public Microsoft SQL Server Training Classes
Microsoft SQL AlwaysOn and High Availability for SQL 2016 Training/Class 16 March, 2020 - 17 March, 2020 $1190
HSG Training Center
Mentor, Ohio
Hartmann Software Group Training Registration

Microsoft SQL Server Training Catalog

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Blog Entries publications that: entertain, make you think, offer insight

What are the three most important things non-programmers should know about programming?
 
Written by Brian Knapp, credit and reprint CodeCareerGenius
 
 
Since you asked for the three most important things that non-programmers should know about, and I’ve spent most of my career working with more non-programmers than programmers, I have a few interesting things that would help.
 
Number One - It Is Impossible To Accurately Estimate Software Projects
 
No matter what is tried. No matter what tool, agile approach, or magic fairy dust people try to apply to creating software… accurately predicting software project timelines is basically impossible.
 
There are many good reasons for this. Usually, requirements and feature ideas change on a daily/weekly basis. Often it is impossible to know what needs to be done without actually digging into the code itself. Debugging and QA can take an extraordinary amount of time.
 
And worst of all…
 
Project Managers are always pushing for shorter timelines. They largely have no respect for reality. So, at some point they are given estimates just to make them feel better about planning.
 
No matter how much planning and estimation you do, it will be wrong. At best it will be directionally correct +/- 300% of what you estimated. So, a one year project could actually take anywhere between 0 and 5 years, maybe even 10 years.
 
If you think I’m joking, look at how many major ERP projects that go over time and over budget by many years and many hundreds of millions of dollars. Look at the F-35 fighter jet software issues.
 
Or in the small, you can find many cases where a “simple bug fix” can take days when you thought it was hours.
 
All estimates are lies made up to make everyone feel better. I’ve never met a developer or manager who could accurately estimate software projects even as well as the local weatherman(or woman) predicts the weather.
 
Number Two - Productivity Is Unevenly Distributed
 
What if I told you that in the average eight hour work day the majority of the work will get done in a 30 minute timeframe? Sound crazy?
 
Well, for most programmers there is a 30–90 minute window where you are extraordinarily productive. We call this the flow state.
 
Being in the flow state is wonderful and amazing. It often is where the “magic” of building software happens.
 
Getting into flow can be difficult. It’s akin to meditation in that you have to have a period of uninterrupted focus of say 30 minutes to “get in” the flow, but a tiny interruption can pull you right out.
 
Now consider the modern workplace environment. Programmers work in open office environments where they are invited to distract each other constantly.
 
Most people need a 1–2 hour uninterrupted block to get 30–90 minutes of flow.
 
Take the 8 hour day and break it in half with a lunch break, and then pile in a few meetings and all of a sudden you are lucky to get one decent flow state session in place.
 
That is why I say that most of the work that gets done happens in a 30 minute timeframe. The other 7–8 hours are spent being distracted, answering email, going to meetings, hanging around the water cooler, going to the bathroom, and trying to remember what you were working on before all these distractions.
 
Ironically, writers, musicians, and other creative professionals have their own version of this problem and largely work alone and away from other people when they are creating new things.
 
Someday the programming world might catch on, but I doubt it.
 
Even if this became obvious, it doesn’t sit well with most companies to think that programmers would be paid for an 8 hour day and only be cranking out code for a few hours on a good day. Some corporate middle manager would probably get the bright idea to have mandatory flow state training where a guru came in and then there would be a corporate policy from a pointy haired boss mandating that programmers are now required to spend 8 hours a day in flow state and they must fill out forms to track their time and notify their superiors of their flow state activities, otherwise there would be more meetings about the current flow state reports not being filed correctly and that programmers were spending too much time “zoning out” instead of being in flow.
 
Thus, programmers would spent 7–8 hours a day pretending to be in flow state, reporting on their progress, and getting all their work done in 30 minutes of accidental flow state somewhere in the middle of all that flow state reporting.
 
If you think I’m joking about this, I’m not. I promise you this is what would happen to any company of more than 2 employees. (Even the ones run by programmers.)
 
Number Three - It Will Cost 10x What You Think
 
Being a programmer, I get a lot of non-programmers telling me about their brilliant app ideas. Usually they want me to build something for free and are so generous as to pay me up to 5% of the profits for doing 100% of the work.
 
Their ideas are just that good.
 
Now, I gently tell them that I’m not interested in building anything for free.
 
At that point they get angry, but a few ask how much it will cost. I give them a reasonable (and very incorrect) estimate of what it would cost to create the incredibly simple version of their app idea.
 
Let’s say it’s some number like $25,000.
 
They look at me like I’m a lunatic, and so I explain how much it costs to hire a contract programmer and how long it will actually take. For example’s sake let’s say it is $100/hr for 250 hours.
 
To be clear, these are made up numbers and bad estimates (See Number One for details…)
 
In actuality, to build the actual thing they want might cost $250,000, or even $2,500,000 when it’s all said and done.
 
Building software can be incredibly complex and expensive. What most people can’t wrap their head around is the fact that a company like Google, Apple, or Microsoft has spent BILLIONS of dollars to create something that looks so simple to the end user.
 
Somehow, the assumption is that something that looks simple is cheap and fast to build.
 
Building something simple and easy for the end user is time consuming and expensive. Most people just can’t do it.
 
So, the average person with a brilliant app idea thinks it will cost a few hundred or maybe a few thousand dollars to make and it will be done in a weekend is so off the mark it’s not worth considering their ideas.
 
And programmers are too eager to play along with these bad ideas (by making bad estimates and under charging for their time) that this notion is perpetuated to the average non-programmer.
 
So, a good rule of thumb is that software will cost 10 times as much as you think and take 10 times as long to finish.
 
And that leads to a bonus point…
 
BONUS - Software Is Never Done
 
Programmers never complete a software project, they only stop working on it. Software is never done.
 
I’ve worked at many software companies and I’ve never seen a software project “completed”.
 
Sure, software gets released and used. But, it is always changing, being updated, bugs get fixed, and there are always new customer requests for features.
 
Look at your favorite software and you’ll quickly realize how true this is. Facebook, Instagram, Google Search, Google Maps, GMail, iOS, Android, Windows, and now even most video games are never done.
 
There are small armies of developers just trying to keep all the software you use every day stable and bug free. Add on the fact that there are always feature requests, small changes, and new platforms to deal with, it’s a treadmill.
 
So, the only way out of the game is to stop working on software. At that point, the software begins to decay until it is no longer secure or supported.
 
Think about old Windows 3.1 software or maybe old Nintendo Cartridge video games. The current computers and video game consoles don’t even attempt to run that software anymore.
 
You can’t put an old video game in your new Nintendo Switch and have it “just work”. That is what happens when you think software is done.
 
When programmers stop working on software the software starts to die. The code itself is probably fine, but all the other software keeps moving forward until your software is no longer compatible with the current technology.
 
So, those are the four most important things that non-programmers should know about programming. I know you asked for only three, so I hope the bonus was valuable to you as well.

I’ll get straight to the point.  Why should companies invest more in management training?  Here are 10 simple reasons.

1) An employee’s relationship with his or her direct manager is the most important single factor in employee engagement.

2) Engaged employees are happier and more productive.  Disengaged employees are frustrated and more disruptive.

3) Because there’s no widely agreed-on skillset for management (good managers come in all shapes and sizes), there’s an assumption everyone knows how to do it.  This is akin to someone who’s never driven before being given keys to a car and told: “Drive.”  (Many many years ago, this is how I first learned to manage.  I blundered my way through it.  Trial and error.  It wasn’t pretty.)

Communication is one of the main objectives that an organization needs to have in place to stay efficient and productive. A breakdown in accurate and efficient communication between departments at any point in the organization can result in conflict or loss of business.  Sadly, the efficiency between different departments in an organization becomes most evident when communication breaks down. As an example, David Grossman reported in “The Cost of Poor Communications” that a survey of 400 companies with 100,000 employees each cited an average loss per company of $62.4 million per year because of inadequate communication to and between employees.

With the dawning of the big-data era and the global competition that Machine Learning algorithms has sparked, it’s more vital than ever for companies of all sizes to prioritize departmental communication mishaps. Perhaps, today, as a result of the many emerging markets, the most essential of these connections are between IT and the business units. CMO’s and CIO’s are becoming natural partners in the sense that CMO’s, in order to capture revenue opportunities, are expected to master not just the art of strategy and creativity but also the science of analytics. The CIO, on the other hand, is accountable for using technical groundwork to enable and accelerate revenue growth. Since business and technology people speak very different languages, there’s a need on both sides to start sharing the vocabulary or understanding of what is expected in order to avoid gridlock.

In the McKinsey article, Getting the CMO and CIO to work as partners, the author speaks to five prerequisite steps that the CMO and the CIO can take in order to be successful in their new roles.

--- Be clear on decision governance
Teams should define when decisions are needed, what must be decided, and who is responsible for making them.

Due to the advancements in technology, teens and adults alike can now partake in virtual worlds thanks to video games. Video games are enjoyed as a hobby all over the globe, but some gamers have made it their career with help from the ever-growing e-sport community. This is an inside look at the professional level of gaming from an ex-MLG participant, and what I remember going through when starting to play video games at an elite level.

One of the premiere and most popular leagues within the United States happens to be Major League Gaming or MLG for short. This is a league that usually involves more of the most recent games out, and they create circuits for each major title and its subsequent releases. Two of the most major game circuits within the MLG league were the Halo series and the Call of Duty series, both which happened to be first person shooters (FPS). There were a potential hundred or so teams within each circuit, but much like other competitions, the circuits were ran with winner’s brackets and losers brackets. This means that out of all the teams that would show up to MLG events, about the top eight of each bracket would really be known as the "elite" players. I personally played in the Gears of War circuit at venues like MLG Raleigh and MLG Toronto, and we had very few teams compared to Call of Duty and Halo. The amount of participants at each event usually varies in each circuit based on the popularity of the game being played.

When you win tournaments, the payouts are split between the team members. This means that looking at playing in the MLG for a life career is an ill-advised move. The cost to get to events and buy team passes usually negates the prizes you win most of the time, considering by the time that the prize money is split you are left with about $800 in a popular circuit (Like Call of Duty). The payouts are usually only high in special and certain occasions, one for example being the million dollar showdown that Infinity Ward hosted for Call of Duty: Modern Warfare 3 a couple years back. The way that players that make professional gaming their career get the big money now is by being sponsored by the big companies that back the league like Red Bull and Hot Pockets. MLG players like "Walshy" and "FeaR Moho" were sponsored early on in the league and were able to make a living off of the games they played. I would imagine them getting around $60K in a good year off of sponsors alone. I would go even as far as to say that if you do not have a sponsor in e-sports, you will not be financially successful in the career.

Being an MLG gamer requires passion and understanding for the games. If you just want to make money, then you are better off working at McDonalds.

 

How to Keep a Start Up Team Motivated?

What People Should Know Before Getting Rid of Old Tech Stuff

Surprising Ways Viruses, Malware, Etc. are Infecting Computers

Tech Life in Ohio

Ulysses S. Grant, Rutherford B. Hayes, James A. Garfield, Benjamin Harrison, William McKinley, William H. Taft, and Warren G. Harding, were all U.S. Presidents born in Ohio. The first recognized university in Ohio was Ohio University founded in 1804. It wasn?t long until the first interracial and coeducational college in the United States, Oberlin, was founded in 1833. The Buckeye State produced some interesting discoveries such as: Charles Goodyear discovering the process of vulcanizing rubber in 1839; Roy J. Plunkett inventing Teflon in 1938; and Charles Kettering inventing the automobile self-starter in 1911.
Learning without thought is labor lost; thought without learning is perilous. Confucius
other Learning Options
Software developers near Mentor have ample opportunities to meet like minded techie individuals, collaborate and expend their career choices by participating in Meet-Up Groups. The following is a list of Technology Groups in the area.
Fortune 500 and 1000 companies in Ohio that offer opportunities for Microsoft SQL Server developers
Company Name City Industry Secondary Industry
Nationwide Insurance Company Columbus Financial Services Insurance and Risk Management
Owens Corning Toledo Manufacturing Concrete, Glass, and Building Materials
FirstEnergy Corp Akron Energy and Utilities Gas and Electric Utilities
The Lubrizol Corporation Wickliffe Manufacturing Chemicals and Petrochemicals
Sherwin-Williams Cleveland Retail Hardware and Building Material Dealers
Key Bank Cleveland Financial Services Banks
TravelCenters of America, Inc. Westlake Retail Gasoline Stations
Dana Holding Company Maumee Manufacturing Automobiles, Boats and Motor Vehicles
O-I (Owens Illinois), Inc. Perrysburg Manufacturing Concrete, Glass, and Building Materials
Big Lots Stores, Inc. Columbus Retail Department Stores
Limited Brands, Inc. Columbus Retail Clothing and Shoes Stores
Cardinal Health Dublin Healthcare, Pharmaceuticals and Biotech Healthcare, Pharmaceuticals, and Biotech Other
Progressive Corporation Cleveland Financial Services Insurance and Risk Management
Parker Hannifin Corporation Cleveland Manufacturing Manufacturing Other
American Financial Group, Inc. Cincinnati Financial Services Insurance and Risk Management
American Electric Power Company, Inc Columbus Energy and Utilities Gas and Electric Utilities
Fifth Third Bancorp Cincinnati Financial Services Banks
Macy's, Inc. Cincinnati Retail Department Stores
Goodyear Tire and Rubber Co. Akron Manufacturing Plastics and Rubber Manufacturing
The Kroger Co. Cincinnati Retail Grocery and Specialty Food Stores
Omnicare, Inc. Cincinnati Healthcare, Pharmaceuticals and Biotech Pharmaceuticals
The Procter and Gamble Company Cincinnati Consumer Services Personal Care

training details locations, tags and why hsg

A successful career as a software developer or other IT professional requires a solid understanding of software development processes, design patterns, enterprise application architectures, web services, security, networking and much more. The progression from novice to expert can be a daunting endeavor; this is especially true when traversing the learning curve without expert guidance. A common experience is that too much time and money is wasted on a career plan or application due to misinformation.

The Hartmann Software Group understands these issues and addresses them and others during any training engagement. Although no IT educational institution can guarantee career or application development success, HSG can get you closer to your goals at a far faster rate than self paced learning and, arguably, than the competition. Here are the reasons why we are so successful at teaching:

  • Learn from the experts.
    1. We have provided software development and other IT related training to many major corporations in Ohio since 2002.
    2. Our educators have years of consulting and training experience; moreover, we require each trainer to have cross-discipline expertise i.e. be Java and .NET experts so that you get a broad understanding of how industry wide experts work and think.
  • Discover tips and tricks about Microsoft SQL Server programming
  • Get your questions answered by easy to follow, organized Microsoft SQL Server experts
  • Get up to speed with vital Microsoft SQL Server programming tools
  • Save on travel expenses by learning right from your desk or home office. Enroll in an online instructor led class. Nearly all of our classes are offered in this way.
  • Prepare to hit the ground running for a new job or a new position
  • See the big picture and have the instructor fill in the gaps
  • We teach with sophisticated learning tools and provide excellent supporting course material
  • Books and course material are provided in advance
  • Get a book of your choice from the HSG Store as a gift from us when you register for a class
  • Gain a lot of practical skills in a short amount of time
  • We teach what we know…software
  • We care…
learn more
page tags
what brought you to visit us
Mentor, Ohio Microsoft SQL Server Training , Mentor, Ohio Microsoft SQL Server Training Classes, Mentor, Ohio Microsoft SQL Server Training Courses, Mentor, Ohio Microsoft SQL Server Training Course, Mentor, Ohio Microsoft SQL Server Training Seminar
training locations
Ohio cities where we offer Microsoft SQL Server Training Classes

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.