Microsoft SQL Server Training Classes in Lansing, Michigan

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

Get pricing information (3 or more students may receive a discount)
Contact us to discuss our pricing structure for groups of 3 or more attendees.
Lansing  Upcoming Instructor Led Online and Public Microsoft SQL Server Training Classes
20778: Analyzing Data With Power BI 11 March, 2019 - 13 March, 2019 $1190 Hartmann Software Group Training Registration
55232: Writing Analytical Queries for Business Intelligence 28 January, 2019 - 30 January, 2019 $1290 Hartmann Software Group Training Registration
20779: Analyzing Data With Excel 11 February, 2019 - 13 February, 2019 $1090 Hartmann Software Group Training Registration

Microsoft SQL Server Training Catalog

Course Directory [training on all levels]

Upcoming Classes

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

As someone who works in many facets of the music industry, I used to seethe with a mixture of anger and jealousy when I would hear people in more “traditional” goods-based industries argue in favor of music content-based piracy. They made all the classic talking points, like “I wouldn’t spend money on this artist normally, and maybe if I like it I’ll spend money on them when they come to town” (which never happened), or “artists are rich and I’m poor, they don’t need my money” (rarely the case), or the worst, “if it were fairly priced and worth paying for, I’d buy it” (not true).  I always wondered if they’d have the same attitude if 63% of the things acquired by customers in their industries weren’t actually paid for, as was conservatively estimated as the case for the music industry in 2009 (other estimations put the figure of pirated music at 95%). Well, we may soon see the answer to curiosities like that. Though one can say with tentative confidence that music piracy is on the decline thanks to services like Spotify and Rdio, it could be looming on the horizon for the entire global, physical supply chain. Yes, I’m talking about 3d printers.

Before I get into the heart of this article, let me take a moment to make one thing clear: I think these machines are incredible. It’s damn near inspiring to think of even a few of their potentially world-changing applications: affordable, perfectly fit prosthetic limbs for wounded servicemen and women; the ability to create a piece of machinery on the spot instead of having to wait for a spare to arrive in the mail, or en route if your car or ship breaks down in a far away place; a company based out of Austin, TX even made a fully functioning firearm from a 3d printer a few months ago.

If these machines become as consumer-friendly and idiot-proof as possible (like computers), it’s possible that in a matter of decades (maybe less), a majority of U.S. households will have their own 3d printer. There’s also the possibility they could take the tech-hobbyist path, one that is much less appealing to the masses. Dale Dougherty of Makezine.com estimates there are currently around 100,000 “personal” 3d printers, or those not owned for business or educational purposes. I don’t think they’ll ever be as ubiquitous as computers, but there are plenty of mechanically inclined, crafty hobbyists out there who would love to play around with a 3d printer if it was affordable enough.

That being said, is there reason to worry about the economic implications of consumers making what they want, essentially for free, instead of paying someone else to produce it? Or will the printers instead be used for unique items more so than replicating and ripping off other companies’ merchandise in mass amounts? The number of people working in industries that would be affected by a development like this is far greater than the number of people who work in content-based industries, so any downturn would probably have a much larger economic implications. Certainly, those times are a ways off, but a little foresightedness never hurt anyone!

There are a lot of articles you will find on the internet that talk about the tenants of having a successful professional career. From soft-skills to job relevant skills, there is an unending list of the do’s and don’ts for establishing a great career. However, a successful career in information technology commands some specific efforts and focus. As a result, it is critical to focus on these 4 key tenants that can help you establish a promising and successful career in Information Technology.

·         Be Multi-lingual– This is the analogy of Steve Job’s famous quote ‘Stay Hungry, Stay Foolish’ as it applies to Information Technology. Gone are the days when you could train yourself on a specific programming language say Java or C++ and code your way to a successful career. The best programmers of today and tomorrow are pushing the limits and becoming experts in one of more languages. Knowing more than one programming language instantly makes you more employable since you can add value to multiple projects that require different languages. If you need proof, IT professionals knowing more than one language can attract a salary premium of £10,000 . Additionally, there is no telling how dynamic technology is and by being open to constantly learning new languages you will position yourself to get technology jobs that did not exist a few years ago

