Oversikt over relevante kurs innen IT-kurs i Ranheim

Fleksible kurs for fremtidenNy kunnskap skal gi umiddelbar effekt, og samtidig være holdbar og bærekraftig på lang sikt.NTI AS har 30 års erfaring innen kurs og kompetanseheving, og utdanner årlig rundt 10.000 personer i Nord Europa innen CAD, BIM, industri, design og konstruksjon.   Solibri Anywhere   På kurset vil du lære å: Sammenstille flere IFC-modeller og navigere i disse Velge ut grupper av objekter for nærmere studier Legge inn snitt, måle, markere og opprette slides fra visninger av modellen Opprette rapporter og kommentere «issues» i Excel og BCF-format Se på resultatet av utførte regelsjekker i modellen Se på resultatet av utførte informasjons- og mengdeuttak fra modellen   Dette er et populært kurs, meld deg på nå! Spesialtilpasset kurs: NTI anbefaler spesialtilpassede kurs for bedrifter som planlegger å sende to eller flere deltakere på Solibri-kurs. Grunnen til dette er at Solibri brukes av mange forskjellige aktører og profesjoner i BAE-bransjen, og følgelig blir de åpne kursene ofte for generelle for enkelte kursdeltakere. I et spesialtilpasset kurs vil vår kurskonsulent kartlegge fokusområdene i forkant av kurset, og gjennomføre kurset i henhold til selskapets behov, gjerne basert på kundens egne modeller. Utbyttet av kurset blir følgelig mye større.  Ta kontakt med oss på telefon 483 12 300, epost: salg-no@nti.biz eller les mer på www.nti.biz   [-]

På dette 2-dagerskurset vil du lære hvordan Powe Pivot brukes som et verktøy for å lage rapporter. I kurset lærer en å koble ulike datakilder og gjennom Power Query velge data en ønsker. Ved hjelp av DAX formler gjør en beregninger på tvers av kildene og får ut det en ønsker til fine formaterte rapporter. Etter dette kurset vil du være i stand til å bruke de fleste aspekter av Microsoft Power Pivot.  Nivå: Dette kurset dekker grunnleggende Power Pivot    Kurset består av følgende moduler - du kommer til å jobbe med praktiske modeller gjennom hele kurset: Forskjellen mellom Power Pivot og Pivottabeller Grunnstruktur for god modellering Hvordan få spesifikke data inn i Power Pivot Rensing av data (datavask) Håndtere datarelasjoner i modellene Bygge Power Pivot tabeller ved å bruke flere datakilder Bruk av DAX i din BI løsning Importere data til datamodellen ved hjelp av Power Query Power Pivot formatering - for å lage imponerende rapporter Utarbeide menyer for tilgang til alle rapporter Bruk av slicere 70 % av kurset foregår i Power Pivot og 30 % i Excel  [-]

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.   Learn to: Understand the basic concepts of relational databases ensure refined code by developers. Create reports of sorted and restricted data. Run data manipulation statements (DML). Control database access to specific objects. Manage schema objects. Manage objects with data dictionary views. Retrieve row and column data from tables. Control privileges at the object and system level. Create indexes and constraints; alter existing schema objects. Create and query external tables. Course objectives: Identify the major structural components of the Oracle Database 12c Manage objects with data dictionary views Manage schema objects Retrieve row and column data from tables Run data manipulation statements (DML) in Oracle Database 12c Use scalar and correlated sub-queries Utilize views to display data Write SELECT statements that include queries Write multiple-column sub-queries Control database access to specific objects Create reports of aggregated data Create reports of sorted and restricted data Create tables to store data Display data from multiple tables using the ANSI SQL 99 JOIN syntax Employ SQL functions to retrieve customized data Read the official course description here.    [-]

