Best of SQL — December 2023

  1. 1
    Article
    Avatar of mlnewsMachine Learning News·2y

    Best Platforms to Practice SQL

    SQL is a must-know skill in the tech world. This article explores the best platforms to practice SQL, ranging from beginner-friendly platforms to comprehensive learning resources with real-world interview questions. Each platform offers unique features to enhance SQL skills for various data roles.

  2. 2
    Article
    Avatar of devtoDEV·2y

    Why you should never use an UUID as the primary key in SQL Databases

    Using a UUID as a primary key in SQL databases has advantages and disadvantages. UUIDs have larger storage requirements and decreased performance compared to integers. They are not human-readable, making debugging and manual inspection challenging. UUIDs may result in suboptimal disk I/O patterns and higher levels of index fragmentation. Storing UUIDs increases storage requirements. Managing UUIDs adds complexity to application logic.

  3. 3
    Article
    Avatar of communityCommunity Picks·2y

    Master SQL

    SQL is a powerful language used for data retrieval and manipulation. Learning SQL is important for data-driven careers and offers universal applicability. There are various resources and platforms available for hands-on SQL practice.

  4. 4
    Article
    Avatar of devtoDEV·2y

    How Modern SQL Databases Are Changing Web Development - #4 Into the AI Era

    Explore how modern SQL databases are reshaping web development and enabling easier development of AI-powered applications.

  5. 5
    Article
    Avatar of infoworldInfoWorld·2y

    SQL unleashed: 9 ways to speed up your SQL queries

    Learn 9 best practices for writing faster SQL queries, including retrieving only the columns you need, using CASE instead of UPDATE for conditional column updates, and pre-staging data for improved performance.

  6. 6
    Article
    Avatar of kdnuggetsKDnuggets·2y

    25 Free Books to Master SQL, Python, Data Science, Machine Learning, and Natural Language Processing

    Discover a collection of 25 free books that cover topics like SQL, Python, Data Science, Machine Learning, and Natural Language Processing. These books provide valuable resources to help you gain hands-on experience and build your own applications.

  7. 7
    Article
    Avatar of baeldungBaeldung·2y

    Understanding NewSQL Databases

    NewSQL databases combine the transactional consistency of SQL databases with the scalability and performance of NoSQL databases. They are suitable for applications requiring strong transactional consistency, high performance, and scalability.

  8. 8
    Article
    Avatar of communityCommunity Picks·2y

    AmrDeveloper/GQL: Git Query language is a SQL like language to perform queries on .git files with supports of most of SQL features such as grouping, ordering and aggregations functions

    GQL is a query language similar to SQL, designed to perform queries on .git files. It supports most of the SQL features such as grouping, ordering, and aggregation functions.

  9. 9
    Article
    Avatar of hnHacker News·2y

    SQL as API

    Using SQL in the API can be a viable solution for complex filtering and adding flexibility to the API. It involves validating and sanitizing the SQL input and allows for easy modification and customization. However, it requires careful documentation, has performance considerations, and may lead to vendor lock-in.

  10. 10
    Article
    Avatar of gcgitconnected·2y

    Why Is It Hard to Horizontally Scale SQL Databases

    Learn about the challenges of horizontally scaling SQL databases, including maintaining ACID properties, handling distributed joins, and managing transactions across shards.

  11. 11
    Article
    Avatar of communityCommunity Picks·2y

    Scaling SQL Databases: 8 Challenges of Horizontally Scaling SQL Databases

    Learn about the challenges of horizontally scaling SQL databases, including ACID properties and distributed complexity, the complexity of distributed joins, transaction management across shards, data distribution and sharding strategies, ensuring consistency across nodes, handling schema changes in distributed environments, maintaining foreign keys and constraints, and query optimization in distributed systems.

  12. 12
    Article
    Avatar of infoworldInfoWorld·2y

    SQL unleashed: 7 SQL mistakes to avoid

    Learn about 7 common SQL mistakes to avoid when writing database applications, including blindly reusing queries, nesting views, running large multi-table operations in a single transaction, clustering on volatile columns, inefficiently counting rows, using triggers, and doing negative searches.

See all SQL archives