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.
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.
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.
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 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.
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.
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 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.
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 - Connect2Classroom. This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.
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.
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.
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.
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.
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.
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.
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 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.
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.
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 fundamenten er usikker på hvor du skal begynne? Da er denne workshoppen noe for deg!