SQL Server Training Classes in Olympia, Washington

Learn SQL Server in Olympia, Washington 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 SQL Server related training offerings in Olympia, Washington: SQL Server Training

We offer private customized training for groups of 3 or more attendees.

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

The line between IT consulting and management consulting is quite often blurred, with overlaps between the two fields habitually happening. Worse still, most people do not understand who an IT consultant really is, or what he/she does. There are those who think the job entails fixing computers, others – selling computers and associated accessories. This is misleading though.

In a nutshell, IT consultants are professionals who aid businesses in deciding what computer tools and technologies are best placed to grow and sustain a profitable business. They work hand in hand with clients to help integrate IT systems into the latter’s business. They show clients how to use technology more efficiently, and in so doing, the client is able to get a higher return on their technology investments, and ultimately, increase the bottom-line.

IT consultants, or IT advisories, could work independently or for a consulting firm, with their clientele spread across all sorts of businesses and industries. Companies hire or contract the consulting firm to come in and analyze their IT systems and structure.

The job itself is not short of challenges, however, and the path to becoming a successful IT consultant is fraught with its fair share of ups and downs. But hey, which job isn’t? Experience is the best teacher they say, and only after you’ve worked as a consultant for a number of years will you finally gain invaluable understanding of what is expected of you. Learning from the experiences of those who’ve been in this business for long is a good starting point for those who decide to venture into the world of IT consultancy.

Passbook is one of the newest features of the iPhone. What many people were offput by standards today is that we rely too much on disposable tickets, and the like, such as when you go to the airport for a boarding pass, or a movie ticket. Apple strove to solve that with a new application that is bundled with the newest update: Passbook.

Passbook offers everything you need, especially when a ticket, coupon, or gift card is needed. When you first open the application you are greeted by a sampling of applications that support Passbook, and its features. To begin, install the particular application you want to use. For example, we will be going with the Starbucks application to satiate our coffee needs every morning, as we have a gift card to spend.

Open up the freshly downloaded application, and get ready to be blown away. Like most applications, especially when it has to do with airlines, or coffee, you are almost always required to sign up for a respective account. Don’t worry, it is easy. All you will be asked is to fill out your email, a password, and other miscellaneous information to identify you when you lose your password or others.

Once you have finished signing up, you’re ready to roll. It will prompt you to enter a gift card that you already own, or begin a digital gift card. If you don’t have a gift card, you can start a digital gift card (or, as many may call it: a prepaid card), and pay for your coffee in a fast, and efficient way. Just tap on “Tap to Pay” when you are ready to pay, and tap again after you have paid. It’s really that easy.

data dictionary workThe mainstay of a corporation is the data that it possesses. By data, I mean its customer base, information about the use of its products, employee roles and responsibilities, the development and maintenance of its product lines, demographics of supporters and naysayers, financial records, projected sales ... It is in the organization of this data that advancements to the bottom line are often realized i.e. the nuggets of gold are found. Defining what is important, properly cataloging the information, developing a comprehensive protocol to access and update this information and discerning how this data fits into the corporate venacular is basis of this data organization and may be the difference between moving ahead of the competition or being the one to fall behind.

Whenever we attempt to develop an Enterprise Rule Application, we must begin by harvesting the data upon which those rules are built. This is by no means an easy feat as it requires a thorough understanding of the business, industry, the players and their respective roles and the intent of the application. Depending upon the scope of this undertaking, it is almost always safe to say that no one individual is completely knowledgeable to all facets needed to comprise the entire application.data dictionary

The intial stage of this endeavor is, obviously, to decide upon the intent of the application. This requires knowledge of what is essential, what is an add-on and which of all these requirements/options can be successfully implemented in the allotted period of time. The importance of this stage cannot be stressed enough; if the vision/goal cannot be articulated in a manner that all can understand, the knowledge tap will be opened to become the money drain. Different departments may compete for the same financial resources; management may be jockeying for their day in the sun; consulting corporations, eager to win the bid, may exaggerate their level of competency. These types of endeavors require those special skills of an individual or a team of very competent members to be/have a software architect, subject matter expert and business analyst.

Once the decision has been made and the application development stages have been defined, the next step is to determine which software development tools to employ. For the sake of this article, we will assume that the team has chosen an object oriented language such as Java and a variety of J EE components, a relationsional database and a vendor specific BRMS such as Blaze Advisor. Now, onto the point of this article.

On March 6 of this year, Microsoft's .NET Foundation released its third preview release of .NET Core 3 — which is its free and open-source framework for developing apps on Windows, MacOS and Linux — with an official release scheduled for later this year. This release brings a wealth of new features and enhancements. This includes the following: 
 
1. Windows Desktop Support
 
One of the biggest additions to version 3.0 of the framework is the ability to develop Windows desktop applications. The new Windows Desktop component lets you build applications using either the Windows Presentation Foundation (WPF) graphical subsystem or the Windows Forms graphical class library. You can also use Windows UI XAML Library (WinUI) controls in your applications. 
 
