Browse communities
Presenting a webinar?
Share this content

DB2 Tech Talk: Part Two Certification Prep for DB2 10 Fundamentals Exam

Serge Rielau (host), Andre Albuquerque (presenter)
Validated DB2 skills help you stand out with your employer, meet annual education objectives, and create an edge in the employment marketplace.

IBM is offering the all new DB2 10.1 Fundamentals Certification (exam 610) to attendees of the Information on Demand global conference in Las Vegas, Nevada from October 21 – 25, 2012. And if you are not attending the conference, IBM is offering the Take it Again promotion through November 30, 2012.

This two-part Tech Talk can help you prepare for the exam. Part one was presented on Thursday July 26 from 12:30 to 2:00 PM ET. Part two is presented on Thursday August 2nd from 12:30 – 2:00 PM ET.

Basics of the DB2 products and tools, DB2 pureScale feature, plus data warehousing and OLAP concepts

·Security including authentication, authorization and privileges, and the new Row and Column Access Control (RCAC) feature

·Working with databases and database objects including use of DDL statements to create objects

·Accessing data using SQL, to query data including XML data with XQuery, and use of Time Travel Query with temporal tables

·Working with tables, views and indexes including XML and Oracle compatibility data types and the new temporal tables

·Data concurrency mechanisms


This talk is hosted by Serge Rielau, SQL architect for DB2 for LUW, with presentations by experienced DB2 instructor Andre Albuquerque.

The time is 12:30 PM ET, however note that your view may present in your local time zone.
Aug 2 2012
87 mins
DB2 Tech Talk: Part Two Certification Prep for DB2 10 Fundamentals Exam
DB2 10 certification
More from this community:

Cloud Computing

