Found 57 results for "tag:sql"

• An Introduction to SQL for Weary Data Scientists

  https://gvwilson.github.io/sql-tutorial/?utm_source=hackernewsletter&utm_medium=email&utm_term=fav

  sql

• Ask HN: Are there any websites for SQL puzzle games? | Hacker News

  https://news.ycombinator.com/item?id=39547822&utm_source=unknownews

  sql

• CS50's Introduction to Databases with SQL

  https://cs50.harvard.edu/sql/2024/

  An introduction to databases using a language called SQL.

  sql

• CS50x 2024 - Lecture 7 - SQL

  https://www.youtube.com/watch?v=1RCMYG8RUSE

  ***This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming.***TABLE OF CONTENTS00:00:0...

  sql

• Co musi wiedzieć bazodanowiec w 2025 roku(oprócz SQL)?

  https://www.youtube.com/@nieinformatyk/videos

  ✅Chcesz zostać programistą hurtowni danych? A może programistą baz danych? Praca z danymi wymaga czegoś więcej niż tylko znajomości samego SQL-a. W tym nagraniu omawiam 15 technologii informatycznych, narzędzi BI i konceptów DWH/DB, które powinieneś dziś znać by świetnie radzić sobie na rynku pracy. 🎁 ODBIERZ PREZENTY/ZAPIS NA NEWSLETTER: 1) Roadmapa SQL w PDF: https://promo.mistrzsql.pl/ 2) Książka o tym, jak zostać programistą baz danych: https://promo.podstawybazdanych.pl/ 3) Lista najczęstszych błędów programistów PL/SQL: https://promo.plsql.pl/ == ⏱️ Plan odcinka:== 00:00 wprowadzenie do odcinka 00:41 kim jest bazodanowiec? 01:37 roadmapa technologii bazodanowych 03:06 język zapytań SQL[1] 04:32 znajomość baz danych[2] 06:12 bazodanowy język programowania[3] 08:01 narzędzia ETL[4] 10:12 narzędzia BI[5] 11:37 znajomość chmury[6] 12:30 repozytorium danych[7] 13:56 narzędzia CI/CD[8] 14:47 modelowanie danych[9] 15:34 IDE baz danych[10] 17:06 organizacja pracy(Agile)[11] 17:53 pozostałe narzędzia IT[12] 19:01 język angielski w IT[13] 19:46 teoria IT[14] 21:11 daj się lubić[15] 21:45 podsumowanie odcinka == 🔗 Przydatne linki z nagrania:== 🏷️roadmapa technologii bazodanowych: https://mad.firstmark.com/ 🏷️roadmapa SQL: https://www.youtube.com/watch?v=4_254oVaYUc&list=PL8g9gILZp1OIKNdOlPW4WzilnW8k8Ykgc 🏷️kurs PL/SQL: https://plsql.pl/ 🏷️kurs Podstaw Baz danych: https://podstawybazdanych.pl/ 🏷️kurs "Mistrz SQL": https://mistrzsql.pl/ == 👌 Polecam obejrzeć:== 1. Jak zostać ekspertem SQL? https://www.youtube.com/watch?v=4_254oVaYUc&list=PL8g9gILZp1OIKNdOlPW4WzilnW8k8Ykgc 2. 10 podchwytliwych pytań rekrutacyjnych z SQL: https://www.youtube.com/watch?v=RjVgzdCySXo&list=PL8g9gILZp1OIKNdOlPW4WzilnW8k8Ykgc&index=11 #bazodanowiec == 👨‍💻 Poznaj mniej lepiej:== - Moja strona: https://www.nieinformatyk.pl/ - Facebook: https://www.facebook.com/nieinformatyk - Linkedin: https://www.linkedin.com/in/darekbutkiewicz/ - Instagram: https://www.instagram.com/nieinformatyk - Twitter: https://twitter.com/nieinformatyk Zasubskrybuj mój kanał: https://www.youtube.com/nieinformatyk?sub_confirmation=1 🏁 Witaj na moim kanale :) Od ponad 7 lat estem programistą baz danych oraz developerem hurtownii danych (ETL/ELT). Na tym kanale dzielę się swoją wiedzą dotyczącą relacyjnych baz danych(RDBMS), języka zapytań SQL oraz zagadnień związanych z hurtownią danych(datawarehouse) w prosty i zrozumiały sposób. Jeśli chcesz zdobyć praktyczną praktyczną wiedzę z tego obszaru to trafiłeś na właściwe miejsce. 🚨 Więcej informacji o bazach danych znajdziesz na [https://www.nieinformatyk.pl](https://www.nieinformatyk.pl/) 📧 Masz pytanie, prośbę, sugestię? Pisz śmiało na [[email protected]](mailto:[email protected])

  sql

