Hải Yến Trịnhyentrinh.hashnode.dev·Nov 18, 2024Hướng dẫn tạo một DB server databasse để Demo hoặc làm môi trường lab dạy SQL trong 2 phútMình có dạy cho 1 số bạn học làm ứng dụng Python, và có bài học về SQL. Tuy nhiên học viên của mình có một số bạn khá nhỏ, vẫn còn đang THCS hoặc THPT, nên khá băn khoăn về việc làm sao cho các bạn có môi trường thực hành. Nếu yêu cầu các bạn cài đặt...Discuss·127 readsdatabase
Mahira Technology Private LimitedPromahiratechnology.hashnode.dev·Nov 15, 2024Snowflake Newbies: How to Easily Create a Reader Account in the Web UIOver View :- Remember your first time seeing snow? The excitement, the curiosity, and maybe a bit of confusion about how to make that perfect snowball? Well, embarking on your Snowflake journey can evoke similar emotions. The goal is to have fun and ...DiscussReader Account
Tuanh.nettuanhnet.hashnode.dev·Nov 15, 2024Secrets to Overcoming the Challenges of Horizontal Scaling in SQL DatabasesSource: Secrets to Overcoming the Challenges of Horizontal Scaling in SQL Databases 1. Understanding Horizontal Scaling in SQL Databases Scaling horizontally involves adding more servers to distribute the load, as opposed to vertical scaling, ...Discussdatabase
Tuanh.nettuanhnet.hashnode.dev·Nov 13, 2024Facts About Different Types of SQL Joins: How They Work and When to Use ThemSource: Facts About Different Types of SQL Joins: How They Work and When to Use Them 1. Introduction to SQL Joins 1.1 What Are SQL Joins? SQL joins allow you to retrieve data from two or more tables based on a related column between...Discussdatabase
Tuanh.nettuanhnet.hashnode.dev·Nov 12, 202410 Tips for Mastering T-SQL that Every Developer Should KnowSource: 10 Tips for Mastering T-SQL that Every Developer Should Know 1. What is T-SQL? T-SQL stands for Transact-SQL, an extension of SQL that includes procedural programming, local variables, and error handling. It enables developers to...Discussdatabase
Mehul Kiran Chaudharimehulkc.hashnode.dev·Nov 11, 2024Sharding vs Partitioning: The Key Difference You Need to Know!When it comes to managing large databases, terms like "sharding" and "partitioning" are often used to describe ways of breaking up data for better performance and scalability. But here's the catch: while these two concepts might sound similar, they a...Discussdatabase
Constantin Lungudatawise.dev·Nov 9, 2024For quality work, understand your data grain firstThere’s one concept that is central when working with data and goes beyond specific technology or SQL dialects. You just can’t miss it. I’m talking about the grain—the granularity of the data. It’s essentially answering the question: what does one ro...DiscussMy Data JourneySQL
Ahmed Razaahmedrazadev.hashnode.dev·Nov 9, 2024Introduction to SQL: What It Is and How It Works, with Practical ExamplesSQL (Structured Query Language) is a language used for managing and manipulating data in relational databases such as MySQL, PostgreSQL, Oracle, and SQL Server. SQL allows you to perform various operations, such as creating tables, inserting data, up...DiscussSQL
Eyad Youssefeyadzz.hashnode.dev·Oct 31, 2024PostgreSQL DOXXED: Pages Layout & OptimizationsIn the previous article, we have talked about how our data is structured and stored in PostgreSQL, talking about how rows behave in the MVCC Architecture, how Tables and Indexes are stored, and the role of System Catalog, Schemas and Tablespaces. We ...Discuss·1 like·73 readsPostgreSQL DOXXEDPostgreSQL
BotanicalCoderbotanicalcodersblog.hashnode.dev·Oct 30, 2024Database Basic TermsThis short article describes certain database terms that you would hear thrown around a lot if you work with software developers. Computers make accessing data easy and faster, so storing information on computers is a no-brainer. There are two types ...DiscussPROGRAMMING SIMPLIFIEDDatabases
