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.
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.
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 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 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).
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.
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.
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 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
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.
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.
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 - 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.
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.
This course teaches you how to process SAS data using Structured Query Language (SQL).
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.
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.
Et React introduksjonskurs myntet på nye utviklere og andre som ønsker å lære seg React, men ikke har erfaring fra tidligere. Kurset er basert på over 5 år med hands-on erfaring med rammeverket og vil gi deg et godt fundament for å bygge skalerbare, robuste React applikasjoner.
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 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.
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.