{"id":34406,"date":"2026-09-21T16:24:14","date_gmt":"2026-09-21T19:24:14","guid":{"rendered":"https:\/\/softland.com\/cl\/?page_id=34406"},"modified":"2026-10-05T12:07:51","modified_gmt":"2026-10-05T15:07:51","slug":"curso-aplicacion-de-bases-de-datos-en-softland-erp-con-excel","status":"publish","type":"page","link":"https:\/\/softland.com\/cl\/formacion\/capacitaciones\/curso-aplicacion-de-bases-de-datos-en-softland-erp-con-excel\/","title":{"rendered":"Curso: Aplicaci\u00f3n de Bases de Datos en Softland ERP con Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"34406\" class=\"elementor elementor-34406\" data-elementor-post-type=\"page\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e20bc7a e-flex e-con-boxed e-con e-parent\" data-id=\"e20bc7a\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9ebc320 elementor-widget elementor-widget-spacer\" data-id=\"9ebc320\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b6ccc59 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"b6ccc59\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Capacitaciones &#8211; Cursos<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b49c893 elementor-widget elementor-widget-heading\" data-id=\"b49c893\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">Curso:<br>\nBases de Datos de Softland ERP: Estructura y Consultas con SQL<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d09e350 e-flex e-con-boxed e-con e-parent\" data-id=\"d09e350\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-5e1029c e-con-full e-flex e-con e-child\" data-id=\"5e1029c\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-034a9d1 elementor-widget elementor-widget-heading\" data-id=\"034a9d1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">Presentaci\u00f3n<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8b53d91 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"8b53d91\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Potencia tu gesti\u00f3n de datos y aprende a utilizar Excel para consultar, analizar y aprovechar la informaci\u00f3n de tu sistema Softland ERP de manera eficiente.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a9b97b elementor-widget elementor-widget-image\" data-id=\"0a9b97b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"883\" height=\"393\" src=\"https:\/\/softland.com\/cl\/wp-content\/uploads\/2026\/09\/bbd-excel-detalle.jpg\" class=\"attachment-large size-large wp-image-34415\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c0f6f28 elementor-widget elementor-widget-heading\" data-id=\"c0f6f28\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">Objetivo<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1151496 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"1151496\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Objetivo: <\/strong><\/p><p><strong>Sesi\u00f3n 1: Arquitectura de Bases de Datos Softland ERP<\/strong><\/p><p><strong>Introducci\u00f3n a la arquitectura de Softland ERP<\/strong><\/p><ul><li>Componentes generales del ERP.<\/li><li>Arquitectura funcional y arquitectura de datos.<\/li><li>SQL Server como motor de base de datos.<\/li><li>Organizaci\u00f3n de una base de datos Softland.<\/li><\/ul><p>\u00a0<\/p><p><strong>Conexi\u00f3n mediante SQL Server <\/strong><strong>Management Studio (SSMS)<\/strong><\/p><ul><li>Requisitos de conexi\u00f3n.<\/li><li>Conexi\u00f3n a una instancia SQL Server.<\/li><li>Navegaci\u00f3n por la base de datos.<\/li><li>Bases de datos, tablas, vistas y procedimientos almacenados.<\/li><li>Consulta simple para visualizar registros.<\/li><\/ul><p>\u00a0<\/p><p><strong>Modelo de datos financiero<\/strong><\/p><ul><li>Estructura general del m\u00f3dulo contable.<\/li><li>Flujo de informaci\u00f3n contable.<\/li><li>Principales tablas financieras.<\/li><li>Plan de cuentas.<\/li><li>Comprobantes contables.<\/li><li>Movimientos contables.<\/li><li>Centros de costo.<\/li><li>Auxiliares.<\/li><\/ul><p>\u00a0<\/p><p><strong>Identificaci\u00f3n de relaciones<\/strong><\/p><ul><li>Llaves principales.<\/li><li>Relaciones entre tablas.<\/li><li>C\u00f3mo interpretar la informaci\u00f3n almacenada.<\/li><li>Ejemplos pr\u00e1cticos de consultas simples.<\/li><\/ul><p>\u00a0<\/p><p><strong>Sesi\u00f3n 2: Modelo Comercial de Softland ERP<\/strong><\/p><p><strong>Arquitectura del m\u00f3dulo comercial<\/strong><\/p><ul><li>Flujo del proceso comercial.<\/li><li>Cotizaciones.<\/li><li>Notas de venta.<\/li><li>Facturaci\u00f3n.<\/li><li>Inventario.<\/li><li>Clientes.<\/li><li>Productos.<\/li><\/ul><p>\u00a0<\/p><p><strong>Modelo de datos comercial<\/strong><\/p><ul><li>Principales tablas comerciales.<\/li><li>Relaci\u00f3n entre documentos comerciales.<\/li><li>Relaci\u00f3n entre clientes y ventas.<\/li><li>Relaci\u00f3n entre productos y movimientos.<\/li><li>Integraci\u00f3n entre m\u00f3dulos comerciales y financieros.<\/li><\/ul><p>\u00a0<\/p><p><strong>Identificaci\u00f3n de campos clave<\/strong><\/p><ul><li>Campos de identificaci\u00f3n.<\/li><li>Fechas.<\/li><li>Documentos.<\/li><li>Productos.<\/li><li>Clientes.<\/li><li>Centros de costo.<\/li><li>Estados de documentos.<\/li><li>Campos utilizados habitualmente para an\u00e1lisis e integraci\u00f3n.<\/li><\/ul><p>\u00a0<\/p><p><strong>Buenas pr\u00e1cticas para proyectos de an\u00e1lisis<\/strong><\/p><ul><li>C\u00f3mo identificar la informaci\u00f3n requerida por un usuario.<\/li><li>Uso de vistas SQL para simplificar consultas.<\/li><li>Consideraciones de rendimiento.<\/li><li>Buenas pr\u00e1cticas para trabajar sobre bases de datos Softland.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-03fd3eb e-con-full e-grid e-con e-child\" data-id=\"03fd3eb\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-25100f8 e-con-full e-flex e-con e-child\" data-id=\"25100f8\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-60c0018 elementor-widget elementor-widget-heading\" data-id=\"60c0018\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Valor<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-674fc04 elementor-widget elementor-widget-heading\" data-id=\"674fc04\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">9,75 UF<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b9c82b7 elementor-widget elementor-widget-spacer\" data-id=\"b9c82b7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-91dd0d7 elementor-widget elementor-widget-heading\" data-id=\"91dd0d7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Modalidad<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-280752f elementor-widget elementor-widget-heading\" data-id=\"280752f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Online<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-72dee43 elementor-widget elementor-widget-spacer\" data-id=\"72dee43\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-490fa0a elementor-widget elementor-widget-heading\" data-id=\"490fa0a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Fecha<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a49671b elementor-widget elementor-widget-heading\" data-id=\"a49671b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">24\/11\/26 al 25\/11\/26<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1950853 elementor-widget elementor-widget-spacer\" data-id=\"1950853\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ae36114 elementor-widget elementor-widget-heading\" data-id=\"ae36114\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Horario<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-04c2760 elementor-widget elementor-widget-heading\" data-id=\"04c2760\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">09:00 - 13:00 Hrs.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ce391bd elementor-widget elementor-widget-spacer\" data-id=\"ce391bd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ef42227 elementor-widget elementor-widget-heading\" data-id=\"ef42227\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Facilitador<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ff54cf0 elementor-widget elementor-widget-heading\" data-id=\"ff54cf0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Softland Training Center<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d1c8b33 elementor-widget elementor-widget-spacer\" data-id=\"d1c8b33\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ebd84da elementor-widget elementor-widget-heading\" data-id=\"ebd84da\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">C\u00f3digo Sence<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cec4c78 elementor-widget elementor-widget-heading\" data-id=\"cec4c78\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">No posee c\u00f3digo<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-85fc226 elementor-button-info elementor-align-justify elementor-widget elementor-widget-button\" data-id=\"85fc226\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/seminarioonline.softlandcloud.cl\/Default.aspx?ideventoapp=24251126\" target=\"_blank\" rel=\"noopener\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-angle-right\" viewBox=\"0 0 256 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M224.3 273l-136 136c-9.4 9.4-24.6 9.4-33.9 0l-22.6-22.6c-9.4-9.4-9.4-24.6 0-33.9l96.4-96.4-96.4-96.4c-9.4-9.4-9.4-24.6 0-33.9L54.3 103c9.4-9.4 24.6-9.4 33.9 0l136 136c9.5 9.4 9.5 24.6.1 34z\"><\/path><\/svg>\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Inscribirse<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-491eaf4 e-flex e-con-boxed e-con e-parent\" data-id=\"491eaf4\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6321b15 elementor-widget elementor-widget-spacer\" data-id=\"6321b15\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Capacitaciones &#8211; Cursos Curso: Bases de Datos de Softland ERP: Estructura y Consultas con SQL Presentaci\u00f3n Potencia tu gesti\u00f3n de datos y aprende a utilizar [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"parent":22761,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post-34406","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/softland.com\/cl\/wp-json\/wp\/v2\/pages\/34406","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/softland.com\/cl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/softland.com\/cl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/softland.com\/cl\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/softland.com\/cl\/wp-json\/wp\/v2\/comments?post=34406"}],"version-history":[{"count":10,"href":"https:\/\/softland.com\/cl\/wp-json\/wp\/v2\/pages\/34406\/revisions"}],"predecessor-version":[{"id":34614,"href":"https:\/\/softland.com\/cl\/wp-json\/wp\/v2\/pages\/34406\/revisions\/34614"}],"up":[{"embeddable":true,"href":"https:\/\/softland.com\/cl\/wp-json\/wp\/v2\/pages\/22761"}],"wp:attachment":[{"href":"https:\/\/softland.com\/cl\/wp-json\/wp\/v2\/media?parent=34406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}