Microsoft SQL Server Training Classes in Milford, Connecticut

Learn Microsoft SQL Server in Milford, Connecticut 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 Milford, Connecticut: Microsoft SQL Server Training

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

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

The original article was posted by Michael Veksler on Quora

A very well known fact is that code is written once, but it is read many times. This means that a good developer, in any language, writes understandable code. Writing understandable code is not always easy, and takes practice. The difficult part, is that you read what you have just written and it makes perfect sense to you, but a year later you curse the idiot who wrote that code, without realizing it was you.

The best way to learn how to write readable code, is to collaborate with others. Other people will spot badly written code, faster than the author. There are plenty of open source projects, which you can start working on and learn from more experienced programmers.

Readability is a tricky thing, and involves several aspects:

  1. Never surprise the reader of your code, even if it will be you a year from now. For example, don’t call a function max() when sometimes it returns the minimum().
  2. Be consistent, and use the same conventions throughout your code. Not only the same naming conventions, and the same indentation, but also the same semantics. If, for example, most of your functions return a negative value for failure and a positive for success, then avoid writing functions that return false on failure.
  3. Write short functions, so that they fit your screen. I hate strict rules, since there are always exceptions, but from my experience you can almost always write functions short enough to fit your screen. Throughout my carrier I had only a few cases when writing short function was either impossible, or resulted in much worse code.
  4. Use descriptive names, unless this is one of those standard names, such as i or it in a loop. Don’t make the name too long, on one hand, but don’t make it cryptic on the other.
  5. Define function names by what they do, not by what they are used for or how they are implemented. If you name functions by what they do, then code will be much more readable, and much more reusable.
  6. Avoid global state as much as you can. Global variables, and sometimes attributes in an object, are difficult to reason about. It is difficult to understand why such global state changes, when it does, and requires a lot of debugging.
  7. As Donald Knuth wrote in one of his papers: “Early optimization is the root of all evil”. Meaning, write for readability first, optimize later.
  8. The opposite of the previous rule: if you have an alternative which has similar readability, but lower complexity, use it. Also, if you have a polynomial alternative to your exponential algorithm (when N > 10), you should use that.

Use standard library whenever it makes your code shorter; don’t implement everything yourself. External libraries are more problematic, and are both good and bad. With external libraries, such as boost, you can save a lot of work. You should really learn boost, with the added benefit that the c++ standard gets more and more form boost. The negative with boost is that it changes over time, and code that works today may break tomorrow. Also, if you try to combine a third-party library, which uses a specific version of boost, it may break with your current version of boost. This does not happen often, but it may.

Don’t blindly use C++ standard library without understanding what it does - learn it. You look at std::vector::push_back() documentation at it tells you that its complexity is O(1), amortized. What does that mean? How does it work? What are benefits and what are the costs? Same with std::map, and with std::unordered_map. Knowing the difference between these two maps, you’d know when to use each one of them.

Never call new or delete directly, use std::make_unique and [cost c++]std::make_shared[/code] instead. Try to implement usique_ptr, shared_ptr, weak_ptr yourself, in order to understand what they actually do. People do dumb things with these types, since they don’t understand what these pointers are.

Every time you look at a new class or function, in boost or in std, ask yourself “why is it done this way and not another?”. It will help you understand trade-offs in software development, and will help you use the right tool for your job. Don’t be afraid to peek into the source of boost and the std, and try to understand how it works. It will not be easy, at first, but you will learn a lot.

Know what complexity is, and how to calculate it. Avoid exponential and cubic complexity, unless you know your N is very low, and will always stay low.

Learn data-structures and algorithms, and know them. Many people think that it is simply a wasted time, since all data-structures are implemented in standard libraries, but this is not as simple as that. By understanding data-structures, you’d find it easier to pick the right library. Also, believe it or now, after 25 years since I learned data-structures, I still use this knowledge. Half a year ago I had to implemented a hash table, since I needed fast serialization capability which the available libraries did not provide. Now I am writing some sort of interval-btree, since using std::map, for the same purpose, turned up to be very very slow, and the performance bottleneck of my code.

Notice that you can’t just find interval-btree on Wikipedia, or stack-overflow. The closest thing you can find is Interval tree, but it has some performance drawbacks. So how can you implement an interval-btree, unless you know what a btree is and what an interval-tree is? I strongly suggest, again, that you learn and remember data-structures.

These are the most important things, which will make you a better programmer. The other things will follow.

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.)

