{"id":2063,"date":"2013-09-04T09:00:00","date_gmt":"2013-09-04T16:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/"},"modified":"2024-01-22T22:49:11","modified_gmt":"2024-01-23T06:49:11","slug":"querying-microsoft-sql-server-2012-databases-jump-startseptember-13th","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/","title":{"rendered":"Querying Microsoft SQL Server 2012 Databases Jump Start\u2013September 13th"},"content":{"rendered":"<p><span style=\"font-size:small;\">If you\u2019re already familiar with database fundamentals and you\u2019ve worked with SQL Server, the <\/span><a href=\"http:\/\/www.microsoftvirtualacademy.com\/liveevents\/querying-microsoft-sql-server-2012-jump-start#fbid=9G2KAOpspt6\" target=\"_blank\" rel=\"noopener\"><span style=\"font-size:small;\">Querying Microsoft SQL Server 2012 Databases Jump Start<\/span><\/a><span style=\"font-size:small;\"> course will help you take your skills to the next level. You\u2019ll learn about data manipulation and how to alter tables, and you\u2019ll see it all in action in the demos presented by the experts: <\/span><a href=\"http:\/\/blogs.technet.commailto:@brianalderman\"><span style=\"font-size:small;\">Brian Alderman<\/span><\/a><span style=\"font-size:small;\">, CEO and Founder of MicroTechPoint, and Tobias Ternstrom, Microsoft Program Manager in the SQL Server division. If you\u2019re working on a Microsoft certification, this course will help you prepare for Exam 70-461.<\/span><\/p>\n<p><a href=\"http:\/\/www.microsoftvirtualacademy.com\/liveevents\/querying-microsoft-sql-server-2012-jump-start#fbid=9G2KAOpspt6\" target=\"_blank\" rel=\"noopener\"><span style=\"font-size:small;\">Register now<\/span><\/a><span style=\"font-size:small;\"> for this course to get a detailed look at:<\/span><\/p>\n<ul>\n<li><span style=\"font-size:small;\">Introduction to SQL Server 2012<\/span><\/li>\n<li><span style=\"font-size:small;\">Advanced SELECT statements<\/span><\/li>\n<li><span style=\"font-size:small;\">SQL Server data types<\/span><\/li>\n<li><span style=\"font-size:small;\">Grouping, aggregating and modifying data<\/span><\/li>\n<li><span style=\"font-size:small;\">Table expressions and SET operators<\/span><\/li>\n<li><span style=\"font-size:small;\">Programming with T-SQL<\/span><\/li>\n<li><span style=\"font-size:small;\">Retrieving SQL Server metadata<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size:small;\">This course takes place:<\/span><\/p>\n<blockquote>\n<p><span style=\"font-size:small;\">Date: September 13, 2013 <br \/>Time: 9:00am \u2013 5:00pm <br \/>Where: Live, online virtual classroom <br \/>Cost: Free!<\/span><\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>If you\u2019re already familiar with database fundamentals and you\u2019ve worked with SQL Server, the Querying Microsoft SQL Server 2012 Databases Jump Start course will help you take your skills to the next level.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2433],"topic":[],"coauthors":[2487],"class_list":["post-2063","post","type-post","status-publish","format-standard","hentry","content-type-events"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Querying Microsoft SQL Server 2012 Databases Jump Start\u2013September 13th - Microsoft SQL Server Blog<\/title>\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.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Querying Microsoft SQL Server 2012 Databases Jump Start\u2013September 13th - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"If you\u2019re already familiar with database fundamentals and you\u2019ve worked with SQL Server, the Querying Microsoft SQL Server 2012 Databases Jump Start course will help you take your skills to the next level.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2013-09-04T16:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Querying Microsoft SQL Server 2012 Databases Jump Start\u2013September 13th\",\"datePublished\":\"2013-09-04T16:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/\"},\"wordCount\":159,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/\",\"name\":\"Querying Microsoft SQL Server 2012 Databases Jump Start\u2013September 13th - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2013-09-04T16:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Querying Microsoft SQL Server 2012 Databases Jump Start\u2013September 13th\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Querying Microsoft SQL Server 2012 Databases Jump Start\u2013September 13th - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/","og_locale":"en_US","og_type":"article","og_title":"Querying Microsoft SQL Server 2012 Databases Jump Start\u2013September 13th - Microsoft SQL Server Blog","og_description":"If you\u2019re already familiar with database fundamentals and you\u2019ve worked with SQL Server, the Querying Microsoft SQL Server 2012 Databases Jump Start course will help you take your skills to the next level.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2013-09-04T16:00:00+00:00","article_modified_time":"2024-01-23T06:49:11+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"1 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Querying Microsoft SQL Server 2012 Databases Jump Start\u2013September 13th","datePublished":"2013-09-04T16:00:00+00:00","dateModified":"2024-01-23T06:49:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/"},"wordCount":159,"commentCount":3,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/","name":"Querying Microsoft SQL Server 2012 Databases Jump Start\u2013September 13th - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2013-09-04T16:00:00+00:00","dateModified":"2024-01-23T06:49:11+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/04\/querying-microsoft-sql-server-2012-databases-jump-startseptember-13th\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Querying Microsoft SQL Server 2012 Databases Jump Start\u2013September 13th"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/2063","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=2063"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/2063\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=2063"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=2063"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=2063"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=2063"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=2063"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=2063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}