{"id":9621,"date":"2024-05-22T14:05:53","date_gmt":"2024-05-22T17:05:53","guid":{"rendered":"https:\/\/playcomp.cl\/?post_type=product&#038;p=9621"},"modified":"2024-10-24T17:07:56","modified_gmt":"2024-10-24T20:07:56","slug":"administracion-de-microsoft-sql-server","status":"publish","type":"product","link":"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/","title":{"rendered":"Administraci\u00f3n de Microsoft SQL Server"},"content":{"rendered":"<p><strong>OBJETIVO<\/strong><\/p>\n<p>Al t\u00e9rmino del curso, el participante estar\u00e1 en condiciones de:<\/p>\n<ul>\n<li>Identificar y describir los usos y la ejecuci\u00f3n de las diferentes transacciones en SQL.<\/li>\n<li>Escribir Consultas (Queries) de Selecci\u00f3n aplicando filtros.<\/li>\n<li>Utilizar los m\u00e9todos de agrupaci\u00f3n y totalizaci\u00f3n usando subfiltros<\/li>\n<li>Agregar, Actualizar y Eliminar registros de una Tabla usando subfiltros.<\/li>\n<li>Describir c\u00f3mo programar orientado al objeto.<\/li>\n<\/ul>\n<p><strong>CONTENIDOS PROGRAMATICO<\/strong><\/p>\n<p><strong>INTRODUCCI\u00d3N AL DISE\u00d1O DE BASES DE DATOS<\/strong><\/p>\n<ul>\n<li>Planeaci\u00f3n<\/li>\n<li>Teor\u00eda de la estructura de Base de Datos<\/li>\n<li>Estructura de las bases de datos<\/li>\n<li>Normalizaci\u00f3n<\/li>\n<li>Reglas informales y tips que deben tomarse en cuenta<\/li>\n<li>Diagramaci\u00f3n<\/li>\n<li>Diagrama Entidad \/ V\u00ednculo (E\/R)<\/li>\n<li>Proceso del dise\u00f1o de una base de datos relacional<br \/>\nENTORNO DE TRABAJO DE SQL SERVER MANAGEMENT STUDIO<\/li>\n<li>SQL Server y SQL Server Management Studio<\/li>\n<li>Object Explorer<\/li>\n<li>Ventanas de consulta<\/li>\n<\/ul>\n<p><strong>EL LENGUAJE SQL<\/strong><\/p>\n<ul>\n<li>Antecedentes<\/li>\n<li>Importancia<\/li>\n<li>Componentes (DDL, DML, DCL)<br \/>\nDEFINICI\u00d3N DE DATOS<\/li>\n<li>Tipos de datos del sistema<\/li>\n<li>Creaci\u00f3n de tablas<\/li>\n<li>Creaci\u00f3n de reglas y datos predeterminados<\/li>\n<li>Edici\u00f3n de tablas<\/li>\n<li>Copia de la estructura de una tabla<\/li>\n<li>Copia de la estructura y datos de una tabla<\/li>\n<li>Eliminaci\u00f3n de tablas<\/li>\n<li>Integridad referencial<\/li>\n<li>Creaci\u00f3n de \u00edndices<\/li>\n<\/ul>\n<p><strong>TIPOS DE RELACIONES<\/strong><\/p>\n<ul>\n<li>Llaves primarias (PK)<\/li>\n<li>Llaves for\u00e1neas (FK)<\/li>\n<li>Relaciones uno a varios<\/li>\n<li>Relaciones uno a uno<\/li>\n<li>Relaciones varios a varios<\/li>\n<li>Relaciones recursivas<\/li>\n<\/ul>\n<p><strong>SELECCI\u00d3N DE DATOS<\/strong><\/p>\n<ul>\n<li>Selecci\u00f3n de informaci\u00f3n (Select&#8230;From.., Distinct, Alias)<\/li>\n<li>Especificaci\u00f3n de criterios de selecci\u00f3n de informaci\u00f3n (Where&#8230;)<\/li>\n<li>Operadores l\u00f3gicos (In, Like, Between), matem\u00e1ticos y comodines<\/li>\n<li>Valores nulos<\/li>\n<li>Subconsultas<\/li>\n<li>Ordenamiento de la informaci\u00f3n (Order by)<\/li>\n<li>Agrupaci\u00f3n de informaci\u00f3n y funciones de grupo (Group by, Having)<\/li>\n<li>Creaci\u00f3n de Vistas<\/li>\n<\/ul>\n<p><strong>MANIPULACI\u00d3N DE DATOS<\/strong><\/p>\n<ul>\n<li>Inserci\u00f3n de informaci\u00f3n (insert).<\/li>\n<li>Eliminaci\u00f3n de registros (delete, truncate).<\/li>\n<li>Actualizaci\u00f3n de informaci\u00f3n (update).<\/li>\n<\/ul>\n<p><strong>TIPOS DE COMBINACIONES (JOINTS)<\/strong><\/p>\n<ul>\n<li>Inner Join.<\/li>\n<li>Outer Joins (Right Join \u2013 Left Join)<\/li>\n<li>Self Join<\/li>\n<\/ul>\n<p><strong>USO DE FUNCIONES<\/strong><\/p>\n<ul>\n<li>Principales funciones para datos tipo car\u00e1cter<\/li>\n<li>Principales funciones matem\u00e1ticas<\/li>\n<li>Principales funciones para datos tipo fecha<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>OBJETIVO Al t\u00e9rmino del curso, el participante estar\u00e1 en condiciones de: Identificar y describir los usos y la ejecuci\u00f3n de las diferentes transacciones en SQL. Escribir Consultas (Queries) de Selecci\u00f3n aplicando filtros. Utilizar los m\u00e9todos de agrupaci\u00f3n y totalizaci\u00f3n usando subfiltros Agregar, Actualizar y Eliminar registros de una Tabla usando subfiltros. Describir c\u00f3mo programar orientado&#8230;<\/p>\n","protected":false},"featured_media":10409,"template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[119],"product_tag":[],"class_list":{"0":"post-9621","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-gestion-y-analisis-de-datos","8":"first","9":"instock","10":"shipping-taxable","11":"product-type-simple"},"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Administraci\u00f3n de Microsoft SQL Server - Play Comp<\/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:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Administraci\u00f3n de Microsoft SQL Server - Play Comp\" \/>\n<meta property=\"og:description\" content=\"OBJETIVO Al t\u00e9rmino del curso, el participante estar\u00e1 en condiciones de: Identificar y describir los usos y la ejecuci\u00f3n de las diferentes transacciones en SQL. Escribir Consultas (Queries) de Selecci\u00f3n aplicando filtros. Utilizar los m\u00e9todos de agrupaci\u00f3n y totalizaci\u00f3n usando subfiltros Agregar, Actualizar y Eliminar registros de una Tabla usando subfiltros. Describir c\u00f3mo programar orientado...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Play Comp\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/playcompchile\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-24T20:07:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/SQL-SERVER-IMG-2-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"466\" \/>\n\t<meta property=\"og:image:height\" content=\"466\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/\",\"url\":\"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/\",\"name\":\"Administraci\u00f3n de Microsoft SQL Server - Play Comp\",\"isPartOf\":{\"@id\":\"https:\/\/playcomp.cl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/SQL-SERVER-IMG-2-1.png\",\"datePublished\":\"2024-05-22T17:05:53+00:00\",\"dateModified\":\"2024-10-24T20:07:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/#primaryimage\",\"url\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/SQL-SERVER-IMG-2-1.png\",\"contentUrl\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/SQL-SERVER-IMG-2-1.png\",\"width\":466,\"height\":466},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/playcomp.cl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tienda\",\"item\":\"https:\/\/playcomp.cl\/index.php\/tienda\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Administraci\u00f3n de Microsoft SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/playcomp.cl\/#website\",\"url\":\"https:\/\/playcomp.cl\/\",\"name\":\"Play Comp\",\"description\":\"Organismo T\u00e9cnico de Capacitaci\u00f3n\",\"publisher\":{\"@id\":\"https:\/\/playcomp.cl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/playcomp.cl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/playcomp.cl\/#organization\",\"name\":\"Play Comp\",\"url\":\"https:\/\/playcomp.cl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/playcomp.cl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2017\/07\/Artboard-36.png\",\"contentUrl\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2017\/07\/Artboard-36.png\",\"width\":423,\"height\":112,\"caption\":\"Play Comp\"},\"image\":{\"@id\":\"https:\/\/playcomp.cl\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/playcompchile\/\",\"https:\/\/www.instagram.com\/playcomp_capacitacion?igsh=OGtwZzBsYW5qbTF5\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Administraci\u00f3n de Microsoft SQL Server - Play Comp","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:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/","og_locale":"es_ES","og_type":"article","og_title":"Administraci\u00f3n de Microsoft SQL Server - Play Comp","og_description":"OBJETIVO Al t\u00e9rmino del curso, el participante estar\u00e1 en condiciones de: Identificar y describir los usos y la ejecuci\u00f3n de las diferentes transacciones en SQL. Escribir Consultas (Queries) de Selecci\u00f3n aplicando filtros. Utilizar los m\u00e9todos de agrupaci\u00f3n y totalizaci\u00f3n usando subfiltros Agregar, Actualizar y Eliminar registros de una Tabla usando subfiltros. Describir c\u00f3mo programar orientado...","og_url":"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/","og_site_name":"Play Comp","article_publisher":"https:\/\/www.facebook.com\/playcompchile\/","article_modified_time":"2024-10-24T20:07:56+00:00","og_image":[{"width":466,"height":466,"url":"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/SQL-SERVER-IMG-2-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/","url":"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/","name":"Administraci\u00f3n de Microsoft SQL Server - Play Comp","isPartOf":{"@id":"https:\/\/playcomp.cl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/SQL-SERVER-IMG-2-1.png","datePublished":"2024-05-22T17:05:53+00:00","dateModified":"2024-10-24T20:07:56+00:00","breadcrumb":{"@id":"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/#primaryimage","url":"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/SQL-SERVER-IMG-2-1.png","contentUrl":"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/SQL-SERVER-IMG-2-1.png","width":466,"height":466},{"@type":"BreadcrumbList","@id":"https:\/\/playcomp.cl\/index.php\/producto\/administracion-de-microsoft-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/playcomp.cl\/"},{"@type":"ListItem","position":2,"name":"Tienda","item":"https:\/\/playcomp.cl\/index.php\/tienda\/"},{"@type":"ListItem","position":3,"name":"Administraci\u00f3n de Microsoft SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/playcomp.cl\/#website","url":"https:\/\/playcomp.cl\/","name":"Play Comp","description":"Organismo T\u00e9cnico de Capacitaci\u00f3n","publisher":{"@id":"https:\/\/playcomp.cl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/playcomp.cl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/playcomp.cl\/#organization","name":"Play Comp","url":"https:\/\/playcomp.cl\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/playcomp.cl\/#\/schema\/logo\/image\/","url":"https:\/\/playcomp.cl\/wp-content\/uploads\/2017\/07\/Artboard-36.png","contentUrl":"https:\/\/playcomp.cl\/wp-content\/uploads\/2017\/07\/Artboard-36.png","width":423,"height":112,"caption":"Play Comp"},"image":{"@id":"https:\/\/playcomp.cl\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/playcompchile\/","https:\/\/www.instagram.com\/playcomp_capacitacion?igsh=OGtwZzBsYW5qbTF5"]}]}},"_links":{"self":[{"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product\/9621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/media\/10409"}],"wp:attachment":[{"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/media?parent=9621"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product_brand?post=9621"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product_cat?post=9621"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product_tag?post=9621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}