Home
Search results “Oracle query from excel”
Formatting your Oracle Query Results Directly to CSV
 
03:02
How to get Oracle SQL Developer to automatically format your query results to CSV, HTML, JSON, Insert statements, and more.
Views: 45921 Jeff Smith
Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records
 
18:02
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to use Power Query (Get & Transform) with Input Variables from Excel Sheet to Extract Records and create a Revenue Report. Here are the steps: 1. (00:15) Introduction including Preview of Finished Solution and Preview of steps necessary to accomplish this goal. 2. (02:00) Import and transform Data Set, including removing Columns, Filter For Records and adding an extra Column to calculate Net Revenue using the Number.Round Power Query Function. 3. (06:38) Load Report to Sheet 4. (07:09) Import each Parameter/Criteria Table. 5. (07:36) Convert each Criteria Table to a single Text Item using the Record.Field Power Query Function. 6. (11:38) Declare and Insert Variables into M Code for Report 7. (14:10) Test Reporting System 8. (14:30) Create Recorded Macro To Refresh All and assign it to a Form button 9. (16:40) Test Macro and Reporting System 10. (17:25) Summary
Views: 79721 ExcelIsFun
How to build multi record INSERT and UPDATE SQL query with MS Excel
 
13:09
The video shows how to use Microsft Excel to prepare / build / construct SQL INSERT and UPDATE query / queries for multi / many records / rows of data. It can be especially useful for UPDATE clause queries because INSERT type has alternatives methods in provided SQL tools. It also demostartes the general usage of method to multi build queries with the usage of concatenate function. More examples on: http://www.excel.sos.pl Tags: MS SQL, My SQL, MS Excel, Oracle
Oracle Query VBA Tool
 
04:24
Oracle Query VBA Tool (OQVT) is Microsoft Excel (VBA) based solution to fetch data from oracle database. It allows fetching data from multiple schemas (users) of same or different oracle database.
Views: 939 Rakesh Jain
Excel VBA Introduction Part 30 - ADO (ActiveX Data Objects) Querying a Database
 
01:22:06
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! You can buy our Introduction to Excel VBA book here https://www.lulu.com/shop/andrew-gould/introduction-to-excel-vba/paperback/product-23301058.html By Andrew Gould https://www.wiseowl.co.uk - Connecting to databases in VBA sounds like it should be complicated, but using the ActiveX Data Objects, or ADO, Object Library makes life an awful lot easier! This video teaches you how to reference the library and how to create a connection to almost any type of database by providing the correct connection string (this video covers Microsoft Access and Microsoft SQL Server). We'll also show you how to grab a set of data from a database using recordset objects and even how to write SQL queries in your VBA procedures. The final part of the video talks about how you can take user input to modify the query to allow you to create a simply querying tool in VBA. You can download the Access Movies database here: https://www.wiseowl.co.uk/files/execise-question-files/qf-1103.zip You can download the script to create the SQL Server Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 113453 WiseOwlTutorials
Beyond Excel: Parameterized Query
 
03:27
Create a Parameterized Query in Excel without Add-ins, Macros, or Formulas
Views: 70059 Craig Hatmaker
Query Oracle DB using Excel - *** Download link in description of video ***
 
03:37
Query Oracle DB using Excel, Utility for SQL Plan and Advisor Recommendations Download App: https://goo.gl/lRHu9w
Views: 74 TxSolve
Run an SQL Query With Dynamic Parameter from Excel
 
03:51
Run an SQL Query With Dynamic Parameter from Excel Running SQL from Excel with dynamic parameters Truy vấn dữ liệu từ SQL Server từ excel với tham số FBPage: https://www.facebook.com/excelvbatips... Facebook: https://www.facebook.com/quan.luu.1989 Youtube: https://www.youtube.com/mrdba1989 Website: https://quanluu1989.com Bạn để lại comment nếu có thắc mắc hoặc có vấn đề cần giải quyết Nếu video hữu ích thì nhớ like để khuyến khích mình nhé Bạn có thể SUBSCRIBE kênh mình tại đây: https://goo.gl/9cJoNu Thanks for watching! Please like, share and comment below. Subscribe to my channel for more!
Views: 21403 Mr DBA
Run SQL Query with Date Range filter in Excel
 
