In this article we’ll learn “SQL Server” concepts. This tutorial is designed for beginners as well as professional developers who want to learn basics and advance concepts of SQL Server. Please check out below article for SQL.
SQL Server Concepts for Beginners and Professionals
- SQL server Column Encryption using symmetric key.
- How to Update using Select statement in SQL Server.
- SQL Server Interview Questions and Answers.
- Import One Database to another in SQL server.
- Generate database scripts in SQL server.
- Different ways to search SQL objects in database.
- SQL CASE statement
- SQL IIF function
- QUOTENAME function in SQL
- How to Take SQL Server Database Offline/Online
- How to use SQL ORDER BY in Your Queries
- SQL Paging using OFFSET and FETCH
- How is data physically stored in a SQL database
- Fill Factor in SQL Server
- How to Search SQL Object in Complete Database
- How to generate SQL table script with data
- Delete Truncate and disk storage.
- How to safely delete the SQL database objects.
- Deadlock in SQL Server.
- Exception handling in SQL Server.
More for you
- How to enable SQL Server authenticationSQL Server Authentication is a default way to connect to MS SQL Server, but there may be many times that you need to use SQL Server Authentication to connect to… Read more: How to enable SQL Server authentication
- Set Transaction Isolation Level in SQL In this post we’ll discuss SQL server “Set Transaction Isolation Level”. These are of 5 types, and we’ll discuss all one by one below. READ UNCOMMITTED Read uncommitted specifies that… Read more: Set Transaction Isolation Level in SQL
- Is SQL NOLOCK bad practice?In this post we’ll read about the use of [Nolock] in SQL Queries and stored procedures. Is this good or bad practice to use this in query. Let’s check out… Read more: Is SQL NOLOCK bad practice?
- SQL Paging using OFFSET and FETCHIn this article we will learn about SQL Paging using OFFSET and FETCH. In SQL these clauses can be used with ORDER BY to limit the number of rows returned… Read more: SQL Paging using OFFSET and FETCH
- Aggregate and Summarize Totals with SQL SUMIn this we will discuss about ‘aggregate and summarize totals with SQL SUM function. Knowing the method to calculate the complete addition of a specified column in a SQL Server… Read more: Aggregate and Summarize Totals with SQL SUM
- How to use SQL ORDER BY in Your QueriesIn this article we will learn how to use SQL ORDER BY in your queries. SQL is a powerful tool for manipulating data and ordering results in a specific order.… Read more: How to use SQL ORDER BY in Your Queries
- How to Take SQL Server Database Offline/OnlineIn this article we will learn how to take SQL server database offline/online. There are some situations when we need to offline the database like How to make your DB… Read more: How to Take SQL Server Database Offline/Online
- How to generate SQL table script with dataIn this article we’ll learn how to generate SQL table script with data. You can create insert script of table before playing with its data for the safer side so… Read more: How to generate SQL table script with data
- SQL server column encryption using symmetric keyIn this article we’ll learn about SQL server Column encryption using Symmetric key. In Financial organizations or banks, we have sensitive data including account numbers and credit card numbers. As… Read more: SQL server column encryption using symmetric key
- How to UPDATE using SELECT statement in SQL ServerIn this article, we will learn how to UPDATE using a SELECT statement in SQL Server. There are “multiple ways which are used to update the data in a given… Read more: How to UPDATE using SELECT statement in SQL Server
- Fill Factor in SQL ServerIn this article we’ll learn about “Fill factor in SQL server”. Fill factor is used to decide how the data will get stored on SQL 8KB pages. We all know… Read more: Fill Factor in SQL Server
- Delete Truncate and disk storageDelete Truncate and disk storage
- SQL CASE StatementIntroduction of SQL CASE: In this article we’ll learn about SQL CASE Statement. Like if-else the CASE statement goes through multiple conditions and returns a value when the first condition is… Read more: SQL CASE Statement
- QUOTENAME Function in SQL: should readIn this article you’ll learn QUOTENAME Function in SQL. This Function was first introduced in SQL Server 2012. Main use of this function is to add square brackets to the… Read more: QUOTENAME Function in SQL: should read
- SQL IIF FunctionIn this article, we’ll explain you about SQL IIF function. IIF Stands for Immediate IF function. It is an inline IF function that can be used to provide a conditional… Read more: SQL IIF Function
- How is data physically stored in a database: All you need to knowIn the article we’ll discuss “How is data physically stored in a database” in the form of “series of 8kb pages”. We all know that SQL server stores data in… Read more: How is data physically stored in a database: All you need to know
- Import one SQL Database into anotherIn this article we’ll learn how to “Import one SQL Database into another”. To start the SQL Server Import and Export Wizard using SSMS, go to Object Explorer, right click on… Read more: Import one SQL Database into another
- How to Search SQL Object in Complete DatabaseThis article we’ll learn how to search SQL object in complete database. You can search for database objects in SQL database such as tables, stored procedures, functions, and views. In… Read more: How to Search SQL Object in Complete Database
- How to Generate Complete Database ScriptIn this article we’ll learn how to generate complete database script. To generate full database script using SSMS, go to Object Explorer, right click on a database for which want to generate scripts;… Read more: How to Generate Complete Database Script
- SQL Query Optimization TechniquesIn this article we will learn SQL query optimization techniques. There are some useful practices to reduce the cost of the query so that it can perform better. To achieve… Read more: SQL Query Optimization Techniques
- SQL ServerIn this article we’ll learn “SQL Server” concepts. This tutorial is designed for beginners as well as professional developers who want to learn basics and advance concepts of SQL Server.… Read more: SQL Server
- Interview Questions and AnswersThis article will cover top .NET Interview Questions and Answers and is designed for Students, beginners as well as experienced professional developers who want to prepare an interview for .NET… Read more: Interview Questions and Answers
- SQL Server Interview QuestionsIn this article you will get list all MS SQL server interview questions for beginners at one place. It is designed for beginners and experts too. It is a set… Read more: SQL Server Interview Questions
Using above SQL Server topics, you will learn from the very basic to the advanced level features of SQL Server. So, stay tuned with latest posts.
Prerequisites:
There are no prerequisites required to learn above topics in SQL Server. It is good to have SQL Server installed on your computer. This is required for you in executing the examples yourself and get to know how it works.
More For You:
SQL Section
C# Section
For more knowledge of MS SQL, you can check this section HERE