SQL Server Training
Intertech’s SQL Server courses cover all important aspects of Microsoft’s core database engine: administration, Business Intelligence (BI), querying and, of course, programming. After completing our SQL Server courses student are able to use SQL Server Management Server (SSMS), object explorer, SQL Server data tools, and SQL Server configuration manager.
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 Server 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 Server 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.