05:38
Run SQL Query with Date Range filter in Excel My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 14820 SQL with Manoj
Controlling Microsoft Excel with query tool - Invantive Vision
 
07:23
In this Query Tool tutorial you can see how to use the Invantive Query Tool. The Invantive Query Tool can be used with Microsoft Excel, Microsoft Word, Microsoft PowerPoint and Oracle database. You can find the Query tool in the Microsoft Outlook add-in Invantive Vision and Invantive Estate. The Invantive Query tool is comparable with TOAD software and SQuirrel SQL. http://www.invantive.com/products/invantive-query-tool Telephone: +31 88 0026500 [email protected]
Views: 2008 Invantive BV
Data Analysis using Excel- Database Queries, Filters and Pivot Tables
 
54:54
I have noticed that many people throughout the world have been interested in my training videos on Using Database Queries and Pivot Tables in Microsoft Excel. So this training video, while very helpful for Active Planner customers, is applicable to any Excel user who wants to create database queries and then analyze that data using Filters and Pivot Tables. And as an added bonus, we will go into SQL Management Studio to build and debug our query and I will show you how to create a PIVOT query. I have created a new video for Sage 300 users so check it out at: https://youtu.be/HXzm8s2mVhI And Sage 500 users check out this new video at: https://youtu.be/UWJ9UrTeEr8 Thank you, Doug Leasure
Views: 171631 ActivePlanner
Database Query Oracle
 
07:23
In deze Database Query voor Oracle tutorial zie je hoe je de Invantive Query Tool kunt gebruiken. Met de Invantive Query Tool kun je onder anderen gegevens in Microsoft Excel ophalen en in je database verwerken. Daarnaast kun je Queries in je Oracle database uitvoeren. Met de Invantive Query Tool kun je ook SQL, PL/SQL Queries uitvoeren. De Query Tool is vergelijkbaar met TOAD en vindt je bij de Microsoft Outlook add-in Invantive Vision, Invantive Estate en Invantive Control. Wil je meer informatie over werken met Queries in Microsoft Excel, Microsoft PowerPoint of Oracle database? Bezoek dan op onze website. https://www.invantive.nl/producten/invantive-query-tool Telephone: +31 88 0026500 [email protected]
Views: 790 Invantive BV
Parameterized Power Query
 
05:17
How to add Excel parameters to Power Query. https://sites.google.com/site/beyondexcel/project-updates/parameterizedpowerquery Sample workbook can be downloaded from Beyond Excel (click link above)
Views: 3005 Craig Hatmaker
Creating a table , database and importing data from excel
 
07:04
This video show how to create a database , a table , relationships and a database diagram using sql server management studio. Its also shows how to query data from the table and also how to add or edit data within a table that already been created. The video then moves on to show how you can import data from an excel sheet directly into tables within SQL Server using the import data wizard. http://msdn.microsoft.com/en-us/library/cc645993%28v=sql.100%29.ASPX http://technet.microsoft.com/en-us/library/ms365247%28v=sql.105%29.aspx
Views: 75438 Jayanth Kurup
Creating Basic Ad Hoc Reports in Smart View
 
05:08
In this tutorial you learn how to use ad-hoc analysis to create reports and analyze data in Smart View for Oracle Enterprise Performance Reporting Cloud Service.
Views: 57039 Oracle EPM Tutorials
how to pass dynamic parameters to SQL query from Excel to import the data in it.
 
04:49
This video demonstrates how to pass dynamic parameters to SQL query from Excel to import the data in it.
Views: 3561 Mandeep baluja
Using Postgres SQL Queries and Excel to determine non-employee answers
 
12:55
Here is a video that covers how to get a Postgres SQL dump of all questions from Jive as well as who answered them. The data from this query is combined with profile data you can get from CMR as well as space data that you can classify many ways. Instructions for installing Postgres, creating databases, and restoring databases from Jive cloud .dmp files: Installing Postgres for Jive DWH Implementation Query to get answers: select question.threadid, answer.messageid, answer.containerid, question.userid as "Asker", answer.userid as "Answerer",to_timestamp(question.creationdate/1000) as "creationdate",to_timestamp(question.resolutiondate/1000) as "resolutiondate", question.resolutionstate,answer.helpfulanswer,answer.correctanswer from jivequestion question left join jiveanswer answer on answer.threadid = question.threadid order by question.threadid asc Excel formula to distinguish employees from external users: =IF(ISNUMBER(SEARCH("@domain.com",H2)),"EMPLOYEE","USER") NOTE: replace "@domain.com" with the proper e-mail string and replace H2 with the cell containing e-mail addresses of the person that supplied the answer.
Views: 6896 nogoodnamesleft555
How to Import Access Query Into Excel : Microsoft Office Tips
 
