About the course
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.
- Introduction to Transact-SQL
- Sort and filter results in T-SQL
- Combine multiple tables with JOINs in T-SQL
- Write Subqueries in T-SQL
- Use built-in functions and GROUP BY in Transact-SQL
- Modify data with T-SQL
- Starting with SQL Server and Azure SQL Database
No matter how much ado is currently about big data, semi and unstructured data, the appropriate place for the most important data is still the relational database management system (RDBMS). If you need to take care about the data integrity, then you should use the relational model as the logical model for your data and database schema. You have to learn the standard language for working with data in a RDBMS, the Structured Query Language (SQL).
In this course, you will learn the basics about the relational model, including normalization and constraints. You will start using the language that SQL Server and Azure SQL Database understand, the Transact-SQL (T-SQL) language. You will learn how to write basic and advanced queries. You will see how to create tables and insert, update, and delete data. You will learn how to handle errors and define user transactions. You will also understand the programmatic objects in a SQL database, including views, functions, stored procedures, and triggers.
In this introduction to the course, you will also get the information on the products and demo database used for the course, how to obtain, and how to install them.
You will start your journey with the mighty SELECT statement. In the first module, you will learn how to write simple queries. Then you will go in depth with the SELECT statement and learn how to write more advanced queries.
In order to store your data, you need to create objects and populate them. You will learn how to create schemas, tables, and other objects. The SQL Server system data types overview is a part of this module as well. INSERT, UPDATE, DELETE, and MERGE statements are the data modification elements of the T-SQL language.
The seminar then switches to the theoretical background. You will learn about the relational model and how to design a normalized database following the relational model. You will also learn how to enforce data integrity. For analytical applications, you typically model your data differently. A module in the seminar introduces the dimensional model, the most widely used model for centralized and self-service reporting and analyzing your data.
Going back to practical database development. You will get an initial knowledge about the programmatic objects inside a database, why to use them, and how to create them. In the final module, you will learn how to handle errors and define your own transactions.
- Core Transact-SQL SELECT statement elements
- Advanced SELECT techniques
- Data Definition Language statements
- Data Modification Language statements
- Introducing the relational model
- Normalization and constraints
- Dimensional modeling
- Programming views, functions, stored procedures, and triggers
- Error Handling and Transactions More