{"id":7,"date":"2018-03-26T16:41:42","date_gmt":"2018-03-26T09:41:42","guid":{"rendered":"http:\/\/www.sqlservertutorial.net\/?page_id=7"},"modified":"2024-09-30T11:02:15","modified_gmt":"2024-09-30T04:02:15","slug":"home","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/","title":{"rendered":"SQL Server Tutorial"},"content":{"rendered":"<div class=\"wp-block-image is-resized\">\n<figure class=\"alignright size-large\"><img decoding=\"async\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-tutorial.svg\" alt=\"SQL Server Tutorial\" class=\"wp-image-2764\" style=\"width:200px\"\/><\/figure>\n<\/div>\n\n\n<p>Welcome to the SQLServerTutorial.Net website!<\/p>\n\n\n\n<p>If you are looking for an easy, fast, and efficient way to master SQL Server, you are in the right place.<\/p>\n\n\n\n<p>Our SQL Server tutorials are practical and packed with many hands-on\u00a0activities.<\/p>\n\n\n\n<p>After completing the entire tutorial, you will be able to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Query data efficiently from tables in the SQL Server database.<\/li>\n\n\n\n<li>Create database objects such as tables, <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-views\/\">views<\/a>, <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-indexes\/\">indexes<\/a>, <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/sql-server-sequence\/\">sequences<\/a>, <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/sql-server-synonym\/\">synonyms<\/a>, <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-stored-procedures\/\">stored procedures<\/a>, <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-user-defined-functions\/\">user-defined functions<\/a>, and <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-triggers\/\">triggers<\/a>.<\/li>\n\n\n\n<li>Manage SQL Server database efficiently.<\/li>\n<\/ul>\n\n\n\n<p>SQL Server is a relational database management system (RDBMS) developed and marketed by Microsoft. As a database server, the primary function of the SQL Server is to store and retrieve data used by other applications.<\/p>\n\n\n<section class=\"feature-pages\"><article class=\"feature-page\"><div class=\"feature-image\"><img decoding=\"async\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/getting-started-with-sql-server.svg\" width =\"90\" height=\"90\" alt=\"\"><\/div><div class=\"feature-body\">\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"https:\/\/www.sqlservertutorial.net\/getting-started\/\">Getting Started with SQL Server<\/a>\n\t\t\t\t<\/h3>\n\t\t\t\t<div>This section helps you get started with the SQL Server quickly. After completing this section, you will have a good understanding of the SQL Server and know how to install the SQL Server Developer Edition for practicing.\r\n\r\n<\/div>\n\t\t\t<\/div>\n\t\t<\/article><article class=\"feature-page\"><div class=\"feature-image\"><img decoding=\"async\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-basics.svg\" width =\"90\" height=\"90\" alt=\"\"><\/div><div class=\"feature-body\">\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/\">SQL Server Basics<\/a>\n\t\t\t\t<\/h3>\n\t\t\t\t<div>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.\r\n<\/div>\n\t\t\t<\/div>\n\t\t<\/article><article class=\"feature-page\"><div class=\"feature-image\"><img decoding=\"async\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-views.svg\" width =\"90\" height=\"90\" alt=\"\"><\/div><div class=\"feature-body\">\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-views\/\">SQL Server Views<\/a>\n\t\t\t\t<\/h3>\n\t\t\t\t<div>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.<\/div>\n\t\t\t<\/div>\n\t\t<\/article><article class=\"feature-page\"><div class=\"feature-image\"><img decoding=\"async\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-indexes.svg\" width =\"90\" height=\"90\" alt=\"\"><\/div><div class=\"feature-body\">\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-indexes\/\">SQL Server Indexes<\/a>\n\t\t\t\t<\/h3>\n\t\t\t\t<div>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.<\/div>\n\t\t\t<\/div>\n\t\t<\/article><article class=\"feature-page\"><div class=\"feature-image\"><img decoding=\"async\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-stored-procedures.svg\" width =\"90\" height=\"90\" alt=\"\"><\/div><div class=\"feature-body\">\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-stored-procedures\/\">SQL Server Stored Procedures<\/a>\n\t\t\t\t<\/h3>\n\t\t\t\t<div>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.<\/div>\n\t\t\t<\/div>\n\t\t<\/article><article class=\"feature-page\"><div class=\"feature-image\"><img decoding=\"async\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-user-defined-functions.svg\" width =\"90\" height=\"90\" alt=\"\"><\/div><div class=\"feature-body\">\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-user-defined-functions\/\">SQL Server User-defined Functions<\/a>\n\t\t\t\t<\/h3>\n\t\t\t\t<div>In this section, you will learn about SQL Server user-defined functions including scalar-valued functions and table-valued functions to simplify your development.<\/div>\n\t\t\t<\/div>\n\t\t<\/article><article class=\"feature-page\"><div class=\"feature-image\"><img decoding=\"async\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-triggers.svg\" width =\"90\" height=\"90\" alt=\"\"><\/div><div class=\"feature-body\">\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-triggers\/\">SQL Server Triggers<\/a>\n\t\t\t\t<\/h3>\n\t\t\t\t<div>SQL Server triggers are special stored procedures that are executed automatically in response to the database object, database, and server events. <\/div>\n\t\t\t<\/div>\n\t\t<\/article><\/section>\n\n\n\n<h2 class=\"wp-block-heading\" id='sql-server-functions'>SQL Server Functions <a href=\"#sql-server-functions\" class=\"anchor\" id=\"sql-server-functions\" title=\"Anchor for SQL Server Functions\">#<\/a><\/h2>\n\n\n\n<p>In this section, you&#8217;ll find the commonly used SQL Server functions, such as aggregate functions, date functions, string functions, system functions, and window functions.<\/p>\n\n\n<section class=\"feature-pages\"><article class=\"feature-page\"><div class=\"feature-image\"><img decoding=\"async\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-aggregate-functions.svg\" width =\"90\" height=\"90\" alt=\"\"><\/div><div class=\"feature-body\">\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-aggregate-functions\/\">SQL Server Aggregate Functions<\/a>\n\t\t\t\t<\/h3>\n\t\t\t\t<div>This tutorial introduces you to the SQL Server aggregate functions and shows you how to use them to calculate aggregates.<\/div>\n\t\t\t<\/div>\n\t\t<\/article><article class=\"feature-page\"><div class=\"feature-image\"><img decoding=\"async\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-date-functions.svg\" width =\"90\" height=\"90\" alt=\"\"><\/div><div class=\"feature-body\">\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-date-functions\/\">SQL Server Date Functions<\/a>\n\t\t\t\t<\/h3>\n\t\t\t\t<div>This page lists the most commonly used SQL Server Date functions that allow you to handle date and time date effectively.<\/div>\n\t\t\t<\/div>\n\t\t<\/article><article class=\"feature-page\"><div class=\"feature-image\"><img decoding=\"async\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-string-functions.svg\" width =\"90\" height=\"90\" alt=\"\"><\/div><div class=\"feature-body\">\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-string-functions\/\">SQL Server String Functions<\/a>\n\t\t\t\t<\/h3>\n\t\t\t\t<div>This tutorial provides with many useful SQL Server String functions that allow you to manipulate character string effectively.<\/div>\n\t\t\t<\/div>\n\t\t<\/article><article class=\"feature-page\"><div class=\"feature-image\"><img decoding=\"async\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-system-functions.svg\" width =\"90\" height=\"90\" alt=\"\"><\/div><div class=\"feature-body\">\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/\">SQL Server System Functions<\/a>\n\t\t\t\t<\/h3>\n\t\t\t\t<div>This page provides you with the commonly used system functions in SQL Server that return objects, values, and settings in SQL Server.<\/div>\n\t\t\t<\/div>\n\t\t<\/article><article class=\"feature-page\"><div class=\"feature-image\"><img decoding=\"async\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-window-functions.svg\" width =\"90\" height=\"90\" alt=\"\"><\/div><div class=\"feature-body\">\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-window-functions\/\">SQL Server Window Functions<\/a>\n\t\t\t\t<\/h3>\n\t\t\t\t<div>SQL Server Window Functions calculate an aggregate value based on a group of rows and return multiple rows for each group.<\/div>\n\t\t\t<\/div>\n\t\t<\/article><\/section>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The SQL Server Tutorial website offers practical tutorials with many hands-on examples to help you learn SQL Server quickly and effectively.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-7","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server Tutorial<\/title>\n<meta name=\"description\" content=\"The SQL Server Tutorial website offers practical tutorials with many hands-on examples to help you learn SQL Server quickly and effectively.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlservertutorial.net\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Tutorial\" \/>\n<meta property=\"og:description\" content=\"The SQL Server Tutorial website offers practical tutorials with many hands-on examples to help you learn SQL Server quickly and effectively.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlservertutorial.net\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Server Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-30T04:02:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-tutorial.svg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/\",\"name\":\"SQL Server Tutorial\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/wp-content\\\/uploads\\\/sql-server-tutorial.svg\",\"datePublished\":\"2018-03-26T09:41:42+00:00\",\"dateModified\":\"2024-09-30T04:02:15+00:00\",\"description\":\"The SQL Server Tutorial website offers practical tutorials with many hands-on examples to help you learn SQL Server quickly and effectively.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlservertutorial.net\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/wp-content\\\/uploads\\\/sql-server-tutorial.svg\",\"contentUrl\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/wp-content\\\/uploads\\\/sql-server-tutorial.svg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Tutorial\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/\",\"name\":\"SQL Server Tutorial\",\"description\":\"The Practical SQL Server Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Tutorial","description":"The SQL Server Tutorial website offers practical tutorials with many hands-on examples to help you learn SQL Server quickly and effectively.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlservertutorial.net\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Tutorial","og_description":"The SQL Server Tutorial website offers practical tutorials with many hands-on examples to help you learn SQL Server quickly and effectively.","og_url":"https:\/\/www.sqlservertutorial.net\/","og_site_name":"SQL Server Tutorial","article_modified_time":"2024-09-30T04:02:15+00:00","og_image":[{"url":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-tutorial.svg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlservertutorial.net\/","url":"https:\/\/www.sqlservertutorial.net\/","name":"SQL Server Tutorial","isPartOf":{"@id":"https:\/\/www.sqlservertutorial.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlservertutorial.net\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlservertutorial.net\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-tutorial.svg","datePublished":"2018-03-26T09:41:42+00:00","dateModified":"2024-09-30T04:02:15+00:00","description":"The SQL Server Tutorial website offers practical tutorials with many hands-on examples to help you learn SQL Server quickly and effectively.","breadcrumb":{"@id":"https:\/\/www.sqlservertutorial.net\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlservertutorial.net\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlservertutorial.net\/#primaryimage","url":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-tutorial.svg","contentUrl":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-tutorial.svg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlservertutorial.net\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlservertutorial.net\/"},{"@type":"ListItem","position":2,"name":"SQL Server Tutorial"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlservertutorial.net\/#website","url":"https:\/\/www.sqlservertutorial.net\/","name":"SQL Server Tutorial","description":"The Practical SQL Server Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlservertutorial.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/7","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/comments?post=7"}],"version-history":[{"count":5,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/7\/revisions"}],"predecessor-version":[{"id":4618,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/7\/revisions\/4618"}],"wp:attachment":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/media?parent=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}