02:06
Subscribe Now: http://www.youtube.com/subscription_center?add_user=ehowtech Watch More: http://www.youtube.com/ehowtech Importing an Access query into Excel requires you to make sure that you're exporting that query in the right format. Import an Access query into Excel with help from a longtime software expert and professional in this free video clip. Expert: Brie Clark Filmmaker: Alexis Guerreros Series Description: Microsoft's Office still has the most powerful word processing, presentation, database and spreadsheet creation tools on any system available today. Get Microsoft Office tips with help from a longtime software expert and professional in this free video series.
Views: 8539 eHowTech
MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop
 
19:11
Download Excel START File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MSPTDA-ImportSQLIntoPowerQuery-Start.xlsx Download Excel FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MSPTDA-ImportSQLIntoPowerQuery-Finished.xlsx Download Power BI Desktop FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MPSTDA-PowerBIDesktop-GetSQL-Data.pbix Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MSPTDA-PowerQueryImportSQLData.pdf Practice Problems: Assigned Homework: Download homework file (Practice Problems) : https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MSPTDA-Homework-Start.xlsx Example of Finished Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MSPTDA-Homework-Finished.xlsx link to Microsoft Notes on Direct Query: https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery In this Video learn how to connect to an SQL Server Database and extract and transform data using Power Query in Excel and Power BI Desktop. Topics: 1. (00:16) Introduction 2. (00:32) What is an SQL Server Database 3. (02:19) The Goal of our Queries and a look at the end result reports in Excel 4. (03:04) Comparing and Contrast using 1) Using Power Query User Interface or 2) Writing SQL Code in Power Query 5. (04:46) Example 1: Use Power Query User Interface to connect to SQL Server and Extract, Transform and Load Data. 6. (11:27) Example 2: Write SQL Code to connect to SQL Server and Extract, Transform and Load Data. 7. (14:44) Example 3: Using Power BI Desktop to connect to SQL Server and Import multiple Tables. 8. (18:29) Summary Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor. The Power Query logo used in this video is copyright of and used with the express permission of https://powerquery.training Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!
Views: 7794 ExcelIsFun
Running a SQL query in Excel
 
01:31
A "how-to" video to show how to add a connection in Excel and then changing it to run a SQL query.
Views: 25767 Riaan Lategan
Business Intelligence: Automating Power Query with VBA
 
04:35
View this demo to see how to record and edit VBA Macros to automate the Power Query Data Import Processor. Want to see more tech tutorials? Subscribe to the Learning Tree Tech Tips and Tricks playlist: https://www.youtube.com/playlist?list=PLXrVfv7YnPHvbMWTl_91n645Me9E83rjo SUBSCRIBE to the LearningTree YouTube channel: https://www.youtube.com/learningtree Additional ways to get latest tech industry news: -Subscribe to blog: https://www.blog.learningtree.com -Follow on Twitter @LearningTree -Follow on LinkedIn https://www.linkedin.com/company/learning-tree-international -Like on Facebook https://www.facebook.com/LearningTreeIntl/ For more training, visit https://www.learningtree.com/ Learning Tree is recognized as Top 20 IT Training Company for 2016. From single courses to large enterprise solutions, Learning Tree can help your organization overcome skills gaps and accomplish individual and organization objectives.
Export data from Oracle query results to Excel file
 
00:16
Using Withdata OracleToExcel, no need to program, just a few mouse clicks! http://www.withdata.com/oracletoexcel/ . Download link: http://www.withdata.com/down/OracleToExcel.exe
Views: 246 Shiji Pan
Beyond Excel: Get Data using MS Query
 
05:28
Learn how to get data into Excel from any database using MS Query
Views: 100745 Craig Hatmaker
Ejecutar consulta SQL desde Excel @EXCELeINFO
 
