The main purpose of this 3 day course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines: namely, Database Administration, Database Development and Business Intelligence.
This Microsoft Official Courses On-Demand is an integrated blend of video, reading, Microsoft Labs Online and knowledge checks that can help you stay abreast of the latest technologies and build technical skills in a flexible, time-efficient and cost-effective manner.
This five-day course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.
This three-day 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.
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.
This course teaches you how to process SAS data using Structured Query Language (SQL).
This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014.
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.
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.
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.
Vi tilbyr kurs i PHP og MYSQL. Målsettingen er at deltakerne skal etter endt kurs kunne lage enkle Web-programmer og CMS basert på programmeringsspråket PHP og databasesystemet MySQL.
Målsettingen er at deltakerne skal på en effektiv måte kunne benytte Structured Query Language (SQL) som verktøy etter at kurset er ferdig. De vil lære å bruke de viktigste konseptene og funksjonene, og kjenne til grunnleggende prinsipper for utvalg og databaseoppbygging i SQL.
This 5-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.
This 5-day instructor-led course introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions.
This 5-day instructor-led course describes how to empower information workers through self-service analytics and reporting.
This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012.
This 5-day instructor-led course describes how to implement a BI platform to support information worker analytics.
Advanced Machine Learning with Microsoft ML Server, SQL Server, and Azure ML. The agenda for this 4 day Advanced class with Rafal Lukawiecki is under development. Content will be released.
This MOC (Microsoft Official Course) is completely new (as of October 2018), and will lead to the new Azure certifications to be released by Microsoft.
This is a completely new course that together with course "AZ-201: Develop Advanced Microsoft Azure Cloud Solutions" leads to the new MCSA Azure Developer certification.
This is a completely new course that together with course "AZ-200: Develop Core Microsoft Azure Cloud Solutions" leads to the new MCSA Azure Developer certification.
This is a completely new course that leads to the new Azure Developer Associate certification. This five day course is aligned to Azure Exam: AZ-203 Developing Solutions for Microsoft Azure.
This course is completely new (as of September 2018), and will lead to the new Microsoft Certified: Azure Solutions Architect Associate certification. Course description is currently not released, but will be updated as soon as available.
This 5-day course provides students with the key knowledge to help prepare for exam AZ-400, which will lead to the new Azure DevOps Engineer Expert certification.
In this course students will gain the knowledge and skills needed to implement security controls, maintain the security posture, and identify and remediate vulnerabilities by using a variety of security tools. The course covers scripting and automation, virtualization, and cloud N-tier architecture
This course will provide foundational level knowledge of cloud services and how those services are provided with Microsoft Azure.
This live classroom course is new for 2018! It focuses on the newest technologies of Microsoft Machine Learning Server and SQL Server 2017, and teaches you R and how to use it for machine learning on the Microsoft platform.
Introduction to Machine Learning, AI and Data Science with Azure ML. This live classroom course is new for 2018! It focuses on the newest technologies of Microsoft Machine Learning Server and SQL Server 2017.
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.
In this course, students will gain an understanding of directory service options, how to use a custom domain, how to manage users and groups, as well as how to use multi-factor authentication.
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 course is aimed for experienced IT Professionals who currently administer their on-premise infrastructure and needs architecture skills necessary to design solutions for Microsoft Azure.
You have a Datawarehouse and a BI solution in place. You probably have some doubts about how it will scale or if it is aligned with modern trends. Then this workshop is for you!
This course provides the underlying knowledge required by all individuals who will be evaluating Microsoft Azure, whether they are administrators, developers, or database administrators..
This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.
This 4-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.
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 intended for students who have experience building web applications. Students should also have experience with the Microsoft Azure platform and a basic understanding of the services offered in 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 5-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 5-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 databases
This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.
This 5-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.
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 the ability to use Microsoft R Server to create and run an analysis on a large dataset, and show how to utilize it in Big Data environments, such as a Hadoop or Spark cluster, or a SQL Server database.
The MySQL for Database Administrators course teaches DBAs and other database professionals how to maximize their organizations investment in MySQL and about the benefits of using the MySQL Cloud Service.
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.
This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data and exclude branches from the tree structure.
This Oracle Database 12c: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.
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 I 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.
This Oracle Database: SQL Workshop 2 helps you enhance your skills as an Application developer by learning how to manage the database objects, data dictionary views and multicolumn subqueries.
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: 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.
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.
Practical Machine Learning, AI and Data Science on SQL Server 2017, Microsoft ML Server, R, and Azure ML - with Rafal Lukawiecki. This live classroom course is new for 2018! It focuses on the newest technologies of Microsoft Machine Learning Server and SQL Server 2017.
In this workshop you will analyze, learn and practice critical tasks for implementing highly secure SQL Server infrastructure.
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.
This course describes how to implement a data warehouse platform to support a BI solution.
This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions.
The focus of this five-day instructor-led course is on creating managed enterprise BI solutions
The MySQL for Database Administrators training is designed for DBAs and other database professionals.
The MySQL Performance Tuning course teaches you how to tune MySQL for optimal performance. You will learn best practices for configuring, monitoring, and troubleshooting your server, databases and queries using a range of tools.
Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You´ll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios.
This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion.
This course offers you an introduction to Oracle Database 12c database technology. You will learn the concepts of relational databases and the powerful SQL programming language.
This Oracle Database Cloud for Oracle DBAs training teaches you how to administer the Oracle Database Cloud Service. Its ideal for existing DBAs who want to learn how to administer Oracle Database in the cloud.
This Oracle Database: Develop PL/SQL Program Units course is designed for developers with basic PL/SQL and SQL language skills. You will learn to develop, execute and manage PL/SQL stored program units, which include: procedures, functions, packages and database triggers
This Oracle Database: Develop PL/SQL Program Units course is designed for developers with basic PL/SQL and SQL language skills.