The course focuses on providing students with Linux administration "survival skills" by focusing on core administration tasks. Red Hat System Administration I provides a foundation for students wishing to become full-time Linux system administrators by introducing key command line concepts and other enterprise-level tools. These concepts are further developed in the follow-on course, Red Hat System Administration II (RH134). Course content summary: Introduction to the command line Managing physical storage Learning how to install and configure software components and services Establishing network connections and firewall access Monitoring and managing processes Managing and securing files Administrating users and groups Accessing Linux file systems Installing and using virtualized systems Reviewing the system log files and journal   Course Outline: Access the command lineLog in to a Linux system and run simple commands using the shell. Manage files from the command lineCopy, move, create, delete, and organize files from the bash shell prompt. Get help in Red Hat Enterprise LinuxResolve problems by using online help systems and Red Hat support utilities. Create, view, and edit text filesCreate, view, and edit text files from command output or in an editor. Manage local Linux users and groupsManage local Linux users and groups, and administer local password policies. Control access to files with Linux file system permissionsSet Linux file system permissions on files and interpret the security effects of different permission settings. Monitor and manage Linux processesObtain information about the system, and control processes running on it. Control services and daemonsControl and monitor network services and system daemons using systemd Configure and secure OpenSSH serviceAccess and provide access to the command line on remote systems securely using OpenSSH Analyze and store logsLocate and accurately interpret relevant system log files for troubleshooting purposes. Manage Red Hat Enterprise Linux networkingConfigure basic IPv4 networking on Red Hat Enterprise Linux systems. Archive and copy files between systemsArchive files and copy them from one system to another. Install and update software packagesDownload, install, update, and manage software packages from Red Hat and yum package repositories. Access Linux file systemsAccess and inspect existing file systems on a Red Hat Enterprise Linux system. Use virtualized systemsCreate and use Red Hat Enterprise Linux virtual machines with KVM and libvirt. Comprehensive reviewPractice and demonstrate the knowledge and skills learned in this course. [-]

The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI. This course is recommended as preparation for exam 70-779 which is the first of two exams leading to MCSA BI Reporting certification.  After completing this course, students will be able to: Explore and extend a classic Excel dashboard. Explore and extend an Excel data model. Pre-format and import a .CSV file. Import data from a SQL Server database Import data from a report. Create measures using advanced DAX functions. Create data visualizations in Excel. Create a Power BI dashboard with Excel. Read the official course description here: MS 20779: Analyzing Data with Excel  [-]

Blended Virtual CourseThe course is a hybrid of virtual training and self-study which will be a mixture of teaching using Microsoft Teams/Zoom for short bursts at the beginning of the day, then setting work for the rest of the day and then coming back at the end of the day for another on-line session for any questions before setting homework in the form of practice exams for the evening. KursinnholdDette kurset forklarer det grunnleggende i softwaretesting. Det er basert på ISTQB- pensum og er akkreditert av BCS.  Kurset inneholder øvelser, prøveeksamener og spill for å fremheve sentrale deler av pensum. Dette sammen med kursmateriell og presentasjoner vil bistå i forståelse av begreper og metoder som blir presentert.   Bouvet sine kursdeltakeres testresultater vs ISTQB gjennomsnitt. Course content Fundamentals of Testing This section looks at why testing is necessary, what testing is, and explains general testing principles, the fundamental test process, and psychological aspects of testing.   Skills Gained • Learn about the differences between the testing levels and targets• Know how to apply both black and white box approaches to all levels of testing• Understand the differences between the various types of review and be aware of Static Analysis• Learn aspects of test planning, estimation, monitoring and control• Communicate better through understanding standard definitions of terms• Gain knowledge of the different types of testing tools and the best way of implementing those tools   Testing throughout the software lifecycle Explains the relationship between testing and life cycle development models, including the V-model and iterative development. Outlines four levels of testing:• Component testing• Integration testing• System testing• Acceptance testing Describes four test types, the targets of testing:• functional• non-functional characteristics• structural• change-related Outlines the role of testing in maintenance.   Static Techniques Explains the differences between the various types of review, and outlines the characteristics of a formal review. Describes how static analysis can find defects.   Test Design Techniques This section explains how to identify test conditions (things to test) and how to design test cases and procedures. It also explains the difference between white and black box testing. The following techniques are described in some detail with practical exercises :• Equivalence Partitioning• Boundary Value Analysis• Decision Tables• State Transition testing• Statement and Decision testingIn addition, use case testing and experience-based testing (such as exploratory testing) are described, and advice is given on choosing techniques.   Test Management This section looks at organisational implications for testing and describes test planning and estimation, test monitoring and control. The relationship of testing and risk is covered,and configuration management and incident management.   Tool Support for Testing Different types of tool support for testing are described throughout the course. This session summarises them, and discusses how to use them effectively and how best to introduce a new tool.   The Exam The ISTQB Foundation exam is a 1-hour, 40 question multiple choice exam. There is an extra 15 minutes allowed for candidates whose first language is not English.The pass mark is 65% (26/40) and there are no pre requisites to taking this exam.The exam is a remote proctored exam [-]

