ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

IBM Informix Red Brick Warehouse Administration V6.30 - Instructor Led Online  (3X500)

Format: Formation virtuelle avec formateur
Autres formats:
 
 

ILO classes are closed to further enrollment 5 business days before the start of class so that we can ensure students will have their materials on time. Please enroll in the next offering if the class start date is less than 5 days from today. This is an online course. Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs. Gain practical, hands-on experience with building, loading, indexing, administering, and monitoring an Informix Red Brick Decision Server database. Learn how to create, load, and index database tables, how to segment table and index data, and how to define database users and roles. Learn how to use querypriority concurrency to decrease the load window.

 
 

Compétences acquises
 

  • Describe a database vs. a data warehouse

  • Analyze a Sample Customer Case Study

  • Create an IBM Informix Red Brick Data Warehouse

  • Connect to a database through Open Database Connectivity (ODBC)

  • Create and assign authorizations and permissions to users

  • Create, Load, Unload and Segment Red Brick tables

 

  • Create indexes using Red Brick index technology

  • View system tables as you progress through the exercises

  • Monitor database activities

  • Use the IBM Informix Red Brick Warehouse Administration Tool

  • Use Red Brick Intelligent SQL (RISQL) commands

  • Use VI editor to create files on the server

Qui peut en profiter
  This intermediate course is for DBAs that monitor, maintain and load the Red Brick Warehouse.

Préalables
  You should have met the following prerequisites:
 

  • Structured Query Language

 

  • Fundamental knowledge of the UNIX operating system

IBM Education Advantage Program Eligibility
 

  • Yes- IBM Education Pack - Online account

 
     
    Enroll For This Class
    Enroll For This Class
    DB2 Lotus Tivoli Training Class Ce cours est donné par des formateurs certifiés IBM.

    À titre de partenaire en formation agréée , ExitCertified peut vous inscrire à n’importe quel cours en Amérique du Nord.

    Il y a une différence. Découvrez-la
    Training Class Enrollment Ask A Question About This Training
    Code: 3X500
    Format: Formation virtuelle avec formateur
    Durée: 4 days
    Certifié par: IBM
    Frais d’inscription (CAD): 2,860$
    TrainingIndustry.com selects ExitCertified as a Top 20 IT Training Company for 2011
    Recherchez des cours semblables
    Cours connexes

    Trier l'horaire par: 
    No Course Dates Ce cours n'est pas prévu à l'horaire pour l'instant. Si vous êtes intéressé à suivre ce cours, utilisez le lien ci-dessous pour demander une date.
       
    demander la date/l’emplacement demander de la formation sur place
     

    IBM Informix Red Brick Warehouse Administration V6.30 - Instructor Led Online  (3X500) Contenu détaillé
     
     
    Data Warehouse Overview and Design
    • Outline the basics of data warehouse design
    • Outline relational database fundamentals
    • Define dimensional modeling
    • Describe a star schema
    • List possible data sources
    IBM Informix Red Brick Architecture
    • List the software, hardware and functional components of a Red Brick data warehouse
    • State the requirements for building an application with the Red Brick JDBC driver
    • Use the correct syntax to start and stop the Red Brick Warehouse server
    • List and define each of the Red Brick processes
    • List the steps to upgrade a Red Brick database
    IBM Informix Red Brick Data Warehouse and Database
    • Describe a Red Brick Data Warehouse
    • File structure
    • Ownership
    • Describe an individual database
    • File structure
    • Ownership
    • Create a database
    • Verify and connect to the new database
    IBM InformixRed Brick Users and Security
    • List levels of security
    • Describe each of the pre-defined system roles
    • Create and delete Red Brick users
    • Create roles
    • Assign authorizations and object privileges to users and roles
    • List password security options
    • View the user authorization system table
    IBM InformixRed Brick Tables
    • List the components of a user-created table
    • List available column datatypes
    • Outline the benefits of variable character columns
    • Describe fillfactor when used with variable character columns
    • Create and alter Aroma tables
    • View system tables to verify database content
    • Describe and create temporary tables
    • Define referential integrity and how it is established
    • Create all of the tables within the Aroma schema
    		 
    Table Segmentation
    • Explain the purpose of segmentation
    • Differentiate between logical and physical allocations
    • Identify default segment names and sizes
    • Create named segments for table data and indexes
    • Assign segments to tables and indexes
    Basic Table Loading Options
    • List the methods used to load data into a table
    • Use the INSERT, UPDATE, and DELETE commands
    • List the Table Management Utility control file clauses
    • Demonstrate many of the Table Management Utility (TMU) capabilities
    • Describe the purpose of Automatic Row Generation
    • Describe the benefits of an optimized load
    Advanced Table Loading Options
    • Describe Serial vs. Parallel load processing
    • Monitor load activity within the warehouse
    • Unload table contents using TMU and High-Speed Export
    • Create and manipulate files generated during an unload
    • Describe the Query Priority Concurrency feature
    • Describe the purpose of Frozen Versions of a database
    IBM InformixRed Brick Index Technologies
    • Name and describe each Red Brick index
    • Describe each of the index block structures
    • Explain the best implementation of each available index
    • Create indexes for the Aroma tables
    • Describe and use fill factors for indexes
    • Interpret index build processing
    • Choose the correct option when creating and building indexes
    • Use the EXPLAIN utility
    Data Warehouse Maintenance
    • Monitor database and user activity
    • Set and change configuration parameters
    • Alter database objects
    • Alter database access and events
    • Make use of Red Brick utilities


      ExitCertified is your Authorized IT Training Partner  
      Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

    Il y a une différence. Apprenez directement de la source.    		  
    Training Contacts  
       
    Canada United States

    Formation à Montréal :: 514.876.1666
    Formation à Ville de Québec :: 514.876.1666
    Formation à Ottawa :: 613.232.3948
    Formation à Toronto :: 416.487.3948

    Formation à Vancouver :: 604.633.3948
    Formation à Victoria :: 1.866.328.3948
    Formation à Calgary :: 403.291.2855
    Formation à Edmonton :: 780.441.3948
    Formation à Regina :: 1.866.328.3948

    		 Formation à Sacramento :: 916.669.3970
    Formation à San Francisco :: 415.975.3948
    Formation à San Jose :: 408.288.3948
    Formation à Las Vegas :: 1.800.803.3948
    Formation à Phoenix :: 602.889.9350
    À travers le monde - 613.232.3948 Des questions?
    Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
       



    (c) 2012 ExitCertified Corp. Tous droits réservés.


    ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
     
    Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
    Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
             
    Formation MySQL Formation Apple Formation en gestion de projet    
    Base de données MySQL Cours Apple, Formation Leopard Formation du PMI