• Composable SQL

  https://borretti.me/article/composable-sql

  Better SQL through typed, composable query fragments.

  sql

• Data analysis with SQLite and Python, PyCon 2023 — Data analysis with SQLite and Python, PyCon 2023 557f94c documentation

  https://sqlite-tutorial-pycon-2023.readthedocs.io/en/latest/

  sql

• Database Star - YouTube

  https://www.youtube.com/@DatabaseStar/videos

  Are you looking to improve your database development and SQL skills? You've come to the right place. Learn how to improve these skills by watching the videos on my channel. You'll learn: - how to use many different SQL functions and features - how to design a database and normalise your database tables - how to set up different databases - how to use SQL Developer and other IDEs Plus much more!

  sql

• Dicklesworthstone/sqlalchemy_data_model_visualizer: Automatically turn your SQLalchemy Data Models into a Nice SVG Diagram

  https://github.com/Dicklesworthstone/sqlalchemy_data_model_visualizer?utm_source=hackernewsletter&utm_medium=email&utm_term=data

  Automatically turn your SQLalchemy Data Models into a Nice SVG Diagram - Dicklesworthstone/sqlalchemy_data_model_visualizer: Automatically turn your SQLalchemy Data Models into a Nice SVG Diagram

  sql

• Don't Do This - PostgreSQL wiki

  https://wiki.postgresql.org/wiki/Don%27t_Do_This

  sql

• Dr Milan Milanović on X: "𝗧𝗼𝗽 𝟮𝟬 𝗦𝗤𝗟 𝗾𝘂𝗲𝗿𝘆 𝗼𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻 𝘁𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀 Here is the list of the top 20 SQL query optimization techniques I found noteworthy: 1. Create an index on huge tables (>1.000.000) rows 2. Use EXIST() instead of COUNT() to find an element in the… https://t.co/XugSjlNZ37" / X

  https://twitter.com/milan_milanovic/status/1758831924380880968?utm_source=unknownews

  𝗧𝗼𝗽 𝟮𝟬 𝗦𝗤𝗟 𝗾𝘂𝗲𝗿𝘆 𝗼𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻 𝘁𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀 Here is the list of the top 20 SQL query optimization techniques I found noteworthy:1. Create an index on huge tables (1.000.000) rows2. Use EXIST() instead of COUNT() to find an element in the… pic.twitter.com/XugSjlNZ37— Dr Milan Milanović (@milan_milanovic) February 17, 2024

  sql

• GitHub - ben-n93/SQL-tips-and-tricks: SQL tips and tricks

  https://github.com/ben-n93/SQL-tips-and-tricks

  SQL tips and tricks. Contribute to ben-n93/SQL-tips-and-tricks development by creating an account on GitHub.

  sql

