This course teaches you how to process SAS data using Structured Query Language (SQL).
During this training, you will learn the basics of SQL Data Definition Language (DDL) and Data Manipulation Language (DML), with which you can create and manipulate database structure and update data content.
Navigate the Developer Tool and collaborate on projects with Analysts. Perform Column, Rule, Multi object, Comparative and Mid-Stream Profiling. Manage reference tables. Design and develop Mapplets. Create standardization, cleansing and parsing routines.
DAX is the native language of Power Pivot for Excel, Power BI Desktop and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power Pivot for Excel, Power BI Desktop and at Analysis Services developers that want to learn and master the DAX language.
SQL is a query language standardized by the ANSI Institute, which is used to retrieve information and to edit database structures in to relational databases.
Learn how to manage security and identity within the context of Azure. Also, you’ll be introduced to multiple SaaS services available in Azure that for integration into existing Azure solutions.
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.
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.
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.
Connect2Classroom - 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.
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.
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.
Machine Learning and Data Science in R on Microsoft ML and SQL Servers - with Rafal Lukawiecki. 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.
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.
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.
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 Masterclass suits Database administrators who are responsible for the proper and reliable operation of one or more SQL servers. If you would like to learn how to search and detect problems within SQL database, or if you would like to learn the QP and code Execution.
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.
This Boot Camp contains all official modules from the two official Microsoft courses: AZ-300: Microsoft Azure Architect Technologies and AZ-301: Microsoft Azure Architect Design and leads to the Azure Expert Architecture and Design certification.
Virtual This Boot Camp contains all official modules from the two official Microsoft courses: AZ-300: Microsoft Azure Architect Technologies and AZ-301: Microsoft Azure Architect Design and leads to the Azure Expert Architecture and Design certification.
This migration training is focusing on describing the Azure services that participate in the modern Datawarehouse deployment first (such as Azure Data Lake, Azure Data Factory, Azure SQL DB, Azure Synapse Analytics, Azure Analysis Services, PBI).
MS 10987: Performance Tuning and Optimizing SQL - Connect2Classroom. 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 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 5-day instructor-led course teaches students 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.
This 5-day virtua instructor-led course teaches students 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.
In this course, students will learn how to design and develop services that access local and remote data from various data sources. Students will also learn how to develop and deploy services to hybrid environments, including on-premises servers and Windows Azure.
MS 20537: Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack. This five-day course will provide students with the key knowledge required to deploy and configure Microsoft Azure Stack.
This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.
This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.
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
MS 20765: Provisioning SQL Databases. This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.
MS 20765: Provisioning SQL Databases - Connect2Classroom. This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.
This five-day instructor-led course will teach students to create BI solutions and to implement a Data Warehouse, data flow by using SSIS and an ETL solution. Students will also learn about data cleansing.
MS 20767: Implementing a SQL Data Warehouse - Connect2Classroom. This five-day instructor-led course will teach students to create BI solutions and to implement a Data Warehouse, data flow by using SSIS and an ETL solution. Students will also learn about data cleansing.
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.
MS 20768: Developing SQL Data Models - Connect2Classroom. 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.
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.
MS 20778: Analyzing Data with Power BI - Connect2Classroom. 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.
MySQL Performance Tuning Ed 4 - Connect2Classroom. This course provides experienced MySQL DBAs with knowledge of how and why server settings affect performance, and when and how to tune them.
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.
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 course will help students enhance their skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries.
Connect2Classroom - 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.
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. Through hands-on instruction from expert Oracle instructors, you´ll learn to develop stored procedures, functions, packages and more.
Oracle Database: Program with PL / SQL - Connect2Classroom. 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.
In the Oracle NoSQL Database for Developers Ed 1 course, you will learn how to use the Oracle NoSQL Database developer APIs for Java. You will also discover how to access the KVStore from a Java application to store and manipulate data in a KVStore.
Vi tilbyr kurs i (PB100) Building Semantic Models With SQL Server Analysis Services (SSAS).
Vi tilbyr kurs i (PB100) Building Semantic Models With SQL Server Analysis Services (SSAS) for bedrifter.
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.
For deg som vil lære hvordan du kan bruke SQL i din testhverdag På leting etter bugs eller testdata, kan du komme langt på vei med litt kjennskap til underliggende database og muligheten til å søke med SQL.
Vi tilbyr nettkurs om Introduction to SQL Databases. Lær om ulike database-konsepter og modellering av databaser. Se hvordan du bruker relasjoner og indekser i en database. Bli kjent med hvordan du tuner en database for optimal ytelse.
Vi tilbyr nettkurs om Performance Tuning and Optimizing SQL Databases. Lær hvordan du får optimal ytelse på database og SQL Server. Se hva som er best practices på bruk av SQL server funksjonalitet. Bli kjent med hvordan man feilsøker og retter.
Vi tilbyr nettkurs om Analyzing Data with SQL Server Reporting Services. Lær om datamodellering. Lær om datakilder og hvordan disse konfigureres. Lær hvordan du lager rapporter.
Vi tilbyr nettkurs om Administering Microsoft SQL Server 2014 Databases. Lær deg å administrerer og vedlikeholde en SQL Server løsning. Gjennomfør opplæringen når det passer deg, i ditt eget tempo. Samme hands-on, live real-time labmiljø som på et klasseromskurs.
Vi tilbyr nettkurs om Implementing a Data Warehouse with Microsoft SQL Server 2014. Lær om datavarehus-konsepter og datamodeller. Lær hvordan du kvalitetsikrer data 3. Lær hvordan andre tjenester bruker datavarehuset.
Vi tilbyr nettkurs om Querying Data with Transact-SQL. Bli godt kjent med T-SQL syntaks og muligheter. Lær deg hvordan man lager queries, samt bruker innebygde funksjoner. Lær hvordan man lager og bruker stored procedures.
Vi tilbyr nettkurs om Developing SQL Databases. Lær hvordan du lager tabeller og spørringer. Lær hvordan du setter opp relasjoner og indekser. Lær hvordan du bruker Stored Procedures og triggers.
Vi tilbyr nettkurs om Administering a SQL Database Infrastructure. Lær om sikkerhet, rettigheter og tilganger. Lær om backup og gjenoppretting, samt overvåkning. Lær hvordan man kan automatisere administrasjon.
Vi tilbyr nettkurs om 20765 Provisioning SQL Databases. Lær hvordan man setter opp en SQL Server. Lær hvordan man oppgraderer og konfigurerer SQL Server. Lær hvordan man migrere databaser fra on-premise til Azure.
Vi tilbyr nettkurs om Implementing a SQL Data Warehouse. Lær om mulighetene med data warehouse. Lær hvordan du setter opp løsningen. Lær hvordan du bruker masterdata.
Vi tilbyr nettkurs om Developing SQL Data Models. Lær hvordan du bruker SQL Server Analysis Services. Lær hvordan du bruker kuber, dimensjoner, mål og målgrupper. Lær hvordan du bruker DAX til spørringer.
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.
The SQL Master Class for Java Developers training is aimed to level up your SQL skills with techniques such as Window Functions, recursive queries, Pivoting, JSON processing, and many other database querying features supported by Oracle, SQL Server, MySQL, or PostgreSQL.
Vi tilbyr kurs i webutvikling med PHP og MySQL. PHP er et kraftig skriptspråk som brukes til å lage dynamiske og interaktive websider. PHP brukes bl.a av Facebook, Wikipedia og Wordpress, og er et effektivt alternativ til f.eks. Ruby on Rails, Django, Microsoft ASP/.net og Java EE.
Har du hatt lyst til å lære deg React, men er usikker på hvor du skal begynne? Da er denne workshoppen noe for deg!
React og Redux er to navn som ofte følger hverandre når det er snakk om såkalte Single-Page-Applications eller SPAs. Denne kombinasjonen har etterhvert blitt blant de mest kjente verktøyene for bygging av slike applikasjoner.