decor
 

planetDB2 logo

Planet DB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.

 

December 07, 2016

Big Data University

New York Data Science Bootcamp And Validated Badges

This post is about our New York Data Science Bootcamp. Interested? Find data science bootcamps in your city.

The Data Science Bootcamp journey for Big Data University started in China back in September. At the time, we were in Bejing for the CDA (Certified Data Analyst) Summit, which had an attendance of more than 3,000 data analysts, data scientists, data engineers, students, and professors. After that, we held a Data Science Bootcamp in Mexico which was a 4-day affair with an attendance of 80 participants in the city of Guadalajara.

New York Data Science BootcampMore recently, IBM’s Big Data University held a four and a half day beginner friendly, hands-on data science bootcamp in New York City. It took place from Tuesday, November 29th to Saturday, December 3rd at the Zicklin School of Business, Baruch College, CUNY.

BDU’s Chief Data Scientist Saeed Aghabozorgi, PhD delivered the Data Science bootcamp with the aid of two fellow BDU data scientists: Candi Halbert and Hima Vasudevan. 45 participants from the corporate and academic world took part in the bootcamp.

We are very grateful for the help and support from Maithily Erande (Lecturer, Marketing Analytics Dept. of Marketing & International Business) in arranging this New York data science bootcamp. (Maithily is an Analytics Expert and a Product Manager/ Vice President for Product Engineering with several Fortune 100 clients including Apple, Microsoft, Dun & Bradstreet, JP Morgan Chase, Cisco, and Sesame Street.)

Introducing Validated Badges

Saeed at the New York Data Science BootcampAt this bootcamp, Saeed gave an overview of data science, Big Data University, an introduction to the R language, data analysis, data visualization, machine learning and working with big data with SparkR. There was also a capstone project which gave participants a hands-on experience on a real-world data science project. For this project, participants used the Data Scientist Workbench, a virtual lab environment which allowed them to perform lab exercises directly from their browsers.

For the first time ever, participants who passed the exam were eligible not only for a certificate but for a Validated Badge as well. This badge is reserved for Big Data University students who pass the test for a course in person (so that we can guarantee that they were the ones who took the exam). These badges, like our regular badges, can be shared with others using social media, on your resume, etc.

We, at BDU, are greatly enjoying these bootcamps. The feedback received so far has been equally enthusiastic. If you are interested in attending future Data Science Bootcamps worldwide, please refer to our Data Science Bootcamps link. We hope to see you there!

The post New York Data Science Bootcamp And Validated Badges appeared first on Big Data University.


Dave Beulke

Reliability, Availability, and Scalability Lessons for Holiday Peak Processing

Operational performance is always paramount for applications, websites, and order systems during the busy Christmas holiday shopping season. Keeping holiday peak processing going with good performance is a pains-taking ordeal. Even with the best laid plans of continuous improvement builds,...

(Read more)
Big Data University

This Week in Data Science (December 06, 2016)

Here’s this week’s news in Data Science and Big Data. Data Trends 2017

Don’t forget to subscribe if you find this useful!

Interesting Data Science Articles and News

The post This Week in Data Science (December 06, 2016) appeared first on Big Data University.

 

December 06, 2016


DB2utor

How Customers are Benefiting from DB2 Accelerator Tables

Following up on my recent posts on the latest version of IBM DB2 Analytics Accelerator for z/OS (DB2 Accelerator) as well as the new Accelerator cloud-centric solution, I wanted to step back a bit and discuss an IBM Redbook.
 

December 05, 2016


Craig Mullins

The Tao of DB2 - Part 13: Constantly Learning More

It is time, once again, to look in on our intrepid young DBA as he continues to learn database administration as an intern to an older, wiser, but soon-to-be-retiring DBA. The intern approached his mentor and said "You have taught me a lot in the past few months. I am more prepared now when it comes to supporting the developers, database/application performance management, making database...

(Read more)
 

December 02, 2016


DB2Night Replays

DB2Night Show #z74: DB2 Utilities: Changes you should know

Presented by: Klaas Brant Klaas Brant, IBM Gold Consultant and Champion for IM "The DB2Night Show z74: DB2 Utilities: Changes you should know" Replays available in WMV and M4V formats! 100% of our studio audience learned something!Klaas shared must know information on DB2 utilities and changes in DB2 11. Watch the replay...

(Read more)
 

December 01, 2016


Kim May

The Fillmore Group IBM Analytics Class Schedule – First Half, 2017

Although the Global Skills Initiative hasn’t delivered on its promise IBM continues to schedule and deliver classes with the Global Training Partners.  It’s just more difficult for...

(Read more)

Triton Consulting

DB2 12 for z/OS – The In-Memory Enterprise Database for Transactions and Analytics

IBM have just released their latest white paper on DB2 12.  This white paper was authored by our very own Julian Stuhler and provides a high-level overview of the major new features of IBM DB2 12 for z/OS from an … Continue reading →

(Read more)

Henrik Loeser

SQL Magic in Notebooks in the IBM Data Science Experience

New Notebook in IBM Data Science Experience At the recent IDUG DB2 Tech Conference in Brussels I gave a talk on using Jupyter Notebooks with IBM DB2 or dashDB. For the presentation I used a local...

