Vi tilbyr kurs i (PB100) Building Semantic Models With SQL Server Analysis Services (SSAS).
The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.
The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.
This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
We offer online course about 101 Google BigQuery from SQL data analytics to creating machine learning models with BigQuery. In this workshop, we’ll first introduce BigQuery.
We offer online course about advanced T-SQL Querying, Programming and Tuning for SQL Server 2012, 2014 and 2016. The course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2012, 2014 and 2016.
This course teaches you how to process SAS data using Structured Query Language (SQL). You can gain this experience from the SAS Programming 1: Essentials course. No knowledge of SQL is necessary. This course addresses Base SAS software.
Gain the necessary knowledge about how to use Azure services to develop, train and deploy machine learning solutions. The course starts with an overview of Azure services that support data science.
DP-100: Designing and Implementing a Data Science Solution on Azure virtual.This course teaches you to leverage your existing knowledge of Python and machine learning to manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring in 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.
DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI - virtual. This course covers methods and practices for performing advanced data analytics at scale.
Machine Learning and Data Science in R on Microsoft ML and SQL Servers - with Rafal Lukawiecki Virtual. This very intensive, hands-on, 5-day course has been designed for those who want to learn more in-depth machine learning and data science using R.
Virtual The course goal is to dive into SQL Server Technologies and solutions that support and provide service and database availability, in order to understand and being able to design, maintain and support them in practical production environments.
This class teaches students tips and tricks for writing highly efficient, performant and scalable stored procedures, batches and transactions. Participants will be shown how to properly code functions, joins, sub-queries, Ccse statements, and grouping facilities.
MS 10987: Performance Tuning and Optimizing SQL - Virtual. This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.
This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databa
Connect2Classroom - In the Oracle Database 12c R2: Advanced PL / SQL course, students learn how to use the advanced features of PL / SQL in order to design and tune PL / SQL to interface with the database and integrate with the other applications in the most efficient manner.
The Oracle Database: PL / SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL / SQL blocks of application code.
The Oracle Database: SQL Workshop 1 Ed 2 course offers students an introduction to Oracle Database 12c database technology. The students are also introduced to Oracle Database Exadata Express Cloud Service.
The Oracle Database: SQL Workshop 2 Ed 2 virtual course will help students enhance their skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries.
Virtual - In this course students use Analytic SQL to aggregate, analyze and report, and model data. Students learn to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data, and exclude branches from the tree structure.
In this course students use Analytic SQL to aggregate, analyze and report, and model data. Students learn to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data, and exclude branches from the tree structure.
This course is designed for developers with basic PL / SQL and SQL language skills. Students learn to develop, execute, and manage PL / SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL / SQL subprograms and triggers.
This Oracle Database Introduction to SQL training teaches you basic concepts of relational databases and the SQL programming language.It will help you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions.
Oracle Database: Program with PL / SQL - Virtual. This Oracle Database: Program with PL / SQL training starts with an introduction to PL / SQL and then explores the benefits of this powerful programming language.
In the Oracle Database SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.
Vi tilbyr kurs i (PB100) Building Semantic Models With SQL Server Analysis Services (SSAS) for bedrifter.
Vi tilbyr 2-dagers påbyggingskurs i SQL-programmering. Vi bruker MySQL og MariaDB, Oracle Express, PostgreSQL og Microsoft SQL-server i kurset og belyser forskjellene mellom disse i håndteringen av avanserte SQL-setninger.
Vi tilbyr SQL grunnkurs. Etter gjennomført kurs vil deltakerne være fortrolige med å opprette databaser og tabeller, sette inn data, endre og slette data og søke etter data i SQL-databaser.