GitHub - malloydata/malloy: Malloy is an experimental language for describing data relationships and transformations.You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
社内SQLç ”ä¿®ã®ãŸã‚ã«ä½œã£ãŸè³‡æ–™ã‚’公開ã—ã¾ã™ | æ ªå¼ä¼šç¤¾AI Shift
ã“ã‚“ã«ã¡ã¯ã€Development Teamã®ä¸‰å®…ã§ã™ã€‚ 先日ã€ç¤¾å†…（AI事æ¥æœ¬éƒ¨å†…）ã§SQLç ”ä¿®ã®è¬›å¸«ã‚’担当ã—ãŸã®ã§ã€ä»Šå›žã¯ãã®å†…容ã«ã¤ã„ã¦ç°¡å˜ã«å…±æœ‰ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¯ã˜ã‚㫠例年ã€AI事æ¥æœ¬éƒ¨ã§ã¯ã€æ–°å’エンジニアã®è‚²æˆã®ãŸã‚ã«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ç ”修を行ã£ã¦ãŠã‚Šã¾ã™ã€‚今年ã¯ãƒ•ãƒ«ãƒªãƒ¢ãƒ¼ãƒˆã§ã®å®Ÿæ–½ã¨ãªã‚Šã¾ã—ãŸã€‚ç ”ä¿®æœŸé–“ã¯2週間ã»ã©ã§ã€å†…容ã¯å‰åŠãŒè¬›ç¾©ã€å¾ŒåŠãŒå®Ÿè·µï¼ˆãƒãƒ¼ãƒ 開発）ã§ã—ãŸã€‚ç§ãŒæ‹…当ã—ãŸã®ã¯ã€è¬›ç¾©ãƒ‘ートã®ä¸€éƒ¨ã§ã‚ã‚‹SQLç ”ä¿®ã§ã™ã€‚SQLã‚„RDBã«ã‚ã¾ã‚Šæ…£ã‚Œã¦ã„ãªã„人ã§ã‚‚ã€ã§ãã‚‹ã ã‘体系的ãªå¦ã³ãŒå¾—られるよã†ã«ã™ã‚‹ã“ã¨ã‚’目標ã«ã€æ§˜ã€…ãªè³‡æ–™ã‚’ã¾ã¨ã‚ã¦æä¾›ã™ã‚‹æ–¹é‡ã§æº–å‚™ã—ã¾ã—ãŸã€‚çµæžœçš„ã«ã¯ã€ãƒãƒ³ã‚ºã‚ªãƒ³è¾¼ã¿ã§4時間ã»ã©ã®ã‚„ã‚„é•·ã„講義ã¨ãªã‚Šã¾ã—ãŸãŒã€å‹‰å¼·ã«ãªã£ãŸã¨ã„ã†å£°ã‚‚é ‚ã‘ãŸã®ã§ã‚„ã£ã¦è‰¯ã‹ã£ãŸã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ç ”ä¿®è³‡æ–™ ç ”ä¿®å†…å®¹ SQLç ”ä¿®ã®å†…容ã¯ã€åŸºæœ¬çš„ã«ã¯å¤§å¦ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¬›ç¾©ã§
Practical SQL for Data Analysis
Pandas is a very popular tool for data analysis. It comes built-in with many useful features, it's battle tested and widely accepted. However, pandas is not always the best tool for the job. SQL databases have been around since the 1970s. Some of the smartest people in the world worked on making it easy to slice, dice, fetch and manipulate data quickly and efficiently. SQL databases have come such
æ•°å—ã®ãƒãƒ©ä»˜ãを考慮ã—ã¦æ„æ€æ±ºå®šã™ã‚‹æŠ€è¡“ - Hatena Developer Blog
ã“ã‚“ã«ã¡ã¯ã€‚Mackerelãƒãƒ¼ãƒ ã§CRE(Customer Reliability Engineer)ã‚’ã—ã¦ã„ã‚‹id:syou6162ã§ã™ã€‚主ã«ã‚«ã‚¹ã‚¿ãƒžãƒ¼ã‚µã‚¯ã‚»ã‚¹ã‚’支ãˆã‚‹ãƒ‡ãƒ¼ã‚¿åŸºç›¤ã®æ§‹ç¯‰ã‚„ã€ãƒ‡ãƒ¼ã‚¿åˆ†æžã‚’担当ã—ã¦ã„ã¾ã™ã€‚ æ„æ€æ±ºå®šã‚’ã™ã‚‹éš›ã«ã¯ä¸ç¢ºå®Ÿæ€§ãŒã¤ãã¾ã¨ã„ã¾ã™ãŒã€ä¸ç¢ºå®Ÿæ€§ã‚’ä¿¡é ¼åŒºé–“ã¨ã„ã†å½¢ã§è€ƒæ…®ã—ã¦æ„æ€æ±ºå®šã‚’è¡ŒãªãŠã†ã€ã¨ã„ã†è©±ã‚’ã—ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã¯ã¯ã¦ãªã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ Advent Calendar 2020ã®4日目ã®è¨˜äº‹ã§ã™ã€‚ å‰æ—¥ã¯id:dekokunã•ã‚“ã«ã‚ˆã‚‹Google Cloud ã® Associate Cloud Engineer è³‡æ ¼ã‚’å–å¾—ã™ã‚‹ãŸã‚ã«ã—ãŸå‹‰å¼·ã§ã—ãŸã€‚ æ•°å—ã®ãƒãƒ©ä»˜ãを考慮ã—ã¦æ„æ€æ±ºå®šã—ãŸã„ケース: NPSã§ã®äº‹ä¾‹ 統計å¦ã‚’使ã£ã¦æ•°å—ã®ãƒãƒ©ä»˜ãを考慮ã™ã‚‹: ä¿¡é ¼åŒºé–“ NPSã®ä¿¡é ¼åŒºé–“ã‚’SQLã§è¨ˆç®—ã™ã‚‹ ã¾ã¨ã‚ æ•°å—ã®ãƒãƒ©ä»˜ãを考慮ã—ã¦æ„æ€æ±ºå®šã—ãŸã„ケース: N
SQLå¦ç¿’モãƒãƒ™ã‚’爆上ã’ã™ã‚‹ã€ŒSQLテスト制度ã€ã‚’å°Žå…¥ã—ã¦ã„る話 - AppBrew Tech Blog
ã“ã‚“ã«ã¡ã¯ã€æœ€è¿‘ã¯ã‚¢ãƒ—リグãƒãƒ¼ã‚¹ã‚’担当ã—ã¦ã„ã‚‹abeshi（@abeshi_official）ã§ã™ã€‚ 美容ã®ãƒ—ラットフォーム「LIPSã€ã‚’é‹å–¶ã™ã‚‹AppBrewã§ã¯éžé–‹ç™ºè·ã®SQLç¿’å¾—ã«åŠ›ã‚’入れã¦ã„ã¾ã™ã€‚誰ã§ã‚‚Re:dashã‚„ãƒã‚°ã‚’触れる状態ã«ãªã£ã¦ã„ã‚‹ã—ã€ãã‚Œãžã‚Œã®DBã«ä½•ãŒã©ã†å…¥ã£ã¦ã„ã‚‹ã‹ã‚’共有ã™ã‚‹ãŸã‚ã®ãƒ‰ã‚ュメントもå˜åœ¨ã—ã¦ã„ã¾ã™ã€‚ 「éžé–‹ç™ºè·ã‚‚SQL書ã‘るよã†ã«é ‘å¼µã‚ã†ï¼ã€ã¨æŽ²ã’ãŸã¨ã“ã‚ã§ã€å½“ã®æœ¬äººãŸã¡ã¯æ¯Žæ—¥ä»•äº‹ãŒå¿™ã—ããªã‹ãªã‹æ™‚é–“ã‚‚å–ã‚Œãªã„上ã«æ˜Žç¢ºãªç›®æ¨™ãŒãªã„ã¨ã„ã¾ã„ã¡å¦ç¿’モãƒãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä¿ã¤ã“ã¨ãŒã§ãã¾ã›ã‚“。ãã“ã§å¼Šç¤¾ãŒå°Žå…¥ã—ãŸã®ãŒã€ŒSQLテスト制度ã€ã§ã™ã€‚ âœï¸SQLテスト制度ã¨ã¯ SQLã®å¦ç¿’到é”度ã«ã‚ˆã£ã¦ãƒ¬ãƒ™ãƒ«ã”ã¨ã«åˆ†ã‘ãŸãƒ†ã‚¹ãƒˆã§ã€åˆæ ¼ã™ã‚‹ã¨çµ¦ä¸ŽãŒä¸ŠãŒã‚Šã¾ã™ã€‚ *1ç¾åœ¨ã¯äºŒã¤ãƒ¬ãƒ™ãƒ«ãŒå˜åœ¨ã—ã¦ã„ã¦ã€ ã€ãƒ¬ãƒ™ãƒ«2】... åˆå¦è€…å‘ã‘ã§where・joinãªã©åŸºæœ¬çš„ãªæ–‡æ³•ãŒä½¿ãˆ
ウェブãƒã‚°ã‹ã‚‰SQLã§æŒ‡æ¨™ã‚’計算ã™ã‚‹8構文～GA4ã®BigQueryã‚’é¡Œæ㫠– marketechlabo
Googleアナリティクス4プãƒãƒ‘ティãŒç™»å ´ã—ã€èª°ã§ã‚‚BigQueryã«ãƒã‚°ã‚’出力ã§ãるよã†ã«ãªã£ãŸã€‚ãƒã‚°åˆ†æžã‚’始ã‚る環境ã¯æƒã£ãŸã‚ã‘ã ãŒã€ãƒã‚°åˆ†æžã®ãƒŽã‚¦ãƒã‚¦ã¯ã‚ã¾ã‚Šä¸–ã«å‡ºã¦ã„ãªã„。SQLを使ã£ã¦ã“れらを分æžã™ã‚‹æ–¹æ³•ã‚’å°‘ã—紹介ã™ã‚‹ã€‚ã©ã‚“ãªé«˜åº¦ãªãƒã‚°åˆ†æžã‚’ã™ã‚‹ã«ã—ã¦ã‚‚ã€ã“ã‚ŒãŒåŸºæœ¬ã¨ãªã‚‹ã€‚ ウェブ分æžã®æŒ‡æ¨™ ウェブ分æžã®åŸºæœ¬ã¯ ページビュー数 セッション数 人数 ã®ã‚«ã‚¦ãƒ³ãƒˆã§ã‚る。複雑ãªåˆ†æžã‚‚ã€çµå±€ã‚«ã‚¦ãƒ³ãƒˆã—ã¦ã„ã‚‹ã®ã¯ã“ã®3ã¤ã®æŒ‡æ¨™ã«é›†ç´„ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„。Eコマースã«ãªã‚‹ã¨è³¼å…¥é‡‘é¡ã®åˆè¨ˆãªã©ã‚‚å…¥ã£ã¦ãã‚‹ã“ã¨ã¯ã‚る。 ãã—ã¦ã“ã‚Œã«ã€Œâ—‹â—‹ã—ãŸã€ã¨ã„ã†æ¡ä»¶ãŒä»˜ã„㦠イベント○○ãŒç™ºç”Ÿã—ãŸå›žæ•° â—‹â—‹ã—ãŸãƒšãƒ¼ã‚¸ãƒ“ュー数 パラメータ△△ã®å€¤ãŒâ–¡â–¡ã ã£ãŸã‚¤ãƒ™ãƒ³ãƒˆâ—‹â—‹ãŒç™ºç”Ÿã—ãŸå›žæ•°ï¼ˆãƒšãƒ¼ã‚¸â–¡â–¡ã®ãƒšãƒ¼ã‚¸ãƒ“ュー数） â—‹â—‹ã—ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³æ•° â—‹â—‹ã—ãŸäººæ•° ã‚’ã²ãŸã™ã‚‰ã‚«ã‚¦ãƒ³ãƒˆã™ã‚‹ã€‚ãŸã¨ãˆã° 資料ダウンãƒãƒ¼ãƒ‰ãƒœã‚¿ãƒ³ã‚’クリ
Some SQL Tricks of an Application DBA
When I started my career in development, my first job was a DBA. Back then, before AWS RDS, Azure, Google Cloud and the rest of them cloud services, there were two types of DBAs: The Infrastructure DBA was in charge of setting up the database, configuring the storage and taking care of backups and replication. After setting up the database, the infrastructure DBA would pop up from time to time and
ã™ã¹ã¦ã®ã‚¨ãƒ‡ã‚£ã‚¿ã§SQLã®è‡ªå‹•è£œå®Œã‚’ã™ã‚‹ãŸã‚ã«SQL Language Server(sqls)を作ã£ãŸ - Qiita
MySQL互æ›ã®ãƒ‘ーサーãŒå¤šã„å°è±¡ã§ã™ã。ã©ã®SQLパーサーを利用ã™ã‚‹ã®ãŒæœ€ã‚‚é©åˆ‡ãªã®ã‹3æ—¥ã»ã©æ‚©ã¿ã¾ã—ãŸãŒã€ãŠãらã1ヶ月悩んã§ã‚‚çµè«–ã¯ã§ãªã„ã¨é€”ä¸ã§æ°—ãŒä»˜ãã€ã‚¶ãƒ©ãƒƒã¨ä¸èº«ã‚’見ãŸæ„Ÿã˜ã‚·ãƒ³ãƒ—ルãªä½œã‚Šã®xwb1989/sqlparserã‚’ãƒãƒ§ã‚¤ã‚¹ã—ã¾ã—ãŸã€‚ xwb1989/sqlparserã§é©å½“ãªSELECT文をパースã™ã‚‹ã¨AST(Abstract Syntax Tree)ãŒæ§‹é€ 体ã¨ã—ã¦è¿”å´ã•ã‚Œã¦ãã¾ã—ãŸã€‚ASTã¨ã¯èžã„ãŸã“ã¨ãŒã‚ã‚Šã¾ã™ãŒä½•ãªã®ã‹ã¯å…¨ãã‚ã‹ã‚Šã¾ã›ã‚“。怖ã„ã§ã™ã。 ASTãŒä½•ãªã®ã‹ã¯ã‚ã‹ã‚Šã¾ã›ã‚“ãŒã€ã²ã¨ã¾ãšä¸èº«ã‚’解æžã—ã¦ã¿ã‚‹ã¨SELECT文をèªã¿å–ã£ãŸã‚‰SELECT文を表ç¾ã—ãŸæ§‹é€ 体ã«æƒ…å ±ã‚’æ ¼ç´ã—ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã¯ã‚ã‹ã‚Šã¾ã—ãŸã€‚æ§‹é€ ä½“ã‚’æ›´ã«ãŸã©ã£ã¦ã¿ã‚‹ã¨ã“ã®SELECTæ–‡ã©ã®ãƒ†ãƒ¼ãƒ–ルをå‚ç…§ã—ã¦ã„ã‚‹ã®ã‹ã€JOINã—ã¦ã„るテーブルã¯ä½•ã‹ãªã‚“ã¦ã“ã¨ã‚‚ã‚ã‹ã‚Šã¾ã™ã€‚ã“ã‚Œãªã‚‰è£œå®Œå€™è£œãŒå‡º
SQL Tutorial
グループåˆåŒã®æ–°å’ç ”ä¿®ã§è¡Œã£ãŸ SQL 入門å‘ã‘ã®è§£èª¬ + ワークショップã§ã™ã€‚ 基本的ãªéƒ¨åˆ†ã®è§£èª¬ã®ã¿ã§ã€ä¸€éƒ¨è§¦ã‚Œã¦ã„ãªã„構文もã”ã–ã„ã¾ã™ã€‚ ã”了承ãã ã•ã„。 KKK: ä¾¡æ ¼, TNK: å˜ä¾¡, MST: マスタ, IDX: インデックス # URL HomePage: https…
ランã‚ング
ランã‚ング
メンテナンス
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
GitHub - muhmud/qsh: shell-based query tool
Query and visualize CSV files using SQL
GitHub - kamijin-fanta/prrn: Simple migration tool for MySQL
Best practices for writing SQL queries | Metabase Learn
GitHub - joereynolds/sql-lint: An SQL linter
GitHub - mergestat/mergestat-lite: Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔠📊
GitHub - adelsz/pgtyped: pgTyped - Typesafe SQL in TypeScript
The SQL Editor and Database Manager Of Your Dreams
The Best Medium-Hard Data Analyst SQL Interview Questions
GitHub - plotly/falcon: Free, open-source SQL client for Windows and Mac 🦅
Start-SQL | SQLå¦ç¿’Webサービス
{{#tags}}- {{label}}
{{/tags}}