(Read more)
 

November 30, 2016


DB2 Guys

DB2 for SAP – Poised for growth

Like most organizations, your company is pressing ahead to close out projects and prepare new ones for the coming year. Inevitably, these annual evaluations and reviews call into question the preservation of your existing IT investment while exploiting new areas for growth. Some vendors strongly encourage vertically integrated solutions with a promise of seamless operation, […]
 

November 29, 2016

Big Data University

This Week in Data Science (November 29, 2016)

Here’s this week’s news in Data Science and Big Data. Machine Learning

Don’t forget to subscribe if you find this useful!

Interesting Data Science Articles and News

Upcoming Data Science Events

  • Data Science Bootcamp – This is a beginner-friendly, hands-on bootcamp, where you will learn the fundamentals of data science from IBM Data Scientists Saeed Aghabozorgi, PhD and Polong Lin.

The post This Week in Data Science (November 29, 2016) appeared first on Big Data University.


DB2utor

Continuous Delivery and DB2 12 Function Levels

I recently attended a regional DB2 user group meeting, and the subject of continuous delivery came up frequently. People were wondering about the process of adding new features being added through the maintenance stream and how to fallback if it's determined that the new features are causing a problem.
 

November 28, 2016


ChannelDB2 Videos

DB2 Tips n Tricks Part 101 - How To Start/Stop DB2 Instance without using DB2START


Thumbnail

How To Start/Stop DB2 Instance without using DB2START Configure Autostart Instance or Configure Fault Monitor Happy Learning & Sharing

Robert Catterall

DB2 for z/OS ZPARMs that Organizations Consistently Set in a Sub-Optimal Fashion

Over the past several years, I have reviewed DB2 for z/OS systems running at quite a few client sites. Part of the analysis work I do in performing these reviews involves looking over a DB2 subsystem's DSNZPARM values (or ZPARMs, for short -- the parameters through which the set-up of a DB2 system is largely specified). I have seen that certain ZPARM parameters are very regularly set to values that are not ideal. In this blog entry I will spotlight those ZPARMs, showing how they often ARE set...

(Read more)
Use the Index, Luke

Big News In Databases

There's bee a lot of big news in 2016, also when it comes to databases. Let's have a look at the really BIG news.

MySQL and MariaDB Become Modern

For a long time, MySQL and MariaDB were mostly limited to the functionality of SQL-92. Now, both of them have decided to move forward by supporting the WITH and OVER clauses in their next major release (MySQL 8.0, MariaDB 10.2). The MariaDB beta release already supports both features while the current MySQL “lab release” only currently supports the WITH clause.

Parallel Execution in PostgreSQL 9.6

Commercial databases have been able to do it for decades, but in the open source database scene it is quite unique: Since release 9.6, PostgeSQL can execute single queries on multiple cores and thus make better use of modern hardware for data-intensive queries. At the moment, only some special cases can take advantage of in-query parallelism. The next releases will gradually extend this functionality. Speaking of next releases: The next major PostgreSQL release will be 10.0.

SQL Server on Linux (Beta)

A beta of the next version of SQL Server (currently called “vNext”) was released, also for Linux. On supported distributions (Red Hat, Ubuntu) the installation is carried out by the regular package manager. Furthermore, Microsoft provides Docker images. The “What's New” list of vNext is rather modest from a developer's perspective. However, SQL Server is finally getting STRING_AGG. It's also worth noting that CREATE OR ALTER was added to SQL Server 2016 SP1, which was released at the same time that vNext beta went public.

Oracle 12cR2 Currently Cloud Only

First off, Version 12.2 of the Oracle Database hast already been released. Interestingly, you cannot download it. Cloud first seems to be the new strategy for Oracle. For developers the new release is not very exciting anyway: Error handling for CASE and LISTAGG, approximate aggregates and of course more JSON. Find the full list in the “New Features” documentation.

DB Learns OFFSET…Unfortunately

DB2 for Linux, UNIX and Windows (abbrevated LUW) has gotten release 11.1 earlier this year. The general theme of the new SQL features was compatibility. It seems like IBM aims to support every single SQL dialect out there, and one part of this is that DB2 supports the SQL:2011 OFFSET clause even without enabling the MySQL compatibility vector. This is a big setback from my No-Offset movement!

SQLite Gets Row-Values

SQLite is compensating for this by introducing row values support in version 3.15.0—the SQL-92 feature that often makes life without OFFSET more easy. If you don't know about No-Offset yet, you should definitively read this article.

Big News In Databases” by Markus Winand was originally published at Use The Index, Luke!.

 

November 24, 2016


Henrik Loeser

Stuff - The Day of the BLOB and Object Storage

Regardless of whether it is turkey, cranberry sauce, stuffing, gravy, sweet potatoe pie, mashed potatoes or more that you eat, independent of whether it is a new iPhone, tablet, big screen, Bluetooth...

(Read more)

Craig Mullins

Happy Thanksgiving