Webinars and videos

  • Live and recorded (2728)
  • Upcoming (82)
  • Date
  • Rating
  • Views
  • Perchè i Server? La Protezione dei sistemi critici
    La sicurezza dei server è un asset fondamentale per abilitare il business. Non solo per le informazioni che gestiscono ma anche per i servizi per i quali sono configurati. Pianificarne la sicurezza e la conformità è l’unico strumento per per ridurre il rischio in caso di attacco
    In questo webcast approfondiremo i vantaggi delle soluzione end point protection ed anche di server hardening
    Partecipa a questo webcast per pianificare al meglio la tua politica di Cyber Security.
    Read more >
  • Join Amazon Web Services for the sixth in our series of webinars, 'Journey Through the AWS Cloud'. This complimentary webinar discusses the use of AWS as a storage and archive platform.

    A wide range of assets can be cost effectively held in highly durable storage systems within the AWS cloud, for global distribution, long term storage or cold archive. Learn about a range of use cases for the Amazon Simple Storage Service (S3) beyond simple object storage, and how Amazon Glacier can revolutionise long term archive economics and technology.
    Read more >
  • CA Technologies is committed to helping you make Here's a quick look at how CA Technologies is intensely focused on their customers--how they're helping them do more, making their job better, more fun, and freeing up their time with innovative action. Learn more at http://www.ca.com/mainframe
    Read more >
  • In the last 10 years, hacking has become big business with a well organised infrastructure, defined roles and responsibilities, and sophisticated attack vector automation that generates large-scale attacks of unprecedented size, speed and devastation. Advanced protection is needed in order to successfully stand up to the ‘industrialisation of hacking’. In this webinar, Andy will talk about:

    - How to prevent web attacks like SQL injection, cross-site scripting, app DDoS or site scraping.

    - The limitations and vulnerabilities associated with IPS solutions and other traditional security solutions.

    - Attack-mitigation techniques for combating malware including bots and other automated attacks common in industrialised hacking.

    - How to protect networks from the ‘compromised insider’ threat.

    About the speaker:
    Mark has 18 years’ experience in the IT industry, and has specialised in Internet security systems for more than 16 years. Mark is a passionate evangelist for technology and is multi-skilled across a broad range of security solutions including Firewalls, VPNs, IPS, WAF, web and email content filtering, SIM/SIEM, load balancing, DLP, risk assessment, monitoring tools, DB security and consultancy. Mark joined Imperva in 2007 and held previous technical roles at Nokia and contracted as a security specialist where he has held senior roles designing and implementing firewall, IDP and VPN solutions in mission critical environments.
    Read more >
  • Come avvengono gli attacchi? 5 STAGES OF A DATA BREACH
    Per proteggere le aziende da attacchi informatici, è importante capire come operano gli attacanti. Questo webcast descrive l’anatomia di un attacco nelle sue 5 fasi: Reconnaissance, Incursion, Discovery, Capture ed Exfiltration
    Verranno inoltre analizzate le principali tecniche impiegate e le soluzioni per prevenirle e/o contrastarle oltre al relativo impatto sul business (rilevato dalla ricerca “Cost of a Data Breach 2013”)
    Partecipa a questo webcast per vedere come si sono evolute le cyber minacce e come stanno influenzando le realtà produttive.
    Read more >
  • Cosa sta DAVVERO succedendo? Il Security Threat Report
    Il Security Threat Report fornisce una panoramica e un'analisi di attività delle minacce a livello mondiale nel 2012. Dai dati della Global Intelligence Network, esperti di Symantec analizzano le tendenze emergenti negli attacchi, nelle vulnerabilità e negli obiettivi.
    Inoltre, l’ultima ricerca “Cost of a Data Breach Report 2013” traccerà gli impatti economici per le organizzazioni nel caso di attacchi informatici
    Partecipa a questo webcast per avere un aggiornamento sul panorama delle minacce e della sicurezza nel 2013 e sulle conseguenze nel business.
    Read more >
  • Pour limiter les risques d’une cyber-attaque, la politique de sécurité doit comprendre la mise en place d’une politique de supervision incluant la surveillance des vulnérabilités, la corrélation des événements de sécurité, les procédures de réponse en cas d’attaque… Lors de ce webcast, nous vous invitons à faire le point sur les solutions de SOC, SSIEM, Services Managés et leurs bénéfices.
    Read more >
  • Join Raj for a complete regulatory overview including:

    - HIPAA Omnibus Update
    - FTC Health Breach Rule
    - Top 5 reasons organizations FAIL Security Assessments
    - Case Studies
    - Guidance
    - Success Stories
    Read more >
  • Enterprise Storage moving toward the cloud requires an interoperable interface foundation to avoid vendor lock-in and provide choice. This tutorial will provide an overview of the features of a Enterprise cloud storage standard and explain how interoperability between clouds is achieved.

    What should you be requiring from your cloud vendors?
    How can you expect standards to roll out in implementations?

    Learning Objectives
    How this cloud storage standard can achieve interoperability and what this interoperability means to you.
    How you can use the cloud storage standard both internally for private clouds as well as for public clouds.
    Read more >
  • Virtualization, cloud computing, hybrid environments and BYOD are here to stay. When implemented successfully, these solutions can transform the way businesses operate and lower the OPEX and CAPEX costs of IT departments. However, these major IT trends cannot be considered separately: virtualization and cloud are often linked, and needs for anytime anywhere connectivity and mobile workforce enablement won't wait. This is why it's essential to have a holistic approach and address the business, technology and financial implications of today for tomorrow's needs.


    Dell has quickly become one of the largest and fastest growing networking providers in the world by leveraging its extensive expertise in the data center to build a complete portfolio of switches that are designed to be open, flexible, powerful and economical.
    Read more >
You might also like: Big Data and the Analysis Conundrum
  • Channel
  • Channel profile

IDUG DB2 Tech Channel

