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.
Nya utbildningar för SQL Server 2012: http://www.informator.se/sql_server.aspx
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
MS10778AB
Implementing Data Models and Reports with Microsoft SQL Server 2012
Students will learn how to implement PowerPivot and tabular data models, create and deliver rich data visualizations with Project Power View and SQL Server Reporting Services, and discover business insights by using data mining
Läs mer
MS10775A
Administering Microsoft® SQL Server® 2012 Databases
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.
Läs mer
MS10776A
Developing Microsoft® SQL Server® 2012 Databases
This 5 day course covers implementing a Microsoft SQL Server 2012 Database. It covers core database development and implementation skills required for SQL Server. While based on SQL Server 2012
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
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 Server 2008 Analysis Services
Denna tre dagar långa 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
T1014
MCTS SQL 2008 Business Intelligence - Bootcamp
Vi erbjuder nu en nedkortad, intensiv femdagarsutbildning 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
MS2778B
Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
Läs mer
MS50399A
Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008
This five-day instructor-led course provides in-depth knowledge on designing a Business Intelligence solution by using Microsoft SQL Server 2008.
Läs mer
MS50400A
Designing, Optimizing, and Maintaining a Database Administrative Solution for Microsoft SQL Server 2008
This five-day instructor-led course provides the knowledge and skills to design, optimize, and maintain a database administrative solution for Microsoft SQL Server 2008.
Läs mer
MS50401A
Designing and Optimizing Database Solutions with Microsoft SQL Server 2008
This five-day instructor-led course provides the knowledge and skills that IT Professionals need to design, optimize, and maintain SQL Server 2008 database.
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
TRS2028
Administrera SQL Server 2008 R2
Skaffa dig riktig, verklighetsbaserad kunskap kring SQL Server 2008 R2 och hur du skapar optimala lösningar för datalagring. Den här labben kommer att ge dig en fördjupad förståelse för hur SQL Server fungerar och hur du ska göra för att den ska leverera en optimal lösning för de behov som du har.
Läs mer
MS50490
Advanced SQL Server 2008 R2: Implementing and Managing High Availability Database Server Deployments
This three-day instructor-led course provides students with the knowledge and skills to help manage their highly-available Microsoft SQL Server 2008 R2 database server deployment. The Microsoft SQL Server 2008 R2 High-availability features include: Failover Clustering, Database Mirroring, Peer-to-peer Replication, and Log Shipping. This course presents various demos and hands-on labs to ensure that the students understand the considerations for the various high-availability solutions available w
Läs mer
MS50487
Advanced SQL Server 2008 R2: Tuning a Scalable and Performance-Optimized Database Environment
This three-day 300-400 level Instructor-Led Training course focuses on performance and tuning tasks: architecture, memory, waits and events, storage, CPU, DML processing, concurrency, TempDB considerations, and diagnostics toolsets in a scale-up or scale-out infrastructure. Throughout the course, students practice the art of tuning many key components of the SQL Server 2008 R2 environment through a series of labs and demonstrations. Performance and tuning best practice methodologies are emphas
Läs mer
MS50489
Advanced SQL Server 2008 R2: Building a Secure Database Environment
The three-day 300-400 level Instructor-Led Training course focuses on the various security features available in SQL Server 2008 R2 to help you satisfy your compliance requirements, whether from from HIPAA, PCI DSS, Sarbanes-Oxley Act, or any other industry governing body. Throughout the course students practice applying the security principles with various tools in the SQL Server 2008 R2 environment through a series of labs and demonstrations.
Läs mer
MS50488
Advanced SQL Server 2008 R2: Managing and Monitoring Database Server Deployment
This three-day instructor-led 300-level course provides students with the knowledge and skills to help efficiently manage their Microsoft SQL Server 2008 R2 database server. The Microsoft SQL Server 2008 R2 Manageability features include: policy-based management, storage optimization, resource governance, and automating administrative tasks.
Läs mer
Oracle Database Server 10g
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
Oracle Database Server 11g
OR167
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Release 2
In this intensive course, students will learn about the Oracle Grid Infrastructure products. This includes Oracle Automatic Storage Manager (ASM), ASM Cluster File System and Oracle Clusterware. Students will also learn to administer the Oracle Clusterware and storage products using both command line utilities and graphical tools. Administration of ASM and ACFS will be done using both command line and graphical user interface clients.
Läs mer
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.
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.
Läs mer
OR123
Oracle Database 11g: 2 Day DBA Ed 2
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.
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