Workshopen består av et minimum med teori og et maksimum av praktiske øvelser hvor vi lager streams av  Arrays, List, Set, Map og Files - filtrerer, mapper til nye objekter, utfører aggregeringer og konverterer tilbake til nye collections mm. Workshopen vil dekke bl.a. Sette opp en stream, med Stream.of(), IntStream.of() og DoubleStream.of() Konvertere et Array til en stream med Arrays.stream() Konvertere en collection av typen List, Set eller Map til en stream med stream() Filtrere ut verdier med filter() Mappe til nye objekter med map() og flatMap() Sortere med sorted() og ulike typer Comparators Aggregere med reduce() og collect() Behandle hvert element med forEach() og forEachOrdered() Gruppere og telle opp forekomster i hver gruppe med collect() Konvertere tilbake til en collection med collect() Konvertere til et objekt med get() Begrense reultatet med limit() Hente enkel statistikk (min, max, average, sum) med reduce() og collect() og bl.a. summarizingInt() Bruke :: til metodereferanser Lese en fil inn i en stream med Files.lines() Behandle hvert element med forEach() og forEachOrdered [-]

This course (together with MS-100) will help you prepare for the new certification: Microsoft 365 Certified Enterprise Administrator Expert. This 4 day course contains of these 3 official Microsoft courses (all courses will be continously updated): MS-101T01: Microsoft 365 Security Management Learn about Microsoft 365 Security Management, including how to manage your security metrics, how to enable Azure AD Identity Protection, how to configure your Microsoft 365 security services, and user Microsoft 365 Threat Intelligence. MS-101T02: Microsoft 365 Compliance Management Learn about Microsoft 365 Compliance Management, including data retention and data loss prevention solutions in Microsoft 365, archiving and retention in Microsoft 365, implementing and managing data governance, and managing search and investigations. MS-101T03: Microsoft 365 Device Management This course introduces you to the world of Microsoft 365 device management - from establishing Microsoft Intune, to enrolling devices to Intune, to monitoring the devices, to controlling what users can do from the enrolled devices by using conditional access policies. If you are already managing devices by using a traditional device management tool such as Configuration Manager, you will be interested to know how you can seamlessly move to modern management, in which devices are managed by Intune, and how you can benefit from new device management capabilities, such as compliance, conditional access, and Windows Autopilot to deploy new devices from the cloud.  [-]

Learn how with Windows PowerShell 4.0, you can remotely manage multiple Windows based servers and automate day to day management and administration tasks.   Description This five day course provides students with the fundamental knowledge and skills to use Windows PowerShell 4.0 for administering and automating administration of Windows based servers. It focuses on primary Windows PowerShell command-line features and techniques, and will provide pre-requisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Exchange Server, SharePoint Server, SQL Server, System Center, and more. In keeping with that goal, this course will not focus on any one of those products, although Windows Server (which is the common platform for all of those) will serve as the example for the techniques being taught. In this course you will learn to execute and monitor scripts more efficiently through more robust session connectivity, workflow capabilities, enhanced job scheduling, and Windows PowerShell Web Access. Learn Windows PowerShell with greater ease through improved cmdlet discovery and simplified, consistent syntax across all cmdlets. Write Windows PowerShell scripts quicker and more intuitively through the new Integrated Scripting Environment (ISE) that enables script sharing, which connects IT pros to a larger Windows PowerShell user community. Learn all this and more in this five-day Microsoft Official Course in Windows PowerShell 4.0. The course is built on Windows Server 2012 R2 and Windows 8.1 and while it is specifically focused on Windows PowerShell v4.0, is also relevant in v2.0 and v3.0 Windows PowerShell environments. [-]