• GitHub - chat2db/Chat2DB: 🔥 🔥 🔥 An intelligent and versatile general-purpose SQL client and reporting tool for databases which integrates ChatGPT capabilities.(智能的通用数据库SQL客户端和报表工具)

  https://github.com/chat2db/Chat2DB?ml_recipient=92389183911363954&ml_link=92389182355277696&utm_source=newsletter&utm_medium=email&utm_term=2023-07-03&utm_campaign=+Data+Science+News+16+SoundStorm+Midjourney+v+5+2+50+robot+w+na+szczycie+ONZ+Kurs+Data+Science+od+IBM+MotionGPT

  🔥 🔥 🔥 An intelligent and versatile general-purpose SQL client and reporting tool for databases which integrates ChatGPT capabilities.(智能的通用数据库SQL客户端和报表工具) - GitHub - chat2db/Chat2DB: 🔥 🔥 🔥 An intel...

  sql

• GitHub - dbeaver/dbeaver: Free universal database tool and SQL client

  https://github.com/dbeaver/dbeaver?utm_source=hackernewsletter&utm_medium=email&utm_term=data

  Free universal database tool and SQL client. Contribute to dbeaver/dbeaver development by creating an account on GitHub.

  sql

• GitHub - julien040/anyquery: Query anything (JSON, Salesforce, GitHub, etc.) with SQL and visualize your data with any MySQL-compatible BI tool.

  https://github.com/julien040/anyquery

  Query anything (JSON, Salesforce, GitHub, etc.) with SQL and visualize your data with any MySQL-compatible BI tool. - julien040/anyquery

  sql

• GitHub - vanna-ai/vanna: 🤖 Chat with your SQL database 📊. Accurate Text-to-SQL Generation via LLMs using RAG 🔄.

  https://github.com/vanna-ai/vanna

  🤖 Chat with your SQL database 📊. Accurate Text-to-SQL Generation via LLMs using RAG 🔄. - GitHub - vanna-ai/vanna: 🤖 Chat with your SQL database 📊. Accurate Text-to-SQL Generation via LLMs using RAG 🔄.

  sql

• Harvard CS50’s Intro to Databases with SQL – Full University Course

  https://www.youtube.com/watch?v=WXk7yDqsKxs

  This is CS50’s introduction to databases using a language called SQL. You'll learn how to create, read, update, and delete data with relational databases, wh...

  sql

• How SQL Query works? SQL Query Execution Order for Tech Interview

  https://dev.to/somadevtoo/how-sql-query-works-sql-query-execution-order-for-tech-interview-15kb?utm_source=unknownews

  How SQL Query works? Understanding SQL Query Execution Order for Tech Interview

  sql

