SQL Server Training

See All Scheduled Courses

Intertech’s SQL training courses cover all important aspects of Microsoft’s core database engine: administration, Business Intelligence (BI), querying and, of course, programming. After completing our SQL training courses student are able to use SQL Server Management Server (SSMS), object explorer, SQL Server data tools, and SQL Server configuration manager. See more details below or request more information on our SQL training options.

Course Finder

Return To Top
Filter Options
close

Training Category

  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See more Adobe Categories
  • See more Adobe Categories
  • See more Adobe Categories
  • See more Agile | Scrum Categories
  • See more Agile | Scrum Categories
  • See more Citrix Categories
  • See more EC Council Categories
  • See more F5 Categories
  • See more IBM Categories
  • See more IBM Categories
  • See more ITIL Categories
  • See more Java Categories
  • See more Java Categories
  • See more Java Categories
  • See more Java Categories
  • See more Linux Categories
  • See more Linux Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Open Source Categories
  • See more Open Source Categories
  • See more Open Source Categories
  • See more Oracle Categories
  • See more Oracle Categories
  • See more Programming Categories
  • See more Programming Categories
  • See more Software Testing Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more XML Categories
  • See more XML Categories

Scheduled Classes


Date

  • X
  • X
  • Please ensure that the End Date is greater than or equal to the Start Date.
  • Please ensure that the End Date is greater than the present Date.

Delivery

Location

- of results

Free Resources

Free Guide: Introducing Microsoft SQL Server 2016

Free eBook: SQL Server Issues, Answers, and Tips

Free Video: VS Reports Deployment to SSRS

MORE ON SQL SERVER TRAINING

Our students receive a comprehensive introduction to the vast majority of tools and features available within the Microsoft SWL Server Database Engine, which is at the core of the SQL Server components. Instructors describe how the Database Engine allows programmers to leverage the full capabilities of all of the other components, such as accessing, storing and securing the data. 
 
Within the Database Engine, the storage engine is the primary component but students also learn about the other components that depend on the engine: T-SQL programming interface, security subsystem, replication, SQL server agent, high availability and disaster recovery tools, SQL server integration services and server management tools. Intertech’s SQL training teaches how to install SQL Server and use the administrative and development tools. 
 
Students learn to design SQL Server databases and tables, as well as indexing and other techniques that leverage the robust set of components and tools available with SQL Server. This builds understanding of the requirements and functions of each system database, as well as the SQL Server database structure. Instructors ensure that students learn to create SQL Server databases using several different tools, such as SQL Server Data Tools, Windows PowerShell, and the C# and VB.NET programming languages. 
 
We also cover advanced techniques, such as compression, partitioning, and database snapshots. All of this instruction, which is supplemented with many opportunities to actually apply it in labs, hone students’ ability to design an efficient, flexible and highly available database topology.
 
Our SQL training covers using T-SQL to manipulate data in SQL Server databases and tables, as well as how to create other database objects that can be used for data retrieval. Students learn about each replication type available in SQL Server and how to build a comprehensive maintenance solution that ensures the availability and performance of the SQL Server environment.  
 
Intertech instructors also describe aspects of the technology that assist those acting as DBAs in proactively monitoring and managing a single or multiserver SQL Server topology. Equally important is the review of features of SQL Server that ensure servers are available should a catastrophic event occur.  
 
 
 

Looking for Different Training?