This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS. After completing this course, students will be able to: Describe the components, architecture, and nature of a BI solution Create a multidimensional database with analysis services Implement dimensions in a cube Implement measures and measure groups in a cube Use MDX syntax Customize a cube Implement a tabular database Use DAX to query a tabular model Use data mining for predictive analysis Module 1: Introduction to Business Intelligence and Data Modeling This module introduces key BI concepts and the Microsoft BI product suite. Lessons Introduction to Business Intelligence The Microsoft business intelligence platform Lab : Exploring a Data Warehouse After completing this module, you will be able to: Describe the concept of business intelligence Describe the Microsoft business intelligence platform Module 2: Creating Multidimensional Databases This module describes the steps required to create a multidimensional database with analysis services. Lessons Introduction to multidimensional analysis Creating data sources and data source views Creating a cube Overview of cube security Lab : Creating a multidimensional database After completing this module, you will be able to: Use multidimensional analysis Create data sources and data source views Create a cube Describe cube security Module 3: Working with Cubes and Dimensions This module describes how to implement dimensions in a cube. Lessons Configuring dimensions Define attribute hierarchies Sorting and grouping attributes Lab : Working with Cubes and Dimensions After completing this module, you will be able to: Configure dimensions Define attribute hierarchies. Sort and group attributes Module 4: Working with Measures and Measure Groups This module describes how to implement measures and measure groups in a cube. Lessons Working with measures Working with measure groups Lab : Configuring Measures and Measure Groups After completing this module, you will be able to: Work with measures Work with measure groups Module 5: Introduction to MDX This module describes the MDX syntax and how to use MDX. Lessons MDX fundamentals Adding calculations to a cube Using MDX to query a cube Lab : Using MDX After completing this module, you will be able to: Describe the fundamentals of MDX Add calculations to a cube Query a cube using MDX Module 6: Customizing Cube Functionality This module describes how to customize a cube. Lessons Implementing key performance indicators Implementing actions Implementing perspectives Implementing translations Lab : Customizing a Cube After completing this module, you will be able to: Implement key performance indicators Implement actions Implement perspectives Implement translations Module 7: Implementing a Tabular Data Model by Using Analysis Services This module describes how to implement a tabular data model in PowerPivot. Lessons Introduction to tabular data models Creating a tabular data model Using an analysis services tabular model in an enterprise BI solution Lab : Working with an Analysis services tabular data model After completing this module, you will be able to: Describe tabular data models Create a tabular data model Be able to use an analysis services tabular data model in an enterprise BI solution Module 8: Introduction to Data Analysis Expression (DAX) This module describes how to use DAX to create measures and calculated columns in a tabular data model. Lessons DAX fundamentals Using DAX to create calculated columns and measures in a tabular data model Lab : Creating Calculated Columns and Measures by using DAX After completing this module, you will be able to: Describe the fundamentals of DAX Use DAX to create calculated columns and measures in a tabular data model Module 9: Performing Predictive Analysis with Data Mining This module describes how to use data mining for predictive analysis. Lessons Overview of data mining Using the data mining add-in for Excel Creating a custom data mining solution Validating a data mining model Connecting to and consuming a data mining model Lab : Perform Predictive Analysis with Data Mining After completing this module, you will be able to: Describe data mining Use the data mining add-in for Excel Create a custom data mining solution Validate a data mining solution Connect to and consume a data mining solution [-]

This course (together with MD-101) will help you prepare for the new certification: Microsoft 365 Certified Modern Desktop Administrator.   Course content This 5 day course contains these modules: Installing Windows  Introducing Windows 10 Installation Options and Requirements for Windows Features Installation Process and Media Upgrading to Windows 10 Updating Windows Windows Servicing Model Updating Windows Applying Applications and Windows Updates Post-installation Configuration and Personalization Customize the Windows 10 UI Configure device specific settings such as power plans and mobile device options Use the Windows control panel and setting app to configure settings. Describe using Windows PowerShell Maintaining Windows 10  Configuring Peripherals, Drivers and Networking Managing Devices & Drivers and Printers Configure IP Network Connectivity Implement Name Resolution and Wireless Network Connectivity Remote Access Overview and Remote Management Configuring Storage Overview of storage options Using OneDrive Managing Disks, Partitions, Volumes and Storage Spaces Maintaining Disks and Volumes Managing Apps in Windows 10 Providing Apps to Users Managing Universal Windows Apps The Windows Store Web browsers in Windows 10 Configuring Authorization & Authentication Using Security Settings to Mitigate Threats Configuring User Account Control Implementing Device Registration Authentication Configuring Data Access & Usage and Advanced Management Tools Overview of File Systems Configuring and Managing File Access and Shared Folders Managing Security with Policies Configuring Tenant Roles Managing Tenant Health and Services Supporting the Windows 10 Environment Troubleshooting Windows Troubleshooting Tools Troubleshooting the Windows OS and Files & Applications Troubleshooting Windows Startup, Operating System Service Issues and Sign-In Issues File Recovery in Windows 10 Application Troubleshooting Troubleshooting Hardware and Drivers Troubleshooting Device Driver Failures and Physical Failures Overview of Hardware Troubleshooting [-]

