SQL Server Training Classes in Portsmouth, Virginia
Learn SQL Server in Portsmouth, Virginia 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 Portsmouth, Virginia: SQL Server Training
SQL Server Training Catalog
Course Directory [training on all levels]
- .NET Classes
- Agile/Scrum Classes
- AI Classes
- Ajax Classes
- Android and iPhone Programming Classes
- Blaze Advisor Classes
- C Programming Classes
- C# Programming Classes
- C++ Programming Classes
- Cisco Classes
- Cloud Classes
- CompTIA Classes
- Crystal Reports 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
- 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 I
3 November, 2025 - 7 November, 2025 - Linux Fundaments GL120
22 September, 2025 - 26 September, 2025 - RHCSA EXAM PREP
17 November, 2025 - 21 November, 2025 - RED HAT ENTERPRISE LINUX AUTOMATION WITH ANSIBLE
15 September, 2025 - 18 September, 2025 - RED HAT ENTERPRISE LINUX SYSTEMS ADMIN II
18 August, 2025 - 21 August, 2025 - See our complete public course listing
Blog Entries publications that: entertain, make you think, offer insight
In the ever changing landscape of software programming, it is not surprising that developers and employees have a different set of preferences for desired skills. However the number one language that developers want to learn according to a survey of developers by technical recruiter, Hacker Rank is Python. This is not a surprise considering that Python has been in demand for several years and programmers tend to really enjoy this language for clear syntax, good OOP support and great shortcuts. Python, named “the language of the year” in 2007 and 2010 in the TIOBE Index and has climbed to #4 status in May of 2018.
According to the study, employers want developers who:
- Have problem-solving skills, such as the ability to break down large, complex problems.
- Are proficient in their programming language and debugging.
- Can design systems.
- Can optimize performance.
- Have experience in reviewing and testing code.
- Are proficient in database design
Surprisingly, formal education is not the deciding factor when it comes to what companies care about the most. People with computer degrees or certifications on a resume are not necessarily a first choice for hiring managers. Others that have years of experience even if those individuals are partially self-taught in the field stand to be taken seriously in the field. For those individuals with a passion to learn and master a skill, there are ample opportunities with smaller to mid-sized companies.
Some interesting FAQ’s from the study:
On average, developers know 4 languages, and they aspire to learn 4 more.
Younger developers between 18 and 24 plan to learn 6 languages.
Folks older than 35 only plan to learn and additional 3 languages.
The top languages developers said they will learn were, Go, Python, Scala, Kotlin, and Ruby.
There is a large gap between employers seeking developers that know React than there are folks that can do it.
So, Why Learn Python?
It is now the most popular introductory teaching language in U.S. universities. Python is easy to use, powerful, and versatile, making it a great choice for beginners and experts alike. It allows you to think like a programmer and not waste time understanding difficult syntax that other programming languages can command. And, because of its rapid growth, many developers contribute to the Python community and share Python libraries making creativity that much more a reality
I will begin our blog on Java Tutorial with an incredibly important aspect of java development: memory management. The importance of this topic should not be minimized as an application's performance and footprint size are at stake.
From the outset, the Java Virtual Machine (JVM) manages memory via a mechanism known as Garbage Collection (GC). The Garbage collector
- Manages the heap memory. All obects are stored on the heap; therefore, all objects are managed. The keyword, new, allocates the requisite memory to instantiate an object and places the newly allocated memory on the heap. This object is marked as live until it is no longer being reference.
- Deallocates or reclaims those objects that are no longer being referened.
- Traditionally, employs a Mark and Sweep algorithm. In the mark phase, the collector identifies which objects are still alive. The sweep phase identifies objects that are no longer alive.
- Deallocates the memory of objects that are not marked as live.
- Is automatically run by the JVM and not explicitely called by the Java developer. Unlike languages such as C++, the Java developer has no explict control over memory management.
- Does not manage the stack. Local primitive types and local object references are not managed by the GC.
So if the Java developer has no control over memory management, why even worry about the GC? It turns out that memory management is an integral part of an application's performance, all things being equal. The more memory that is required for the application to run, the greater the likelihood that computational efficiency suffers. To that end, the developer has to take into account the amount of memory being allocated when writing code. This translates into the amount of heap memory being consumed.
Memory is split into two types: stack and heap. Stack memory is memory set aside for a thread of execution e.g. a function. When a function is called, a block of memory is reserved for those variables local to the function, provided that they are either a type of Java primitive or an object reference. Upon runtime completion of the function call, the reserved memory block is now available for the next thread of execution. Heap memory, on the otherhand, is dynamically allocated. That is, there is no set pattern for allocating or deallocating this memory. Therefore, keeping track or managing this type of memory is a complicated process. In Java, such memory is allocated when instantiating an object:
String s = new String(); // new operator being employed String m = "A String"; /* object instantiated by the JVM and then being set to a value. The JVM calls the new operator */
How Can Managers Work More Efficiently with IT?
Would you rather work under someone who is an excellent developer but lacks people skills or leadership capabilities - or for someone that has excellent people skills, communicates well, and is a great leader but has limited understanding of productive coding practices? That’s not to say that the choice is one or the other but in many professional situations it does.
Managing an IT staff comes with numerous challenges, especially if the manager has no previous experience with the coding necessary for completing the project. Managing a business and IT's execution of tasks vary greatly in required skill sets, but it's important to find a cohesive and cooperative middle ground in order to see a project to its end. To fully grasp the intricacies of IT's involvement in the project at hand, managers can do the following to help further their efforts.
Get a basic understanding of coding and technical practices necessary for the project at hand by taking the time to research and practice enough to get a grip on the concept. This will allow managers insight on what their IT folks are really working on daily. Expertise in a programming language is not required, only an overview of the stuff that matters, i.e. understanding the concept of OOP (Object Oriented Programming.) Having this knowledge cannot be overlooked and will gain respect among multiple spectrums in the organization.
Checking to see if a file exists is a two step process in Python. Simply import the module shown below and invoke the isfile function:
import os.path
os.path.isfile(fname)
Tech Life in Virginia
Company Name | City | Industry | Secondary Industry |
---|---|---|---|
Brink's Inc. | Richmond | Business Services | Security Services |
Federal Home Loan Mortgage Corporation (Freddie Mac) | Mc Lean | Financial Services | Lending and Mortgage |
General Dynamics Corporation | Falls Church | Manufacturing | Aerospace and Defense |
CarMax, Inc. | Henrico | Retail | Automobile Dealers |
NVR, Inc. | Reston | Real Estate and Construction | Construction and Remodeling |
Gannett Co., Inc. | Mc Lean | Media and Entertainment | Newspapers, Books and Periodicals |
Smithfield Foods, Inc. | Smithfield | Manufacturing | Food and Dairy Product Manufacturing and Packaging |
ManTech International Corporation | Fairfax | Computers and Electronics | IT and Network Services and Support |
DynCorp International | Falls Church | Manufacturing | Aerospace and Defense |
Genworth Financial, Inc. | Richmond | Financial Services | Insurance and Risk Management |
MeadWestvaco Corporation | Richmond | Manufacturing | Paper and Paper Products |
Dollar Tree, Inc. | Chesapeake | Retail | Department Stores |
Alpha Natural Resources, Inc. | Abingdon | Agriculture and Mining | Mining and Quarrying |
SRA International, Inc. | Fairfax | Business Services | Business Services Other |
NII Holdings, Inc. | Reston | Telecommunications | Wireless and Mobile |
Dominion Resources, Inc. | Richmond | Energy and Utilities | Gas and Electric Utilities |
Norfolk Southern Corporation | Norfolk | Transportation and Storage | Freight Hauling (Rail and Truck) |
CACI International Inc. | Arlington | Software and Internet | Data Analytics, Management and Storage |
Amerigroup Corporation | Virginia Beach | Financial Services | Insurance and Risk Management |
Owens and Minor, Inc. | Mechanicsville | Healthcare, Pharmaceuticals and Biotech | Personal Health Care Products |
Advance Auto Parts, Inc | Roanoke | Retail | Automobile Parts Stores |
SAIC | Mc Lean | Software and Internet | Software |
AES Corporation | Arlington | Energy and Utilities | Gas and Electric Utilities |
Capital One Financial Corporation | Mc Lean | Financial Services | Credit Cards and Related Services |
Sunrise Senior Living, Inc. | Mc Lean | Healthcare, Pharmaceuticals and Biotech | Residential and Long-Term Care Facilities |
Computer Sciences Corporation | Falls Church | Software and Internet | Software |
Altria Group, Inc. | Richmond | Manufacturing | Manufacturing Other |
Northrop Grumman Corporation | Falls Church | Manufacturing | Aerospace and Defense |
Alliant Techsystems Inc. | Arlington | Manufacturing | Aerospace and Defense |
Markel Corporation | Glen Allen | Financial Services | Insurance and Risk Management |
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 Virginia 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 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…