Anuradha Guptatechno101.hashnode.dev·Mar 20, 2024NOT NULL in SQLIn SQL, the NOT NULL constraint is used to specify that a column cannot contain any NULL values. When you define a column with the NOT NULL constraint, it means that every row inserted into the table must have a value for that column. Here's an examp...DiscussSQL
Babatunde Daramolaritechoice23.hashnode.dev·Mar 20, 2024A quick guide to SQL JoinsSQL joins is your go-to when it comes to combining data from multiple tables in a database. But with different join types, it can get confusing, my goal for this post is to clear your confusion. So let's take a look at the different joins available. ...Discuss·10 likesSQL
Swati Sarangicodingstars.hashnode.dev·Mar 13, 2024SQL & Relational Databases🔆Introduction I have always tried to summarize the contents of the courses that I take in the form of notes which help me to revise the concepts easily during any exam or interview. As I am taking a course SQL & Relational Database from Metropolia U...Discuss·1 likeSQL
AKEH EUNICEladyintech.hashnode.dev·Mar 1, 2024A Step-by-Step Guide In Creating A SQL Virtual Machine In AzureIntroduction In today's cloud-driven world, businesses are increasingly adopting virtual machines (VMs) to efficiently manage their data and applications. Microsoft Azure provides a robust platform for hosting SQL Server databases on virtual machines...DiscussSQL Server
AKEH EUNICEladyintech.hashnode.dev·Feb 29, 2024How to Create an Azure SQL Database: The Complete GuidePerquisites An Azure account An Azure Subscription Introduction As the demand for scalable and dependable data storage solutions grows, cloud databases are becoming an increasingly popular option for businesses all over the world. Microsoft's ful...Discuss·10 likesSQL
Dominik KellerforLow-Code Software Engineeringfive.hashnode.dev·Feb 13, 2024How To Create One-to-Many Relationships in SQLRelational database systems, such as MySQL, PostgreSQL, or SQLite make storing and retrieving data quick and efficient. The underlying principle of a relational database is to store data in related tables, which avoids data redundancy. Tables can be ...Discussone to many
Anuradha Guptatechno101.hashnode.dev·Feb 12, 2024Order of Execution in SQLThe order of execution in SQL for a query is generally as follows: FROM clause: This specifies the tables from which data will be retrieved. WHERE clause: This filters rows based on specified conditions. GROUP BY clause: This groups rows that have...DiscussSQL
Nataraj Mlearnjava.hashnode.dev·Dec 28, 2023SQL - Basics & AdvancedRelational Database Management Systems An RDBMS uses the client-server model. This means that it’s a server process that responds to client requests rather than relying on another program to send requests to the server. SQL is divided into two basic ...DiscussSQL
Anuradha Guptatechno101.hashnode.dev·Dec 27, 2023UNIQUE KEY in SQLIn the expansive world of SQL, the UNIQUE KEY constraint stands as a powerful tool for ensuring data integrity within database tables. Whether you're delving into SQL through a comprehensive SQL tutorial or implementing queries on an online SQL edito...DiscussSQL
Anuradha Guptatechno101.hashnode.dev·Dec 27, 2023Order of Execution in SQLUnderstanding the order of execution in SQL is fundamental for anyone venturing into the world of databases. Whether you're exploring through a SQL tutorial or honing your skills on an online SQL compiler, knowing how SQL queries are processed ensure...DiscussSQL