Beginner to Advance SQL
- SQL Server Basics
1
2
3
4
5
6
- The SQL server basics section shows you how to use the Transact-SQL (T-SQL) to interact with SQL Server databases. You will learn how to manipulate data from the database such as querying, inserting, updating, and deleting data. ## - SQL Server Views
- This section introduces you to the SQL Server views and discusses the advantage and disadvantages of the database views. You will learn everything you need to know to manipulate views effectively in SQL Server. ## - SQL Server Indexes
- In this section, you will learn everything you need to know about the SQL Server indexes to come up with a good index strategy and optimize your queries. ## - SQL Server Stored Procedures
- This section introduces you to the SQL Server stored procedures. After completing the section, you will be able to develop complex stored procedures using Transact-SQL constructs. ## - SQL Server User-defined Functions
- In this section, you will learn about SQL Server user-defined functions including scalar-valued functions and table-valued functions to simplify your development. ## - SQL Server Triggers
- SQL Server triggers are special stored procedures that are executed automatically in response to the database object, database, and server events
This post is licensed under CC BY 4.0 by the author.