Up Down
  • DB2 Tech Talk: Adopt BLU Acceleration in DB2 10.5 the Faster Easier Way Jul 25 2013 4:30 pm UTC 90 mins
    DB2 BLU Acceleration allows for “Speed of Thought” analytics designed to handle data-intensive analytics workload. It extends the capabilities of traditional in-memory systems by providing in-memory performance even when the data set size exceeds the size of the available memory.

    BLU Acceleration introduces a new column organization for table storage along with parallel data analysis and added compression.
    Learn about the use InfoSphere Optim tooling to allow for faster and easier adoption of BLU Acceleration that will provide the following:
    - Monitor the system performance before the adoption
    - Capture of the workload on the pre-adoption DB2 system
    - Recommend which tables are the best candidates to convert to columnar organization as well as obtain estimates on how much improvement you can expect
    - Automatically apply the conversion to adopt the new technology
    - Re-monitor and validate the results after conversion.

    This webcast will demonstrate an end-to-end scenario of how the tools can be used to make the adoption of BLU Acceleration technology faster and easier.
  • DB2 Tech Talk: DB2 pureScale + HADR for Always Available Transactions, DB2 10.5 Jun 20 2013 4:30 pm UTC 90 mins
    Join IBM architect Aamer Sachedina for an in-depth discussion of the enhancements in DB2 10.5 that help ensure "always available" transactions. DB2 pureScale provides two major functions: enables capacity scaling without application change; and provides an always available environment so that transactional workloads, queries and other tasks continue uninterrupted in case of unplanned downtime. Now in DB2 10.5, several enhancements work with DB2 pureScale to ensure the ultimate in availability and disaster recovery for transactional workloads.

    In addition to providing a DB2 pureScale refresher, Aamer will cover the new enhancements including:

    • Integration with DB2 high availability disaster recovery (HADR) functionality, to provide pureScale cluster mirroring remotely or locally to a standby server, thus enabling minimal impact to critical transaction systems

    • Support for rolling maintenance updates, which is the ability to maintain individual machines in the cluster without impacting the user experience

    Join us to learn the technical details behind these enhancements and how they help to ensure "always available" transactions.
  • DB2 Tech Talk: Deep Dive on BLU Acceleration in DB2 10.5, Super Easy Analytics Recorded: May 30 2013 89 mins
    Join DB2 expert Sam Lightstone for an in-depth discussion of the all-new BLU Acceleration features in DB2 10.5 for Linux, UNIX and Windows. BLU Acceleration is designed to deliver results from data-intensive analytic workloads with speed and precision that is termed "speed of thought" analytics.

    In this Tech Talk, Sam will explain the details of this ground-breaking technology such as:

    •Dynamic in-memory analytics that do not require all of the data to fit in memory in order to perform analytics processing

    •Parallel vector processing, driving spectacular CPU exploitation


    •Enhanced columnar storage techniques, including supporting the coexistence of row-organized and column-organized tables in the same database, and even in the same workload and SQL

    •Actionable compression that does not require data to be decompressed in order to be analyzed, plus intelligent pre-fetch capabilities

    ... and more! Join us to learn the technical details behind this exciting advancement and find out why it makes super analytics, super easy to perform.
  • DB2 Tech Bit: Iqbal Goralwalla and Jean-Marc Blaise on DB2 BLU Acceleration Recorded: May 15 2013 25 mins
    Listen to this brief webcast of the impressions these two IBM Champions have after evaluating DB2 10.5 with BLU Acceleration.
  • DB2 Tech Talk: Introduction and Technical Tour of DB2 with BLU Acceleration Recorded: May 8 2013 90 mins
    Join Distinguished Engineer and DB2 expert Berni Schiefer and host Rick Swagerman for a technical tour of the all new DB2 10.5 with BLU Acceleration software. You will learn about new features such as:

    •BLU Acceleration, for “Speed of Thought” analytics
    Designed to handle data-intensive analytics workloads, BLU Acceleration extends the capabilities of traditional in-memory systems by providing in-memory performance even when the data set size exceeds the size of the memory. Learn about RAM data loading capabilities, plus “data skipping”; parallel data analysis; actionable compression for analysis without decompressing data and more.

    • New DB2 pureScale capabilities that enable online rolling maintenance updates and capacity growth with no planned downtime, plus new integration HADR capabilities to help ensure always available transactions.

    • SQL and Oracle Database compatibility refinements in DB2 10.5, helping to ensure fast, easy moves to DB2 as well as increased flexibility for DB2 applications.

    • Enhancements to NoSQL technologies that are now business-ready in DB2 10.5. Although not part of the DB2 10.5 announcement, we will fill you in on other No SQL technology introduction plans as well.

    • New packaging editions of DB2 that that handle either OLTP or data warehousing needs.

    • DB2 tools advances that support these new functions.

    Join us for this Tech Talk to find out about these exciting enhancements and how they can help you deliver the data analytics your organization needs while providing tools to keep your OLTP systems in top shape.
  • DB2 Tech Bit: IBM Champ Tony Winch on DB2 10.5 with BLU Acceleration Recorded: May 2 2013 16 mins
    In this brief Tech Bit, IBM Champion Tony Winch speaks on his impressions of DB2 10.5 with BLU Acceleration.
  • IDUG North America 2013 - Conference Orientation Program Recorded: Apr 12 2013 44 mins
    IDUG North America 2013 - Conference Orientation Program
  • DB2 Tech Talk: Real-World Data Warehousing for Tech Pros: Current and Coming Recorded: Mar 28 2013 76 mins
    Data warehousing is a rapidly growing and exciting area of technology because warehouse applications provide insightful information. In turn, these insights result in an operational or marketplace advantage for the organization.

    While keeping the OLTP systems in top condition is a full time focus for many, warehousing has become a must-have skill. Through this technical webcast, you can quickly expand your level of understanding on data warehousing technologies.

    Join Jessica Rockwood, IBM warehouse development and performance expert, to learn the current technologies in warehousing and what is needed in the future. Jessica will review core principles - the why, what, and how of warehousing. Then, she’ll cover current day challenges and the new capabilities needed for warehouses of the future.

    Attend this talk to expand your warehousing knowledge.
  • DB2 Tech Talk: Realtime Decision Making PureData Systems for Op Analytics Recorded: Feb 28 2013 85 mins
    Join architect James Cho for an in-depth discussion of this new tool for realtime operational warehousing that can help your organization speed the decision making process. You will learn when to use an operational warehouse for realtime decision making, for example fraud detection. James will also explain the features and advantages of this expert integrated system -- simplified deployment and maintenance and more.

    Please note this talk is being delivered at 12:30 PM ET. You may see a different time presented depending the default CT zone or the time zone you indicate when you register.
  • DB2 Tech Talk: DB2 in a Big Data World: NoSQL, XML & More Recorded: Jan 31 2013 88 mins
    Big Data is a hot topic today because it is now possible to analyze 'all' available data and derive meaningful insights. This includes a massive volume of both structured and unstructured data from standard relational databases to internet chatter, to device-derived data such as sensors and more.

    While DB2 is commonly associated with relational data, it is able to handle many other data types. XML data support has been available for several releases and in DB2 10 RDF Graph Store has been introduced for building next-generation applications.

    This Tech Talk will hit on features in DB2 10 that make it suitable for certain types of Big Data applications. It will also cover capabilities in other product offerings in the IBM Big Data portfolio and how they integrate with and compliment DB2.

    Our presenters are Rav Ahuja, a DB2 on cloud expert and Big Data evangelist as well as Mario Briggs who is the developer for the RDF technologies in DB2 10.
  • IDUG Tech Talk: What Matters Next in Big Data? Recorded: Jan 4 2013 43 mins
    This was the keynote presentation at IDUG EMEA 2012 Technical Conference. With the recent focus on Big Data, new technologies have emerged to help deal with the massive growth of structured and unstructured information. But what does this mean for the future of traditional database technologies? How do we prepare for it? And how might it affect our careers as data professionals? David Barnes, Program Director for IBM’s Emerging Internet Technologies group, will address those questions and more. David will also discuss how analytics are affecting our data strategies, and how to adapt your skills to the world of Data Science.
  • DB2 Tech Talk: Inside Row and Column Access Control for DB2 10 for LUW Recorded: Dec 12 2012 61 mins
    Many organizations are struggling to comply with data security and compliance mandates, while also reducing costs. With the new row-permission and column-mask features, IBM DB2 10 takes security and ease of use to the next level.

    Join IM Information Management Chief Security Architect Walid Rjaibi for a deep dive technical discussion of the new Row and Column Access Control (RCAC) features in DB2 10 for Linux UNIX and Windows and InfoSphere Warehouse 10. Walid will also teach you proven methods to implement data security in the most cost-effective way.
  • IDUG Tech Talk: DB2 for z/OS Performance and Cost Savings Recorded: Nov 29 2012 61 mins
    IBM Gold Consultant and Champion Cristian Molaro discusses best practices on why where and how to achieve performance and cost savings on DB2 10 for z/OS.
  • DB2 Tech Talk: Technical Tour and Introduction to IBM PureData Systems Recorded: Nov 15 2012 79 mins
    Kick-start your learning on the new IBM PureData Systems expert integrated solutions, which utilize DB2 for Linux and as a core technology. James Cho, architect for IBM PureData System for Transactions and IBM PureData System for Operational Analytics, will introduce these solutions at the technical level. We will also briefly cover PureData for Analytics, which is based on the Netezza platform, providing a complete picture of the PureData Systems products.

    We will cover technical aspects of the transactional and operational analytics products such as:
    • Which type of workload is best on which system

    • Fully integrated management features that streamline the management process and automate routine tasks

    • Applying database patterns to speed deployment, provisioning and replicating databases

    • Expert integrated and optimized out of the factory to ensure built-in scalability, and reliability with automatic failoverfor better system responsiveness

    • Cloud-based capabilities for transactional and operational analytics systems, with application-as-a-service and infrastructure-as-a-service features

    •New DB2 features such as Adaptive Compression that helps to maximize existing storage resources and improve performance

    • Support for DB2 applications without change and Oracle applications with minimal change

    • And more!

    Join us for this informative webcast to get the learning process started! This Tech Talk will kick off some additional “deep dives” on these integrated expert systems. Reserve a space from the start.
  • DB2 Tech Talk: What's Hot from Information on Demand Conference Recorded: Oct 24 2012 94 mins
    Host Serge Rielau will take you through the highlights and hot news from the Information on Demand conference about DB2 for Linux, UNIX and Windows and other IBM Data Management products! This will include new offerings such as IBM PureData Systems for Transactions and IBM PureData Systems for Analytics. We will also cover IBM Mobile Database, which is a new free download that works with DB2. And we'll hit some of the best presentations from the conference too. Don't miss this Tech Talk!
  • DB2 Tech Talk: Compression Comparison DB2 vs. Oracle Database and The Rest Recorded: Sep 27 2012 85 mins
    Running the data storage environment can be a costly proposition. In addition to escalating costs for storage resources, there are additional costs associated with managing, powering and cooling the systems.

    In response to customers concerns about these storage-related costs, IBM Information Management has been delivering advanced capabilities within the DB2 for Linux, UNIX and Windows product family to reduce storage requirements and improve database performance by focusing on various forms of in-database and in-memory compression.

    With an eye toward current industry capabilities, this Tech Talk delves into the benefits and advantages of the DB2 solution in the following areas:
    • database compression
    • backup and archival compression
    • how and when to use file system and storage deduplication technology

    Along with these features and capabilities native to DB2, we will also compare these to Oracle and the rest of the database industry to show you why DB2 has a clear advantage when it comes to storage optimization.
  • DB2 Tech Talk: Making RealTime Operational Warehouses a Reality Recorded: Sep 11 2012 69 mins
    Today's decisions need to be made “as soon as possible” to keep up with the fast pace of business and gain competitive advantage. For this reason the new DB2 10 and InfoSphere Warehouse 10 software products have some key new enhancements that help speed decision making with realtime operational data warehousing.

    We will discuss the advantages of this type of warehousing as compared to non-realtime warehousing and traditional database applications.

    And wer'll continue the "deep dive" into the major new features of the DB2 10 for Linux, UNIX and Windows and InfoSphere Warehouse 10, you will learn in this webcast how to :

    --Deliver insights faster by combining the new Continuous Data Ingest feature with several performance enhancements for BI queries, such as star schema queries

    -- Reduce capture and analysis latency across the warehousing process

    -- Employ near real-time loading of warehouse data from multiple data sources, without the need to lock the entire target table

    This is an exciting time to work with IBM data warehousing and analytics solutions. Please join us to see how these new features can help you advance your data applications on pace with growing business needs.
  • DB2 Tech Talk: Database Application Performance Management Best Practices Recorded: Aug 30 2012 90 mins
    Rigorous performance monitoring and management are crucial for business critical applications. Even with premier in-engine query optimization, application performance for DB2 is dependent on factors like available resources, good database design, and data access best practices.

    Join us for this DB2 Tech Talk where we will "deep dive" into IBM InfoSphere Optim solutions that offer state of the art performance monitoring and optimization technology for DB2 for Linux, UNIX and Windows applications. Using these performance management solutions for IBM DB2, experts from IBM labs will show you how to:

    - Identify emergent performance related problems
    - Diagnose where the problem resides
    - Resolve issues in the application or database design, and
    - Proactively prevent performance problems from re-occurring


    The featured offerings include IBM InfoSphere Optim Performance Manager, InfoSphere Optim Query Workload Tuner, InfoSphere Optim Configuration Manager, and InfoSphere Optim pureQuery Runtime, which are also part of DB2 Advanced Enterprise Edition and InfoSphere Warehouse Advanced Enterprise Edition.
  • DB2 Tech Talk: Part Two Certification Prep for DB2 10 Fundamentals Exam Recorded: Aug 2 2012 87 mins
    Validated DB2 skills help you stand out with your employer, meet annual education objectives, and create an edge in the employment marketplace.

    IBM is offering the all new DB2 10.1 Fundamentals Certification (exam 610) to attendees of the Information on Demand global conference in Las Vegas, Nevada from October 21 – 25, 2012. And if you are not attending the conference, IBM is offering the Take it Again promotion through November 30, 2012.

    This two-part Tech Talk can help you prepare for the exam. Part one was presented on Thursday July 26 from 12:30 to 2:00 PM ET. Part two is presented on Thursday August 2nd from 12:30 – 2:00 PM ET.

    Basics of the DB2 products and tools, DB2 pureScale feature, plus data warehousing and OLAP concepts

    ·Security including authentication, authorization and privileges, and the new Row and Column Access Control (RCAC) feature

    ·Working with databases and database objects including use of DDL statements to create objects

    ·Accessing data using SQL, to query data including XML data with XQuery, and use of Time Travel Query with temporal tables

    ·Working with tables, views and indexes including XML and Oracle compatibility data types and the new temporal tables

    ·Data concurrency mechanisms


    This talk is hosted by Serge Rielau, SQL architect for DB2 for LUW, with presentations by experienced DB2 instructor Andre Albuquerque.

    The time is 12:30 PM ET, however note that your view may present in your local time zone.
  • DB2 Tech Talk: Part One Certification Prep for DB2 10 Fundamentals Exam Recorded: Jul 26 2012 88 mins
    Validated DB2 skills help you stand out with your employer, meet annual education objectives, and create an edge in the employment marketplace.

    IBM is offering the all new DB2 10.1 Fundamentals Certification (exam 610) to attendees of the Information on Demand global conference in Las Vegas, Nevada from October 21 – 25, 2012. And if you are not attending the conference, IBM is offering the Take it Again promotion through November 30, 2012.

    This two-part Tech Talk can help you prepare for the exam. Part one is presented on Thursday July 26 from 12:30 to 2:00 PM ET. Part two will be presented on Thursday August 2nd from 12:30 – 2:00 PM ET.

    Basics of the DB2 products and tools, DB2 pureScale feature, plus data warehousing and OLAP concepts

    ·Security including authentication, authorization and privileges, and the new Row and Column Access Control (RCAC) feature

    ·Working with databases and database objects including use of DDL statements to create objects

    ·Accessing data using SQL, to query data including XML data with XQuery, and use of Time Travel Query with temporal tables

    ·Working with tables, views and indexes including XML and Oracle compatibility data types and the new temporal tables

    ·Data concurrency mechanisms


    This talk is hosted by Serge Rielau, SQL architect for DB2 for LUW, with presentations by experienced DB2 instructor Andre Albuquerque.

    The time is 12:30 PM ET, however note that your view may present in your local time zone.
Joint DB2 Tech Talk series sponsored by IDUG with IBM
This one-stop webcast channel makes it fast and easy to build and extend your technical skills on the IBM DB2 product family. IDUG has joined forces with IBM to bring together a wide array of learning sessions on technical product features, related products, new product developments and more.
  • Upcoming webinars (2)
  • Recorded webinars (25)
  • Subscribers (4,854)
Channel RSS feed
Up Down
You might also like: Big Data and the Analysis Conundrum

Embed in website or blog

Successfully added emails: 0
Remove all
  • Title: DB2 Tech Talk: Part Two Certification Prep for DB2 10 Fundamentals Exam
  • Live at: Aug 2 2012 4:30 pm
  • Presented by: Serge Rielau (host), Andre Albuquerque (presenter)
  • From:
Your email has been sent.
or close
You must be logged in to email this
OK