HARTMANN software group

SQL Server Training Classes in Clearwater, Florida

Learn SQL Server in Clearwater, Florida 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 Clearwater, Florida: SQL Server Training

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

SQL Server Training Catalog

10985: Introduction to SQL Databases Class
cost: $ 1290length: 3 day(s)
10989: Analyzing Data with Power BI Class
cost: $ 890length: 2 day(s)
20761: Querying Data with Transact-SQL Class
cost: $ 2090length: 5 day(s)
20762: Developing SQL Databases Class
cost: $ 2090length: 4 day(s)
20765: Provisioning SQL Databases Class
cost: $ 2090length: 5 day(s)
20767: Implementing a SQL Data Warehouse Class
cost: $ 2190length: 5 day(s)
20768: Developing SQL Data Models Class
cost: $ 1290length: 3 day(s)

Course Directory [training on all levels]

Technical Training Courses
Software engineer/architect, System Admin ... Welcome!
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
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 Advantages of Python Over Ruby?
[Apr, 03, 2014]    |
   Tags:

Python and Ruby, each with roots going back into the 1990s, are two of the most popular interpreted programming languages today. Ruby is most widely known as the language in which the ubiquitous Ruby on Rails web application framework is written, but it also has legions of fans that use it for things that have nothing to do with the web. Python is a big hit in the numerical and scientific computing communities at the present time, rapidly displacing such longtime stalwarts as R when it comes to these applications. It too, however, is also put to a myriad of other uses, and the two languages probably vie for the title when it comes to how flexible their users find them.

A Matter of Personality...


That isn't to say that there aren't some major, immediately noticeable, differences between the two programming tongues. Ruby is famous for its flexibility and eagerness to please; it is seen by many as a cleaned-up continuation of Perl's "Do What I Mean" philosophy, whereby the interpreter does its best to figure out the meaning of evening non-canonical syntactic constructs. In fact, the language's creator, Yukihiro Matsumoto, chose his brainchild's name in homage to that earlier language's gemstone-inspired moniker.

Python, on the other hand, takes a very different tact. In a famous Python Enhancement Proposal called "The Zen of Python," longtime Pythonista Tim Peters declared it to be preferable that there should only be a single obvious way to do anything. Python enthusiasts and programmers, then, generally prize unanimity of style over syntactic flexibility compared to those who choose Ruby, and this shows in the code they create. Even Python's whitespace-sensitive parsing has a feel of lending clarity through syntactical enforcement that is very much at odds with the much fuzzier style of typical Ruby code.

For example, Python's much-admired list comprehension feature serves as the most obvious way to build up certain kinds of lists according to initial conditions:

a = [x**3 for x in range(10,20)]
b = [y for y in a if y % 2 == 0]

first builds up a list of the cubes of all of the numbers between 10 and 19 (yes, 19), assigning the result to 'a'. A second list of those elements in 'a' which are even is then stored in 'b'. One natural way to do this in Ruby is probably:

a = (10..19).map {|x| x ** 3}
b = a.select {|y| y.even?}

but there are a number of obvious alternatives, such as:

a = (10..19).collect do |x|
x ** 3
end

b = a.find_all do |y|
y % 2 == 0
end

It tends to be a little easier to come up with equally viable, but syntactically distinct, solutions in Ruby compared to Python, even for relatively simple tasks like the above. That is not to say that Ruby is a messy language, either; it is merely that it is somewhat freer and more forgiving than Python is, and many consider Python's relative purity in this regard a real advantage when it comes to writing clear, easily understandable code.

And Somewhat One of Performance

What are the different versions of linux, and how do they compare?
[Jul, 22, 2012]    |
   Tags:

Attempting to create an intelligent entry about Linux for such a wide ranging audience is a bit like trying to compare a presentation on quantum mechanics for physicists while being readable by somebody with a junior high school education.

If you are a *NIX expert, then I suggest you keep on reading so you know how to explain this world to mere mortals.

I called it *nix for a reason. It represents a family of thinking. It is not unlike the difference between the language C and C++. Are there differences between the two? Certainly. And it is not like the difference between COBOL and C.

Years ago when I ran my own vo-tech school I would teach the students there are only two things in life. MS and *NIX. A friend of mine, a genius developer in her own right was aghast.

The Templatization of Business Rules
[Jul, 05, 2012]    |
   Tags:

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

IT Job Roles and Responsibilities Explained
[Apr, 30, 2019]    |
   Tags:

Let's face it, IT roles have evolved and are no longer meant for the IT department alone. Most departments tend to have a technical person that can help make sense of data. These days, businesses encourage data democratization, meaning that everyone in the business is responsible for the information that the organization receives. Departments no longer have to wait for data to pass through IT before they receive it. The departments get information as it comes. Then, they make decisions based on that data. 

IT Job Roles and Responsibilities

1. Project Manager

A project manager, in this case, is someone that plays a managerial role in a company’s project. In fact, this is one of the most important IT job roles. The manager is responsible for his or her team. He or she makes sure that deadlines are met, and the project proceeds as planned. It mainly includes planning, design, initiation, monitoring, execution, and control. 


2. IT Director

In most cases, the term director is associated with big positions in a company, and is often associated with a board role. As one of the top IT job roles, the IT director is responsible for planning, managing and executing the core-infrastructure of a company. The primary role of the IT director is to oversee all the technology operations within the firm. The director then evaluates what his or her team does to make sure that the activities are in line with firm’s main objectives. On top of that, the IT director makes sure that all departments have their technology needs met by his or her team. 

3. IT Manager

The rank of an IT manager is definitely lower than that of a director, however, the role is still very crucial for any IT department. Every IT department has staff members that are meant to deliver results at the end of the day. The IT manager supervises most of the workers in the IT department. He or she is in charge of motivating them and making sure that they do what they are supposed to do. The IT manager’s roles include monitoring, planning, coaching, disciplining employees, and counseling.

