SQL

  • 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.