• Intuitive SQL For Data Analytics - Tutorial

  https://www.youtube.com/watch?v=mXW7JHJM34k

  Learn SQL for analytics. Learn both the theory and the practice so you can confidently solve hard SQL challenges on your own. No previous experience required and you'll do everything in your browser using BigQuery. Course resources: https://miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab Created by @vladdata741 ⭐️ Contents ⭐️ ⌨️ (00:00:00) Introduction ⌨️ (00:04:42) Syllabus & resources ⌨️ (00:09:04) Meet SQL! ⌨️ (00:10:30) Types of SQL statements ⌨️ (00:12:20) Why BigQuery ⌨️ (00:13:27) How to setup Google Cloud ⌨️ (00:17:02) How to avoid Google Cloud charges ⌨️ (00:22:11) Introduction to our data ⌨️ (00:23:16) How data is organized in BigQuery ⌨️ (00:26:53) Loading our data in BigQuery ⌨️ (00:30:09) The BigQuery Interface ⌨️ (00:37:54) Running our first query ⌨️ (00:46:20) How SQL organizes data ⌨️ (00:54:32) The SQL statement ⌨️ (00:56:05) The three orders of SQL operations ⌨️ (01:00:05) The logical order of SQL operations ⌨️ (01:03:28) Introduction to basics ⌨️ (01:04:10) SELECT and FROM ⌨️ (01:08:22) Transform columns with SELECT ⌨️ (01:19:32) The order of arithmetic operations ⌨️ (01:24:03) The WHERE filter ⌨️ (01:31:28) Boolean algebra ⌨️ (01:48:07) DISTINCT ⌨️ (01:52:04) Create BigQuery tables from queries ⌨️ (01:57:38) UNION 1 ⌨️ (02:05:15) UNION 2 ⌨️ (02:11:57) UNION 3 ⌨️ (02:19:58) UNION 4 ⌨️ (02:22:41) ORDER BY ⌨️ (02:28:52) LIMIT ⌨️ (02:34:06) CASE ⌨️ (02:52:29) Simple aggregations ⌨️ (03:06:59) Subqueries 1 ⌨️ (03:16:28) Subqueries 2 ⌨️ (03:25:46) Subqueries 3 ⌨️ (03:29:43) Nested queries ⌨️ (03:40:11) Common table expressions 1 ⌨️ (03:48:12) Common table expressions 2 ⌨️ (03:53:08) Common table expressions 3 ⌨️ (03:59:18) Joins ⌨️ (05:15:39) GROUP BY And Aggregations ⌨️ (06:04:11) Window Functions ⌨️ (07:09:50) Putting It All Together ⌨️ (07:15:56) Let's Solve A Hard SQL Challenge! ⌨️ (07:33:54) PostgreSQL Exercises - Introduction ⌨️ (07:42:00) PostgreSQL Exercises - Basic ⌨️ (08:10:33) PostgreSQL Exercises - Joins and Subqueries ⌨️ (08:56:45) PostgreSQL Exercises - Aggregations Pt. 1 ⌨️ (09:57:51) PostgreSQL Exercises - Aggregations Pt. 2 ⌨️ (10:57:51) PostgreSQL Exercises - Conclusion 🎉 Thanks to our Champion and Sponsor supporters: 👾 davthecoder 👾 jedi-or-sith 👾 南宮千影 👾 Agustín Kussrow 👾 Nattira Maneerat 👾 Heather Wcislo 👾 Serhiy Kalinets 👾 Justin Hual 👾 Otis Morgan 👾 Oscar Rahnama -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news

  sql

