Interface Technical Training

This 5-day course on Developing SQL Databases in Microsoft SQL Server 2016 is designed for individuals who have a working knowledge of relational databases and Transact-SQL and want to expand their skills. Students will learn how design impacts database performance, and best practices for the development of tables, indexes (including OpGmized and Columnstore indexes), In-Memory Tables, and Query Blobs. This course is offered as part of an "all you can eat" subscription plan.

This 4-day introduction to Transact SQL gives students a comprehensive overview of this powerful tool. Students will learn how to use SQL Server Management Studio (SSMS), basic filtering with WHERE clause, NULL functions, and CASE expressions. They will also master the use of SELECT statements to access tables. This course is offered as part of an "all you can eat" subscription plan.

This 5-day program teaches students how to write queries following a step-by-step process and using T-SQL statements inside objects like Views and User-Defined Functions.Students will learn how to utilize subqueries, formulate join strategies, and write WHERE clauses. Finally, students will learn how to write procedural logic for stored procedures. This course is offered as part of an "all you can eat" subscription plan.

This 4-day program teaches basic and intermediate skills in data analysis with Microsoft Power BI. BI allows users to transform and combine data from numerous sources. Students will explore concepts like database connection, loading, and grouping, data merges, query syntax, and visualizations. This course is offered as part of an "all you can eat" subscription plan.

This 5-day program teaches the use of Report Builders, Power BI tools, Data Model Designers, and DAX Functions in Power BI for Excel.Specific course topics include a Power BI overview, visualization creation, data publication, transformation, distribution, and DAX expression usage. This course is offered as part of an "all you can eat" subscription plan.

This three-day course on analyzing data with Excel focuses on PivotTables, data models, and calculated columns. This function is Excel's most prominent data summary feature. Specific course topics include data table preparation, PivotTable creation, data analysis, advanced PivotTable functionality, and PivotTable chart creation. This course is offered as part of an "all you can eat" subscription plan.

Learn Microsoft Office 365 in this one-day, beginner-level course. Students will learn how to use this cloud-based platform to increase team productivity through document accessibility, real-time communication, effective mobility, and team collaboration. Boots-on-the-ground users and decision-makers considering this product both benefit from this course. Specific topics include navigation, OneDrive document usage, Outlook email, Planner scheduling, Teams collaboration, To-Do task assignment, and Microsoft Forms. This course is offered as part of an "all you can eat" subscription plan.

This 5-day course teaches foundational skills in HTML5, CSS, and JavaScript. This official Microsoft course starts with an introduction to web development and moves onto HTML and CSS syntax, how to use HTML to format web pages, and how to use CSS to structure various elements of a web page. This course also covers a variety of page layouts, working with lists, links, and navigation menus, using responsive web design, and using Flexible Box Layout for a better user interface. Students will have a firm understanding of front-end development using these tools and be prepared to sit for the Programming in HTML5 with JavaScript and CSS3 (exam 70-480) exam. This course is offered as part of an "all you can eat" subscription plan.

This 5-day comprehensive course prepares students for Exam SYO-501 (CompTIA Security+) certification. This program teaches students the essential skills needed to handle cyber threats and attacks and identify and repair vulnerabilities. Students will learn about every aspect of security covered in the exam, including risk management, monitoring, and diagnosing networks, devices and infrastructure, access management, and cloud-based security. This course is offered as part of an "all you can eat" subscription plan.

This 5-day comprehensive Python programming course is designed for students with no prior programming experience and are looking to get comfortable with the basic skills needed for Python programming. The course will cover foundational Python concepts, including data types, control statements, using functions and modules, handling exceptions and debugging programs, working with lists, and how to work with a variety of data types. By the end of the course, students will be familiar with writing programs for simple applications. This course is offered as part of an "all you can eat" subscription plan.