·         Go Beyond the ‘How’, Focus On ‘Why’: A common theme with most information technology professionals is their ability to figure out the HOW or, in other words, applying their technical know-how in achieving the solution to a problem. This is especially true when you are working for a service based IT organization where your key job is to develop a solution for the client’s business problem. Yes, you are and will get paid to be good at the ‘How’ but to advance a career in IT; it will help you immensely to also start focussing on the ‘Why’. This stems from a famous quote by Einsten “If I were given one hour to save the planet, I would spend 59 minutes defining the problem and one minute resolving it”. In essence, spend time in understanding ‘Why’ are your trying to solve the problem before you get down with figuring out the ‘How’ part. The reasons for developing this mindset are two-fold. One, you will instantly distinguish yourself from thousands of other IT peers who are content with the ‘How’ part. Two, there is a good chance that you want to get ahead in your career not only as a programmer but as a system architect or a business solution consultant. This is where the habit of asking the right questions pertaining to why a certain IT solution is requires will help you build the right solution.

·         Focus on the impact and results (Financial impact):This may not apply to IT professionals who are early in their careers but is paramount for senior IT professionals. For the most part, IT departments are required to make sure that the systems and the solutions function as desired and help the business run efficiently. In other words, the key metric for success for most IT professionals is being extremely good at technology, languages and Quality Assurance. However, the times are changing! No longer is the Chief Information Officer (CIO) in charge of making IT decisions. With organizations closely guarding the ROI of their investment in technology, CIOs are increasingly required to be cognizant of the financial benefits of technology so that they can justify the spending on IT. No wonder than that CFOs are increasingly pressurizing CIOs to get their act together

Technology is wonderful. It helps us run our businesses and connects us to the world. But when computer problems get in the way of getting what you need to get done, you can go from easygoing to mad-as-a-hornet in 3 seconds flat. Before you panic or give in to the temptation to throw your computer out the window, try these easy fixes.

5 Common Computer Problems

  1. Sluggish PC

A sluggish PC often means low disk space caused by an accumulation of temporary Internet files, photos, music, and downloads. One of the easiest fixes for a slow PC is to clear your cache.

The way you’ll do this will depend on the Internet browser you use:

  • Chrome– On the top right-hand side of the screen, you’ll see what looks like a window blind. Click on that. Click on ‘History’ and hit ‘Clear Browsing Data’.
  • Safari– On the upper left-hand side, you’ll see a tab marked ‘Safari’. Click on that. Scroll down and hit ‘Empty Cache’.
  • Internet Explorer– Click on ‘Tools’ and scroll down to ‘Internet Options’. Under ‘Browsing History’ click ‘Delete’. Delete files and cookies.
  • FireFox – At the top of the window click ‘Tools’ then go to ‘Options’. Select the ‘Advanced’ panel and click on the ‘Network’ tab. Go to ‘Cached Web Content’ and hit ‘Clear Now’.

A business rule is the basic unit of rule processing in a Business Rule Management System (BRMS) and, as such, requires a fundamental understanding. Rules consist of a set of actions and a set of conditions whereby actions are the consequences of each condition statement being satisfied or true. With rare exception, conditions test the property values of objects taken from an object model which itself is gleaned from a Data Dictionary and UML diagrams. See my article on Data Dictionaries for a better understanding on this subject matter.

A simple rule takes the form:

if condition(s)

then actions.

An alternative form includes an else statement where alternate actions are executed in the event that the conditions in the if statement are not satisfied:

if condition(s)

then actions

else alternate_actions

