Power BI And SQL Server CoursesInterface Technical Training View All Courses
Interface Technical Training View All Courses
SQL Server Training
Interface offers quality SQL Server Training to IT professionals. We tune our SQL training courses and build our program based on what you require. We often use Microsoft Official Courses. Sometimes we modify and improve these courses. Sometimes we build our own courses from the ground up. Attend our classes in person, or online with RemoteLive™. And, watch your live class again with Replay™! Try our SQL training – we guarantee your satisfaction.
LIVE / VIRTUAL TRAINING
NON-TECHNICAL SQL TRAINING
BUSINESS USERS AND NON-PROGRAMMERS
SQL101: Introduction to Transact SQL
This 4-day course is for students with no programming background! You’ll learn how to access complex databases and master the SELECT statement in order to retrieve the data you need. If you are responsible for data reporting, and you need access a SQL Server database, this is the perfect course.
This 4-day course is for students with no programming background! You’ll learn how to access complex databases and master the SELECT statement in order to retrieve the data you need. If you are responsible for data reporting, and you need access a SQL Server database, this is the perfect course.
TECHNICAL SQL TRAINING
Database Administrators
SQL764A: Provisioning and Administering a SQL Server Database
Interface created this 5-day course by combining all the infrastructure training (and removing all the cloud implementation) from two Microsoft Official courses – 20764 and 20765. If you need to administer a full SQL Server implementation in an on-premise or cloud infrastructure, and you have no intention of implementing in the cloud, you’ll gain mastery in SQL Server implementation in one week instead of 2 weeks.
Interface created this 5-day course by combining all the infrastructure training (and removing all the cloud implementation) from two Microsoft Official courses – 20764 and 20765. If you need to administer a full SQL Server implementation in an on-premise or cloud infrastructure, and you have no intention of implementing in the cloud, you’ll gain mastery in SQL Server implementation in one week instead of 2 weeks.
DP-300: Administering Relational Databases on Microsoft Azure
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
DP-900: Microsoft Azure Data Fundamentals
In this course, students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Microsoft Azure. They will explore the roles, tasks, and responsibilities in the world of data. The students will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure. They will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure. Students will explore the processing options available for building data analytics solutions in Azure. They will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.
In this course, students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Microsoft Azure. They will explore the roles, tasks, and responsibilities in the world of data. The students will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure. They will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure. Students will explore the processing options available for building data analytics solutions in Azure. They will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.
Database Developers
SQL250: Transact-SQL for Developers
This 5-day course is structured the same way the SQL executes a query, rather than teaching to a list of features. The result is a more logical way to learn. You’ll master the technical skills required to write Transact-SQL queries, scripts, Views, Stored Procedures and User-Defined Functions, and how to use T-SQL statements inside common database objects. If you need to go faster and deeper than SQL101, and have a programming and developer background, this is the perfect course.
This 5-day course is structured the same way the SQL executes a query, rather than teaching to a list of features. The result is a more logical way to learn. You’ll master the technical skills required to write Transact-SQL queries, scripts, Views, Stored Procedures and User-Defined Functions, and how to use T-SQL statements inside common database objects. If you need to go faster and deeper than SQL101, and have a programming and developer background, this is the perfect course.
Business Intelligence Developers
10990: Analyzing Data with SQL Server Reporting Services Training
This is a 3-day Microsoft Official Course – MOC 10990: Analyzing Data with SQL Server Reporting Services Training.
This course is an overview of how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions. It also reviews Data Modeling, mobile reports and report mapping for filtering and sorting parameters and grouping.
If you are an IT Professional and need to learn how to deploy in a production environment, see course: BI790 – SQL Server 2016 Reporting Services (SSRS) for Report Developers.
This is a 3-day Microsoft Official Course – MOC 10990: Analyzing Data with SQL Server Reporting Services Training.
This course is an overview of how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions. It also reviews Data Modeling, mobile reports and report mapping for filtering and sorting parameters and grouping.
If you are an IT Professional and need to learn how to deploy in a production environment, see course: BI790 – SQL Server 2016 Reporting Services (SSRS) for Report Developers.
DA-100: Analyzing Data with Microsoft Power BI
This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.
This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.
Azure Data Engineering
DP-200: Implementing an Azure Data Solution
In this course, the students will implement various data platform technologies into solutions that are in line with business and technical requirements including on-premises, cloud, and hybrid data scenarios incorporating both relational and No-SQL data. They will also learn how to process data using a range of technologies and languages for both streaming and batch data. The students will also explore how to implement data security including authentication, authorization, data policies and standards. They will also define and implement data solution monitoring for both the data storage and data processing activities. Finally, they will manage and troubleshoot Azure data solutions which includes the optimization and disaster recovery of big data, batch processing and streaming data solutions.
This course is part of the Microsoft Certified: Azure Data Engineer Associate and prepares students for the Azure Certification Exam: DP-200.
In this course, the students will implement various data platform technologies into solutions that are in line with business and technical requirements including on-premises, cloud, and hybrid data scenarios incorporating both relational and No-SQL data. They will also learn how to process data using a range of technologies and languages for both streaming and batch data. The students will also explore how to implement data security including authentication, authorization, data policies and standards. They will also define and implement data solution monitoring for both the data storage and data processing activities. Finally, they will manage and troubleshoot Azure data solutions which includes the optimization and disaster recovery of big data, batch processing and streaming data solutions.
This course is part of the Microsoft Certified: Azure Data Engineer Associate and prepares students for the Azure Certification Exam: DP-200.
DP-201: Designing an Azure Data Solution
In this course, the students will design various data platform technologies into solutions that are in line with business and technical requirements. This can include on-premises, cloud, and hybrid data scenarios which incorporate relational, No-SQL or Data Warehouse data. They will also learn how to design process architectures using a range of technologies for both streaming and batch data. The students will also explore how to design data security including data access, data policies and standards. They will also design Azure data solutions which includes the optimization, availability and disaster recovery of big data, batch processing and streaming data solutions.
In this course, the students will design various data platform technologies into solutions that are in line with business and technical requirements. This can include on-premises, cloud, and hybrid data scenarios which incorporate relational, No-SQL or Data Warehouse data. They will also learn how to design process architectures using a range of technologies for both streaming and batch data. The students will also explore how to design data security including data access, data policies and standards. They will also design Azure data solutions which includes the optimization, availability and disaster recovery of big data, batch processing and streaming data solutions.
DP-300: Administering Relational Databases on Microsoft Azure
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
DP-900: Microsoft Azure Data Fundamentals
In this course, students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Microsoft Azure. They will explore the roles, tasks, and responsibilities in the world of data. The students will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure. They will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure. Students will explore the processing options available for building data analytics solutions in Azure. They will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.
In this course, students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Microsoft Azure. They will explore the roles, tasks, and responsibilities in the world of data. The students will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure. They will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure. Students will explore the processing options available for building data analytics solutions in Azure. They will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.