13:09
✅ Descarga el archivo de ejemplo | http://www.exceleinfo.com/ejecutar-consulta-sql-desde-excel-e-importar-datos-a-una-tabla 🏆 Suscríbete a este canal | https://goo.gl/M5zNA8 En este tutorial voy a mostrarles una manera sencilla de ejecutar una Consulta o un Query de SQL desde Excel y volcar los datos una Tabla. Para desarrollar el tutorial tuve que instalar una máquina virtual con Windows Server y SQL Server, para simular un ambiente real. Anteriormente ya había desarrollado un tutorial sobre cómo Consultar información de SQL mediante Power Query. En este tutorial haremos igual una conexión, pero usaremos otra herramienta. Credenciales de acceso al Servidor SQL Para poder conectarnos al Servidor de SQL debemos saber primero el nombre del Servidor o la IP del mismo. Dentro de la máquina virtual ejecutamos la aplicación CMD y ejecutamos el comando IPCONFIG, el cual nos dirá la IP del Servidor de Windows. El usuario y contraseña de SQL serán las misma que asignaron al momento de la instalación o un usuario que puedan crear posterior a la instalación. En caso de que no tengas un ambiente de pruebas como el anterior, te sugiero solicites a tu departamento de Sistemas los siguientes datos: IP o nombre del Servidor. Usuario asignado de SQL. Contraseña del usuario asignado. Muchos ejemplos | http://www.exceleinfo.com Muchos ejemplos | http://blogs.itpro.es/exceleinfo Página de Facebook | https://www.facebook.com/EXCELeINFO Recibe notificaciones por Telegram | https://t.me/EXCELeINFO Twitter | @EXCELeINFO Twitter | @SergioACamposH Descargar EXCELeINFO addin: http://addin.exceleinfo.com
Export a Table or Query results from SQL Server to Excel
 
05:39
Export a Table or Query results from SQL Server to Excel My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 33591 SQL with Manoj
How to access data from file - External Table - Oracle - Query Data from flat files
 
11:48
In this video we can see what is the external table, how can we use it.... How to access table from a flat file? We can access data from any type of format loaded by SQL*Loader. Code: create or replace directory External_Dir as 'D:\External'; create table External_Table ( v_num number(5), v_name varchar2(20) ) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY External_Dir Access parameters ( RECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY ',' ) LOCATION('Sample_File.txt') );
Excel Power Query & Data Cleansing BONUS VIDEO #2: Convert ERP Reports into a Pivot Table
 
20:37
In this Bonus video of the free training series on Excel Power Query & Data Cleansing you will learn how to get a report that comes in from your ERP system (QuickBooks, Oracle, PeopleSoft, SAP etc) and transform it into an Excel Pivot Table report using Power Query. Download the Excel workbooks used in this tutorial to practice: http://myexcelonline.com/blog/wp-content/uploads/2016/06/EricData.zip Here is the timeline of this Power Query & Data Cleansing video: 00:00 Intro: Converting Financial Data into a Flat File 01:00 Starting the Solution 03:30 Add Conditional Column in PQ 03:58 Fill Down 04:32 Replace Values 04:50 Add Conditional Column in PQ 06:29 Formatting Columns in PQ 07:10 Unpivot Other Columns 08:42 Insert Pivot Table 09:28 Insert Slicers 10:28 Intro 2: Pointing to a Dedicated Folder 11:20 Starting the Solution 11:35 Making the Folder 11:46 Starting to Develop the Query 11:52 Navigate to New Folder 12:20 Telling PQ what to Import 12:50 Add Custom Column for Import 13:06 Custom Column Formula 14:16 Re-doing the Query Steps from Part 1 15:20 Insert Pivot Table 16:05 Insert Slicers 16:25 Add New File to Dedicated Folder 16:50 Refresh Query 17:08 Refresh Pivot Table 17:27 Add another File to Dedicated Folder 17:48 Delete Query that was created in Part 1 17:18 Turn off Grand Total for Pivot Table Column 18:50 A word about Queries, Connections and Filepaths 19:43 Error in Query 20:00 Editing the Query WATCH THE REST OF OUR FREE TRAINING SERIES HERE: VIDEO 1: Excel Power Query & Data Cleansing Part 1: Different Ways to Format Data Using Power Query https://youtu.be/QJITjit-la0 VIDEO 2: Format & extract data using Excel Formulas & Excel's Data Tools https://www.youtube.com/watch?v=9q4_QLr5VoA VIDEO 3: Consolidate Workbooks & Worksheets using Power Query https://www.youtube.com/watch?v=3EMACCDmsVU WATCH OUR FREE WEBINAR ON POWER QUERY & DATA CLEANING NOW: http://www.myexcelonline.com/107-21.html Please share, like & leave your comments below. Thank You, JOHN MICHALOUDIS www.MyExcelOnline.com
Views: 3616 MyExcelOnline.com
Matching transactions (reconciling) using Excel Pivot Tables | ExcelTutorials
 
