{"id":896,"date":"2015-05-20T17:09:08","date_gmt":"2015-05-20T08:09:08","guid":{"rendered":"http:\/\/course.certpro.jp\/?p=896"},"modified":"2015-05-20T17:09:08","modified_gmt":"2015-05-20T08:09:08","slug":"cp304-google-bigquery","status":"publish","type":"post","link":"http:\/\/course.certpro.jp\/?p=896","title":{"rendered":"CP304: Google BigQuery"},"content":{"rendered":"
\n
<\/div><\/fb:like><\/div>\n
<\/div><\/fb:share-button><\/div>\n
Tweet<\/a><\/div>\n
<\/g:plusone><\/div>\n
LINE\u3067\u9001\u308b<\/a><\/div>\n <\/div>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\u30b8\u30e3\u30f3\u30eb<\/td>\nGoogle\u6280\u8853\u95a2\u9023<\/td>\n<\/tr>\n
\u8b1b\u5ea7\u540d\u79f0<\/td>\nCP304: Google BigQuery<\/td>\n<\/tr>\n
\u53d7\u8b1b\u671f\u9593<\/td>\n1\u65e5(10:00\uff5e18:00\u3000\u663c\u4f11\u61a91\u6642\u9593\u7a0b\u5ea6)<\/td>\n<\/tr>\n
\u8b1b\u5ea7\u5f62\u5f0f<\/td>\n\u8b1b\u7fa9\uff0f\u6f14\u7fd2<\/td>\n<\/tr>\n
\u8b1b\u5ea7\u6982\u8981<\/td>\nBigQuery\u306f\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u3092Google\u306e\u30a4\u30f3\u30d5\u30e9\u3092\u99c6\u4f7f\u3057\u3066\u5206\u6790\u3059\u308b\u30b5\u30fc\u30d3\u30b9\u3067\u3059\u3002SQL Like\u306a\u69cb\u6587\u3092\u5229\u7528\u3059\u308b\u306e\u3067\u3001\u4eca\u307e\u3067SQL\u3092\u66f8\u3044\u305f\u3053\u3068\u304c\u3042\u308b\u4eba\u306a\u3089\u3070\u3001\u5c11\u306a\u3044\u5b66\u7fd2\u30b3\u30b9\u30c8\u3067\u5206\u6790\u3092\u884c\u3048\u308b\u306e\u3082\u7279\u5fb4\u3067\u3059\u3002\u3053\u306e\u30c8\u30ec\u30fc\u30cb\u30f3\u30b0\u3067\u306f\u3001BigQuery\u306e\u6982\u8981\u304b\u3089\u3001BigQuery\u306eSQL\u306e\u57fa\u790e\u3001\u305d\u3057\u3066\u3053\u3053\u307e\u3067\u5b89\u4fa1\u304b\u3064\u9ad8\u901f\u306b\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u306e\u5206\u6790\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u308bBigQuery\u306e\u88cf\u5074\u306e\u4ed5\u7d44\u307f\u306b\u3064\u3044\u3066\u5b66\u3073\u307e\u3059\u3002<\/td>\n<\/tr>\n
\u5b66\u7fd2\u76ee\u6a19<\/td>\nGoogle BigQuery\u3092\u3088\u308a\u6709\u52b9\u306b\u6d3b\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u3001Google BigQuery\u306e\u30a8\u30ad\u30b9\u30d1\u30fc\u30c8\u3068\u3057\u3066\u3001\u5341\u5206\u306a\u30b9\u30ad\u30eb\u3068\u77e5\u8b58\u3092\u4fee\u5f97\u3059\u308b<\/td>\n<\/tr>\n
\u4f7f\u7528\u6559\u6750<\/td>\n\u96fb\u5b50\u30c7\u30fc\u30bf\u3067\u5171\u6709\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\u5b66\u7fd2\u9805\u76ee<\/td>\n\u200b- – -1\u65e5\u76eeAM- – –
\n1. BigQuery\u3068\u306f\uff1f
\n– BigQuery\u6982\u8981
\n– \u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u306e\u8ab2\u984c
\n– \u30e6\u30fc\u30b9\u30b1\u30fc\u30b92. BigQuery\u57fa\u790e
\n– BigQuery\u306e\u69cb\u6210
\n– BigQuery\u306e\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e33. BigQuery\u3078\u306e\u30a2\u30af\u30bb\u30b9
\n– BigQuery\u30d6\u30e9\u30a6\u30b6\u30c4\u30fc\u30eb
\n– \u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30c4\u30fc\u30eb\u306e\u4f7f\u3044\u65b9
\n– BigQuery\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30e9\u30a4\u30d6\u30e9\u30ea\/REST API
\n– \u30b5\u30fc\u30c9\u30d1\u30fc\u30c6\u30a3\u30c4\u30fc\u30eb<\/p>\n

– – -1\u65e5\u76eePM – – –
\n4. BigQuery\u3078\u306e\u30c7\u30fc\u30bf\u306e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9
\n– BigQuery\u3078\u306e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u30c7\u30fc\u30bf\u306e\u6bb5\u53d6\u308a
\n– \u4e2d\u9593\u30c7\u30fc\u30bf\u306e\u4fdd\u7ba1
\n– \u30c7\u30fc\u30bf\u306e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9<\/p>\n

5. \u30af\u30a8\u30ea\u3068\u30d5\u30a1\u30f3\u30af\u30b7\u30e7\u30f3
\n– BigQuery SQL<\/p>\n

6. \u5de8\u5927\u306a\u30c7\u30fc\u30bf\u306e\u6271\u3044\u65b9
\n– \u5de8\u5927\u306a\u30c7\u30fc\u30bf\u306e\u8ab2\u984c
\n– JOIN EACH\u3068GROUP EACH BY
\n– \u30c6\u30fc\u30d6\u30eb\u30c7\u30b3\u30ec\u30fc\u30bf<\/p>\n

7. \u30cd\u30b9\u30c8\u3055\u308c\u305f\u30d5\u30a3\u30fc\u30eb\u30c9\u3068\u7e70\u308a\u8fd4\u3057\u30d5\u30a3\u30fc\u30eb\u30c9
\n– \u30cd\u30b9\u30c8\u3055\u308c\u305f\u30d5\u30a3\u30fc\u30eb\u30c9
\n– \u7e70\u308a\u8fd4\u3057\u30d5\u30a3\u30fc\u30eb\u30c9
\n– \u30cd\u30b9\u30c8\u3055\u308c\u305f\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u7e70\u308a\u8fd4\u3057\u30d5\u30a3\u30fc\u30eb\u30c9\u306b\u5165\u308c\u308b<\/p>\n

8. \u30c7\u30fc\u30bf\u306e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8
\n– \u30a2\u30af\u30bb\u30b9\u5236\u5fa1\u3068\u30af\u30a9\u30fc\u30bf
\n– \u30aa\u30d7\u30b7\u30e7\u30f3\u8a2d\u5b9a
\n– \u30c7\u30fc\u30bf\u306e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8<\/p>\n

9. \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9
\n– BigQuery\u306e\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3
\n– \u30af\u30a9\u30fc\u30bf\u7ba1\u7406
\n– \u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u306e\u51e6\u7406<\/td>\n<\/tr>\n

\u524d\u63d0\u6761\u4ef6<\/td>\nSQL\u306e\u77e5\u8b58\u304c\u3042\u308b\u3053\u3068<\/td>\n<\/tr>\n
\u53d7\u8b1b\u5bfe\u8c61<\/td>\n\u5b66\u7fd2\u76ee\u6a19\u306b\u8a18\u8f09\u3055\u308c\u305f\u6280\u8853\u3092\u7fd2\u5f97\u3057\u305f\u3044\u65b9<\/td>\n<\/tr>\n
\u95a2\u9023\u8b1b\u5ea7<\/td>\nCP301: Google App Engine
\nCP302: Google Cloud Storage \/ CP303: Google Cloud SQL
\nCP305: Google Compute Engine
\nCP306: Google Container Engine<\/td>\n<\/tr>\n
\u53d7\u8b1b\u6599\u91d1<\/td>\n\u4f1a\u5834\u53d7\u8b1b\uff1a60,000\u5186(\u7a0e\u629c)
\n\u30cf\u30f3\u30b0\u30a2\u30a6\u30c8\u53d7\u8b1b\uff1a48,000\u5186(\u7a0e\u629c)<\/td>\n<\/tr>\n
\u958b\u50ac\u65e5\u7a0b<\/td>\n\u203b\u4e8b\u52d9\u5c40\u3078\u304a\u554f\u5408\u305b\u304f\u3060\u3055\u3044\u3002<\/td>\n<\/tr>\n
\u5099\u8003<\/td>\n\u3010\u5834\u6240(\u4f1a\u5834\u53d7\u8b1b)\u3011
\nStudioGeeks(\u3012113-0033 \u6771\u4eac\u90fd\u6587\u4eac\u533a\u672c\u90f73-40-11 \u67cf\u5c4b\u30d3\u30eb4F)\u3010\u4e8b\u524d\u6e96\u5099\u3011
\n\u30fb\u30af\u30ec\u30b8\u30c3\u30c8\u30ab\u30fc\u30c9
\n\u30fb\u6301\u8fbcPC\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7
\n\u30fbGoogle\u30a2\u30ab\u30a6\u30f3\u30c8
\n\u30fb\u5199\u771f\u4ed8\u8eab\u5206\u8a3c\u660e\u66f8(\u8a66\u9a13\u6642)\u3010\u5f53\u65e5\u6301\u3061\u7269\u3011
\n\u30fb\u30af\u30ec\u30b8\u30c3\u30c8\u30ab\u30fc\u30c9\uff08\u6cd5\u4eba\u540d\u7fa9\u3001\u500b\u4eba\u540d\u7fa9\u3044\u305a\u308c\u3067\u3082\u53ef\uff09
\n\u203bGoogleCloudPlatform(\u5b9f\u7fd2\u74b0\u5883)\u306e\u5229\u7528\u306b\u30af\u30ec\u30b8\u30c3\u30c8\u30ab\u30fc\u30c9\u60c5\u5831\u306e\u767b\u9332\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002
\n\u203b\u5b9f\u7fd2\u74b0\u5883\u306e\u5229\u7528\u81ea\u4f53\u306fGoogle\u767a\u884c\u306e\u30af\u30fc\u30dd\u30f3\u30b3\u30fc\u30c9\u3092\u5229\u7528\u3057\u307e\u3059\u306e\u3067\u3001\u30af\u30ec\u30b8\u30c3\u30c8\u30ab\u30fc\u30c9\u3092\u5229\u7528\u3057\u305f\u53d6\u5f15\u304c\u767a\u751f\u3059\u308b\u3053\u3068\u306f\u3054\u3056\u3044\u307e\u305b\u3093\u3002
\n\u30fb\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u63a5\u7d9a\u53ef\u80fd\u306aPC(Mac\u8cb8\u51faPC\u3042\u308a)
\n\u203b\u8cb8\u51faPC\u306b\u3064\u3044\u3066\u306f\u7533\u8fbc\u307f\u6642\u306b\u304a\u554f\u3044\u5408\u308f\u305b\u304f\u3060\u3055\u3044\u3002<\/p>\n

\u3010Google\u30a2\u30ab\u30a6\u30f3\u30c8\u7528\u9014\u3011
\n\u30fb\u8cc7\u6599\u5171\u6709
\n\u30fbGCP\u30c8\u30ec\u30fc\u30cb\u30f3\u30b0\u74b0\u5883\u69cb\u7bc9
\n\u30fbGCP\u30af\u30fc\u30dd\u30f3\u5229\u7528<\/p>\n

\u3010\u8a66\u9a13\u306b\u3064\u3044\u3066\u3011
\n\u30c8\u30ec\u30fc\u30cb\u30f3\u30b0\u7d42\u4e86\u5f8c\u3001GoogleCloudPlatform\u8a8d\u5b9a\u8cc7\u683c\u8a66\u9a13\u3092\u53d7\u9a13\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002
\n\u5408\u683c\u3059\u308b\u3068Google\u3088\u308a\u8a8d\u5b9a\u8a3c\u304c\u6388\u4e0e\u3055\u308c\u307e\u3059\u3002
\n\u30c8\u30ec\u30fc\u30cb\u30f3\u30b0\u53d7\u8b1b\u5f8c\u306b\u8a66\u9a13\u8cfc\u5165\u7528\u30d0\u30a6\u30c1\u30e3\u30fc\u3092\u767a\u884c\u3057\u307e\u3059\u306e\u3067\u53d7\u8b1b\u8005\u306f\u7121\u6599\u3067\u53d7\u9a13\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002
\n\u53d7\u9a13\u6642\u306b\u76e3\u7763\u5b98\u3088\u308a\u5199\u771f\u4ed8\u8eab\u5206\u8a3c\u660e\u66f8(\u30d1\u30b9\u30dd\u30fc\u30c8\u3001\u904b\u8ee2\u514d\u8a31\u8a3c\u7b49)\u306e\u63d0\u793a\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n

\u3010\u6301\u8fbcPC\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3011(CP301: Google App Engine\u306e\u307f)
\nJava\u3092\u4f7f\u7528\u3059\u308b\u65b9
\n\u30fbJava1.7\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb(\u5fc5\u9808)
\n\u30fbEclipse\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb(\u5fc5\u9808)<\/p>\n

python\u3092\u4f7f\u7528\u3059\u308b\u65b9
\n\u30fbpython2.7\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb(\u5fc5\u9808)<\/p>\n

Java\/python\u5171\u901a
\n\u30fbGoogle Cloud SDK(\u4efb\u610f)<\/p>\n

\u3010\u30aa\u30f3\u30e9\u30a4\u30f3\u53d7\u8b1b\u306b\u3064\u3044\u3066\u3011
\n\u9060\u9694\u5730\u3067\u3054\u6765\u5834\u304c\u96e3\u3057\u3044\u65b9\u306a\u3069\u306e\u305f\u3081\u306b\u3001\u8a66\u9a13\u7684\u306b\u30cf\u30f3\u30b0\u30a2\u30a6\u30c8\u3067\u306e\u30c8\u30ec\u30fc\u30cb\u30f3\u30b0\u3092\u53d7\u3051\u4ed8\u3051\u3066\u3044\u307e\u3059\u3002
\n\u30aa\u30f3\u30e9\u30a4\u30f3\u306e\u6027\u8cea\u4e0a\u3001\u6b21\u306e\u3088\u3046\u306a\u5834\u5408\u304c\u3054\u3056\u3044\u307e\u3059\u306e\u3067\u3001\u3054\u5e0c\u671b\u306e\u65b9\u306f\u3001\u5fc5\u305a\u304a\u7533\u8fbc\u524d\u306b\u3054\u4e00\u8aad\u304f\u3060\u3055\u3044\u3002<\/p>\n

\u3010\u30cf\u30f3\u30b0\u30a2\u30a6\u30c8\u53d7\u8b1b\u306e\u6ce8\u610f\u4e8b\u9805\u3011
\n\u30fb\u30b3\u30fc\u30b9\u306e\u9032\u884c\u4e0a\u3001\u30b5\u30d6\u30e2\u30cb\u30bf\u30fc\u306e\u3054\u5229\u7528\u3092\u63a8\u5968\u3057\u307e\u3059\u3002
\n\u30fb\u53d7\u8b1b\u958b\u59cb\u307e\u305f\u306f\u53d7\u8b1b\u9014\u4e2d\u3067\u3001\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u969c\u5bb3\uff08\u307e\u305f\u306f\u707d\u5bb3\u3001\u505c\u96fb\u306a\u3069\uff09\u306e\u5f71\u97ff\u306b\u3088\u308a\u3001\u53d7\u8b1b\u3067\u304d\u306a\u304f\u306a\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u3053\u306e\u5834\u5408\u306f\u3001\u5225\u65e5\u3067\u518d\u53d7\u8b1b\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002
\n\u30fb\u53d7\u8b1b\u8005\u306e\u8cac\u4efb\u3067\u3001\u53d7\u8b1b\u958b\u59cb\u307e\u305f\u306f\u53d7\u8b1b\u7d99\u7d9a\u3067\u304d\u306a\u304b\u3063\u305f\u5834\u5408\u306f\u3001\u518d\u53d7\u8b1b\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3002
\n\u30fb\u97f3\u58f0\u3084\u753b\u50cf\u304c\u4e71\u308c\u305f\u308a\u3001\u9045\u5ef6\u3059\u308b\u5834\u5408\u304c\u3042\u308a\u3001\u4e00\u90e8\u307e\u305f\u306f\u5168\u90e8\u306e\u5185\u5bb9\u304c\u8996\u8074\u3067\u304d\u306a\u304f\u306a\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002
\n\u30fb\u30cf\u30f3\u30b0\u30a2\u30a6\u30c8\u4e2d\u306e\u6620\u50cf\u3092\u9332\u753b\u307e\u305f\u306f\u4fdd\u5b58\u3059\u308b\u3053\u3068\u306f\u7981\u6b62\u3055\u308c\u3066\u3044\u307e\u3059\u3002
\n\u30fbGoogleApps\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u5229\u7528\u3059\u308b\u5834\u5408\u306f\u3001\u5916\u90e8\u30c9\u30e1\u30a4\u30f3\u3068\u306e\u30cf\u30f3\u30b0\u30a2\u30a6\u30c8\u304c\u8a31\u53ef\u3055\u308c\u3066\u3044\u308b\u304b\u7ba1\u7406\u8005\u306b\u3054\u78ba\u8a8d\u304f\u3060\u3055\u3044\u3002\u5bfe\u5fdc\u304c\u96e3\u3057\u3044\u5834\u5408\u306f\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u30fc\u5411\u3051\u306eGmail\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u5225\u9014\u7528\u610f\u306e\u4e0a\u3001\u4e8b\u52d9\u5c40\u307e\u3067\u304a\u77e5\u3089\u305b\u304f\u3060\u3055\u3044\u3002<\/td>\n<\/tr>\n

\u4e8b\u52d9\u5c40<\/td>\n\u6559\u80b2\u7814\u4fee\u4e8b\u696d\u90e8<\/td>\n<\/tr>\n
<\/td>\n\u682a\u5f0f\u4f1a\u793e\u30b5\u30fc\u30c8\u30d7\u30ed www.certpro.jp<\/a><\/td>\n<\/tr>\n
<\/td>\nTEL\uff1a03-6276-1168 FAX\uff1a03-6276-1169<\/td>\n<\/tr>\n
\u304a\u554f\u5408\u305b<\/td>\nhttp:\/\/course.certpro.jp\/?page_id=63<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n
<\/div><\/fb:like><\/div>\n
<\/div><\/fb:share-button><\/div>\n
Tweet<\/a><\/div>\n
<\/g:plusone><\/div>\n
LINE\u3067\u9001\u308b<\/a><\/div>\n <\/div>\n
\n","protected":false},"excerpt":{"rendered":"

\u30b8\u30e3\u30f3\u30eb Google\u6280\u8853\u95a2\u9023 \u8b1b\u5ea7\u540d\u79f0 CP304: Google BigQuery \u53d7\u8b1b\u671f\u9593 1\u65e5(10:00\uff5e18:00\u3000\u663c\u4f11\u61a91\u6642\u9593\u7a0b\u5ea6) \u8b1b\u5ea7\u5f62\u5f0f \u8b1b\u7fa9\uff0f\u6f14\u7fd2 \u8b1b\u5ea7\u6982\u8981 BigQuery\u306f\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u3092Goog<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[9],"tags":[115,82,114,41],"jetpack_publicize_connections":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4IeX8-es","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/course.certpro.jp\/index.php?rest_route=\/wp\/v2\/posts\/896"}],"collection":[{"href":"http:\/\/course.certpro.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/course.certpro.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/course.certpro.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/course.certpro.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=896"}],"version-history":[{"count":0,"href":"http:\/\/course.certpro.jp\/index.php?rest_route=\/wp\/v2\/posts\/896\/revisions"}],"wp:attachment":[{"href":"http:\/\/course.certpro.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/course.certpro.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=896"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/course.certpro.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}