• Kursy

  https://kajodata.com/kursy/

  [et_pb_section fb_built=”1″ _builder_version=”4.21.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_row _builder_version=”4.21.0″ _module_preset=”default” background_color=”#2F6571″ custom_margin=”|auto|17px|auto||” custom_padding=”12px||9px|||” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.21.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.21.0″ _module_preset=”default” global_colors_info=”{}”] KajoDataSpace🚀 [/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row _builder_version=”4.21.0″ _module_preset=”default” locked=”off” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.21.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_countdown_timer title=”W niedzielę 8 września o 22:00 cena wzrośnie 📈😮” date_time=”2024-09-08 22:00″ _builder_version=”4.21.0″ _module_preset=”default” header_font_size=”44px” numbers_font_size=”33px” label_font_size=”10px” background_color=”#B12E22″ header_font_size_tablet=”” header_font_size_phone=”22px” header_font_size_last_edited=”on|phone” numbers_font_size_tablet=”” numbers_font_size_phone=”18px” numbers_font_size_last_edited=”on|phone” global_colors_info=”{}”][/et_pb_countdown_timer][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ _builder_version=”4.21.0″ _module_preset=”default” […]

  sql

• Learn SQL (FAST) with these resources

  https://www.thezenofdatascience.com/p/learn-sql-fast-with-these-resources

  If you’re an aspiring Data Analyst, Data Engineer, or Data Scientist, it is ESSENTIAL for you to learn SQL. SQL (Structured Query Language), is the tool you’ll use the most to create databases, organize data, and do most of your daily job functions.

  sql

• Learn SQL for Efficient Data Storage and Retrieval

  https://www.freecodecamp.org/news/learn-sql-full-course/

  Unlock the power of data with SQL! Master one of the most in-demand skill in the data-driven world and supercharge your career with our new video course. We just released a comprehensive video course on the freeCodeCamp.org YouTube channel that will take you on a journey from understanding the basics

  sql

• Lost at SQL - SQL learning game

  https://lost-at-sql.therobinlord.com/

  The text-based SQL learning game for data scientists and marketers

  sql

• Master SQL (Week 4 Practical): Hands-On Joins to Supercharge Your Database Skills!

  https://www.youtube.com/@i-pingsolutions8753/videos

  In this engaging practical session, we take our SQL journey a step further by applying the theoretical knowledge of joins to real-world scenarios. This Week 4 Practical session is designed to solidify your understanding through hands-on exercises and examples. Dive into practical exercises on inner joins, outer joins, cross joins, and self joins, and learn how to write and optimize queries for real-world applications. Whether you're just starting out or looking to sharpen your skills, this session provides valuable experience to boost your database management capabilities. By the end of this practical session, you'll have the confidence and expertise to handle complex join operations, making your SQL queries more efficient and powerful. Join us and transform your theoretical knowledge into practical skills! 👉 Support our growth: LIKE, SUBSCRIBE & SHARE 👉Join our Telegram Channel and download the student practice files: https://t.me/+s4PYG27YuXVmYWRh SEO-Optimized Hashtags: #SQLJoins #DatabaseManagement #SQLTutorial #LearnSQL #DataSkills #SQLQueries #SQLMastery #TechTutorial #CodingSkills #DataScience

  sql

• Mobilo - YouTube

  https://www.youtube.com/@Mobilo24eu/playlists

  Filmy i tutoriale szkoleniowe Kurs PowerShell dla administratora Windows. Kurs SQL - instalacja i narzędzia Kurs SQL - budowa zapytań SQL Kurs SQL - typy zaawansowane, programowanie, XML Kurs Python dla początkujących Promocja ograniczona ilością aktywacji - z kuponem YOUTUBE każdy kurs po 35 zł! Sprawdź http://www.kursyonline24.eu Więcej informacji o kursach oraz kupony promocyjne!

  sql

• Python: Just write SQL

  https://joaodlf.com/python-just-write-sql?utm_source=hackernewsletter&utm_medium=email&utm_term=code

  sql

• SQL 101 Crash Course: Learn SQL Fundamentals (8 Hours!)

  https://www.youtube.com/watch?v=zrTKNSoQUrw

  Full SQL 101 Crash Course for Beginners. In this 8-hour course, you'll learn the fundamentals of databases & SQL and even get to practice your new SQL skills with 18+ exercises. This SQL Crash Course is the first 8 hours of Mo Binni & Andrei Neagoie's 26-hour SQL + Databases Bootcamp Course, which is one of the most in-depth and highly-rated SQL courses online (and perfect for beginners). So once you finish, come take the rest of Mo & Andrei's SQL + Databases Bootcamp where you'll go even deeper and have the skills to get hired 👇 🔥 Full SQL + Databases Bootcamp: https://zerotomastery.io/courses/sql-bootcamp/ 🤑 Use code: YTSQL10 to get 10% OFF (for life!) 🚀 Career Paths (step-by-step roadmap from beginner to hired): Become a Backend Developer: https://zerotomastery.io/career-paths/become-a-backend-developer/ Become a Data Analyst: https://zerotomastery.io/career-paths/become-a-data-analyst/ ========= 🗂 Crash Course Files: https://links.zerotomastery.io/sql-crash-course-files 🎼 SQL Cheat Sheet: https://zerotomastery.io/cheatsheets/sql-cheat-sheet/ 👍 Subscribe for more free tutorials and exclusive content: https://links.zerotomastery.io/youtube ========= ⏰ Timestamps: 00:00 Introduction 01:49 The Big Data Breach At Keiko Corp 04:22 What Is a Database? 10:28 I Didn't Learn Anything, Try Again... 17:13 Database Management System (DBMS) 25:06 Exercise: Building Amazon 30:50 Exercise: Building Amazon 2 36:27 5 Types Of Databases 42:14 Exercise: What Is A Database? 43:34 Section Review 45:13 SQL Playground 47:16 What Is SQL? 49:43 What Is A Query? 56:36 Exercise: Setting Up Your First Database 56:57 Imperative vs Declarative 1:00:31 History of SQL 1:03:02 Exercise: The Select Statement 1:03:09 SQL Standards 1:07:43 What Is A Database? Revisited 1:13:29 Database Oriented Approach 1:20:30 Exercise: SQL Starter Quiz 1:20:37 Database Models 1:22:07 Hierarchical And Networking Model 1:30:19 Relational Model 1:37:46 DBMS Revisited 1:51:52 Relational Model Revisited 1:53:08 Tables 1:57:02 Columns 2:01:19 Rows 2:03:56 Primary And Foreign Keys 2:09:09 OLTP vs OLAP 2:12:35 Exercise: OLTP vs OLAP 2:16:05 Exercise: Relational Model Quiz 2:16:12 Why PostgreSQL 2:18:14 Environment Tooling 2:21:34 Command Line 101 2:27:05 WINDOWS Setup 2:32:06 Optional: Setting Up Windows For Command Line 2:36:43 MAC Setup 2:43:22 LINUX Setup 2:49:08 Importing The Databases 2:55:21 Starting With Query 3:00:44 Exercise: Simple Queries 3:11:04 Changing Column Names in a SELECT Query 3:14:32 Concat Function 3:19:33 What Is A Function In SQL? 3:26:28 Aggregate Functions 3:31:57 Exercise: Aggregate Functions 3:32:04 Commenting Your Queries 3:41:45 Common SELECT Mistakes 3:50:22 Filtering Data 3:56:15 AND and OR 4:10:39 Exercise: Filtering Data 4:18:45 The NOT Keyword 4:26:13 Exercise: The Where Clause 4:26:20 Comparison Operators 4:32:31 Exercise: Comparison Operators 4:32:38 Logical Operators 4:40:19 Operator Precedence 4:50:07 Operator Precedence 2 5:01:47 Exercise: Operator Precedence 5:01:54 Checking For NULL Values 5:14:05 IS Keyword 5:27:56 NULL Coalescing 5:35:18 Exercise: Null Value Coalescing 5:35:25 3 Valued Logic 5:47:58 Exercise: 3 Valued Logic 5:48:05 BETWEEN + AND 5:50:21 Exercise: BETWEEN + AND 5:50:28 IN Keyword 5:54:01 Exercise: IN Keyword 5:54:08 LIKE 6:07:36 Exercise: Like Keyword 6:07:43 Dates And Timezones 6:20:45 Setting Up Timezones 6:24:31 How Do We Format Date And Time? 6:30:56 Timestamps 6:41:33 Date Functions 6:46:34 Date Difference And Casting 6:48:31 Age Calculation 6:50:49 Extracting Information 6:53:49 Intervals 6:57:12 Exercise: Date and Timestamp 6:57:19 DISTINCT 7:01:39 Exercise: Distinct Keyword 7:01:46 Sorting Data 7:08:13 Exercise: Sorting Data 7:08:20 Multi Table SELECT 7:19:16 Inner Join 7:39:08 Self Join 7:44:11 Outer Join 7:55:51 Less Common Joins 8:02:36 Exercise: Inner Join 8:02:43 USING Keyword 8:07:21 Final Words ========= 💥 Who should take the rest of this SQL + Databases Bootcamp? https://zerotomastery.io/courses/sql-bootcamp/ ◾ Both beginner and advanced professionals looking to learn modern SQL and Database principles ◾ Professionals who are working with or will be working with databases and want to learn to work smart and efficiently using best practices ◾ Anyone interested in learning one of the most in-demand tech skills that will be around for many years to come: SQL ◾ Developers, Data Scientists, Machine Learning Engineers, Business Analysts, Product Managers, Sales/Marketers, and anyone who uses data to make business decisions ========= Graduates of Zero To Mastery are now working at Google, Tesla, Amazon, Apple, IBM, JP Morgan, Facebook, Shopify + other top tech companies. Many are also working as top-rated Freelancers getting paid $1,000s while working remotely around the world. 🎓 Here are just a few of them: https://zerotomastery.io/testimonials This could be you 👆 ========= Become a SQL & Database Pro 👉 https://zerotomastery.io/courses/sql-bootcamp/ #zerotomastery #sql

  sql

• SQL For Web Developers - Complete Database Course

  https://www.youtube.com/watch?v=KBDSJU3cGkc

  Learn all the basics of Structured Query Language in this comprehensive SQL course. You will build out real database tables and practice querying them in fle...

  sql

• SQL Interviews Preparations Material Resources - KDnuggets

  https://www.kdnuggets.com/2023/02/sql-interviews-preparations-material-resources.html

  SQL is a must-known programming language for data people, and many modern jobs have SQL as a prerequisite. Here are material collections to prepare for your SQL interview.

  sql

• SQL Noir - A Detective SQL Game

  https://www.sqlnoir.com/

  Solve crimes and mysteries using SQL queries in this detective-themed SQL learning game.

  sql

• SQL Polyglot

  https://codapi.org/sql/

  Try running a query anywhere from PostgreSQL to DuckDB in your browser.

  sql

• SQL Polyglot

  https://codapi.org/sql/?utm_source=hackernewsletter&utm_medium=email&utm_term=show_hn

  Try running a query anywhere from PostgreSQL to DuckDB in your browser.

  sql

• SQL Window Functions Explained

  https://antonz.gumroad.com/l/sql-windows

  About window functionsWindow functions are probably the most confusing section of SQL. You might think, "So what? They just came up with some additional functions". Not really. "Window functions" is a separate language built into regular SQL. And it's more complicated than everything you know about SELECTs.In short, window functions assist in making great analytical reports without Excel. Maybe you want to calculate monthly sales percentages over the year? Window functions. Split marketing channels into effective and ineffective ones? Window functions. Choose the top 10 clients for each segment? Same.About the bookThis book is a clear and visual introduction to window functions. Clear — because I can describe complex topics in a readable way. Visual — because I have prepared a hundred pictures and GIFs to help you understand SQL windows.Window functions are a complex topic. So the book only teaches a little at a time. It gives just enough theory and a lot of practice, because it’s the only way to turn abstract knowledge into skills.The book starts with SQL windows basics (Part 1) and goes through frame nuances (Part 2) to some pretty advanced stuff (Part 3).Book contentsHere is what you will learn:Why use window functionsWindows and functionsRankingOffsetAggregationRolling aggregatesStatisticsFramesROWS and GROUPSRANGEEXCLUDEFILTERPracticeFinanceClusteringData cleaningAbout the authorI'm Anton Zhiyanov, a Python/Golang developer and SQLite enthusiast. I work on open source, teach courses and blog about programming.In 2021 I launched a course on SQL window functions. It now has 1000+ graduates and an average rating of 5 stars based on 300+ student reviews.In 2023 I decided to write a book based on the original course. Here it is.Book details296 pages100+ pictures and GIFs56 interactive exercises (with solutions)PDF 17.8 × 23.3 cm (7 × 9.2 inches)

  sql

• SQL dla początkujących - PostgreSQL - kurs z podręcznikiem PDF

  https://www.youtube.com/playlist?list=PLavRpT5VJEEudl3xllJWH4DmepFugZGK0

  Share your videos with friends, family, and the world

  sql

• SQL for Beginners Tutorial

  https://www.youtube.com/watch?v=h0nxCDiD-zg

  In this step-by-step tutorial, learn how you can write your own SQL queries. You don't need any prior knowledge and we're going to use all free tools. By the...

  sql

• SQL for Data Analytics - Learn SQL in 4 Hours

  https://www.youtube.com/watch?v=7mz73uXD9DA

  Course Links, Problems, & Notes 👉 https://lukebarousse.com/sqlThanks to Kelly Adams for her work in producing this course 🎉🙌👩🏻‍💼 Kelly's LinkedIn: http...

  sql

• SQLBolt - Learn SQL - Introduction to SQL

  https://sqlbolt.com/

  SQLBolt provides a set of interactive lessons and exercises to help you learn SQL

  sql

• SQLBolt - Learn SQL - SQL Lesson 1: SELECT queries 101

  https://sqlbolt.com/lesson/select_queries_introduction

  SQLBolt provides a set of interactive lessons and exercises to help you learn SQL

  sql

• SQLTutor - Your interactive, AI-assisted SQL tutor.

  https://sql.programmable.net/dashboard

  sql

• SQLZoo

  https://sqlzoo.net/wiki/SQL_Tutorial

  sql

• SQLime — Online SQLite playground

  https://sqlime.org/

  SQLime is an online SQLite playground for debugging and sharing SQL snippets.

  sql

• Select Star SQL

  https://selectstarsql.com

  sql

• The Querynomicon

  https://gvwilson.github.io/sql-tutorial/?utm_source=unknownews

  sql

• Top 7 SQL Project Ideas (+ Code) To Level-Up Your Skills in 2023 | Zero To Mastery

  https://zerotomastery.io/blog/sql-project-ideas/

  Quality over quantity... we give you the only 7 SQL projects (+ our top 3) that you need to boost your SQL skills, confidence, and portfolio!

  sql

• fcc-learn-sql-assets/course at main · bootdotdev/fcc-learn-sql-assets

  https://github.com/bootdotdev/fcc-learn-sql-assets/tree/main/course

  Contribute to bootdotdev/fcc-learn-sql-assets development by creating an account on GitHub.

  sql

• frectonz/sql-studio: SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB]

  https://github.com/frectonz/sql-studio

  SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB] - frectonz/sql-studio

  sql