The Windows Desktop component is only supported and included on Windows installs. 
 
2. Support for C# 8
 
The new framework has support for C# 8, which includes not only the ability to create asynchronous steams but features such as: 
 
Index and Range data types
Using declarations
Switch expressions
 
The Index and Range data types make array manipulation easier, while Using declarations ensure that your objects get disposed once they are out of scope. Finally, Switch expressions extend Switch statements by allowing you to return a value. 
 
3. IEEE Floating-Point Improvements
 
The new framework includes floating point APIs that comply with IEEE 754-2008. This includes fixes to both formatting and parsing as well as new Math APIs such as: 
 
BitIncrement/BitDecrement
MaxMagnitude/MinMagnitude
ILogB
ScaleB
Log2
FusedMultiplyAdd
CopySign
 
4. Support for Performance-Oriented CPU Instructions
 
The new framework includes support for both SIMD and Bit Manipulation instruction sets, which can create significant performance boosts in certain situations, such as when you are processing data in parallel. 
 
5. Default Executables
 
With the new framework, you can now produce framework-dependent executables by default without having to use self-contained deployments. 
 
6. Local dotnet Tools
 
In the previous version of the framework, there was support for global dotnet tools. But the current version adds support for local tools as well. These tools are associated with a specific disk location, and this allows you to enable per-repository and per-project tooling. 
 
7. Support for MSIX Deployments
 
The new framework supports MSIX, which is a Windows app package format that you can use when deploying Windows desktop applications. 
 
8. Built-In and Fast JSON Support
 
In prior versions of the framework, you had to use Json.NET if you wanted JSON support in your application. The framework, though, now has built-in support that is not only fast but also has low allocation requirements. It also adds 3 new JSON types, which include: 
 
Utf8JsonReader
Utf8JsonWriter
JsonDocument
 
9. Cryptography Support
 
The new framework supports AES-GCM and AES-CCM ciphers. It also supports the importing and exporting of asymmetric public and private keys from a variety of formats without the need of an X.509 certificate. 
 
Platform Support
 
.NET Core 3 supports the following operating systems: 
 
Alpine: 3.8+
Debian: 9+
Fedora: 26+
macOS: 10.12+
openSUSE: 42.3+
RHEL: 6+
SLES: 12+
Ubuntu: 16.04+
Windows Clients: 7, 8.1, 10 (1607+)
Windows Servers: 2012 R2 SP1+
 
The framework further supports the following chips: 
 
x64 (Windows, macOS and Linux)
x86 (Windows)
ARM32 (Windows and Linux)
ARM64 (Linux)
 Jump to top
 

Tech Life in Washington

Not only is Washington a major player in the manufacturing industries such as aircraft and missiles, shipbuilding, lumber, food processing, metals and metal products, chemicals, and machinery, it’s the home of Microsoft Corporation and Bill Gates, chairman and former CEO of Microsoft. Other Washington state billionaires include Paul Allen (Microsoft), Steve Ballmer (Microsoft), Jeff Bezos (Amazon), Craig McCaw (McCaw Cellular Communications), James Jannard (Oakley), Howard Schultz (Starbucks), and Charles Simonyi (Microsoft).
The funny thing is, if you give two programmers the same problem-- it depends on the problem, but problems of a more mathematical nature, they can often end up writing the same code... Are we creating these things or are we just pulling the cobwebs off? Joe Armstrong - From the book: Coders at Work.
other Learning Options
Software developers near Olympia 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 Washington that offer opportunities for SQL Server developers
Company Name City Industry Secondary Industry
Symetra Financial Corporation Bellevue Financial Services Insurance and Risk Management
Alaska Air Group, Inc. Seattle Travel, Recreation and Leisure Passenger Airlines
Expedia, Inc. Bellevue Travel, Recreation and Leisure Travel Agents & Services
Itron, Inc. Liberty Lake Computers and Electronics Instruments and Controls
PACCAR Inc. Bellevue Manufacturing Automobiles, Boats and Motor Vehicles
Puget Sound Energy Inc Bellevue Energy and Utilities Gas and Electric Utilities
Expeditors International of Washington, Inc. Seattle Transportation and Storage Freight Hauling (Rail and Truck)
Costco Wholesale Corporation Issaquah Retail Grocery and Specialty Food Stores
Starbucks Corporation Seattle Retail Restaurants and Bars
Nordstrom, Inc. Seattle Retail Department Stores
Weyerhaeuser Company Federal Way Manufacturing Paper and Paper Products
Microsoft Corporation Redmond Software and Internet Software
Amazon.com, Inc. Seattle Retail Sporting Goods, Hobby, Book, and Music Stores

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 Washington 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 SQL Server programming
  • Get your questions answered by easy to follow, organized SQL Server experts
  • Get up to speed with vital 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
Olympia, Washington SQL Server Training , Olympia, Washington SQL Server Training Classes, Olympia, Washington SQL Server Training Courses, Olympia, Washington SQL Server Training Course, Olympia, Washington SQL Server Training Seminar

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