It is not considered a best prectice to write rules via nested if-then-else statements as they tend to be difficult to understand, hard to maintain and even harder to extend as the depth of these statements increases; in other words, adding if statements within a then clause makes it especially hard to determine which if statement was executed when looking at a bucket of rules. Moreoever, how can we determine whether the if or the else statement was satisfied without having to read the rule itself. Rules such as these are often organized into simple rule statements and provided with a name so that when reviewing rule execution logs one can determine which rule fired and not worry about whether the if or else statement was satisfied. Another limitation of this type of rule processing is that it does not take full advantage of rule inferencing and may have a negative performance impact on the Rete engine execution. Take a class with HSG and find out why.

Rule Conditions

Tech Life in Michigan

Home of the Ford Motor Company and many other Fortune 500 and Fortune 1000 Companies, Michigan has a list of famous people that have made their mark on society. Famous Michiganians: Francis Ford Coppola film director; Henry Ford industrialist, Earvin Magic Johnson basketball player; Charles A. Lindbergh aviator; Madonna singer; Stevie Wonder singer; John T. Parsons inventor and William R. Hewlett inventor.
It is your attitude, not your aptitude that determines your altitude. Zig Ziglar
other Learning Options
Software developers near Lansing 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 Michigan that offer opportunities for Microsoft SQL Server developers
Company Name City Industry Secondary Industry
Lear Corporation Southfield Manufacturing Automobiles, Boats and Motor Vehicles
TRW Automotive Holdings Corp. Livonia Manufacturing Automobiles, Boats and Motor Vehicles
Spartan Stores, Inc. Byron Center Retail Grocery and Specialty Food Stores
Steelcase Inc. Grand Rapids Manufacturing Furniture Manufacturing
Valassis Communications, Inc. Livonia Business Services Advertising, Marketing and PR
Autoliv, Inc. Auburn Hills Manufacturing Automobiles, Boats and Motor Vehicles
Cooper-Standard Automotive Group Novi Manufacturing Automobiles, Boats and Motor Vehicles
Penske Automotive Group, Inc. Bloomfield Hills Retail Automobile Dealers
Con-Way Inc. Ann Arbor Transportation and Storage Freight Hauling (Rail and Truck)
Meritor, Inc. Troy Manufacturing Automobiles, Boats and Motor Vehicles
Visteon Corporation Van Buren Twp Manufacturing Automobiles, Boats and Motor Vehicles
Affinia Group, Inc. Ann Arbor Manufacturing Automobiles, Boats and Motor Vehicles
Perrigo Company Allegan Healthcare, Pharmaceuticals and Biotech Pharmaceuticals
BorgWarner Inc. Auburn Hills Manufacturing Automobiles, Boats and Motor Vehicles
Auto-Owners Insurance Lansing Financial Services Insurance and Risk Management
DTE Energy Company Detroit Energy and Utilities Gas and Electric Utilities
Whirlpool Corporation Benton Harbor Manufacturing Tools, Hardware and Light Machinery
Herman Miller, Inc. Zeeland Manufacturing Furniture Manufacturing
Universal Forest Products Grand Rapids Manufacturing Furniture Manufacturing
Masco Corporation Inc. Taylor Manufacturing Concrete, Glass, and Building Materials
PULTEGROUP, INC. Bloomfield Hills Real Estate and Construction Real Estate & Construction Other
CMS Energy Corporation Jackson Energy and Utilities Energy and Utilities Other
Stryker Corporation Portage Healthcare, Pharmaceuticals and Biotech Medical Devices
General Motors Company (GM) Detroit Manufacturing Automobiles, Boats and Motor Vehicles
Kellogg Company Battle Creek Manufacturing Food and Dairy Product Manufacturing and Packaging
The Dow Chemical Company Midland Manufacturing Chemicals and Petrochemicals
Kelly Services, Inc. Troy Business Services HR and Recruiting Services
Ford Motor Company Dearborn Manufacturing Automobiles, Boats and Motor Vehicles

the hsg library depth in learning

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 Michigan 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
Lansing, Michigan Microsoft SQL Server Training , Lansing, Michigan Microsoft SQL Server Training Classes, Lansing, Michigan Microsoft SQL Server Training Courses, Lansing, Michigan Microsoft SQL Server Training Course, Lansing, Michigan Microsoft SQL Server Training Seminar