Not getting any hits on your dating profile? It doesn’t mean you’re a loser. There are literally millions of computer dating profiles out there and dozens of free and paid websites to find a date. A dating profile is kind of like a resume for your personal life. To succeed, you have to learn a few tricks to stand out.

Tips to Improve Your Computer Dating Profile

1.  Make a Good First Impression

Filling out an online dating profile can be a daunting task. When you’re faced with all that blank space to write about yourself, it gets intimidating. The best way to improve your computer dating odds is to make a good first impression. Start with a good opening line such as a favorite quote or a personal motto you can easy build on.

As part of our Java Tutorials program, we will list a number of interview questions to aid in a better understaing of Java and J2EE and, hopefully, provide a greater likelihood of getting a job.  Let us begin with the basics:

1. What is meant by J2EE?

J2EE is an abreviation for Java 2 Platform Enterprise Edition

2.  What is the purpose of J2EE?

The purpose of J2EE is to provide a component based platform in a multitier application model with transaction management, web services and reusable component support.

3.  What is the tier structure of the typical J2EE application?

A typical J2EE application consists of the following tiers/machines:  the client machine (browser/non-browser application), the J2EE server (an application server such as Oracle, JBoss, GlassFish, Tomcat) and a database.

Tech Life in Connecticut

Software developers in Hartford, Fairfield, New Haven, Greenwich and New Britain are rich in Fortune 1000 companies such as the Xerox Corporation, CIGNA, Aetna, and United Technologies Corporation just to name a few. A fun fact: Hartford has the oldest U.S. newspaper still being published?the Hartford Courant, established 1764. Connecticut is also the insurance capital of the nation.
Teaching is only demonstrating that it is possible. Learning is making it possible for yourself. Paulo Coelho
other Learning Options
Software developers near Milford 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 Connecticut that offer opportunities for Microsoft SQL Server developers
Company Name City Industry Secondary Industry
Stanley Black and Decker, Inc. New Britain Manufacturing Tools, Hardware and Light Machinery
EMCOR Group, Inc. Norwalk Energy and Utilities Energy and Utilities Other
The Hartford Financial Services Group Inc. Hartford Financial Services Insurance and Risk Management
Crane Co. Stamford Manufacturing Tools, Hardware and Light Machinery
Cenveo. Inc. Stamford Business Services Business Services Other
Amphenol Corporation Wallingford Computers and Electronics Semiconductor and Microchip Manufacturing
W. R. Berkley Corporation Greenwich Financial Services Insurance and Risk Management
Silgan Holdings Inc. Stamford Manufacturing Manufacturing Other
Hubbell Incorporated Shelton Manufacturing Concrete, Glass, and Building Materials
IMS Health Incorporated Danbury Business Services Management Consulting
CIGNA Corporation Hartford Financial Services Insurance and Risk Management
Chemtura Corp. Middlebury Manufacturing Chemicals and Petrochemicals
Harman International Industries, Inc Stamford Computers and Electronics Audio, Video and Photography
United Rentals, Inc. Greenwich Real Estate and Construction Construction Equipment and Supplies
The Phoenix Companies, Inc. Hartford Financial Services Investment Banking and Venture Capital
Magellan Health Services, Inc. Avon Healthcare, Pharmaceuticals and Biotech Healthcare, Pharmaceuticals, and Biotech Other
Terex Corporation Westport Manufacturing Heavy Machinery
Praxair, Inc. Danbury Manufacturing Chemicals and Petrochemicals
Knights of Columbus New Haven Non-Profit Social and Membership Organizations
Xerox Corporation Norwalk Computers and Electronics Office Machinery and Equipment
Starwood Hotels and Resorts Worldwide, Inc. Stamford Travel, Recreation and Leisure Hotels, Motels and Lodging
United Technologies Corporation Hartford Manufacturing Aerospace and Defense
General Electric Company Fairfield Computers and Electronics Consumer Electronics, Parts and Repair
Pitney Bowes, Inc. Stamford Manufacturing Tools, Hardware and Light Machinery
Charter Communications, Inc. Stamford Telecommunications Cable Television Providers
Aetna Inc. Hartford Financial Services Insurance and Risk Management
Priceline.com Norwalk Travel, Recreation and Leisure Travel, Recreation, and Leisure Other

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 Connecticut 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
Milford, Connecticut Microsoft SQL Server Training , Milford, Connecticut Microsoft SQL Server Training Classes, Milford, Connecticut Microsoft SQL Server Training Courses, Milford, Connecticut Microsoft SQL Server Training Course, Milford, Connecticut Microsoft SQL Server Training Seminar
training locations
Connecticut 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.