Public Key Infrastructure (PKI) is a core service that facilitates authentication, encryption, and digital signing. This 4-day course teaches the skills required to design, operate, and maintain your PKI system. The training begins with an overview of cryptography and the working principals of algorithms. After gaining an understanding of certificates, you will learn about the considerations for designing a highly reliable Certification Authority structure. Practical implementation examples are given in both Windows and Linux environments. Use-cases show how PKI can be used for, among others, securing websites, encrypting storage, validating executable code, and protecting communication.   Course outline:  Cryptography Basics: Introduction to Cryptography: Symmetric Cryptography Asymmetric Cryptography Hash Functions Security Goals Usage Scenarios Encryption Signing Components of PKI Algorithms, Protocols and Standards DES and 3DES RSA Object Identifiers X.500, X.509 PKCS#10, PKCS# Understanding Certificates Structure and Content Extensions Getting Started with CAs: Using External CAs Self-signed Certificates CA Hierarchy Writing Policies Certificate Policy Certification Practice Statement Windows Server Certificate Security Choosing an Architecture Implementing a CA Hierarchy Certificate Templates Issuing Certificates Certificate Renewal OpenSSL on Linux Maintaining a CA Verifying and Monitoring Backup Certificate Revocation Reasons for Revocation Methods of Revocation Checking Practical Applications: SSL for Web Server Internet Information Services (IIS) Apache (optional) Certificate-based Authentication Authentication User Authentication vs Server Authentication Considering Smart Card Logon Virtual Private Networking (optional) Wi-Fi with 802.1x Encrypting File System (EFS) Local EFS Encryption EFS Within a Domain Recovery Securing E-Mail Certificate Requirements Signing in Outlook Encryption in Outlook Code Signing Time Stamping Signing PowerShell Scripts (optional) Signing Visual Studio Files (optional) Signing Office VBScript Code Other PKI-Enable Applications   [-]

Agenda for kurset: Er det egentlig så stor forskjell mellom bruk av switcher og routere? La oss finne det ut - vi implementerer nettverk med begge deler! VLAN er mye brukt. La oss få forståelsen og konfigurere nettopp dette! Har du konfigurert en Cisco router før? Basic konfigurasjon av router og routing tabell er på agendaen! Hva forteller en nettverksmasken 255.255.255.224 oss? La oss få oversikten over ulike nettverksmasker! Vi ser også på relevante verktøy ifbm feilsøking. [-]

This five-day intensive course enables participants to develop the expertise needed to audit an Information Security Management System (ISMS) and to manage a team of auditors by applying widely recognized audit principles, procedures and techniques. During this training, the participant will acquire the skills and knowledge needed to proficiently plan and perform audits compliant with the certification process of the ISO/IEC 27001:2013 standard. Based on practical exercises, the participant will develop the abilities (mastering audit techniques) and skills (managing audit teams and audit program, communicating with customers, conflict resolution, etc.) necessary to the efficient conducting of an audit. Les mer om kurset og agenda [-]

Vasking av lister Fjerne duplikater Tette hull i lister Dele kolonner Power Query Import av data Enkel behandling av data Bruk av data fra Power Query i Excel Pivottabeller i Excel Ulike kilder Effektiv bruk av pivot Beregninger: Akkumulering, prosentfordeling osv PowerPivot og Datamodell Laste data inn i Datamodell Lage ulike pivottabeller og pivotdiagram fra Datamodell Koble ulike tabeller Bruk av kalendertabell Nyttige funksjoner Excel til bruk ved rapportarbeid FinnRad, FinnKolonne, Indeks Sammenligne Forskyvning Dashboard og meny Lage hovedside men meny og slicers Bruk av Stiler og Tema Samle relevant informasjon til et sted [-]