4. Software Engineer

This position can also be referred to as a software architect, system engineer or application programmer. The main work typically involves creating and programming system-level software such as database systems, operating systems, and embedded systems. Their primary role is to ensure that they understand how both software and hardware work and to use them appropriately. However, the responsibilities don’t stop there. The software engineer is also required to interact with both colleagues and clients to explain which system or solution is going to be more suitable for use. 

5. Systems Analyst

A systems analyst can also be called a solutions specialist, product specialist or a systems engineer. Their primary work mainly involves identifying, analyzing, and coming up with new information systems that will provide a viable solution. This is mostly done as a response to the requests of customers or just for the business. They also have to make sure that they determine the costs and total time required to bring the information systems into effect. 

6. Helpdesk Support

There are times when your team could encounter system problems. Perhaps, a piece of hardware or software has malfunctioned. You need helpdesk support to deal with such issues. This is a professional that knows about common computer problems. Without them, business operations could stall because an employee can be stranded, and there’s no one to help. 

7. Network Designer

As much as helpdesk support can solve most IT problems, there are other issues that they can’t solve. You may experience system shutdowns or slow internet. In that case, you need an expert in maintaining communication systems. These professionals will also be responsible for setting up cyber security systems for the organization. 


IT involves many job roles and responsibilities that all work hand-in-hand to deliver results. As you begin your business, you should know about these roles so that you can know which ones are going to be the most suitable for your firm. 

Tech Life in Florida

Software developers in Florida, have reasonably great opportunities for development positions in Fortune 1000 companies scattered throughout the state. In town and in reach, Floridians have access to corporate headquarters for Citrix Systems, Tech Data Corporation, the SFN Group, and the Harris Corporation just to name a few.
Wonder rather than doubt is the root of knowledge. ~ Abraham Joshua Heschel
other Learning Options
Software developers near Clearwater 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 Florida that offer opportunities for SQL Server developers
Company Name City Industry Secondary Industry
Lender Processing Services, Inc. (LPS) Jacksonville Software and Internet Data Analytics, Management and Storage
World Fuel Services Corporation Miami Energy and Utilities Gasoline and Oil Refineries
SEACOR Holdings Inc. Fort Lauderdale Transportation and Storage Marine and Inland Shipping
MasTec, Inc. Miami Business Services Security Services
Health Management Associates, Inc. Naples Healthcare, Pharmaceuticals and Biotech Hospitals
B/E Aerospace, Inc. Wellington Manufacturing Aerospace and Defense
Roper Industries, Inc. Sarasota Manufacturing Manufacturing Other
AutoNation Fort Lauderdale Retail Automobile Dealers
Watsco, Inc. Miami Wholesale and Distribution Wholesale and Distribution Other
SFN Group Fort Lauderdale Business Services HR and Recruiting Services
Tupperware Corporation Orlando Manufacturing Plastics and Rubber Manufacturing
AirTran Holdings, Inc. Orlando Travel, Recreation and Leisure Passenger Airlines
WellCare Health Plans, Inc. Tampa Healthcare, Pharmaceuticals and Biotech Healthcare, Pharmaceuticals, and Biotech Other
Lennar Corporation Miami Real Estate and Construction Real Estate Agents and Appraisers
HSN, Inc. Saint Petersburg Retail Retail Other
Certegy Saint Petersburg Business Services Business Services Other
Raymond James Financial, Inc. Saint Petersburg Financial Services Trust, Fiduciary, and Custody Activities
Winn-Dixie Stores, Inc. Jacksonville Retail Grocery and Specialty Food Stores
Jabil Circuit, Inc. Saint Petersburg Computers and Electronics Semiconductor and Microchip Manufacturing
CSX Corporation Jacksonville Transportation and Storage Freight Hauling (Rail and Truck)
Fidelity National Financial, Inc. Jacksonville Financial Services Insurance and Risk Management
Tech Data Corporation Clearwater Consumer Services Automotive Repair & Maintenance
TECO Energy, Inc. Tampa Manufacturing Chemicals and Petrochemicals
Lincare Holdings Inc Clearwater Healthcare, Pharmaceuticals and Biotech Medical Supplies and Equipment
Chico's FAS Inc. Fort Myers Retail Clothing and Shoes Stores
Burger King Corporation LLC Miami Retail Restaurants and Bars
Publix Super Markets, Inc. Lakeland Retail Grocery and Specialty Food Stores
Florida Power and Light Company Juno Beach Energy and Utilities Gas and Electric Utilities
Ryder System, Inc. Miami Transportation and Storage Freight Hauling (Rail and Truck)
Citrix Systems, Inc. Fort Lauderdale Software and Internet Software and Internet Other
Harris Corporation Melbourne Telecommunications Wireless and Mobile
Office Depot, Inc. Boca Raton Computers and Electronics Audio, Video and Photography
Landstar System, Inc. Jacksonville Transportation and Storage Freight Hauling (Rail and Truck)
Darden Restaurants, Inc. Orlando Retail Restaurants and Bars
PSS World Medical, Inc. Jacksonville Healthcare, Pharmaceuticals and Biotech Medical Supplies and Equipment

training details locations, tags and why hsg

the hartmann software group advantage
why take SQL Server Training with the hartmann software group?
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 Florida 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
Clearwater, Florida SQL Server Training , Clearwater, Florida SQL Server Training Classes, Clearwater, Florida SQL Server Training Courses, Clearwater, Florida SQL Server Training Course, Clearwater, Florida SQL Server Training Seminar
training locations
Florida cities where we offer SQL Server Training Classes

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