Databas
Informators utbildningar inom databaser, med fokus på Microsoft SQL Server och Oracle, ger dig de färdigheter du behöver för att effektivt kunna jobba med implementation, konfiguration och administration men även med säkerhet, databasoptimering, business intelligence och mycket mer.
T618
Informationsbehandling med SQL
Detta är en utbildning för dig som behöver få en grundläggande förståelse för skapande och underhåll av databasstrukturer med hjälp av SQL (Structured Query Language). Du kommer att få lära dig SQL-språkets syntax, möjligheter, begränsningar och funktionalitet. Denna kurs är främst riktad mot systemerare och programmerare som ska kunna utveckla och underhålla applikationer mot en databas och avancerade användare som behöver kunna formulera och ställa egna frågor mot en databas.
Läs mer
SQL Server
T618
Informationsbehandling med SQL
Detta är en utbildning för dig som behöver få en grundläggande förståelse för skapande och underhåll av databasstrukturer med hjälp av SQL (Structured Query Language). Du kommer att få lära dig SQL-språkets syntax, möjligheter, begränsningar och funktionalitet. Denna kurs är främst riktad mot systemerare och programmerare som ska kunna utveckla och underhålla applikationer mot en databas och avancerade användare som behöver kunna formulera och ställa egna frågor mot en databas.
Läs mer
MS2791
Implementing and Maintaining Microsoft® SQL Server™ 2005 Analysis Services
This course teaches you how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.
Läs mer
MS2793
Implementing and Maintaining Microsoft® SQL Server™ 2005 Reporting Services
This course teaches you how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.
Läs mer
MS2792
Implementing and Maintaining Microsoft® SQL Server™ 2005 Integration Services
This course teaches you how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
Läs mer
MS2780
Maintaining a Microsoft SQL Server 2005 Database
This course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.
Läs mer
SQL Server 2008
MS6158Adm
SQL Server 2008 Update för IT-proffs
Denna två dagar långa utbildning går igenom de nyheter som kommer i SQL Server 2008 och som påverkar dig som jobbar som tekniker.
Läs mer
MS6158BI
SQL Server 2008 Update - Business Intelligence
Denna utbildning går igenom de nyheter som kommer i SQL Server 2008 inom Business Intelligence.
Läs mer
MS50263
Introduction to Microsoft Business Intelligence from SQL 2008 through SharePoint and Office 2007
This instructor-ledcourse provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 in an integrated environment with SharePoint and Office 2007. The course introduces the students to Microsoft Unified Data Model, SQL 2008 Analysis Services, Integration Services, Reporting Services, Report Builder 2.0, SharePoint 2007 Integration, Reporting Services Content Types, Business Data Catalog, and Business Intelligence with Excel 2007 and V
Läs mer
T1014
MCTS SQL 2008 Business Intelligence - Bootcamp
Vi erbjuder nu en nedkortad men intensiv 5 dagars kurs med genomförande av certifieringstest och analys av detta på sista dagen. Ni får tillgång till kursmaterial innan kursstart för att kunna vara så väl förberedda som möjligt. Tiderna för genomförande under de 4 kursdagarna är ca 09.00-18.00.
Läs mer
MS6231
Maintaining a Microsoft SQL Server 2008 Database
Denna utbildning på fem dagar lär dig att installera, konfigurera och administrera en SQL Server 2008-databas. Utbildningen går bland annat igenom viktiga delar som backup och restore, säkerhet, replikering och övervakning.
Läs mer
MS6232
Implementing a Microsoft SQL Server 2008 Database
Denna utbildning lär dig att effektivt och problemfritt implementera en SQL Server-databas. Utbildningen går bland annat igenom viktiga delar som stored procedures, optimering av index och implementering av dataintegritet.
Läs mer
MS6235
Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
Denna tre dagar långa utbildning lär dig att utveckla, implementera och administrera en integrationslösning baserad på SQL Server Integration Services.
Läs mer
MS6234
Implementing and Maintaining Microsoft SQL Server2008 Analysis Services
Denna tre dagar lång utbildning lär dig att bygga en Analysis Services-lösning. Du får lära dig att designa din databas och hur du bygger OLAP-kuber. Du får även lära dig att effektivt administrera en sådan lösning.
Läs mer
MS6236
Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
Denna utbildning på tre dagar lär dig att implementera en Reporting Services-lösning. Du får lära dig att skapa rapporter, att jobba effektivt med data och även att effektivt administrera en sådan lösning.
Läs mer
MS6315
Designing, Optimizing, and Maintaining a Database Administrative Solution for Microsoft SQL Server 2008
Denna utbildning är lär dig att designa och sjösätta avancerade infrastrukturella lösningar med SQL Server. Utbildningen riktar sig mot erfarna SQL Server-administratörer som vill lära sig mer om design och best-practices.
Läs mer
MS6314
Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008
Denna utbildning lär dig att designa och utveckla avancerade business intelligence-lösningar med hjälp av SQL Server. Kursen riktar sig mot erfarna BI-utvecklare som vill lära sig mer om design och best-practices.
Läs mer
MS10337
Updating Your SQL Server 2008 BI Skills to R2
The primary audience for this course is developers who have knowledge of Business Intelligence (BI) concepts, with an experience of 3-4 years in BI. The audience has an understanding of how to use SQL Server 2008 BI tools to implement a BI infrastructure and solution.
Läs mer
MS50350
Developing Spatial Data Solutions With Microsoft SQL Server 2008
This one-day instructor-led course provides students with the knowledge and skills to create database solutions that use spatial data in Microsoft SQL Server 2008. The course introduces developers to spatial data concepts and the geography and geometry spatial data types in SQL Server 2008. It then describes how to use these data types to store geographic and location-based data and to perform spatial operations and queries. Finally, the course describes how to integrate spatial data in SQL Serv
Läs mer
T1011
Mastering SQL Server 2008, featuring Clustering
Lär dig sätta upp olika lösningar med hög tillgänglighet för Windows Server och SQL Server. Under labben går vi igenom skillnader och likheter mellan de olika lösningarna. Vad är för- och nackdelarna med de olika teknikerna? Syftet med labben är att hjälpa dig göra rätt teknikval för ditt behov och lära dig att sätta upp den lösningen.
Mattias Lind har jobbat med SQL Server och Windowsinfrastruktur sedan mitten av 90-talet. Han har kunder över hela skalan -
Läs mer
Oracle Database Server 10g
OR128
Oracle Database 10g: Security Release 2
In this course, the students learn how they can use Oracle database features to meet the security and compliance
requirements of their organization. The current regulatory environment of the Sarbanes-Oxley Act, HIPPA, the UK Data
Protection Act, and others requires better security at the database level. Students learn how to secure their database
and how to use the database features that enhance security. The course provides suggested architectures for common
problems.
Läs mer
OR135
Oracle Enterprise Manager 10g Grid Control Release 2
Oracle Enterprise Manager 10g Grid Control delivers centralized management functionality for the complete Oracle IT infrastructure, including systems running Oracle and non-Oracle technologies. With a broad set of administration, configuration management, provisioning, end-to-end monitoring, and security capabilities, Oracle Grid Control reduces the cost and complexity of managing grid computing environments.
Läs mer
OR144
Oracle Spatial: Essentials
The course extensively covers the concepts and usage of the native data types, functions and operators available in
Oracle Spatial for implementing geospatial applications and location-based services.
Läs mer
OR155
Advanced Oracle 10g Performance Analysis and Tuning with Kyle Hailey
This two day Oracle 10g Performance Tuning seminar will teach attendees how to fully harness the powerful new performance tuning and diagnostic tools in Oracle 10g.
Attendees will learn techniques in order to gain the necessary skills and knowledge to finally conquer their database woes, thus allowing more time and freedom for you.
Läs mer
OR117
Oracle Database 10g: Administration Workshop II Release 2
This course advances your success as an Oracle professional in the area of database administration. In this class, you'll learn how to configure an Oracle database for multilingual applications. You will practice various methods of recovering the database using RMAN and Flashback technology. Database performance monitoring tools will be covered, in addition to the steps to take to resolve common problems and improve performance.
Läs mer
OR116
Oracle Database 10g: Administration Workshop I Release 2
This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another.
Läs mer
OR118
Oracle Database 10g: Backup and Recovery
After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. They learn how to use RMAN and Enterprise Manager to perform backup and recovery operations. Flashback features are described as an additional way to recover from human error.
Läs mer
OR119
Oracle Enterprise Manager 10g Grid Control Release 2
Oracle Enterprise Manager 10g Grid Control delivers centralized management functionality for the complete Oracle IT infrastructure, including systems running Oracle and non-Oracle technologies. With a broad set of administration, configuration management, provisioning, end-to-end monitoring, and security capabilities, Oracle Grid Control reduces the cost and complexity of managing grid computing environments.
Läs mer
Oracle Database Server 11g
OR120
Oracle Database 11g: Administration Workshop I Release 2
This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic
database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a
conceptual understanding of the Oracle database architecture and how its components work and interact with one
another. You will also learn how to create an operational database and properly manage the various structures in an
effective and efficient manner
Läs mer
OR121
Oracle Database 11g: Administration Workshop II
In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios.
Läs mer
OR122
Oracle Database 11g: Performance Tuning
Students learn how to use Oracle Database 11g automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement performance, and tuning the Oracle Database Instance components. Throughout the course, students practice the art of tuning an Oracle Instance through a
Läs mer
OR123
Oracle Database 11g: 2 Day DBA
The goal of this course is to teach Database Administrators how to install the Oracle Database 11g software and perform the tasks required to manage an Oracle database. Enterprise Manager is used throughout to teach students how to quickly accomplish the required task. Emphasis is on the self-managing capabilities and automatic features of Oracle Database 11g. This course is targeted towards Database Administrators of small to medium sized businesses.
Läs mer
OR124
Oracle Database 11g: New Features for Administrators
This five-day classroom course gives you the opportunity to learn about and practice with the new change management
features and other key enhancements in Oracle Database 11g Release 1 and Release 2.
Läs mer
OR125
Oracle Database 11g: RAC Administration
This course offers students an introduction to the general features and capabilities of Oracle Database 11g Release 1 for Oracle Real Application Clusters (RAC). Students learn how to install and administer Oracle Clusterware, Real Application Clusters, and Automatic Storage Management. Students also learn how to administer their Database in a Real Application Clusters environment using Enterprise Manager Grid Control.
Läs mer
OR126
Oracle Database 11g: Implement Streams
Oracle Streams allows students to share data, messages, and events between schemas, applications, and databases. This course includes lessons on the fundamental components of Oracle Streams and how to administer each of these components. The lessons are designed to give students practical experience in configuring and managing a Streams environment. The course covers enqueue and dequeue messages using Oracle Streams. Also included are best practice guidelines and troubleshooting practices.
Läs mer
OR127
Oracle Database 11g: Data Guard Administration
In this course, students learn how to use Oracle Data Guard to help protect their Oracle database against planned and unplanned downtimes. They also learn how Data Guard standby databases can be used to support production functions such as reporting, querying, and testing, while in a standby role. The course includes Data Guard architecture, the configuration of physical and logical standby databases, and role transitions.
Läs mer
OR154
Oracle Database 11g: Security
In Oracle Database 11g: Security course students learn how they can use Oracle database features to meet the
security, privacy and compliance requirements of their organization. The current regulatory environment of the
Sarbanes-Oxley Act, HIPAA, the UK Data Protection Act, and others requires better security at the database level.
Läs mer
OR129
Oracle Database 11g: Introduction for Experienced SQL Users
In this course students with previous ANSI SQL experience are introduced to the Oracle Database 11g environment,
SQL Developer, the SQL language and extensions to the ANSI SQL standard.
Läs mer