{"id":2858,"date":"2020-04-14T15:10:39","date_gmt":"2020-04-14T19:10:39","guid":{"rendered":"https:\/\/bt.academy\/home\/?p=2858"},"modified":"2020-06-19T07:27:44","modified_gmt":"2020-06-19T11:27:44","slug":"sql-server-2016","status":"publish","type":"post","link":"https:\/\/bt.academy\/home\/sql-server-2016\/","title":{"rendered":"SQL Server 2016"},"content":{"rendered":"<div id=\"pl-2858\"  class=\"panel-layout\" >\n<div id=\"pg-2858-0\"  class=\"panel-grid panel-no-style\"  data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;,&quot;cell_alignment&quot;:&quot;flex-start&quot;}\"  data-ratio=\"1\"  data-ratio-direction=\"right\" >\n<div id=\"pgc-2858-0-0\"  class=\"panel-grid-cell\"  data-weight=\"1\" >\n<div id=\"panel-2858-0-0-0\" class=\"so-panel widget widget_sow-editor panel-first-child panel-last-child\" data-index=\"0\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<h4><strong>Crea y utiliza bases de datos con SQL Server 2016.<\/strong><br \/>\nA trav\u00e9s de este curso se lograr\u00e1 comprender los principales conceptos de bases datos y realizar\u00e1, crear\u00e1, dise\u00f1ar\u00e1 e implementar\u00e1 una base de datos con SQL Server.<\/h4>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"pg-2858-1\"  class=\"panel-grid panel-no-style\"  data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;,&quot;cell_alignment&quot;:&quot;flex-start&quot;}\" >\n<div id=\"pgc-2858-1-0\"  class=\"panel-grid-cell\"  data-weight=\"0.5\" >\n<div id=\"panel-2858-1-0-0\" class=\"so-panel widget widget_sow-editor panel-first-child\" data-index=\"1\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;,&quot;font_color&quot;:&quot;#dd3333&quot;}\" >\n<div class=\"panel-widget-style panel-widget-style-for-2858-1-0-0\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>DIRIGIDO A:<\/strong><\/p>\n<p>El curso es ideal para estudiantes de programar, desarrolladores web y gente interesada en la tecnolog\u00eda.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"panel-2858-1-0-1\" class=\"so-panel widget widget_sow-editor\" data-index=\"2\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>DURACI\u00d3N:<\/strong><\/p>\n<p>El curso consta de 61 videos con una duraci\u00f3n aproximada de 8 horas y 30 minutos.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"panel-2858-1-0-2\" class=\"so-panel widget widget_sow-editor panel-last-child\" data-index=\"3\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>REQUISITOS PREVIOS:<\/strong><\/p>\n<p>Es recomendable tener nociones b\u00e1sicas sobre bases de datos, pero no existe un conocimiento que sea elemental<br \/>\npara tomar el curso y aprovecharlo.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"pgc-2858-1-1\"  class=\"panel-grid-cell\"  data-weight=\"0.5\" >\n<div id=\"panel-2858-1-1-0\" class=\"so-panel widget widget_sow-editor panel-first-child\" data-index=\"4\" data-style=\"{&quot;background&quot;:&quot;#dddddd&quot;,&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;,&quot;font_color&quot;:&quot;#666666&quot;}\" >\n<div class=\"panel-widget-style panel-widget-style-for-2858-1-1-0\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<h3 style=\"text-align: left;\"><span style=\"color: #d7624e;\">OBJETIVOS<\/span><\/h3>\n<ul>\n<li>Conocer SQL.<\/li>\n<li>Aprender SQL Server.<\/li>\n<li>Crear bases de datos.<\/li>\n<li>Conceptos principales de bases de datos<\/li>\n<li>Administraci\u00f3n de bases de datos<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"panel-2858-1-1-1\" class=\"so-panel widget widget_text panel-last-child\" data-index=\"5\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"textwidget\">\n<p><a href=\"https:\/\/bt.academy\/home\/cotizacion\/?curso=Curso+Audiovisual+SQL+Server+2016\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-2372 aligncenter\" src=\"https:\/\/bt.academy\/home\/wp-content\/uploads\/2018\/09\/contacto-300x71.png\" alt=\"\" width=\"300\" height=\"71\" srcset=\"https:\/\/bt.academy\/home\/wp-content\/uploads\/2018\/09\/contacto-300x71.png 300w, https:\/\/bt.academy\/home\/wp-content\/uploads\/2018\/09\/contacto-600x142.png 600w, https:\/\/bt.academy\/home\/wp-content\/uploads\/2018\/09\/contacto.png 636w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n<div id=\"pg-2858-2\"  class=\"panel-grid panel-no-style\"  data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;,&quot;cell_alignment&quot;:&quot;flex-start&quot;}\"  data-ratio=\"1\"  data-ratio-direction=\"right\" >\n<div id=\"pgc-2858-2-0\"  class=\"panel-grid-cell\"  data-weight=\"1\" >\n<div id=\"panel-2858-2-0-0\" class=\"so-panel widget widget_text panel-first-child panel-last-child\" data-index=\"6\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"textwidget\">\n<h3 style=\"text-align: left;\"><span style=\"color: #d7624e;\">TEMARIO DEL CURSO<\/span><\/h3>\n<\/div><\/div>\n<\/div>\n<\/div>\n<div id=\"pg-2858-3\"  class=\"panel-grid panel-no-style\"  data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;,&quot;cell_alignment&quot;:&quot;flex-start&quot;}\" >\n<div id=\"pgc-2858-3-0\"  class=\"panel-grid-cell\"  data-weight=\"0.5\" >\n<div id=\"panel-2858-3-0-0\" class=\"so-panel widget widget_sow-editor panel-first-child\" data-index=\"7\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>M\u00f3dulo 1: Iniciaci\u00f3n SQL Server<\/strong><\/p>\n<p>En este m\u00f3dulo iniciaremos con las bases de las bases de datos y realizando la instalaci\u00f3n y configuraci\u00f3n de las herramientas necesarias para implementar SQL Server.<\/p>\n<ol>\n<li>Inicio del curso<\/li>\n<li>\u00bfQu\u00e9 es una base de datos?<\/li>\n<li>SQL<\/li>\n<li>SQL Server<\/li>\n<li>Versiones SQL Server<\/li>\n<li>Descargas<\/li>\n<li>Iniciar Servidor<\/li>\n<li>Levantar Servidor<\/li>\n<li>Configuraci\u00f3n avanzada de SQL Server<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"panel-2858-3-0-1\" class=\"so-panel widget widget_sow-editor\" data-index=\"8\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>M\u00f3dulo 2: SQL Management Studio<\/strong><\/p>\n<p>En este m\u00f3dulo vamos conocer la herramienta Management Studio.<\/p>\n<ol>\n<li>SQL Management Studio<\/li>\n<li>Opciones<\/li>\n<li>Configuraciones SQL Server Management Studio<\/li>\n<li>Tips SQL Server Management Studio<\/li>\n<li>Monitor<\/li>\n<li>Profiler<\/li>\n<li>Men\u00fa Principal<\/li>\n<li>Ventanas<\/li>\n<li>Opciones de Apoyo<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"panel-2858-3-0-2\" class=\"so-panel widget widget_sow-editor\" data-index=\"9\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>M\u00f3dulo 3: SQL<\/strong><\/p>\n<p>En este m\u00f3dulo no centramos en conocer las implicaciones a fondo de utilizar SQL.<\/p>\n<ol>\n<li>Conociendo SQL<\/li>\n<li>Sentencias b\u00e1sicas<\/li>\n<li>Sentencias complejas<\/li>\n<li>Conceptos SQL<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"panel-2858-3-0-3\" class=\"so-panel widget widget_sow-editor\" data-index=\"10\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>M\u00f3dulo 4: SQL Server<\/strong><\/p>\n<p>En este m\u00f3dulo iniciaremos en el mundo de SQL Server.<\/p>\n<ol>\n<li>Crear una base de datos<\/li>\n<li>Configurar una base de datos<\/li>\n<li>Instalar bases de datos<\/li>\n<li>Crear una tabla<\/li>\n<li>C\u00f3digo en SQL Server<\/li>\n<li>Ejecuci\u00f3n<\/li>\n<li>Llaves primarias<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"panel-2858-3-0-4\" class=\"so-panel widget widget_sow-editor\" data-index=\"11\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>M\u00f3dulo 5: Bases de datos SQL Server<\/strong><\/p>\n<p>En este m\u00f3dulo utilizaremos los principales conceptos de las bases de datos pero ya implementando SQL Server.<\/p>\n<ol>\n<li>Columnas y tablas<\/li>\n<li>Relaciones<\/li>\n<li>Tablas en memoria<\/li>\n<li>Tablas temporales<\/li>\n<li>Vistas<\/li>\n<li>Vistas complejas<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"panel-2858-3-0-5\" class=\"so-panel widget widget_sow-editor panel-last-child\" data-index=\"12\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>M\u00f3dulo 6: Programaci\u00f3n en base de datos<\/strong><\/p>\n<p>En este m\u00f3dulo vamos a ver la parte de programaci\u00f3n que se puede implementar en una base de datos.<\/p>\n<ol>\n<li>\u00bfQu\u00e9 es un procedure?<\/li>\n<li>Par\u00e1metros<\/li>\n<li>\u00bfQu\u00e9 es una funci\u00f3n?<\/li>\n<li>Funciones Escalar<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"pgc-2858-3-1\"  class=\"panel-grid-cell\"  data-weight=\"0.5\" >\n<div id=\"panel-2858-3-1-0\" class=\"so-panel widget widget_sow-editor panel-first-child\" data-index=\"13\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>M\u00f3dulo 7: Sentencias SQL<\/strong><\/p>\n<p>En este m\u00f3dulo analizaremos las diferentes sentencias que podemos utilizar en SQL.<\/p>\n<ol>\n<li>Insertar datos en una BD<\/li>\n<li>Leer datos de una BD<\/li>\n<li>Actualizar datos de una BD<\/li>\n<li>Eliminar datos de una BD<\/li>\n<li>Combinar sentencias<\/li>\n<li>Variables<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"panel-2858-3-1-1\" class=\"so-panel widget widget_sow-editor\" data-index=\"14\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>M\u00f3dulo 8: XML<\/strong><\/p>\n<p>En este m\u00f3dulo veremos las combinaciones los alcances de SQL Server y XML.<\/p>\n<ol>\n<li>\u00bfQu\u00e9 es XML?<\/li>\n<li>Consultas con XML<\/li>\n<li>Shared XML<\/li>\n<li>XML Schemas<\/li>\n<li>Almacenar XML<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"panel-2858-3-1-2\" class=\"so-panel widget widget_sow-editor\" data-index=\"15\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>M\u00f3dulo 9: JSON<\/strong><\/p>\n<p>En este m\u00f3dulo haremos combinaciones entre SQL y JSON y veremos los alcances.<\/p>\n<ol>\n<li>\u00bfQu\u00e9 es JSON?<\/li>\n<li>JSON a tabla<\/li>\n<li>Almacenar JSON<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"panel-2858-3-1-3\" class=\"so-panel widget widget_sow-editor\" data-index=\"16\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>M\u00f3dulo 10: Respaldos<\/strong><\/p>\n<p>En este m\u00f3dulo veremos c\u00f3mo manejar los respaldos de las bases de datos que podemos crear.<\/p>\n<ol>\n<li>Respaldos<\/li>\n<li>Caracter\u00edsticas de un respaldo<\/li>\n<li>Utilizar respaldos<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"panel-2858-3-1-4\" class=\"so-panel widget widget_sow-editor\" data-index=\"17\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>M\u00f3dulo 11: Monitoreo<\/strong><\/p>\n<p>En este m\u00f3dulo veremos c\u00f3mo monitorear la informaci\u00f3n con la que ya contamos en la base datos.<\/p>\n<ol>\n<li>\u00bfQu\u00e9 es un LOG?<\/li>\n<li>Auditor\u00eda<\/li>\n<li>Vistas en la auditor\u00eda<\/li>\n<li>Consola<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"panel-2858-3-1-5\" class=\"so-panel widget widget_sow-editor panel-last-child\" data-index=\"18\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<p><strong>M\u00f3dulo 12: Fin del curso Despedida y recomendaciones finales.<\/strong><\/p>\n<ol>\n<li>Cierre del curso<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"pg-2858-4\"  class=\"panel-grid panel-no-style\"  data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;,&quot;cell_alignment&quot;:&quot;flex-start&quot;}\"  data-ratio=\"1\"  data-ratio-direction=\"right\" >\n<div id=\"pgc-2858-4-0\"  class=\"panel-grid-cell\"  data-weight=\"1\" >\n<div id=\"panel-2858-4-0-0\" class=\"so-panel widget widget_sow-editor panel-first-child panel-last-child\" data-index=\"19\" data-style=\"{&quot;background_image_attachment&quot;:false,&quot;background_display&quot;:&quot;tile&quot;}\" >\n<div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"color: #999999;\"><strong>\u00a0<\/strong><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Crea y utiliza bases de datos con SQL Server 2016. A trav\u00e9s de este curso se lograr\u00e1 comprender los principales conceptos de bases datos y realizar\u00e1, crear\u00e1, dise\u00f1ar\u00e1 e implementar\u00e1 una base de datos con SQL Server. DIRIGIDO A: El curso es ideal para estudiantes de programar, desarrolladores web y gente interesada en la tecnolog\u00eda.&hellip; <br \/> <a class=\"button small blue\" href=\"https:\/\/bt.academy\/home\/sql-server-2016\/\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":2,"featured_media":2864,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[83],"tags":[86,84,85],"class_list":["post-2858","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-e-learning","tag-microsoft","tag-sql","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/bt.academy\/home\/wp-json\/wp\/v2\/posts\/2858","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bt.academy\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bt.academy\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bt.academy\/home\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bt.academy\/home\/wp-json\/wp\/v2\/comments?post=2858"}],"version-history":[{"count":8,"href":"https:\/\/bt.academy\/home\/wp-json\/wp\/v2\/posts\/2858\/revisions"}],"predecessor-version":[{"id":3117,"href":"https:\/\/bt.academy\/home\/wp-json\/wp\/v2\/posts\/2858\/revisions\/3117"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bt.academy\/home\/wp-json\/wp\/v2\/media\/2864"}],"wp:attachment":[{"href":"https:\/\/bt.academy\/home\/wp-json\/wp\/v2\/media?parent=2858"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bt.academy\/home\/wp-json\/wp\/v2\/categories?post=2858"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bt.academy\/home\/wp-json\/wp\/v2\/tags?post=2858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}