• https://cs50.harvard.edu/sql/2024/weeks/0

  https://cs50.harvard.edu/sql/2024/weeks/0

  sql

• https://explainextended.com/2023/12/31/happy-new-year-15/?utm_source=hackernewsletter&utm_medium=email&utm_term=data

  https://explainextended.com/2023/12/31/happy-new-year-15/?utm_source=hackernewsletter&utm_medium=email&utm_term=data

  sql

• https://faun.dev/c/stories/javinpaul/10-best-websites-to-learn-sql-for-free

  https://faun.dev/c/stories/javinpaul/10-best-websites-to-learn-sql-for-free

  sql

• https://matt.blwt.io/post/leadership-power-tools-sql-and-statistics

  https://matt.blwt.io/post/leadership-power-tools-sql-and-statistics

  sql

• https://sqlbolt.com/?ref=faun

  https://sqlbolt.com/?ref=faun

  sql

• https://sqlbolt.com/lesson/select_queries_with_expressions

  https://sqlbolt.com/lesson/select_queries_with_expressions

  sql

• https://sqlzoo.net/wiki/SQL_Tutorial

  https://sqlzoo.net/wiki/SQL_Tutorial

  sql

• jorgerojas26/lazysql: A cross-platform TUI database management tool written in Go.

  https://github.com/jorgerojas26/lazysql

  A cross-platform TUI database management tool written in Go. - jorgerojas26/lazysql

  sql

• qStudio Release Version 3.0 » qStudio

  https://www.timestored.com/qstudio/release-version-3?utm_source=hackernewsletter&utm_medium=email&utm_term=data

  sql

• techTFQ - YouTube

  https://www.youtube.com/@techTFQ/videos

  Hi, I am Thoufiq! On this channel, I teach SQL, Python and Database concepts in the field of Data Analytics and Data Science in the most simplest manner possible. If this excites you then do consider subscribing. You will also find videos covering interview questions and also videos where I provide career guidance in the field of Data Analytics and Data Science which should help you find your dream job. I aim to make techTFQ a go to YouTube channel for anyone learning SQL, Python and Databases in the field of Data Analytics and Data Science. Thank you for begin here :)

  sql

• timeseries/qstudio: qStudio - Free SQL Analysis Tool

  https://github.com/timeseries/qstudio

  qStudio - Free SQL Analysis Tool. Contribute to timeseries/qstudio development by creating an account on GitHub.

  sql