fbpx

ALPHA Camp

ALPHA Camp SQL 課程:14 天從基礎語法到實戰案例 Youchi Kuo ex-BCG,前 ALPHA Camp 營運長 Morris 前綠藤生機 成長行銷副理 Cliff ex-Grab, Data Strategist SQL 資料分析 企業案例 用SQL 實際解析商業問題

SQL課程

資料分析

數據分析師

SQL 課程:
14 天從基礎語法到實戰案例

開賣時間:即買即上課
課程優惠中
優惠截止日:
優惠方案已截止ˇ
分享:
課程介紹

SQL 是和資料溝通的首選工具,在商業情境與資料日益複雜的現今,蹲好馬步打穩 SQL 基礎,是解決實務問題的第一步。上手 SQL 後,就能進一步整合思維、工具、與應用,並實現真正的數據價值。

課程重點

SQL 語法、案例應用、資料分析

學習工具

使用線上資料庫環境學習

學習時數

總時數約 48 小時

地點

線上教學

時間

購買即可上課

※ 資訊內容以實際開課為準
即買即上課
NT$ 2,780
NT$ 2,780
ALPHA Camp {"type":"elementor","siteurl":"https://tw.alphacamp.co/wp-json/","elements":[{"id":"52cbacf7","elType":"widget","isInner":false,"isLocked":false,"settings":{"image":{"url":"https://tw.alphacamp.co/wp-content/uploads/2024/01/240129-Web_CR-24Q1-WB1_SQL-14Days_V04_SR_1200x628.webp","id":24637,"size":"","alt":"","source":"library"},"image_size":"full","image_custom_dimension":{"width":"0","height":"350"},"align":"right","height_tablet":{"unit":"%","size":"","sizes":[]},"height_mobile":{"unit":"%","size":"","sizes":[]},"width_tablet":{"unit":"vw","size":"","sizes":[]},"width_mobile":{"unit":"vw","size":"","sizes":[]},"_title":"Banner-1200x675","align_tablet":"center","image_border_radius_tablet":{"unit":"px","top":"0","right":"0","bottom":"0","left":"0","isLinked":false},"_margin_tablet":{"unit":"px","top":"0","right":"0","bottom":"0","left":"0","isLinked":false},"_padding_tablet":{"unit":"px","top":"0","right":"0","bottom":"0","left":"0","isLinked":false},"_flex_align_self_tablet":"center","caption":"數據驅動決策:打造可信賴的 A/B Testing 模型","caption_source":"none","link_to":"none","link":{"url":"","is_external":"","nofollow":"","custom_attributes":""},"open_lightbox":"default","align_mobile":"","width":{"unit":"%","size":"","sizes":[]},"space":{"unit":"%","size":"","sizes":[]},"space_tablet":{"unit":"%","size":"","sizes":[]},"space_mobile":{"unit":"%","size":"","sizes":[]},"height":{"unit":"px","size":"","sizes":[]},"object-fit":"","object-fit_tablet":"","object-fit_mobile":"","object-position":"center center","object-position_tablet":"","object-position_mobile":"","opacity":{"unit":"px","size":"","sizes":[]},"css_filters_css_filter":"","css_filters_blur":{"unit":"px","size":0,"sizes":[]},"css_filters_brightness":{"unit":"px","size":100,"sizes":[]},"css_filters_contrast":{"unit":"px","size":100,"sizes":[]},"css_filters_saturate":{"unit":"px","size":100,"sizes":[]},"css_filters_hue":{"unit":"px","size":0,"sizes":[]},"opacity_hover":{"unit":"px","size":"","sizes":[]},"css_filters_hover_css_filter":"","css_filters_hover_blur":{"unit":"px","size":0,"sizes":[]},"css_filters_hover_brightness":{"unit":"px","size":100,"sizes":[]},"css_filters_hover_contrast":{"unit":"px","size":100,"sizes":[]},"css_filters_hover_saturate":{"unit":"px","size":100,"sizes":[]},"css_filters_hover_hue":{"unit":"px","size":0,"sizes":[]},"background_hover_transition":{"unit":"px","size":"","sizes":[]},"hover_animation":"","image_border_border":"","image_border_width":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"image_border_width_tablet":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"image_border_width_mobile":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"image_border_color":"","image_border_radius":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"image_border_radius_mobile":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"image_box_shadow_box_shadow_type":"","image_box_shadow_box_shadow":{"horizontal":0,"vertical":0,"blur":10,"spread":0,"color":"rgba(0,0,0,0.5)"},"caption_align":"","caption_align_tablet":"","caption_align_mobile":"","text_color":"","caption_background_color":"","caption_typography_typography":"","caption_typography_font_family":"","caption_typography_font_size":{"unit":"px","size":"","sizes":[]},"caption_typography_font_size_tablet":{"unit":"px","size":"","sizes":[]},"caption_typography_font_size_mobile":{"unit":"px","size":"","sizes":[]},"caption_typography_font_weight":"","caption_typography_text_transform":"","caption_typography_font_style":"","caption_typography_text_decoration":"","caption_typography_line_height":{"unit":"px","size":"","sizes":[]},"caption_typography_line_height_tablet":{"unit":"em","size":"","sizes":[]},"caption_typography_line_height_mobile":{"unit":"em","size":"","sizes":[]},"caption_typography_letter_spacing":{"unit":"px","size":"","sizes":[]},"caption_typography_letter_spacing_tablet":{"unit":"px","size":"","sizes":[]},"caption_typography_letter_spacing_mobile":{"unit":"px","size":"","sizes":[]},"caption_typography_word_spacing":{"unit":"px","size":"","sizes":[]},"caption_typography_word_spacing_tablet":{"unit":"em","size":"","sizes":[]},"caption_typography_word_spacing_mobile":{"unit":"em","size":"","sizes":[]},"caption_text_shadow_text_shadow_type":"","caption_text_shadow_text_shadow":{"horizontal":0,"vertical":0,"blur":10,"color":"rgba(0,0,0,0.3)"},"caption_space":{"unit":"px","size":"","sizes":[]},"caption_space_tablet":{"unit":"px","size":"","sizes":[]},"caption_space_mobile":{"unit":"px","size":"","sizes":[]},"_margin":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_margin_mobile":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_padding":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_padding_mobile":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_element_width":"","_element_width_tablet":"","_element_width_mobile":"","_element_custom_width":{"unit":"%","size":"","sizes":[]},"_element_custom_width_tablet":{"unit":"px","size":"","sizes":[]},"_element_custom_width_mobile":{"unit":"px","size":"","sizes":[]},"_flex_align_self":"","_flex_align_self_mobile":"","_flex_order":"","_flex_order_tablet":"","_flex_order_mobile":"","_flex_order_custom":"","_flex_order_custom_tablet":"","_flex_order_custom_mobile":"","_flex_size":"","_flex_size_tablet":"","_flex_size_mobile":"","_flex_grow":1,"_flex_grow_tablet":"","_flex_grow_mobile":"","_flex_shrink":1,"_flex_shrink_tablet":"","_flex_shrink_mobile":"","_element_vertical_align":"","_element_vertical_align_tablet":"","_element_vertical_align_mobile":"","_position":"","_offset_orientation_h":"start","_offset_x":{"unit":"px","size":0,"sizes":[]},"_offset_x_tablet":{"unit":"px","size":"","sizes":[]},"_offset_x_mobile":{"unit":"px","size":"","sizes":[]},"_offset_x_end":{"unit":"px","size":0,"sizes":[]},"_offset_x_end_tablet":{"unit":"px","size":"","sizes":[]},"_offset_x_end_mobile":{"unit":"px","size":"","sizes":[]},"_offset_orientation_v":"start","_offset_y":{"unit":"px","size":0,"sizes":[]},"_offset_y_tablet":{"unit":"px","size":"","sizes":[]},"_offset_y_mobile":{"unit":"px","size":"","sizes":[]},"_offset_y_end":{"unit":"px","size":0,"sizes":[]},"_offset_y_end_tablet":{"unit":"px","size":"","sizes":[]},"_offset_y_end_mobile":{"unit":"px","size":"","sizes":[]},"_z_index":"","_z_index_tablet":"","_z_index_mobile":"","_element_id":"","_css_classes":"","motion_fx_motion_fx_scrolling":"","motion_fx_translateY_effect":"","motion_fx_translateY_direction":"","motion_fx_translateY_speed":{"unit":"px","size":4,"sizes":[]},"motion_fx_translateY_affectedRange":{"unit":"%","size":"","sizes":{"start":0,"end":100}},"motion_fx_translateX_effect":"","motion_fx_translateX_direction":"","motion_fx_translateX_speed":{"unit":"px","size":4,"sizes":[]},"motion_fx_translateX_affectedRange":{"unit":"%","size":"","sizes":{"start":0,"end":100}},"motion_fx_opacity_effect":"","motion_fx_opacity_direction":"out-in","motion_fx_opacity_level":{"unit":"px","size":10,"sizes":[]},"motion_fx_opacity_range":{"unit":"%","size":"","sizes":{"start":20,"end":80}},"motion_fx_blur_effect":"","motion_fx_blur_direction":"out-in","motion_fx_blur_level":{"unit":"px","size":7,"sizes":[]},"motion_fx_blur_range":{"unit":"%","size":"","sizes":{"start":20,"end":80}},"motion_fx_rotateZ_effect":"","motion_fx_rotateZ_direction":"","motion_fx_rotateZ_speed":{"unit":"px","size":1,"sizes":[]},"motion_fx_rotateZ_affectedRange":{"unit":"%","size":"","sizes":{"start":0,"end":100}},"motion_fx_scale_effect":"","motion_fx_scale_direction":"out-in","motion_fx_scale_speed":{"unit":"px","size":4,"sizes":[]},"motion_fx_scale_range":{"unit":"%","size":"","sizes":{"start":20,"end":80}},"motion_fx_transform_origin_x":"center","motion_fx_transform_origin_y":"center","motion_fx_devices":["desktop","tablet","mobile"],"motion_fx_range":"","motion_fx_motion_fx_mouse":"","motion_fx_mouseTrack_effect":"","motion_fx_mouseTrack_direction":"","motion_fx_mouseTrack_speed":{"unit":"px","size":1,"sizes":[]},"motion_fx_tilt_effect":"","motion_fx_tilt_direction":"","motion_fx_tilt_speed":{"unit":"px","size":4,"sizes":[]},"sticky":"","sticky_on":["desktop","tablet","mobile"],"sticky_offset":0,"sticky_offset_tablet":"","sticky_offset_mobile":"","sticky_effects_offset":0,"sticky_effects_offset_tablet":"","sticky_effects_offset_mobile":"","sticky_parent":"","_animation":"","_animation_tablet":"","_animation_mobile":"","animation_duration":"","_animation_delay":"","_transform_rotate_popover":"","_transform_rotateZ_effect":{"unit":"px","size":"","sizes":[]},"_transform_rotateZ_effect_tablet":{"unit":"deg","size":"","sizes":[]},"_transform_rotateZ_effect_mobile":{"unit":"deg","size":"","sizes":[]},"_transform_rotate_3d":"","_transform_rotateX_effect":{"unit":"px","size":"","sizes":[]},"_transform_rotateX_effect_tablet":{"unit":"deg","size":"","sizes":[]},"_transform_rotateX_effect_mobile":{"unit":"deg","size":"","sizes":[]},"_transform_rotateY_effect":{"unit":"px","size":"","sizes":[]},"_transform_rotateY_effect_tablet":{"unit":"deg","size":"","sizes":[]},"_transform_rotateY_effect_mobile":{"unit":"deg","size":"","sizes":[]},"_transform_perspective_effect":{"unit":"px","size":"","sizes":[]},"_transform_perspective_effect_tablet":{"unit":"px","size":"","sizes":[]},"_transform_perspective_effect_mobile":{"unit":"px","size":"","sizes":[]},"_transform_translate_popover":"","_transform_translateX_effect":{"unit":"px","size":"","sizes":[]},"_transform_translateX_effect_tablet":{"unit":"px","size":"","sizes":[]},"_transform_translateX_effect_mobile":{"unit":"px","size":"","sizes":[]},"_transform_translateY_effect":{"unit":"px","size":"","sizes":[]},"_transform_translateY_effect_tablet":{"unit":"px","size":"","sizes":[]},"_transform_translateY_effect_mobile":{"unit":"px","size":"","sizes":[]},"_transform_scale_popover":"","_transform_keep_proportions":"yes","_transform_scale_effect":{"unit":"px","size":"","sizes":[]},"_transform_scale_effect_tablet":{"unit":"px","size":"","sizes":[]},"_transform_scale_effect_mobile":{"unit":"px","size":"","sizes":[]},"_transform_scaleX_effect":{"unit":"px","size":"","sizes":[]},"_transform_scaleX_effect_tablet":{"unit":"px","size":"","sizes":[]},"_transform_scaleX_effect_mobile":{"unit":"px","size":"","sizes":[]},"_transform_scaleY_effect":{"unit":"px","size":"","sizes":[]},"_transform_scaleY_effect_tablet":{"unit":"px","size":"","sizes":[]},"_transform_scaleY_effect_mobile":{"unit":"px","size":"","sizes":[]},"_transform_skew_popover":"","_transform_skewX_effect":{"unit":"px","size":"","sizes":[]},"_transform_skewX_effect_tablet":{"unit":"deg","size":"","sizes":[]},"_transform_skewX_effect_mobile":{"unit":"deg","size":"","sizes":[]},"_transform_skewY_effect":{"unit":"px","size":"","sizes":[]},"_transform_skewY_effect_tablet":{"unit":"deg","size":"","sizes":[]},"_transform_skewY_effect_mobile":{"unit":"deg","size":"","sizes":[]},"_transform_flipX_effect":"","_transform_flipY_effect":"","_transform_rotate_popover_hover":"","_transform_rotateZ_effect_hover":{"unit":"px","size":"","sizes":[]},"_transform_rotateZ_effect_hover_tablet":{"unit":"deg","size":"","sizes":[]},"_transform_rotateZ_effect_hover_mobile":{"unit":"deg","size":"","sizes":[]},"_transform_rotate_3d_hover":"","_transform_rotateX_effect_hover":{"unit":"px","size":"","sizes":[]},"_transform_rotateX_effect_hover_tablet":{"unit":"deg","size":"","sizes":[]},"_transform_rotateX_effect_hover_mobile":{"unit":"deg","size":"","sizes":[]},"_transform_rotateY_effect_hover":{"unit":"px","size":"","sizes":[]},"_transform_rotateY_effect_hover_tablet":{"unit":"deg","size":"","sizes":[]},"_transform_rotateY_effect_hover_mobile":{"unit":"deg","size":"","sizes":[]},"_transform_perspective_effect_hover":{"unit":"px","size":"","sizes":[]},"_transform_perspective_effect_hover_tablet":{"unit":"px","size":"","sizes":[]},"_transform_perspective_effect_hover_mobile":{"unit":"px","size":"","sizes":[]},"_transform_translate_popover_hover":"","_transform_translateX_effect_hover":{"unit":"px","size":"","sizes":[]},"_transform_translateX_effect_hover_tablet":{"unit":"px","size":"","sizes":[]},"_transform_translateX_effect_hover_mobile":{"unit":"px","size":"","sizes":[]},"_transform_translateY_effect_hover":{"unit":"px","size":"","sizes":[]},"_transform_translateY_effect_hover_tablet":{"unit":"px","size":"","sizes":[]},"_transform_translateY_effect_hover_mobile":{"unit":"px","size":"","sizes":[]},"_transform_scale_popover_hover":"","_transform_keep_proportions_hover":"yes","_transform_scale_effect_hover":{"unit":"px","size":"","sizes":[]},"_transform_scale_effect_hover_tablet":{"unit":"px","size":"","sizes":[]},"_transform_scale_effect_hover_mobile":{"unit":"px","size":"","sizes":[]},"_transform_scaleX_effect_hover":{"unit":"px","size":"","sizes":[]},"_transform_scaleX_effect_hover_tablet":{"unit":"px","size":"","sizes":[]},"_transform_scaleX_effect_hover_mobile":{"unit":"px","size":"","sizes":[]},"_transform_scaleY_effect_hover":{"unit":"px","size":"","sizes":[]},"_transform_scaleY_effect_hover_tablet":{"unit":"px","size":"","sizes":[]},"_transform_scaleY_effect_hover_mobile":{"unit":"px","size":"","sizes":[]},"_transform_skew_popover_hover":"","_transform_skewX_effect_hover":{"unit":"px","size":"","sizes":[]},"_transform_skewX_effect_hover_tablet":{"unit":"deg","size":"","sizes":[]},"_transform_skewX_effect_hover_mobile":{"unit":"deg","size":"","sizes":[]},"_transform_skewY_effect_hover":{"unit":"px","size":"","sizes":[]},"_transform_skewY_effect_hover_tablet":{"unit":"deg","size":"","sizes":[]},"_transform_skewY_effect_hover_mobile":{"unit":"deg","size":"","sizes":[]},"_transform_flipX_effect_hover":"","_transform_flipY_effect_hover":"","_transform_transition_hover":{"unit":"px","size":"","sizes":[]},"motion_fx_transform_x_anchor_point":"","motion_fx_transform_x_anchor_point_tablet":"","motion_fx_transform_x_anchor_point_mobile":"","motion_fx_transform_y_anchor_point":"","motion_fx_transform_y_anchor_point_tablet":"","motion_fx_transform_y_anchor_point_mobile":"","_background_background":"","_background_color":"","_background_color_stop":{"unit":"%","size":0,"sizes":[]},"_background_color_stop_tablet":{"unit":"%"},"_background_color_stop_mobile":{"unit":"%"},"_background_color_b":"#f2295b","_background_color_b_stop":{"unit":"%","size":100,"sizes":[]},"_background_color_b_stop_tablet":{"unit":"%"},"_background_color_b_stop_mobile":{"unit":"%"},"_background_gradient_type":"linear","_background_gradient_angle":{"unit":"deg","size":180,"sizes":[]},"_background_gradient_angle_tablet":{"unit":"deg"},"_background_gradient_angle_mobile":{"unit":"deg"},"_background_gradient_position":"center center","_background_image":{"url":"","id":"","size":""},"_background_image_tablet":{"url":"","id":"","size":""},"_background_image_mobile":{"url":"","id":"","size":""},"_background_position":"","_background_position_tablet":"","_background_position_mobile":"","_background_xpos":{"unit":"px","size":0,"sizes":[]},"_background_xpos_tablet":{"unit":"px","size":0,"sizes":[]},"_background_xpos_mobile":{"unit":"px","size":0,"sizes":[]},"_background_ypos":{"unit":"px","size":0,"sizes":[]},"_background_ypos_tablet":{"unit":"px","size":0,"sizes":[]},"_background_ypos_mobile":{"unit":"px","size":0,"sizes":[]},"_background_attachment":"","_background_repeat":"","_background_repeat_tablet":"","_background_repeat_mobile":"","_background_size":"","_background_size_tablet":"","_background_size_mobile":"","_background_bg_width":{"unit":"%","size":100,"sizes":[]},"_background_bg_width_tablet":{"unit":"px","size":"","sizes":[]},"_background_bg_width_mobile":{"unit":"px","size":"","sizes":[]},"_background_video_link":"","_background_video_start":"","_background_video_end":"","_background_play_once":"","_background_play_on_mobile":"","_background_privacy_mode":"","_background_video_fallback":{"url":"","id":"","size":""},"_background_slideshow_gallery":[],"_background_slideshow_loop":"yes","_background_slideshow_slide_duration":5000,"_background_slideshow_slide_transition":"fade","_background_slideshow_transition_duration":500,"_background_slideshow_background_size":"","_background_slideshow_background_size_tablet":"","_background_slideshow_background_size_mobile":"","_background_slideshow_background_position":"","_background_slideshow_background_position_tablet":"","_background_slideshow_background_position_mobile":"","_background_slideshow_lazyload":"","_background_slideshow_ken_burns":"","_background_slideshow_ken_burns_zoom_direction":"in","_background_hover_background":"","_background_hover_color":"","_background_hover_color_stop":{"unit":"%","size":0,"sizes":[]},"_background_hover_color_stop_tablet":{"unit":"%"},"_background_hover_color_stop_mobile":{"unit":"%"},"_background_hover_color_b":"#f2295b","_background_hover_color_b_stop":{"unit":"%","size":100,"sizes":[]},"_background_hover_color_b_stop_tablet":{"unit":"%"},"_background_hover_color_b_stop_mobile":{"unit":"%"},"_background_hover_gradient_type":"linear","_background_hover_gradient_angle":{"unit":"deg","size":180,"sizes":[]},"_background_hover_gradient_angle_tablet":{"unit":"deg"},"_background_hover_gradient_angle_mobile":{"unit":"deg"},"_background_hover_gradient_position":"center center","_background_hover_image":{"url":"","id":"","size":""},"_background_hover_image_tablet":{"url":"","id":"","size":""},"_background_hover_image_mobile":{"url":"","id":"","size":""},"_background_hover_position":"","_background_hover_position_tablet":"","_background_hover_position_mobile":"","_background_hover_xpos":{"unit":"px","size":0,"sizes":[]},"_background_hover_xpos_tablet":{"unit":"px","size":0,"sizes":[]},"_background_hover_xpos_mobile":{"unit":"px","size":0,"sizes":[]},"_background_hover_ypos":{"unit":"px","size":0,"sizes":[]},"_background_hover_ypos_tablet":{"unit":"px","size":0,"sizes":[]},"_background_hover_ypos_mobile":{"unit":"px","size":0,"sizes":[]},"_background_hover_attachment":"","_background_hover_repeat":"","_background_hover_repeat_tablet":"","_background_hover_repeat_mobile":"","_background_hover_size":"","_background_hover_size_tablet":"","_background_hover_size_mobile":"","_background_hover_bg_width":{"unit":"%","size":100,"sizes":[]},"_background_hover_bg_width_tablet":{"unit":"px","size":"","sizes":[]},"_background_hover_bg_width_mobile":{"unit":"px","size":"","sizes":[]},"_background_hover_video_link":"","_background_hover_video_start":"","_background_hover_video_end":"","_background_hover_play_once":"","_background_hover_play_on_mobile":"","_background_hover_privacy_mode":"","_background_hover_video_fallback":{"url":"","id":"","size":""},"_background_hover_slideshow_gallery":[],"_background_hover_slideshow_loop":"yes","_background_hover_slideshow_slide_duration":5000,"_background_hover_slideshow_slide_transition":"fade","_background_hover_slideshow_transition_duration":500,"_background_hover_slideshow_background_size":"","_background_hover_slideshow_background_size_tablet":"","_background_hover_slideshow_background_size_mobile":"","_background_hover_slideshow_background_position":"","_background_hover_slideshow_background_position_tablet":"","_background_hover_slideshow_background_position_mobile":"","_background_hover_slideshow_lazyload":"","_background_hover_slideshow_ken_burns":"","_background_hover_slideshow_ken_burns_zoom_direction":"in","_background_hover_transition":{"unit":"px","size":"","sizes":[]},"_border_border":"","_border_width":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_border_width_tablet":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_border_width_mobile":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_border_color":"","_border_radius":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_border_radius_tablet":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_border_radius_mobile":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_box_shadow_box_shadow_type":"","_box_shadow_box_shadow":{"horizontal":0,"vertical":0,"blur":10,"spread":0,"color":"rgba(0,0,0,0.5)"},"_box_shadow_box_shadow_position":" ","_border_hover_border":"","_border_hover_width":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_border_hover_width_tablet":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_border_hover_width_mobile":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_border_hover_color":"","_border_radius_hover":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_border_radius_hover_tablet":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_border_radius_hover_mobile":{"unit":"px","top":"","right":"","bottom":"","left":"","isLinked":true},"_box_shadow_hover_box_shadow_type":"","_box_shadow_hover_box_shadow":{"horizontal":0,"vertical":0,"blur":10,"spread":0,"color":"rgba(0,0,0,0.5)"},"_box_shadow_hover_box_shadow_position":" ","_border_hover_transition":{"unit":"px","size":"","sizes":[]},"_mask_switch":"","_mask_shape":"circle","_mask_image":{"url":"","id":"","size":""},"_mask_notice":"","_mask_size":"contain","_mask_size_tablet":"","_mask_size_mobile":"","_mask_size_scale":{"unit":"%","size":100,"sizes":[]},"_mask_size_scale_tablet":{"unit":"px","size":"","sizes":[]},"_mask_size_scale_mobile":{"unit":"px","size":"","sizes":[]},"_mask_position":"center center","_mask_position_tablet":"","_mask_position_mobile":"","_mask_position_x":{"unit":"%","size":0,"sizes":[]},"_mask_position_x_tablet":{"unit":"px","size":"","sizes":[]},"_mask_position_x_mobile":{"unit":"px","size":"","sizes":[]},"_mask_position_y":{"unit":"%","size":0,"sizes":[]},"_mask_position_y_tablet":{"unit":"px","size":"","sizes":[]},"_mask_position_y_mobile":{"unit":"px","size":"","sizes":[]},"_mask_repeat":"no-repeat","_mask_repeat_tablet":"","_mask_repeat_mobile":"","hide_desktop":"","hide_tablet":"","hide_mobile":"","_attributes":"","custom_css":""},"defaultEditSettings":{"defaultEditRoute":"content"},"elements":[],"widgetType":"image","htmlCache":"\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t","editSettings":{"defaultEditRoute":"content","panel":{"activeTab":"content","activeSection":"section_image"}}}]} SQL 資料分析 企業案例 用SQL 實際解析商業問題 SQL 是資料工作者必備第一技能
ALPHA Camp SSQL 課程:14 天從基礎語法到實戰案例 學會 SQL,可以讓你: 自己抓資料 不用拜託工程師! 資料橫跨各種表單 也能輕鬆解決! 可以處理大量資料 做深入分析!
ALPHA Camp SQL 課程:14 天從基礎語法到實戰案例 在綠藤 , 我們仰賴資料 找到使用者的脈絡 進而找到營運的解答 Harris 綠藤生機 共同創辦人暨執行長
ALPHA Camp SQL 課程:14 天從基礎語法到實戰案例 課程大綱 語法學習 1. 用 SQL 建立資料庫 情景應用題 2. SQL 資料處理入門:外送平台綜合練習題 3. SQL 進階實戰語法應用 真實企業案例 4. 企業案例A:線上課程平台,學生學習成效分析 5. 企業案例B:電商綠藤生機,新客回購率分析
ALPHA Camp SSQL 課程:14 天從基礎語法到實戰案例 最強講師集結 Youchi Kuo ex-BCG,前 ALPHA Camp 營運長 為課程中的企業案例 設計拆解問題流程 將商業問題變成 「資料能夠回答」的問題 Morris 前綠藤生機 成長行銷副理 專精於 MarTech 領域 擅長數據分析 致力於技術、商業可持續性 與用戶需求間的平衡 Cliff ex-Grab, Data Strategist 有十年數據服務經驗 協助企業打造數據策略 在課程中擔任 SQL 語法教練 SQL 資料分析 企業案例 用SQL 實際解析商業問題

課程已完整釋出,即買即上課!

ALPHA Camp SQL 課程:14 天從基礎語法到實戰案例 Youchi Kuo ex-BCG,前 ALPHA Camp 營運長 Morris 前綠藤生機 成長行銷副理 Cliff ex-Grab, Data Strategist SQL 資料分析 企業案例 用SQL 實際解析商業問題 課程獨特優勢
ALPHA Camp SSQL 課程:14 天從基礎語法到實戰案例 Youchi Kuo ex-BCG,前 ALPHA Camp 營運長 Morris 前綠藤生機 成長行銷副理 Cliff ex-Grab, Data Strategist SQL 資料分析 企業案例 用SQL 實際解析商業問題 2個真實企業案例 電商綠藤生機 & 線上課程平台 讓你打好實戰基礎 ALPHACamp 企業案例:線上學習分析 綠藤生機 企業案例:新客回購率
ALPHA Camp SSQL 課程:14 天從基礎語法到實戰案例Youchi Kuo ex-BCG,前 ALPHA Camp 營運長 Morris 前綠藤生機 成長行銷副理 Cliff ex-Grab, Data Strategist SQL 資料分析 企業案例 用SQL 實際解析商業問題 1對1助教批改 專業助教團隊 , 提供撰寫參考解答 讓你學習更有效率 Po Jian Pixl Solutions Data Engineer 敏弘 / Miguu iCHEF 資料分析師 Kai 台灣最大的匿名交流平台 Data Analyst Shu-Ting 知名電商平台 Data Engineert Dan Data Scientist Global SW App Kerwin 趨勢科技 Data Analyst
ALPHA Camp SQL 課程:14 天從基礎語法到實戰案例 Youchi Kuo ex-BCG,前 ALPHA Camp 營運長 Morris 前綠藤生機 成長行銷副理 Cliff ex-Grab, Data Strategist SQL 資料分析 企業案例 用SQL 實際解析商業問題 14天學習進度規劃 4天基礎語法+7天組合運用+3天企業案例實戰 讓你每天都持續在進步
ALPHA Camp SQL 課程:14 天從基礎語法到實戰案例 Youchi Kuo ex-BCG,前 ALPHA Camp 營運長 Morris 前綠藤生機 成長行銷副理 Cliff ex-Grab, Data Strategist SQL 資料分析 企業案例 用SQL 實際解析商業問題 現在購買,就送: 綠藤生機商業分析 SQL case study 完整影片精華 內含綠藤生機團隊親自分享: 1.綠藤如何透過數據解決問題 2.業界分析實務 3.數據人才需要具備的能力與特質 現在加入,啟動你的數據學習!

現在加入,啟動你的數據學習!

※ ALPHA Camp 團隊與講師保留課綱最後微調的權益,相關變動會與參與學員告知更新。

課程大綱
  • 購買後,將會立即收到平台啟動通知信,即可開始上課
  • 建議學習時數約為 48~52 小時,建議每週保留完整的 2~3 小時完成指定作業
  • 本課程將使用線上資料庫環境學習
  • 課程助教批改與問題回覆時間至 2024.05.31,即買即用

認識「資料和資料庫」基本觀念,並開始操作資料庫

你將會學到:SQL 基礎語法

・認識關連式資料庫
・動手設定 SQL 資料庫
・SQL 的 Coding Style
・基礎資料操作 CRUD:新增、更新、刪除語法

📍綜合練習情境 – 送餐平臺。

練習在資料表上運算、分析、資料整理

你將會學到 SQL 進階操作:

・SELECT DISTINCT
・SELECT ORDER BY
・SELECT LIMIT OFFSET
・SELECT IN SELECT
・SELECT WHERE LIKE / IN / BETWEEN
・GROUP BY / HAVING
・JOIN / UNION

📍綜合練習情境 1 – 送餐平臺。
📍綜合練習情境 2 – 飲料店。

學習特定語法處理更複雜的問題

你將會學到:

・時間的處理
・CASE WHEN 進行分群
・WHEN 結合運算
・用 SQL 寫樞紐分析表
・長 Query 應用

商業問題:受疫情變化影響,學生表現似乎比起前一季落後

你會一步步完成分析:

・第一步:確認核心問題「學生投入學習的時間」
・第二步:驗證不同背景的學生,是否會有不同的投入程度
・第三步:驗證假設「學習成效」是否遇到挑戰

📍你的分析結果,會由業界專業前輩提供回饋

商業問題:如何提升顧客回購率,提升新客的第二次購買

你會一步步完成分析:

・第一步:確認核心問題「回購率是否增長」
・第二步:驗證回購與否與「首購產品類型」有關
・第三步:驗證首購品項與「通路」有關

📍你的分析結果,將由業界專業前輩提供回饋

※ ALPHA Camp 團隊與講師保留課綱最後微調的權益,相關變動會與參與學員告知更新。

選購方案

限時優惠 83 折

即買即上,無需等待

$2,299

原價 $2,780

如有專屬折扣碼,請在結帳前輸入

限時優惠:即日至 04/01 (一)  AM 11:59 前

課程已完整釋出,即買即上課

SQL 14天

從基礎語法到實戰案例

$2,780

如有專屬折扣碼,請在結帳前輸入

課程已完整釋出,即買即上課

講師介紹
ALPHA Camp Cliff ex-Grab, Data Strategist SQL 課程:14 天從基礎語法到實戰案例

Cliff

ex-Grab, Data Strategist

擁有十年數據服務經驗,協助企業打造數據策略。

ALPHA Camp Youchi Kuo ex-BCG,前 ALPHA Camp 營運長 SQL 課程:14 天從基礎語法到實戰案例

Youchi

ex-BCG,前 ALPHA Camp 營運長

擁有十年BCG 管理顧問經驗,為 ALPHA Camp 企業案例設計拆解問題流程,將商業問題變成「資料能夠回答」的問題。

ALPHA Camp Morris 前綠藤生機 成長行銷副理 SQL 課程:14 天從基礎語法到實戰案例

Morris

前綠藤生機 成長行銷副理

擁有跨產業產品開發經驗,專精於 MarTech 領域,擅長數據分析,致力於技術、商業可持續性與用戶需求間的平衡。

常見問題

課程都是採用「線上學習」的方式,皆為事先準備好的學習教材,學生會在 AC 學習平台上進行學習。
因此開課後即可開始在 AC 學習平台上瀏覽教材,自由且彈性地安排當週時間學習。

在基礎語法學習的部分,除了 AC 自製內容之外,另外選擇使用 SQLZOO + W3Schools 這兩個開源的 SQL 練習和語法教學的權威網站,作為部分課程內容,並專注設計這過程中的引導。最重要的原因在於:幫助同學建立長期技術學習能力

秉持著「培養技術&學習能力」並重的精神,希望在學習 SQL 的過程當中,也能帶著同學有效利用公開資源來建立查找資料解決問題的能力,未來即使遇到沒練習過的問題和情境也能有足夠的學習力解決。

每天的學習份量為 2~4 小時,共 14 天。不論你想跟著菜單一天 2~4 小時,或按照自己的節奏加快衝刺、慢慢學習,都沒問題!

課程最後,完成企業案例並獲得助教批改,通過者即可獲得證書。

【 無限期觀看課程內容 】
課程教材、助教與同學的問答、作業回饋等內容,都還會留在學習平台上,可以隨時回頭複習,無限期觀看。

【 限期助教支援】
助教回覆與作業批改期限至 2024/12/31 但,商業問題時常不會只有一個解答,在批改時間截止後,你可以透過 AC 的學習社群和同儕交流。

學習途中如有任何疑問,可於 AC 學習平台中提問助教。
• 作業若為有參考類型的作業,會提供參考解答或講師 demo 影片,不另外做個別批改。
• 同學若有對作業詳解的疑問,可直接提問

另,AC 也會不定期舉辦線上工作坊,類型包含:
• 線上解題 Q&A – 彙整同學常見問題和優化方向,由助教一次回答釐清
• 案例實作開箱 – 邀請已經完成案例的學長姐分享分析思維

可以。
當你於報名頁面填寫名字與信箱報名後,會進入付款相關頁面,在頁面上有【發票資訊】的欄位,這邊請選擇【公司發票】,即會出現統編填寫欄位。

鑑賞期 5 天。
學生可於「購買課程當日」起, 5 日鑑賞期之內來信提出退費申請,可以無條件取消註冊併全額退款,惟因退費所生之一切費用,包含但不限於處理費、手續費、工本費等等,均由同學負擔。

延伸閱讀
數據分析師 (Data Analyst) 的工作內容、需要特質、薪水、3 個必備技能

數據分析師 (Data Analyst) 的工作內容、需要特質、薪水、3 個必備技能

數據分析師(Data Analyst)又稱資料分析師,一般定義是能將原始數據轉化成可用於制定決策的資訊和知識的...

發展數據分析職涯,值得你訂閱的四份電子報

發展數據分析職涯,值得你訂閱的四份電子報

本文要推薦四份數據分析主題的電子報,外加兩個部落格。不論是準備跨足數據分析領域、對資料視覺化與資料科學感興趣,...

轉職、應徵數據分析師,評估自己準備好了沒的方法和 2 個補強技巧

轉職、應徵數據分析師,評估自己準備好了沒的方法和 2 個補強技巧

作者 Nancy Yang 五年前從電商行銷成功轉戰商業分析領域,她將在本文從自身經驗出發,與讀者分享成為商業...

SQL 入門課程,帶我掌握數據,累積商業案例分析經驗

SQL 入門課程,帶我掌握數據,累積商業案例分析經驗

Ruey 是名需要做銷售資料分析,但過去僅依賴工程師與 Excel、完全沒使用過 SQL 的工作者。在「SQL...

alphacamp
訂閱最新消息
請勾選您最感興趣的內容 ( 可複選 )