Microsoft SQL Server Training Classes in Royal Oak, Michigan
Learn Microsoft SQL Server in Royal Oak, Michigan 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 Royal Oak, Michigan: Microsoft SQL Server Training
Microsoft SQL Server Training Catalog
Course Directory [training on all levels]
- .NET Classes
- Agile/Scrum Classes
- AI Classes
- Ajax Classes
- Android and iPhone Programming Classes
- Azure Classes
- Blaze Advisor Classes
- C Programming Classes
- C# Programming Classes
- C++ Programming Classes
- Cisco Classes
- Cloud Classes
- CompTIA Classes
- Crystal Reports Classes
- Data Classes
- Design Patterns Classes
- DevOps Classes
- Foundations of Web Design & Web Authoring Classes
- Git, Jira, Wicket, Gradle, Tableau Classes
- IBM Classes
- Java Programming Classes
- JBoss Administration Classes
- JUnit, TDD, CPTC, Web Penetration Classes
- Linux Unix Classes
- Machine Learning Classes
- Microsoft Classes
- Microsoft Development Classes
- Microsoft SQL Server Classes
- Microsoft Team Foundation Server Classes
- Microsoft Windows Server Classes
- Oracle, MySQL, Cassandra, Hadoop Database Classes
- Perl Programming Classes
- Python Programming Classes
- Ruby Programming Classes
- SAS Classes
- Security Classes
- SharePoint Classes
- SOA Classes
- Tcl, Awk, Bash, Shell Classes
- UML Classes
- VMWare Classes
- Web Development Classes
- Web Services Classes
- Weblogic Administration Classes
- XML Classes
- RED HAT ENTERPRISE LINUX SYSTEMS ADMIN II
8 December, 2025 - 11 December, 2025 - Python for Scientists
8 December, 2025 - 12 December, 2025 - Introduction to Spring 6, Spring Boot 3, and Spring REST
15 December, 2025 - 19 December, 2025 - Fast Track to Java 17 and OO Development
8 December, 2025 - 12 December, 2025 - See our complete public course listing
Blog Entries publications that: entertain, make you think, offer insight
A career in the field of software development remains immensely popular due to various factors. Chief among them of course is the higher compensation and lucrative pay scale in the IT industry when compared to other career options. In addition, the flexibility of work hours and the sheer sense of achievement experienced by one while creating new programs are unsurpassed by any other job.
Popularity and reach of Software Programs
Software programming has become a quintessential part of our day to day life, right from the smartphones in your pocket, to video gaming, and everything in between. The opportunities in this field are truly astounding. The niches for specializing are also diverse, from creating operating systems, to mobile app development, or web app development to name a few.
There are various ways in which you can distinguish yourself in the market for the much coveted title of software programmer. Here, we focus on some of them.
Millions of people experienced the frustration and failures of the Obamacare website when it first launched. Because the code for the back end is not open source, the exact technicalities of the initial failings are tricky to determine. Many curious programmers and web designers have had time to examine the open source coding on the front end, however, leading to reasonable conclusions about the nature of the overall difficulties.
Lack of End to End Collaboration
The website was developed with multiple contractors for the front-end and back-end functions. The site also needed to be integrated with insurance companies, IRS servers, Homeland Security servers, and the Department of Veterans Affairs, all of whom had their own legacy systems. The large number of parties involved and the complex nature of the various components naturally complicated the testing and integration of each portion of the project.
The errors displayed, and occasionally the lack thereof, indicated an absence of coordination between the parties developing the separate components. A failed sign up attempt, for instance, often resulted in a page that displayed the header but had no content or failure message. A look at end user requests revealed that the database was unavailable. Clearly, the coding for the front end did not include errors for failures on the back end.
Bloat and the Abundance of Minor Issues
Obviously, numerous bugs were also an issue. The system required users to create passwords that included numbers, for example, but failed to disclose that on the form and in subsequent failure messages, leaving users baffled. In another issue, one of the pages intended to ask users to please wait or call instead, but the message and the phone information were accidentally commented out in the code.
While the front-end design has been cleared of blame for the most serious failures, bloat in the code did contribute to the early difficulties users experienced. The site design was heavy with Javascript and CSS files, and it was peppered with small coding errors that became particularly troublesome when users faced bottlenecks in traffic. Frequent typos throughout the code proved to be an additional embarrassment and were another indication of a troubled development process.
NoSQL Database
The NoSQL database is intended to allow for scalability and flexibility in the architecture of projects that will use it. This made NoSQL a logical choice for the health insurance exchange website. The newness of the technology, however, means personnel with expertise can be elusive. Database-related missteps were more likely the result of a lack of experienced administrators than with the technology itself. The choice of the NoSQL database was thus another complication in the development, but did not itself cause the failures.
Another factor of consequence is that the website was built with both agile and waterfall methodology elements. With agile methods for the front end and the waterfall methodology for the back end, streamlining was naturally going to suffer further difficulties. The disparate contractors, varied methods of software development, and an unrealistically short project time line all contributed to the coding failures of the website.
When you think about the black market, I’m sure the majority of you will think of prohibition days. When alcohol was made illegal, it did two things: It made the bad guys more money, and it put the average joe in a dangerous position while trying to acquire it. Bring in the 21stcentury. Sure, there still is a black market… but come on, who is afraid of mobsters anymore? Today, we have a gaming black market. It has been around for years, but will it survive? With more and more games moving towards auction houses, could game companies “tame” the gaming black market?
In the old days of gaming on the internet, we spent most of our online time playing hearts, spades… whatever we could do while connected to the internet. As the years went by, better and better games came about. Then, suddenly, interactive multiplayer games came into the picture. These interactive games, mainly MMORPGS, allowed for characters to pick up and keep randomly generated objects known as “loot”. This evolution of gaming created the black market.
In the eyes of the software companies, the game is only being leased/rented by the end user. You don’t actually have any rights to the game. This is where the market becomes black. The software companies don’t want you making money of “virtual” goods that are housed on the software or servers of the game you are playing on. The software companies, at this point, started to get smarter.
Where there is a demand…
I suspect that many of you are familiar with the term "hard coding a value" whereby the age of an individual or their location is written into the condition (or action) of a business rule (in this case) as shown below:
if customer.age > 21 and customer.city == 'denver'
then ...
Such coding practices are perfectly expectable provided that the conditional values, age and city, never change. They become entirely unacceptable if a need for different values could be anticipated. A classic example of where this practice occurred that caused considerable heartache in the IT industry was the Y2K issue where dates were updated using only the last 2 digits of a four digit number because the first 2 digits were hard-coded to 19 i.e. 1998, 1999. All was well provided that the date did not advance to a time beyond the 1900’s since no one could be certain of what would happen when the millennia arrived (2000). A considerably amount of work (albeit boring) and money, approximately $200 billion, went into revising systems by way of software rewrites and computer chip replacements in order to thwart any detrimental outcomes. It is obvious how a simple change or an assumption can have sweeping consequences.
You may wonder what Y2K has to do with Business Rule Management Systems (BRMS). Well, what if we considered rules themselves to be hard-coded. If we were to write 100s of rules in Java, .NET or whatever language that only worked for a given scenario or assumption, would that not constitute hard-coded logic? By hard-coded, we obviously mean compiled. For example, if a credit card company has a variety of bonus campaigns, each with their own unique list of rules that may change within a week’s time, what would be the most effective way of writing software to deal with these responsibilities?
Tech Life in Michigan
| 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 |
training details locations, tags and why hsg
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.
- We have provided software development and other IT related training to many major corporations in Michigan since 2002.
- 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…