13:38
Matching transactions (reconciling) using Excel Pivot Tables | ExcelTutorials Learn how to reconcile (or match) transactions using Excel Pivot Tables. Example workbook and more here: http://chandoo.org/wp/2014/06/10/matching-transactions-pivot-tables/ Do Subscribe, Like & Share my video if you like!! Click The Below Link To SUBSCRIBE: https://www.youtube.com/channel/UC8uU_wruBMHeeRma49dtZKA
Views: 141984 Learn Excel from Chandoo
ODBC Connections - First Basic Query with Excel
 
12:53
In this session, Peter discusses the basics of creating queries in Excel using the PBS Accounts Payable Vendor file. Now don't be fooled, though it's a basic query, he goes into quite a bit of detail on what's going on "behind the curtain". It really sets the table to help you understand how the whole ODBC link works whether you're attaching to a SQL database, or one with an ODBC driver.
How to schedule a SQL query and send the result by mail
 
02:56
This video shows how you can use AutoSQL (https://www.autosql.net) to schedule a SQL query and send the results by mail. In the example a SQL server is used to run a query of overdue invoices. If there are any, a mail is send with an Excel attachment containing the results.
Views: 12497 AutoSQL
Excel Tutorial: What is Business Intelligence and an OLAP Cube? | ExcelCentral.com
 
10:18
This video lesson fully explains the concepts of Business Intelligence, OLAP, MDX and and how they apply to Excel 2013. At http://ExcelCentral.com you can view over 850 free Excel video lessons just like this one. All in full HD with vari-speed and human-transcribed subtitles providing the perfect Excel learning environment. You can also track your progress through the course and print a certificate upon completion. Separate videos are provided for Excel 2007, Excel 2010 and Excel 2013. The lesson begins with an explanation of OLAP and its purpose. You'll learn about OLAP Cubes and how they are divided into Dimensions, Measure and Hierarchies to create a multidimensional data structure. You'll also learn about how the MDX query language is used to extract values from OLAP cubes. This lesson also explains the concept of Business Intelligence and how it applies to OLAP. This video comes from the Data Model, OLAP, MDX and BI session (Session 6 in our Excel 2013 Expert Skills free video training course). This session includes the following video lessons: ▪ Lesson 6-1: Understand primary and foreign keys (11m 27s) http://excelcentral.com/excel2013/expert/lessons/06010-understand-primary-key-foreign-key-relationships.html ▪ Lesson 6-2: Create a simple data model (6m 31s) http://excelcentral.com/excel2013/expert/lessons/06020-create-a-simple-data-model.html ▪ Lesson 6-3: Understand OLAP, MDX and Business Intelligence (10m 17s) http://excelcentral.com/excel2013/expert/lessons/06030-what-is-business-intelligence-and-an-olap-cube.html ▪ Lesson 6-4: Use the GETPIVOTDATA function (4m 31s) http://excelcentral.com/excel2013/expert/lessons/06040-use-the-getpivotdata-function.html ▪ Lesson 6-5: Use the CUBEVALUE function to query an OLAP cube (5m 40s) http://excelcentral.com/excel2013/expert/lessons/06050-use-the-cubevalue-function-to-query-an-olap-cube.html ▪ Lesson 6-6: Convert CUBEVALUE functions to include MDX expressions (5m 48s) http://excelcentral.com/excel2013/expert/lessons/06060-convert-cubevalue-functions-to-include-mdx-expressions.html ▪ Lesson 6-7: Understand OLAP pivot table limitations (10m 52s) http://excelcentral.com/excel2013/expert/lessons/06070-understand-olap-pivot-table-limitations.html ▪ Lesson 6-8: Create an asymmetric OLAP pivot table using Named Sets (4m 57s) http://excelcentral.com/excel2013/expert/lessons/06080-create-an-asymmetric-olap-pivot-table-using-named-sets.html ▪ Lesson 6-9: Understand many-to-many relationships (11m 5s) http://excelcentral.com/excel2013/expert/lessons/06090-understand-many-to-many-relationships.html ▪ Lesson 6-10: Create an OLAP pivot table using a many-to-many relationship (12m 47s) http://excelcentral.com/excel2013/expert/lessons/06100-create-an-olap-pivot-table-using-a-many-to-many-relationship.html You can watch any of the 850 Excel video lessons, free and without any required registration at http://excelcentral.com/excel2013/expert/tutorials/default.html.
Views: 248925 ExcelCentral.com
Call Stored Procedure with multiple parameters from Excel
 
05:16
Call Stored Procedure with multiple parameters or different parameter values from Excel SYNTAX: {CALL uspGetManagerEmployees (?)} My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 12239 SQL with Manoj
How to Import Excel Into Your Database
 
17:23
Step by step demonstration of taking an excel (or CSV) file and creating a new Oracle table and then loading the data using Oracle SQL Developer. Yes, it's a Wizard. Yes, you can do it. Yes, there are a few places where you want to be careful.
Views: 3140 Jeff Smith
Excel Magic Trick 1335: Power Query We Couldn’t Refresh The Connection Data Source Not Found Error
 
01:43
Download File: http://people.highline.edu/mgirvin/excelisfun.htm In Power Query see how to use deal with the Refresh Error Message: We couldn’t refresh the connection. Here is the error message we got: [DataSource.NotFound] File or Folder: We couldn’t find the folder.
Views: 15974 ExcelIsFun
Query Light a lightweight and lightning fast Oracle Database client / Browser.
 
02:09
- Has Toad , Sqldevloper like Ctrl + enter to run query function. - Very lightweight application, consumes less than 50Mb in memory. - Provides ability to export/save queried data in excel , csv formats. - Is able to Describe most database objects with select and F4. Download from here. http://www.querylight.in/
Views: 695 Query Light
Oracle - SQL - Merge Statement
 
07:26
Oracle - SQL - Merge Statement Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Excel Power Query & Data Cleansing Part 1: Different Ways to Format Data Using Power Query
 
37:04
*** SPECIAL OFFER *** JOIN THE MYEXCELONLINE ACADEMY & GET 300+ EXCEL TUTORIALS FOR ONLY $1: https://www.myexcelonline.com/107-53.html In this 1st of a 3 part training series on Excel Power Query & Data Cleansing you will learn the different ways to format your messy data using Power Query. Download the Excel workbooks used in this tutorial to practice: http://myexcelonline.com/blog/wp-content/uploads/2016/06/Power-Query-Data-Cleansing-Excel-Workbooks.zip This training is for beginners & intermediate Excel users and can be applied to Microsoft Excel 2010, 2013 & 2016 versions. You will learn the following topics: Intro from John Michaloudis & Oz du Soleil 12:10 – Intro to Power Query (Get & Transform in Excel 2016) 16:30 – Trim leading & trailing spaces 20:30 – Format “text” Dates & Values using Excel v Power Query 24:15 – Parse URLs using Excel v Power Query 27:55 – Transform & automate reports from an ERP system (e.g. Oracle, SAP, QuickBooks) into a flat Excel file Watch the rest of the training videos here: VIDEO 2: Format & extract data using Excel Formulas & Excel's Data Tools https://www.youtube.com/watch?v=9q4_QLr5VoA VIDEO 3: Consolidate Workbooks & Worksheets using Power Query https://www.youtube.com/watch?v=3EMACCDmsVU *** SPECIAL OFFER *** JOIN THE MYEXCELONLINE ACADEMY & GET 300+ EXCEL TUTORIALS FOR ONLY $1: https://www.myexcelonline.com/107-53.html Please share, like & leave your comments below. Thank You, JOHN MICHALOUDIS www.MyExcelOnline.com
Views: 22981 MyExcelOnline.com
How to save the output of a sql query in csv format?
 
01:39
In this video tutorial you will learn How to save the output of a sql query in csv format? Check sql query and program explanation at http://www.roseindia.net/sql/backup-file-separator.shtml Check more tutorials at: http://www.roseindia.net/ http://www.roseindia.net/java/ http://www.roseindia.net/hibernate/ http://www.roseindia.net/struts/ http://www.roseindia.net/spring/ http://www.roseindia.net/ajax/ http://www.roseindia.net/jsp/
Views: 9505 roseindiatutorials
What is OLAP?
 
05:05
This video explores some of OLAP's history, and where this solution might be applicable. We also look at situations where OLAP might not be a fit. Additionally, we investigate an alternative/complement called a Relational Dimensional Model. To Talk with a Specialist go to: http://www.intricity.com/intricity101/
Views: 372316 Intricity101
What is a Smart Query
 
06:50
The Smart Query is a feature of Hyperion Smart View used to create highly complex MDX queries. View this quick demo of the tool presented by HCG's certified Oracle Hyperion instructor. Want to see more? Stay tuned to this youtube channel and visit us at: www.harbinger-group.com for Oracle EPM & BI training, consulting, support and staffing.
Views: 5082 HCGUniversity
Buscar registros en tabla de Access desde Excel usando SQL Query, VBA y ADO @EXCELeINFO
 
22:03
✅ Descarga el archivo de ejemplo | http://www.exceleinfo.com/buscar-registros-en-tabla-de-access-desde-excel-usando-sql-query-vba-y-ado 🏆 Suscríbete a este canal | https://goo.gl/M5zNA8 En este tutorial voy a mostrarte una macro para buscar registros en una Tabla de Access, usando una consulta de tipo SQL. En nuestro tutorial anterior vimos cómo dar de Alta registros a una Tabla de Access. Ahora vamos a buscar esos registros que dimos de alta. Utilizaremos los mismo conceptos de ADO y Recordset. Microsoft ActiveX Data Objects (ADO) ADO es uno de los mecanismos que habilita a las aplicaciones cliente para conectarse a distintos orígenes de datos y acceder y manipular la información o los datos. La conexión de las aplicaciones hacia los orígenes de de datos se hace mediante proveedores OLEDB, que para nuestro tutorial usaremos un proveedor para conectarnos a una Base de datos de Access. Qué es un Recordset Es importante conocer el concepto de Recordset, ya que siempre que nos comunicamos con una Base de datos, sea Oracle, SQL, MySQL o Microsft Access, este concento siempre estará presente. Un Recordset es una estructura de datos que se usa para almacenar información en una Tabla de una Base de datos o lo que devuelve una consulta o Query. El término Recordset se una en infinidad de lenguajes de programación y prácticamente sirve para dar de alta registros, así como eliminar y actualizar los mismos. Formulario de búsqueda Tenemos un UserForm donde buscaremos la información almacenada en nuestra Base de datos de Access. La búsqueda se hará mediante una consulta SQL usando el comodín LIKE que nos buscará valores donde un texto se encuentre dentro de valores completos. En nuestro ejemplo buscaremos todas las filas donde los valores de la columna nombre contengan la letra “s”. Muchos ejemplos | http://www.exceleinfo.com Muchos ejemplos | http://blogs.itpro.es/exceleinfo Página de Facebook | https://www.facebook.com/EXCELeINFO Recibe notificaciones por Telegram | https://t.me/EXCELeINFO Twitter | @EXCELeINFO Twitter | @SergioACamposH Descargar EXCELeINFO addin: http://addin.exceleinfo.com
Excel 2013 Power BI Tools Part 2 - Getting Started with Power Query
 
16:39
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andy Brown https://www.wiseowl.co.uk - How to use Power Query within Excel 2013 to extract, transform and load data, including installing Power Query, creating and managing data transforms and choosing whether to load data into your worksheet, PowerPivot data model or both. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, PowerPivot, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, VBA macros, SQL and Microsoft Access.
Views: 17756 WiseOwlTutorials
SQL - Full course for beginners
 
04:20:39
In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics. Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more. 🔗Company Database Code: https://www.giraffeacademy.com/databases/sql/creating-company-database/ ⭐️ Contents ⭐ ⌨️ (0:00) Introduction ⌨️ (2:36) What is a Database? ⌨️ (23:10) Tables & Keys ⌨️ (43:31) SQL Basics ⌨️ (52:26) MySQL Windows Installation ⌨️ (1:01:59) MySQL Mac Installation ⌨️ (1:15:49) Creating Tables ⌨️ (1:31:05) Inserting Data ⌨️ (1:38:17) Constraints ⌨️ (1:48:11) Update & Delete ⌨️ (1:56:11) Basic Queries ⌨️ (2:08:37) Company Database Intro ⌨️ (2:14:05) Creating Company Database ⌨️ (2:30:27 ) More Basic Queries ⌨️ (2:26:24) Functions ⌨️ (2:45:13) Wildcards ⌨️ (2:53:53) Union ⌨️ (3:01:36) Joins ⌨️ (3:11:49) Nested Queries ⌨️ (3:21:52) On Delete ⌨️ (3:30:05) Triggers ⌨️ (3:42:12) ER Diagrams Intro ⌨️ (3:55:53) Designing an ER Diagram ⌨️ (4:08:34) Converting ER Diagrams to Schemas Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: https://www.youtube.com/channel/UCvmINlrza7JHB1zkIOuXEbw 🐦Follow Mike on Twitter: https://twitter.com/GiraffeAcademy 🔗The Giraffe Academy website: http://www.giraffeacademy.com/ -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://medium.freecodecamp.org And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
Views: 1165573 freeCodeCamp.org
What is Power Query? The best Power Query course ever created is here!
 
06:22
Lear more about the Power Query Academy: https://academy.powerquery.training/ https://academy.powerquery.training/ https://academy.powerquery.training/
Views: 1677 The Power User
QlikView - Connect and Query Data
 
03:28
Video 2 in multi-part series that will help you become more familiar with QlikView. This video covers connecting to a Microsoft SQL Server database and accessing its tables and columns to get data needed for analysis. Video 1 (Download and Install) can be found here: https://www.youtube.com/watch?v=aKQMhtQnaz0 and video 3 can be found here: http://www.youtube.com/watch?v=xwHNM18D9fE
Views: 78348 Qlik
Excel: How to Best Import External Data into Excel & Import data from the Web to Excel
 
11:16
Get the full course: https://courses.xelplus.com Excel has various tools that can help you easily clean up your raw data for further analysis. Apart from using formulas and formatting, there are two useful Excel features that let you easily clean up. One method is text to columns feature and the other to import external data. The Get External Data tool can be used to import and analyse data from other systems. This tool is also useful for importing data to run your dashboards or do further analysis using pivot tables, etc. Usually you can get data extracts from any system (e.g. “.dat” or “.csv” from Oracle, “.xml” files from SAP, etc.). These can be imported into Excel. Importing External Data also gives you control over the decimals and thousand separator, especially if you’re dealing with international companies. In the US, the decimal is dot and the comma is a thousand separator and in most European countries it’s the other way round, where the comma is a decimal and the dot a thousand separator. It’s always safest to Import it properly with the Excel Data Import wizard! After importing press Ctrl + T to create a table out of it. You can create a pivot table off this one, and when you do, even if you add more data to it, the pivot reflects the new data. Importing Data from the Web / Internet into Excel – creating web queries that refresh automatically: In Excel you can also import data directly from the web. You basically create a web query which you set to refresh automatically based on your preference. ★ My Online Excel Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Views: 123531 Leila Gharani
Import data from Excel to SQL Server table
 
02:25
Import data from Excel to SQL Server table My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 69908 SQL with Manoj
Copying Data With Column Headers in Oracle SQL Developer
 
00:52
How to copy data to the clipboard with the column headers or how to ONLY copy the column headers in Oracle SQL Developer
Views: 2826 Jeff Smith
Get External Data from Excel files Using Microsoft Query in Hindi
 
04:29
We can get external data from other Excel files using a microsoft query. Such import can help us create reports even from multiple Excel files. During the import we can filter, sort and manipulate the data in a variety of ways. The updating of data can also be automated during this process by saving the query, for example.
Views: 4654 Dinesh Kumar Takyar
How to write Custom SQL Query in Tableau?
 
02:15
Custom query is useful when you are using database connection and having complex queries.
Views: 18220 Ohio Computer Academy