Today, in the United States of America, we celebrate Thanksgiving by gathering together with our loved ones and giving thanks for all we have. This includes celebrations with food, traditionally a big turkey dinner with mashed potatoes and gravy, as we watch a parade and football games... With this in mind, I give thanks for all of the reader's of my blog, wherever you may be, and wish you a...

(Read more)
 

November 23, 2016


Triton Consulting

IDUG EMEA 2016 Roundup

The Triton team has (just about) recovered from the trip to Brussels and are finally getting their voices back after singing far more songs than they ever imagined they would at any event, let alone an IDUG Technical Conference. Not … Continue reading →

(Read more)

Triton Consulting

Let Triton add some DB2 Magic to your Christmas holidays

It’s nearly the most wonderful time of the year.  Or something.  Whatever your thoughts on Christmas, whether you’re a fairy lights over your laptop or more of a Grinch who stole Christmas kind of techie there is no escape from … Continue reading →

(Read more)
 

November 22, 2016


Leons Petrazickis

Update OpenLDAP SSL certificate on CentOS 6

You may need to update your OpenLDAP SSL certificate, as well as the CA certificate and signing key on a regular basis. The post Update OpenLDAP SSL certificate on CentOS 6 appeared first on Leons...

(Read more)
Big Data University

This Week in Data Science (November 22, 2016)

Here’s this week’s news in Data Science and Big Data. Coffee

Don’t forget to subscribe if you find this useful!

Interesting Data Science Articles and News

Upcoming Data Science Events

  • Apache Spark – Hands-on Session – Come join speakers Matt McInnis and Sepi Seifzadeh, Data Scientists from IBM Canada as they guide the group through three hands-on exercises using IBM’s new Data Science Experience to leverage Apache Spark!

The post This Week in Data Science (November 22, 2016) appeared first on Big Data University.


Henrik Loeser

DB2/dashDB Security: Implicit Privileges Through Group Membership

DB2 Data Security I recently saw an interesting DB2 question on Stack Overflow. Someone asked how it is possible to find out privileges for a user when the privileges were granted to a group the...

(Read more)

DB2utor

DB2 12 for z/OS Manuals Available

Long-time readers of DB2utor know that I prefer using the DB2 manuals in PDF form as opposed to the electronic versions available from the IBM Knowledge Center. After hearing rumors that IBM would no longer make documents available in PDF, I was very pleased to find the DB2 12 for z/OS manuals available in PDF form.
 

November 21, 2016


Leons Petrazickis

Fix full Ubuntu /boot partition

Linux kernel images are stored on a separate partition mounted under /boot. This partition can fill up and prevent you from installing updates. The post Fix full Ubuntu /boot partition appeared...

(Read more)
 

November 20, 2016


ChannelDB2 Videos

DB2 Performance Myth Buster 1 - How Bufferpool with 100% Hit Ratio still has Performance Bottleneck


Thumbnail

How Bufferpool with 100% Hit Ratio still has Performance Bottleneck Look for Page Cleaning. Happy Learning & Sharing
 

November 18, 2016


ChannelDB2 Videos

Help!! My Manager Said We re Getting Off the Mainframe! 2016 11 17


Thumbnail

Abstract: Technology is all about innovation and everyone knows the mainframe is as old as dirt. Therefore, according to many CIO’s, now’s the time to move t...
 

November 17, 2016


Frank Fillmore

“Help!! My Manager Said We’re Moving Off the Mainframe!” Materials #zIBM #zAnalytics

One of our best attended webinars ever!  Lots of great questions. The presentation materials are found here: help-my-manager-said-were-moving-off-the-mainframe-slides-11-14-16-final The recording can...

(Read more)
 

November 16, 2016


Dave Beulke

Analytics Lessons from the Election

I have been doing analytical systems for many years, starting with my first data warehouse database design and application for E F Hutton in 1988. This election followed many analytics lessons that I have learned and experienced with several analytical data warehouse projects over the...

(Read more)

Triton Consulting

IDUG EMEA 2016 – Day 3

Visiting an IDUG location in a centre of cultural significance is always an eye-opener, so I took to the rainy streets of Brussels on arrival, to check out the ambience. After a wander round the Grotemarkt, I grabbed a snack … Continue reading →

(Read more)

Triton Consulting

IDUG Day 2 – Expect the unexpected

Having been fortunate enough to have attended IDUG for many years I know what to expect. But I also know there will be some surprises and to expect the unexpected. I know at IDUG there will be the opportunity to … Continue reading →

(Read more)
 

November 15, 2016


Triton Consulting

IDUG EMEA 2016 – Day 1

IDUG EMEA 2016 is taking place in Brussels, so travel options were a bit more flexible this year. Having decided not to spend most of the day in the queue for security in Stansted airport, we opted to go via … Continue reading →

(Read more)

Craig Mullins

The Tao of DB2 - Part 12: Dealing with Change

It is time, once again, to look in on our friends, the intern DBA and his mentor. After spending so much time on performance issues, the mentor decides to check on his apprentice and make sure that he is not overwhelmed. “Well, now that you mention it, the users want to change the data type of several columns,” stated the intern. “The only constant is change,” replied his mentor. “Remember the...

(Read more)

Subscribe by email

 

About

planetDB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.
 

Bloggers

decor