Discover how to leverage the vast capabilities of Microsoft Azure SQL Database. Learn how to work with the rich syntax of Azure SQL, and use SQL Server Management Studio to write scripts.
- [Anton] Getting started with databases can be daunting, especially given the complexity of real-world databases. Luckily, Structured Query Language can be learned using simple examples and then building complexity as your skills grow. My name is Anton Delsink and I have been teaching developer topics for almost 20 years, and a recurring topic has been SQL. There is even an ANSI standard for SQL and many systems have adopted the syntax, both commercial and open source databases such as Microsoft SQL, Oracle, MySQL, and many others, even systems like Hadoop, providing things like HQL, variation of the SQL syntax, and it is increasingly common to provide SQL-like experience from NoSQL and other non-database systems.
In this course, you can follow along as we use Microsoft Azure SQL database to get started quickly and SQL Server Management Studio to write our scripts. We will be covering creation of tables, adding data to those tables, and combining data and queries from multiple tables. By the end of the course, you'll be able to create your own Azure SQL database, provide users with access to those databases, and create inquiry tables containing your own data.
- Creating a new Azure SQL database
- Using basic SQL statements such as SELECT and INSERT
- Using SQL statements to update, modify, and delete data
- Adding functions to your SELECT statement to modify how numbers are displayed
- Filtering and formatting results
- Saving and sharing your work by creating views
- Sharing access to your database with other users