Skip main navigation

Working with Azure SQL Database Using External Tools

In this step, we'll explore the ability to access our database with external tools such as Microsoft SQL Server Management Studio for Windows.

In this step, we’ll explore our ability to access a database with external tools such as Microsoft SQL Server Management Studio for Windows. We’ll also be introduced to a few types of data relationships.

Microsoft SQL Server Management Studio (Windows)

Applications like this allow you to connect to your databases from outside the Azure browser environment and view the data relationships and other derivative information about the database in a visual representation.

Below are some alternatives for non-Windows users.

OSX

  • Azure Data Studio – Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
  • DBeaver – This is the top-rated alternative on Alternative.to.
  • MAMP – MAMP has a free and paid version, and both Windows & Mac OSX applications.

Linux

  • Azure Data Studio – Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.

Relationship Types

Graeme refers to One to Many, One to One, and Many to Many relationships. These are often shown as 1:N, 1:1, and N:N, respectively.

  • One to One (1:1)
    • This means that a record is associated with one and only one record in another table.
  • One to Many (1:N)
    • One record in a table can be associated with one or more records in another table.
  • Many to Many (N:N)
    • A many-to-many relationship occurs when multiple records in a table are associated with multiple records in another table.
    • Relational database systems usually don’t allow you to implement a direct many-to-many relationship between two tables.
Note: Why not explore more about JOIN, the new SQL command introduced in this step? You can find more information on it at W3Schools.
This article is from the free online

Microsoft Future Ready: Fundamentals of Big Data

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education