SQL

  • Azure: Controlling and Granting SQL Database Access
    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins

    Discusses how to give people and applications access to your Azure SQL database, including the use of administrative accounts, groups and roles, server logins, and database users . Also discusses (with examples) how to grant limited user permissions using built-in stored procedures, as well as security policies and restrictions that govern which users can perform sensitive operations.

  • Creating SQL Logins and SQL Users on your Azure SQL Database
    https://web.archive.org/web/20190110095130/https://blogs.msdn.microsoft.com/azuresqldbsupport/2016/10/05/create-sql-login-and-sql-user-on-your-azure-sql-db/

    MSDN blog post tutorial on how to create logins and users for an Azure SQL Server and Database. Also shows you how to assign specific database roles to users. NOTE: the tutorial was written for an Azure database, but the same SQL commands, roles, and stored procedures apply to local SQL Server databases, as well.

  • How to Generate Database Scripts With Data In SQL Server
    https://www.nuttyabouthosting.co.uk/knowledgebase/article/how-to-generate-database-scripts-with-data-in-sql-server

    Brief tutorial from Nutty About Hosting showing you how to use SQL Server Management Studio to generate SQL script with a database's schema AND data.

  • Intro to SQL @ Khan Academy
    https://www.khanacademy.org/computing/computer-programming/sql

    Self-paced course that introduces basic SQL queries, queries with Booleans and criteria, joins, and table modification. Provides examples and tests your knowledge of SQL and databases.

  • Securing Your Azure SQL Database
    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-security-tutorial

    Tutorial on securing your Azure SQL database at different levels: firewall settings; secure connection strings; user management; encrypting connections; and auditing database activity.

  • SQL Tutorial &: Reference - W3Schools
    https://www.w3schools.com/sql/default.asp

    Less of a SQL tutorial and more examples and reference. Covers SQL syntax and table design, with references for specific DBMS. Best of all, you can practice writing SQL queries online with the Northwind database.

  • Using SQL Server Management Studio (SMSS): Quick Start
    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-ssms

    Brief Microsoft tutorial on connecting to and querying Azure-based SQL Server DBMS instances. The same techniques and commands apply to local databases.