Search results “Drop index oracle text mining”
SQL Server Indexes - Basics by Satya Ramesh (Recorded Webinar)
Please note that this is a recorded webinar. It was recorded during live presentation. In this session, we are going to cover the basics of Clustered Indexes & Non-Clustered Indexes. 1. How to create them and some best practices to follow. 2. What is a covering index and how is it useful. 3. What is fragmentation and how to defrag indexes 4. What is fill factor and how is is useful. This is going to be a level 100 session targeted towards Developers & DBAs beginning their careers with SQL Server. Webinar resources including presentation, demo files, code snippets and more learning material is available on http://www.dataplatformgeeks.com/ (Join for free and access all the resources) As a DPG member, you have free access to all our learning resources like videos, Hands-On-Labs & past event resources. Suggest us topics that you wish to learn through our webinars: http://www.dataplatformgeeks.com/dpg-... Connect with DataPlatformGeeks: http://www.dataplatformgeeks.com/ http://www.twitter.com/SQLServerGeeks https://www.facebook.com/SQLServerGeeks Email us: [email protected] Have technical questions? Join the largest SQL/Data group on FaceBook – https://www.facebook.com/groups/thesq... LinkedIn Group: https://www.linkedin.com/groups/6753546 DataPlatformGeeks (DPG) Community Join the fastest growing community of data & analytics professionals Why Join DPG? http://www.dataplatformgeeks.com/ -Attend all events hosted by DPG, including SQLMaestros Special Events -Get access to free videos, labs, magazines and host of learning resources -Download all events & conference material -Learn new skills. Sharpen existing skills -Be part of Asia’s Largest Data/Analytics Community -Opportunity to be a regional mentor & speaker at our events -Immense technical & professional development -http://www.dataplatformgeeks.com/ Do you know about Data Platform Summit (DPS)? Learn about the largest Data/Analytics Learning Event in Asia. http://www.DPS10.com | [email protected] A word from our sponsors SQLMaestros Hands-On-Labs Want to practice SQL, Azure & BI concepts, step-by-step with exercises, screenshots, instructions & explanations? Get access to 100+ labs covering the entire Microsoft Data Platform stack. Try SQLMaestros Hands-On-Labs – the new way of practical, self-paced learning. Anytime. Anywhere. http://hols.SQLMaestros.com Email [email protected] SQLMaestros Video Courses http://sqlmaestros.com/sql-server-vid... SQLMaestros Master Classes & Accelerators http://sqlmaestros.com/ SQL Health Check http://sqlmaestros.com/ Advanced SQL Training (On-site) Want your team to experience Amit Bansal's Advanced SQL Training? http://www.SQLMaestros.com Email [email protected] Corporate Training Looking for any other high-end technology training for your team? http://www.PeoplewareIndia.com Email [email protected] Connect with the founder of DataPlatformGeeks/SQLServerGeeks Follow on Twitter: https://twitter.com/A_Bansal Follow on FaceBook at http://www.facebook.com/amit.r.bansal Follow on LinkedIN: http://www.linkedin.com/in/amitbansal... Facebook Page: https://www.facebook.com/AmitRSBansal/
Oracle SQL Tutorial 23 - Intro to Data Types
Every column within a table has to be given what is known as a datatype. A data type is a fairly simple concept when you dissect the word. It is literally the type of data. Why do we use types, though? The biggest benefit is so that Oracle knows how to interpret and work with our data. It also makes the database better at rejecting incorrect data. If we had to concept of a data type, there would be a lot more work involved in forcing data to be of the right format. It would also be harder for us to get the database to treat the data in the correct way. In addition to this, a database can optimize storage and performance for a column if everything is of the same data type. Because of this, each column can only support one data type. There are numerous different data types in Oracle and it helps us if we categorize them. The first types of datatypes we should learn about are: String, Numeric, Temporal Now, there are few more categories we could make, but these are the main ones. We will worry about the other ones another day as I am only introducing the topic. A string data type is anything within quotes. Most databases use single quotes for string data. Inside of the quotes can be any number of characters. What is a character? Think of any letter, number, or symbol you can type. Some people call these letters, numbers, and symbols alphanumeric. Numeric data type includes only numbers. These data types are often used for data that you plan on using for mathematical calculations. Temporal data types are data types that are used for dates and times. Now, each data type is probably going to have some options you'll need to worry about, but one that comes up with every data type is storage. The reason we need to consider storage is because we may end up with millions of rows in a table and the difference between a few bytes for each row will make a huge difference when we look at the whole picture. When a data type gives you the option of size, you will want to a size that will be able to hold what you need, but nothing more. In the upcoming videos we are going to discuss the available data types in more detail. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 6960 Caleb Curry
SQL Tutorial - Clustered Indexes OLTP
Another video brought to you by BeardedDev, bringing you tutorials on Business Intelligence, SQL Programming and Data Analysis. You can now support me on patreon - https://www.patreon.com/beardeddev In this video tutorial we talk all about Clustered Indexes in SQL Server. Indexes allow data to be retrieved quickly but we have to respect a proper indexing strategy as too many indexes can cause DML operations to be come slow. Working with indexes is all about finding the balance between read and write operations on the database. Code featured in the video to allow you to follow along: -- Add Table IF OBJECT_ID(N'dbo.Employees', N'U') IS NOT NULL DROP TABLE dbo.Employees; CREATE TABLE dbo.Employees ( EmployeeId INT IDENTITY(1, 1) NOT NULL , EmployeeFirstName VARCHAR(50) NOT NULL , EmployeeLastName VARCHAR(50) NOT NULL , EmployeeDateOfBirth DATE NOT NULL , EmployeePosition VARCHAR(50) NOT NULL , EmployeeStartDate DATE NOT NULL CONSTRAINT DF_EmployeesNew_EmployeeStartDate DEFAULT (GETDATE()) , EmployeeEndDate DATE NULL , EmployeePayrollId INT NOT NULL ); -- Add Data INSERT INTO dbo.Employees (EmployeeFirstName, EmployeeLastName, EmployeeDateOfBirth, EmployeePosition, EmployeeStartDate, EmployeeEndDate, EmployeePayrollId) VALUES ('Tony', 'Smith', '19860415', 'Sales Executive', '20180101', NULL, 123456) , ('Robin', 'Jones', '19860415', 'Sales Manager', '20180101', NULL, 123457) , ('Michelle', 'Parker', '19860415', 'Sales Executive', '20180101', NULL, 123458) , ('Alex', 'Weaver', '19860415', 'Sales Executive', '20180101', NULL, 123459) , ('Paul', 'Attenborough', '19860415', 'Sales Assistant', '20180101', NULL, 123460) -- Retrieve Data SELECT * FROM dbo.Employees WHERE EmployeeId = 3; -- ADD CLUSTERED INDEX TO EXISTING TABLE ALTER TABLE dbo.Employees ADD CONSTRAINT PK_Employee_EmployeeID PRIMARY KEY (EmployeeId); -- DOES THE TABLE HAVE AN INDEX? SELECT name , syspart.index_id FROM sys.tables AS systab INNER JOIN sys.partitions AS syspart ON systab.[object_id] = syspart.[object_id] WHERE systab.name = 'Employees'; -- WHAT TYPE OF INDEX? SELECT name , [type] , type_desc FROM sys.indexes WHERE name = 'PK_Employees_EmployeeId'
Views: 47 BeardedDev
Create Report in Seconds by Fetching Data from SQL Server using Excel VBA
Create Report in Seconds by Fetching Data from SQL Server using Excel VBA If your manager needs the report very frequently then you need to do the same task again and again. Frankly speaking, I faced this kind of situation in my previous company and I prepared the report using VBA and handed over the file to my manager. Now, whenever he will click the button he will get the report of the LIVE DATA from SQL to Excel. You can read our blog to go through instructions as well as download working and code files, Click here: http://yodalearning.com/tutorials/export-data-from-sql-to-excel-spreadsheet-using-vba/ You can enroll in our Excel VBA course: http://courses.yodalearning.com/p/excel-vba-tutorials CHECK SOME OF THE FREE COURSES WE OFFER http://courses.yodalearning.com/p/free-office-2016-tips Keep yourself updated. Follow us now! http://www.facebook.com/yodalearning http://www.twitter.com/yodalearning
Views: 83495 Excel Yoda learning
Excel for HR: Use Data Validation and Auto-correction to Control Text Input Format
***HR Analytics with Excel*** Business Scenario: You want to control the content/format for your datasheet so that user can input faster and more accurately Excel Function: Data Validation, Auto-correction Time for Formula: Data validation 3:20, Auto-corretion 5:00 -~-~~-~~~-~~-~- Please watch: "How to create a Merit Matrix for Salary Increase with Goal Seek function" https://www.youtube.com/watch?v=6ZRixDI8Zws -~-~~-~~~-~~-~-
What are Junk dimensions?
A Junk Dimension is a dimension table consisting of attributes that do not belong in the fact table or in any of the existing dimension tables. The nature of these attributes is usually text or various flags, e.g. non-generic comments or just simple yes/no or true/false indicators. The have low cardinality and usually don't come under SCD. If you require any clarifications for this video, Please drop me a comment and I will try to answer asap.
Views: 2283 Tech Coach
Part 4   Delete duplicate rows in sql
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-4-delete-duplicate-rows-in-sql.html In this video, we will discuss deleting all duplicate rows except one from a sql server table. SQL Script to create Employees table Create table Employees ( ID int, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) The delete query should delete all duplicate rows except one. Here is the SQL query that does the job. PARTITION BY divides the query result set into partitions. WITH EmployeesCTE AS ( SELECT *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber FROM Employees ) DELETE FROM EmployeesCTE WHERE RowNumber ] 1
Views: 322327 kudvenkat
Creating a database, table, and inserting - SQLite3 with Python 3 part 1
Welcome to an SQLite mini-series! SQLite, as the name suggests, is a lite version of an SQL database. SQLite3 comes as a part of the Python 3 standard library. Databases offer, typically, a superior method of high-volume data input and output over a typical file such as a text file. SQLite is a "light" version that works based on SQL syntax. SQL is a programming language in itself, but is a very popular database language. Many websites use MySQL, for example. SQLite truly shines because it is extremely lightweight. Setting up an SQLite database is nearly instant, there is no server to set up, no users to define, and no permissions to concern yourself with. For this reason, it is often used as a developmental and protyping database, but it can and is used in production. The main issue with SQLite is that it winds up being much like any other flat-file, so high volume input/output, especially with simultaneous queries, can be problematic and slow. You may then ask, what really is the difference between a typical file and sqlite. First, SQLite will let you structure your data as a database, which can easily be queried, so you get that functionality both with adding new content and calling upon it later. Each table would likely need its own file if you were doing plain files, and SQLite is all in one. SQLite is also going to be buffering your data. A flat file will require a full load before you can start querying the full dataset, SQLite files don't work that way. Finally, edits do not require the entire file to be re-saved, it's just that part of the file. This improves performance significantly. Alright great, let's dive into some SQLite. https://pythonprogramming.net/sql-database-python-part-1-inserting-database/ Playlist: https://www.youtube.com/playlist?list=PLQVvvaa0QuDezJh0sC5CqXLKZTSKU1YNo https://pythonprogramming.net https://twitter.com/sentdex https://www.facebook.com/pythonprogramming.net/ https://plus.google.com/+sentdex
Views: 212298 sentdex
Customize LOGIN PAGE Using css! Oracle Apex
Customize LOGIN PAGE Using css! Oracle Apex CSS Inline Code: -------------------------- body{font-family: 'Droid Arabic Kufi', sans-serif; font-size:1.3rem;} .t-PageBody--login .t-Body { background-image: url(#WORKSPACE_IMAGES#BG.jpeg); background-position: center center; background-repeat: no-repeat; background-attachment: fixed; background-size: cover; background-color: #45484d; background-color: -moz-linear-gradient(top, #45484d 0%, #000000 100%); background-color: -webkit-linear-gradient(top, #45484d 0%,#000000 100%); background-color: linear-gradient(to bottom, #45484d 0%,#000000 100%); } body .t-Login-title , .t-Login-region { background-color: rgba(128, 152, 180, 0.51); color: #F8F8F8 } .t-Login-body { text-align: right; } .popup { z-index: 10; margin:100px auto; display:block; text-align:center; -moz-box-shadow: 0 0 10px rgba(0,0,0,.18); /* drop shadow */ -webkit-box-shadow: 0 0 10px rgba(0,0,0,.18); /* drop shadow */ -o-box-shadow: 0 0 10px rgba(0,0,0,.18); /* drop shadow */ box-shadow: 0 0 10px rgba(0,0,0,.18); /* drop shadow */ -webkit-transform-origin:top center; -moz-transform-origin:top center; -o-transform-origin:top center; transform-origin:top center; -webkit-animation: iconosani 1.2s forwards; animation: iconosani 1.2s forwards; -moz-animation: iconosani 1.2s forwards; -o-animation: iconosani 1.2s forwards; } .apex-icons-fontawesome .t-Login-logo{ font-size: 50px; color: #fff; } #P101_PASSWORD , #P101_USERNAME { background-color: #0e0d0d00; color: #292929; font-size: 1.5em; border-bottom-color: #0464a9; border-width: 0 0 3px 0; }
Views: 3153 Hesham Abu Elenain
Oracle TEXT und APEX Teil II: Dokumente indizieren und Anwendung erstellen
Dieses Video zeigt, wie man Dokumente in einer Oracle-Tabelle mit Oracle TEXT indiziert und anschließend mit Application Express eine Suchanwendung bereitstellt.
Views: 2285 oracledbtv
Excel Magic Trick 1335: Power Query We Couldn’t Refresh The Connection Data Source Not Found Error
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: 12960 ExcelIsFun
Key NewTransformations in Oracle Big Data Discovery version 1.1
This video covers the key new data transformations available in Oracle Big Data Discovery version 1.1. This video is intended for data analysts or anyone wanting to learn how to perform the key new data transformations available in Big Data Discovery version 1.1.
Basic Excel Business Analytics #42: Comprehensive PowerPivot, Data Model, DAX & Reporting Example
Download file from “Highline BI 348 Class” section: https://people.highline.edu/mgirvin/excelisfun.htm Learn about PowerPivot: Import Big Data, Build Data Model, Create Reports: 1) (00:04) Info about files for project 2) (00:20) Intro to Video and look at end result reports 3) (01:56) Overview of steps in building a Data Model in PowerPivot 4) (03:03) Look at source data files including text files with 5 million rows of records 5) (04:46) From Text Files, use Power Query to import 5 million rows of transactional sales data into the a Fact Table in the Data Model in PowerPivot 6) (09:48) From Excel file, use Power Query to import Product Retail and Standard Cost Dimension Table into the Data Model in PowerPivot 7) (10:52) Build Calendar Dimension Table in Excel and then use Power Query to import into the Data Model in PowerPivot 8) (13:44) From web get ISO 3166-1 County Code Data to build and then use Power Query to import Country Code Dimension Table into the Data Model in PowerPivot 9) (17:50) Build One-to-Many Relationships between Fact Table and Dimension Tables 10) (20:16) Build DAX Calculated Column for Net Revenue for each transaction. See the DAX functions: RELATED (Like VLOOKUP in Excel) and ROUND. 11) (22:30) Build DAX Measure (Calculated Field) for Total Net Revenue (Overall Total Net Revenue for entire Fact table). See the DAX function: SUM. 12) (24:16) Build PivotTable to see that the relationships are working and that we can pull fields from Dimension Tables and Fact Tables. 13) (24:16) Build PivotTable Report to show Net Revenue for each Country. 14) (25:33) “Trouble Shooting” Part of Example: Tracking Down Error between web site data and company data, including finding error and updating Country Code Excel Table and refreshing the linked table in the Data Model so that the PivotTable report updates and has correct results. 15) (30:35) Hide Fields from Field Lists using “Hide From Client Tools” 16) (31:59) Build PivotTable to see that with a Data Model PivotTable you can NOT group Dates 17) (33:20) Create DAX Calculated Column for Month Number and Month Name. See the DAX functions: MONTH and FORMAT (Like TEXT in Excel). 18) (35:20) Build PivotTable to see that Month Name does NOT sort correctly in a Data Model PivotTable. 19) (35:52) Learn how to Sort Month Name column by Month Number so that Month Name sorts correctly in a data Model PivotTable 20) (36:36) Build relationship between Calendar Table and Fact Table 21) (36:36) Build PivotTable Report to show Net Revenue by Month 22) (37:33) Create DAX Calculated Column for Year. See the DAX function: YEAR. 23) (38:02) Build PivotTable Report to show Net Revenue by Month & Year 24) (39:10) Build DAX Calculated Column for COGS for each transaction. See the DAX functions: RELATED (Like VLOOKUP in Excel) and ROUND. 25) (40:55) Build DAX Measure (Calculated Field) for Total COGS (Overall Total COGS for entire Fact table). See the DAX function: SUM. 26) (41:29) Build DAX Measure (Calculated Field) for Gross Profit using Measures (Calculated Fields) in our DAX formula. 27) (42:21) Build PivotTable Report to show Net Revenue, COGS and Gross Profit for each Year and Month. 28) (44:04) Build PivotTable Report to show Percentage Change for Net Revenue over Same Period Last Year. 29) (45:00) Build DAX Measure (Calculated Field) for Percentage Change over Same Period Last Year using the DAX functions: CALCULATE, SAMEPERIODLASTYEAR and IF. 30) (52:22) Build PivotTable Report to show Percentage of Grand Total for Each Product. Concept behind the formula. 31) (54:11) Build DAX Measure (Calculated Field) for Percentage of Grand Total using the DAX functions: CALCULATE and ALL. 32) (56:45) Refresh Reports when source data changes. In our example we bring 7 million rows into the Excel PowerPivot Data Model. 33) (57:48) Update Calendar table 34) (59:34) Summary and Conclusion. Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video. More about CALCULATE function: https://www.youtube.com/watch?v=kMMohkVk8Ds PowerPivot Playlist: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nGCx21PRFbsJpUIH06LKs-
Views: 36881 ExcelIsFun
Creating Basic Ad Hoc Reports in Smart View
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: 50642 Oracle EPM Tutorials
Firebase Database Querying 101 - The Firebase Database For SQL Developers #3
Learn more about qureying in the official documentation: https://goo.gl/iLDAvS Welcome to the third video in the Firebase Database for SQL Developers series! Querying may be less powerful in NoSQL databases than compared to SQL databases, but there's still a lot you can do with the Firebase Database. Watch more videos from this series: https://goo.gl/ZDcO0a Subscribe to the Firebase Channel: https://goo.gl/9giPHG
Views: 92607 Firebase
Creating a PHP Search
This is a tutorial which goes over how to create a PHP search which filters out results from a database table. Sorry for the mistakes made in this video, the video following this goes over how to take this and make it instant with jQuery Tutor Facebook: http://www.facebook.com/JoeTheTutor Dibbble: www.dribbble.com/sleekode www.helpingdevelop.com
Views: 441103 Joseph Smith
Chapter 19 View in Sql Server in Hindi
SQL CREATE VIEW Statement. In SQL, a view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database. Why do we use views in SQL? SQL - Using Views. A view is nothing more than a SQL statement that is stored in the database with an associated name. ... A view can contain all rows of a table or select rows from a table. A view can be created from one or many tables which depends on the written SQL query to create a view. What do you mean by view in SQL? A database view is a searchable object in a database that is defined by a query. Though a view doesn't store data, some refer to a views as “virtual tables,” you canquery a view like you can a table. A view can combine data from two or more table, using joins, and also just contain a subset of information. What are views used for? Views can be used as security mechanisms by letting users access data through the view, without granting the users permissions to directly access the underlying base tables of the view. Views can be used to provide a backward compatible interface to emulate a table that used to exist but whose schema has changed.
Views: 510 Learn Everything
Check out http://www.pgconf.us/2015/event/97/ for the full talk details. In this talk I'm going to touch different techniques and tools for managing changes inside PostgreSQL databases, including schema deployments, data changes and usage of stored procedures as a versioned API layer. Based on my experience of no-downtime deployments at Zalando SE, one of the biggest European fashion retailers, I'm going to highlight different approaches to database deployments and introduce some open-source tools used and developed by the Database Team at Zalando. About the Speaker Alexey started with PostgreSQL at 2003 as a C programmer. He learned how to debug the backend code before learning SQL, but caught up on the latter pretty quickly. He is now using both of those skills and years of experience as a database consultant to help his employer manage a growing number of PostgreSQL database clusters and deal with hundreds of database changes during weekly deployments. A native of Simferopol, Ukraine, he lives in Berlin and works as a Database Engineer at Zalando SE. Over the years, he contributed code and documentation to the PostgreSQL project.
Views: 259 Postgres Conference
MDX Query Basics (Analysis Services 2012)
This video is part of LearnItFirst's SQL Server 2012: A Comprehensive Introduction course. More information on this video and course is available here: http://www.learnitfirst.com/Course170 In this video, we walk through the basics of the MDX Query language. It is a very logical language, however, is somewhat large in syntax. If you enjoy writing Transact-SQL, you will really enjoy the MDX language. The AdventureWorks2012 multidimensional models need to be installed on your SSAS Multidimensional mode instance from the CodePlex web site. Highlights from this video: - The basics of an MDX query - What is the basic format of the MDX query language? - Is it necessary to have a WHERE clause in an MDX query? - How to signal the end of a statement in the MDX query language - Using the Internet Order Count and much more...
Views: 101536 LearnItFirst.com
Open a pcap File in Wireshark with Workbench
This short tutorial shows how the drag and drop capabilities of Workbench can be used to open a pcap/pcap-ng file.
Views: 1023 TribeLab
Connecting SQL Tables and data in Excel spreadsheets
For more videos on technology, visit http://www.Techytube.com By [email protected] SQL server is a powerful database platform, this means that it can also be complex to understand and work with. However the major users of the data in the database are still a non-technical business user. A key problem that most business users face when it comes to working with SQL Server is the dependency on an IT professional to query and return the data in a CSV format or Excel sheet. With the ability of MS Excel to be able to connect to SQL Server via the ODBC Drivers allows users to work with SQL tables within the familiar Excel User interface. This approach allows users to be productive with SQL Server without having to know Transact SQL. The feature set provided with MS Excel and newer versions of SQL allow business users to do much more than just query the database. These include the ability to query and view data in pivot format for large data sets using power pivot. Perform ad hoc calculations to underlying data and create models that are specific to their business case using the powerful DAX language. Embedding reports in SharePoint services using PowerPivot. Working with Excel is one of the most powerful ways that end users can work with MS SQL Server to deliver results faster and improve productivity.
Views: 189391 techytube
Tableau Dynamic Filters Using Parameters | Tableau Parameters
For complete professional training visit at: http://www.bisptrainings.com/course/Tableau-Data-Discovery Follow us on Facebook: https://www.facebook.com/bisptrainings/ Follow us on Twitter: https://twitter.com/bisptrainings Email: [email protected] Call us: +91 975-275-3753 or +1 386-279-6856
Views: 18429 Amit Sharma
Advanced lookup in Excel and its application in Data Analytics
Here is a webinar on Excel Advanced LOOK UP and its application in Data Analytics. Who can benefit? • One who has basic knowledge of MS-EXCEL • Analytics professionals who want to handle large volume of data using V-LOOK-UP • Any analytics aspirant or professional who works with large amount of data and wants to extract data from the same sheet, or from different sheet of the same work book or from different workbooks. Topics to be covered in this webinar: • Quick overview of V-LOOK-UP • 2 Column LOOK UP • Multiple sheets LOOK-UP • Multiple extractions using V-LOOK-UP STAY UPDATED: To get alerts about our future webinars and analytics events, please 'Like' our Facebook page www.facebook.com/ivyproschool or drop an email to [email protected] You can view our past webinars by subscribing to our YouTube channel: www.youtube.com/ivyproschool.
Views: 844 IvyProSchool
Indexes Table Filter SQL Command window - Hindi
Indexes, Table Filter, SQL Command window
How Facebook tracks and manipulates everyone, everything, and everywhere - Delete your Facebook now
Facebook tracks you online and offline, creating profile for targeted advertisements. Facebook knows what you buy and what sites you visit. Do you know where Facebook sells your private information? They have so much they can turn masses against their own government or manipulate people's emotions by tweaking their social media feeds. The cost of letting somebody know everything about you is just too high. You should stop using Facebook. My bitcoin address: 1NmqcqYRZVmbCWweaREigX6qZVdtGND6Mx Follow me: https://twitter.com/The_HatedOne_ https://www.bitchute.com/TheHatedOne/ https://www.reddit.com/user/The_HatedOne/ https://www.minds.com/The_HatedOne Facebook tracks you online and offline | Facebook privacy policy It's known that Facebook collects and sells all of your personal information on their social network for their Facebook ads.Facebook tracks your online and offline activities everywhere you go. With newly introduced Facebook IDs, Facebook will recording your browsing history through social media plugins and like and share buttons on websites, and use Facebook mobile apps to track your offline activities, physical location, and telemetric data. Stop using Facebook | Facebook sells your information Facebook privacy issue is a severe threat to our current democracy. Facebook stands behind big data broking marketing industry that collects your personally identifiable information, creates a personalized profile on you, and sell that information to retailers and governments around the world. There is no privacy protection. It's not explained in the Facebook privacy policy. You have no idea to know where Facebook sells your private information Facebook targeted advertisements | Facebook privacy Acxiom collects Facebook data and matches them with your personally identifiable information. The goal is to sell customer recognition to its retail clients. Will you stop using Facebook? Sources: Facebook Atlas ad platform https://www.nytimes.com/2014/09/29/business/with-new-ad-platform-facebook-opens-the-gates-to-its-vault-of-consumer-data.html https://atlassolutions.com/2014/09/29/meet-the-new-atlas/ https://atlassolutions.com/product-tour/ https://atlassolutions.com/partners/ https://atlassolutions.com/why-atlas/introduction/ Facebook privacy policy https://www.forbes.com/sites/anthonykosner/2013/08/31/new-facebook-policies-sell-your-face-and-whatever-it-infers/#2bb368f0273a Facebook ads sharing your personally identifiable data http://edition.cnn.com/2010/TECH/social.media/10/21/facebook.gay.ads/index.html Facebook apps collecting and selling personal information https://arstechnica.com/tech-policy/2010/10/many-faceook-apps-found-to-be-collecting-selling-user-info/ Facebook tracking through social like and share buttons and plug-ins https://securehomes.esat.kuleuven.be/~gacar/fb_tracking/fb_plugins.pdf From social media service to advertising network. A critical analysis of Facebook’s Revised Policies and Terms http://www.law.kuleuven.be/citip/en/news/item/facebooks-revised-policies-and-terms-v1-2.pdf Acxiom data broker http://www.nytimes.com/2013/09/05/technology/acxiom-lets-consumers-see-data-it-collects.html Acxiom Audience Operating System https://adexchanger.com/analytics/acxiom-prepares-new-audience-operating-system-amid-wobbly-earnings/ Acxiom customer recognition and 360 degree view on consumers http://www.nytimes.com/2012/06/17/technology/acxiom-the-quiet-giant-of-consumer-database-marketing.html?pagewanted=all FTC seeks privacy regulations and Acxiom is aware http://www.nytimes.com/2012/03/27/business/ftc-seeks-privacy-legislation.html?pagewanted=all https://www.nytimes.com/2014/05/28/technology/ftc-urges-legislation-to-shed-more-light-on-data-collection.html FTC report on data broking marketing industry https://www.ftc.gov/system/files/documents/reports/data-brokers-call-transparency-accountability-report-federal-trade-commission-may-2014/140527databrokerreport.pdf Epsilon security breach http://www.nytimes.com/2011/04/05/business/05hack.html?_r=1 Surveillance economy http://www.nytimes.com/2012/12/09/business/company-envisions-vaults-for-personal-data.html Ranking of consumer according to their monetization opportunity http://www.nytimes.com/2012/08/19/business/electronic-scores-rank-consumers-by-potential-value.html Advertising is NOT anonymous Stanford research http://cyberlaw.stanford.edu/blog/2011/10/tracking-trackers-where-everybody-knows-your-username http://www.centerfordigitaldemocracy.org/sites/default/files/20100407-FTCfiling.pdf Do not call law http://donotcallus.net/federal-laws.asp Credits: Shadowlands 1, Dark Frog, Satiate, Stormfront, Bicycle by Kevin MacLeod (incompetech.com) Licensed under Creative Commons: By Attribution 3.0 License http://creativecommons.org/licenses/by/3.0/
Views: 11532 The Hated One
Excel and DataTables Automation 3.3
Learn how UiPath operates with Excel and Data Tables: - Excel application scope - Opening a workbook - access modes - Read and write range - Output datatable Watch a practical example of how to sort data in an Excel file and iterate through all rows.
Views: 181976 UiPath
SAP HANA Academy - Lumira: Exploring in the Cloud
In this series of videos, Tahir Hussain Babar examines using SAP Lumira Desktop and SAP Lumira Cloud. In this video, we walk through exploring your data in the Cloud with SAP Lumira. Uploading files: Bob wants to store objects in SAP Lumira Cloud and shows how to do so in 2 steps. 1. First Bob goes to cloud.saplumira.com and logs into his free personal SAP Lumira Cloud account. 2. Bob clicks on upload, then browse, and then chooses the file that he wants to upload before clicking on open and then ok. A user can upload Storyboards, Datasets, SAP Lumira files, CSVs, Local Spreadsheets, Powerpoints, SAP Crystal Reports or Design Studio files to SAP Lumira Cloud and can filter their objects using the narrow by feature on the toolbar. Creating Datasets: Bob wants to create a dataset in SAP Lumira and shows how to in 5 steps. 1. Bob clicks on the create dataset button and the selects the browse button. 2. After selecting a CSV file (can also use Excel files) Bob clicks ok. 3. Next, Bob clicks on the data acquisitions options and chooses his sheet and if he wants to set the first column as the column header. 4. Then, Bob clicks on the wrench on the left to enrich his data. A data set must have at least one measure and one attribute. Bob has three measures and no attributes so he clicks on one of his measures and chooses to convert it to an attribute. Users can also change their measures from a sum to a min, max, or count and can change the name of the measures and attributes. 5. Bob then names his dataset and clicks on the acquire button. Exploring Data: Bob details how to explore datasets and create visualizations in in SAP Lumira Cloud. Bob clicks on the wheel to the right of a data set and selects explore. Bob receives a prompt that he has too many data points to visualize. To resolve this, Bob drags his current attribute in the X Axis & Values box out and clicks on the plus sign to replace it with a new attribute. Bob shows how users can create visualizations by dragging and dropping measures and attributes from the left onto the canvas in the middle and then choosing different visualizations options from the list on the right. For the geographic chart a user must use latitude and longitude. Bob then shows how users can modify their visualizations by using the analyze tab. A user can add a trellis and change the type, data points, mode, color, size, animation an/or shading of different attributes and measures in their visualization. Bob clicks on the save button at the top right and names his visualization to save it. Clicking on the share button creates a unique URL for the visualization that users can email to their colleagues.
Views: 2612 SAP HANA Academy
Expert Analytics - Change the data type of a column: SAP Predictive Analytics 2.0
In the Expert Analytics interface of SAP Predictive Analytics, you can change the data type of columns in the Prepare room or in the Predict room. In this tutorial, we will use both methods to convert a date column that is formatted as a string into a proper date format for analysis.
Lecture - 5 Structured Query Language
Lecture Series on Database Management System by Dr.S.Srinath, IIIT Bangalore. For more details on NPTEL visit http://nptel.iitm.ac.in
Views: 123798 nptelhrd
Excel Magic Trick 1249: Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail
Download File: https://people.highline.edu/mgirvin/excelisfun.htm **Note; The word "Database" is used loosely in this video. We use it just to mean we have a dynamic table to store raw data. Overview of video: 1) Build Invoice Database with Excel 2016 Table feature 2) Learn how Excel Table feature automatically carries formatting and formulas to new records 3) Learn how to use Table Formula Nomenclature / Structured References for Excel Table formulas 4) Learn about Dynamic Ranges with Excel Table feature 5) VLOOKUP and MATCH functions to lookup Invoice Details Full Detailed list of what is in video including time hyperlinks: 1) (00:11) Look at finished database and VLOOKUP formula to understand what the goal of the video is. 2) (02:00) Database must be a Proper Data Set: 1) Field Names in First Row, 2) Records in subsequent Rows, 3) Empty Cells or Excel Column/Row Headers Around Data Set 3) (03:07) Add Bold Format to Field Names / Column Headers so database interprets headers correctly 4) (04:42) Custom Date Format to Date Field. This is carried forward to new records in Excel Table Database. 5) (05:58) Add word wrap to Product Description. This is carried forward to new records in Excel Table Database. 6) (06:05) Add Number Formatting: Currency and Percentage to number fields. This is carried forward to new records in Excel Table Database. 7) (06:58) Add formula for Amount owed after discount, tax rate and shipping. See the ROUND function. This is carried forward to new records in Excel Table Database. 8) (10:05) Convert Proper Data Set to Excel Table with Ctrl + T. Excel Table feature is Excel’s Database feature. 9) (11:32) Add new column to database for Balance Due. Learn about Table Formula Nomenclature / Structured References for Excel Table formulas. 10) (11:53) Name the Table. 11) (14:30) Add new records to test database. 12) (16:39) Add Proper Field names using Table Formula Nomenclature / Structured References for Excel Table formulas in the lookup area. Learn about relative references in Table Formula Nomenclature / Structured References for Excel Table formulas. 13) (18:50) Add Data Validation Drop Down List for invoice lookup. 14) (19:44) Create VLOOKUP and MATCH Lookup formula to lookup Invoice Detail. Learn about how to lock (absolute) references in Table Formula Nomenclature / Structured References for Excel Table formulas. 15) (24:46) Test database and lookup formulas. 16) (25:21) Summary and Conclusion For more videos about The Excel Table feature and Table Formula Nomenclature (Structured References): https://www.youtube.com/playlist?list=PLrRPvpgDmw0kmoAhXamTJw6XkebJ6gCxg
Views: 91377 ExcelIsFun
Red Dead Redemption 2 o'clock Hands-on Special - We've played it!
We've been hands-on with Red Dead Redemption 2! In this special episode we tell you everything you played and saw in our extensive time with the game. Subscribe to GR+ here: http://goo.gl/cnjsn1 Red Dead Redemption 2 o'clock is the is the world's most in-depth - and best connected - Red Dead 2 show.
Views: 419173 GamesRadar
Nielsen Connected System and Snowflake: Enabling modern data analytics in retail - BRK2428
Hear Nielsen Buy CTO, Srini Varadarajan and Snowflake CEO, Bob Muglia share how Nielsen’s Connected System, powered by Snowflake's cloud-built data warehouse on Microsoft Azure, empowers FMCG manufacturers and retail companies connect Nielsen data and insights directly into their enterprise to achieve sustained, profitable growth. Take a deep dive into how Snowflake's unique architecture enables Connected System to seamlessly integrate large volumes of global, retail, point-of-sale data that enable manufacturers and retailers to democratize data across the business, spot performance gaps, and act on new growth opportunities.
Views: 138 Microsoft Ignite
Excel Demonstration - CI From Data Analysis Tool Pak
Excel Demonstration - CI From Data Analysis Tool Pak
Views: 268 Jim Vernon
Apache Hadoop Tutorial | Hadoop Tutorial For Beginners | Big Data Hadoop | Hadoop Training | Edureka
** Flat 20% Off (Use Code: YOUTUBE20) Hadoop Training: https://www.edureka.co/hadoop ** This Edureka "Hadoop tutorial For Beginners" ( Hadoop Blog series: https://goo.gl/LFesy8 ) will help you to understand the problem with traditional system while processing Big Data and how Hadoop solves it. This tutorial will provide you a comprehensive idea about HDFS and YARN along with their architecture that has been explained in a very simple manner using examples and practical demonstration. At the end, you will get to know how to analyze Olympic data set using Hadoop and gain useful insights. Below are the topics covered in this tutorial: 1. Big Data Growth Drivers 2. What is Big Data? 3. Hadoop Introduction 4. Hadoop Master/Slave Architecture 5. Hadoop Core Components 6. HDFS Data Blocks 7. HDFS Read/Write Mechanism 8. What is MapReduce 9. MapReduce Program 10. MapReduce Job Workflow 11. Hadoop Ecosystem 12. Hadoop Use Case: Analyzing Olympic Dataset Subscribe to our channel to get video updates. Hit the subscribe button above. Check our complete Hadoop playlist here: https://goo.gl/ExJdZs Facebook: https://www.facebook.com/edurekaIN/ Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka #Hadoop #Hadooptutorial #HadoopTutorialForBeginners #HadoopArchitecture #LearnHadoop #HadoopTraining #HadoopCertification How it Works? 1. This is a 5 Week Instructor led Online Course, 40 hours of assignment and 30 hours of project work 2. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course. 3. At the end of the training you will have to undergo a 2-hour LIVE Practical Exam based on which we will provide you a Grade and a Verifiable Certificate! - - - - - - - - - - - - - - About the Course Edureka’s Big Data and Hadoop online training is designed to help you become a top Hadoop developer. During this course, our expert Hadoop instructors will help you: 1. Master the concepts of HDFS and MapReduce framework 2. Understand Hadoop 2.x Architecture 3. Setup Hadoop Cluster and write Complex MapReduce programs 4. Learn data loading techniques using Sqoop and Flume 5. Perform data analytics using Pig, Hive and YARN 6. Implement HBase and MapReduce integration 7. Implement Advanced Usage and Indexing 8. Schedule jobs using Oozie 9. Implement best practices for Hadoop development 10. Work on a real life Project on Big Data Analytics 11. Understand Spark and its Ecosystem 12. Learn how to work in RDD in Spark - - - - - - - - - - - - - - Who should go for this course? If you belong to any of the following groups, knowledge of Big Data and Hadoop is crucial for you if you want to progress in your career: 1. Analytics professionals 2. BI /ETL/DW professionals 3. Project managers 4. Testing professionals 5. Mainframe professionals 6. Software developers and architects 7. Recent graduates passionate about building successful career in Big Data - - - - - - - - - - - - - - Why Learn Hadoop? Big Data! A Worldwide Problem? According to Wikipedia, "Big data is collection of data sets so large and complex that it becomes difficult to process using on-hand database management tools or traditional data processing applications." In simpler terms, Big Data is a term given to large volumes of data that organizations store and process. However, it is becoming very difficult for companies to store, retrieve and process the ever-increasing data. If any company gets hold on managing its data well, nothing can stop it from becoming the next BIG success! The problem lies in the use of traditional systems to store enormous data. Though these systems were a success a few years ago, with increasing amount and complexity of data, these are soon becoming obsolete. The good news is - Hadoop has become an integral part for storing, handling, evaluating and retrieving hundreds of terabytes, and even petabytes of data. - - - - - - - - - - - - - - Opportunities for Hadoopers! Opportunities for Hadoopers are infinite - from a Hadoop Developer, to a Hadoop Tester or a Hadoop Architect, and so on. If cracking and managing BIG Data is your passion in life, then think no more and Join Edureka's Hadoop Online course and carve a niche for yourself! Please write back to us at [email protected] or call us at +91 88808 62004 for more information. Customer Review: Michael Harkins, System Architect, Hortonworks says: “The courses are top rate. The best part is live instruction, with playback. But my favorite feature is viewing a previous class. Also, they are always there to answer questions, and prompt when you open an issue if you are having any trouble. Added bonus ~ you get lifetime access to the course you took!!! ~ This is the killer education app... I've take two courses, and I'm taking two more.”
Views: 292510 edureka!
Kibana 5 Introduction
[ You can find a visual transcript of this video on my blog: https://www.timroes.de/2016/10/23/kibana5-introduction/ ] In this video we'll cover all the basics you need to get started with Kibana 5 and kickstart into visualizing and analyzing your data. More Kibana tutorials can be found on https://www.timroes.de All Kibana tutorials are available in the Kibana Tutorials playlist: https://www.youtube.com/playlist?list=PLWOeloPQaz1C91x7ioqFO8SnaV7xNFvjo The mentioned post about the detailed explanation of queries can be found at: https://www.timroes.de/2016/05/29/elasticsearch-kibana-queries-in-depth-tutorial/ Some tutorials about timelion: - Short introduction: https://www.youtube.com/watch?v=-sgZdW5k7eQ - More detailed talk from DevoxxFR: https://www.youtube.com/watch?v=L5LvP_Cj0A0
Views: 137727 Tim Roes
How to split large table data into multiple Excel Sheets on a Excel File by using SSIS Package-P169
SSIS Video Scenario: How to Export Data to Multiple Excel Sheets from Single SQL Server Table in SSIS Package which was dividing the data to multiple sheets depending upon distinct value in one of the column. In this post, we are going to split the rows without using any column value. Think about a situation where you have 3.5 million records and you would like to write 500,000 on each of the excel sheet. The package should be able to take number of rows per sheet as variable value so we can change anytime we like. link for the script used in the video http://www.techbrothersit.com/2016/03/how-to-split-large-table-data-into.html Check out our Dynamic Excel Source and Destination videos in SSIS Video Tutorial playlist on below topics How to Load Data from Excel Files when Number of Columns can decrease or order is changed in Excel Sheet How to Load Only Matching Column Data to SQL Server Table from Multiple Excel Files (Single Sheet per file) Dynamically in SSIS Package How to Load Excel File Names with Sheet Names ,Row Count,Last Modified Date, File Size in SQL Server Table How to Load Multiple Excel Files with Multiple Sheets to Single SQL Server Table by using SSIS Package How to Load Matching Sheets from Excel to Table and Log Not Matching Sheets Information in SQL Server Table How to create Table for each sheet in Excel Files and load data to it dynamically in SSIS Package How to Create Table per Excel File and Load all Sheets Data Dynamically in SSIS Package by using Script Task How to create CSV file per Excel File and Load All Sheets from Excel File to it in SSIS Package How to Create CSV File for Each Excel Sheet from Excel Files in SSIS Package How to Load Excel File Name and Sheet Name with Data to SQL Server in SSIS Package How to Import data from Multiple Excel Sheets with a pattern of sheet names from Multiple Excel File in SSIS Package How to import Data from Excel Files for specific Sheet Name to SQL Server Table in SSIS Package Load Data To Tables according to Excel Sheet Names from Excel Files dynamically in SSIS Package How to Load Excel Files with Single/ Multiple Sheets to SQL Server Tables according to Excel File Name Dynamically How to Read Excel Sheet Data after Skipping Rows in SSIS Package by using Script Task How to read data from Excel Sheet and Load to Multiple Tables by using Script Task in SSIS Package How to create Excel File Dynamically from SQL server Table/View by using Script Task in SSIS Package How to create Excel File Dynamically for Stored Procedure Results in SSIS Package by using Script Task How to Export SQL Server Tables from Database to Excel File Dynamically in SSIS Package by using Script Task How to Convert CSV/Text Files to Excel Files in SSIS Package by using Script Task How to Load All CSV Files to Excel Sheets ( Sheet Per CSV) in single Excel File in SSIS Package How to Load All CSV Files to Single Excel Sheet with File Names in an Excel File Dynamically in SSIS Package How to Create Sample Excel file with Sheet from each table with Top 1000 Rows per sheet in SSIS Package How to Export Data to Multiple Excel Sheets from Single SQL Server Table in SSIS Package How to split large table data into multiple Excel Sheets on Single Excel File by using SSIS Package How to Export All tables of a database to Excel Files with Date-time in SSIS Package How to read Cell Value from Excel by using Script Task in SSIS Package
Views: 6379 TechBrothersIT
Excel Power Query in Telugu
Download https://www.microsoft.com/en-us/download/confirmation.aspx?id=39379 1.Microsoft Power Query for Excel: Power Query enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, and more. 2.With Power Query, you can Find and connectdata across a wide variety of sources.Merge and shape data sources to match your data analysis requirements or prepare it for further analysis and modeling by tools such as Power Pivot and Power View.Create custom views over data. 3.Power Query Data Sources Web page Excel or CSV file XML file Text file Folder SQL Server database Microsoft Azure SQL Database Access database Oracle database IBM DB2 database MySQL database PostgreSQL Database Sybase Database Teradata Database SharePoint List OData feed Microsoft Azure Marketplace Hadoop File (HDFS) Microsoft Azure HDInsight Microsoft Azure Table Storage Active Directory Microsoft Exchange Facebook
Views: 296 Learners Page
How To Install The Free R Statistical Package
In this video snippet, I'm going to show you how to install the free R statistics package and calculate some basic statistics. This clip is referenced in my blog entitled, How To Quickly Install The Free Statistics Package R. This clip was hijacked from my OraPub Online Institute seminar, Using Skewed Performance Data To Your Advantage. https://resources.orapub.com/OraPub_Online_Training_About_Oracle_Database_Tuning_s/100.htm#skew
Views: 292 OraPub, Inc.
Applying Dashboard Filters
This podcast instructs intermediate users on how to apply filters to the dashboard.
Sharing to twitter from your Zen cart See the results instantly (zencart)
When you share an item from zencart or your blog the spiders index the page you are sharing. In zen cart you can see this instantly. Check out this short video and come see me at http://lenfarneth.com Keywords zen cart zencart podcast with zencart cs cart ckeditor installation zen cart inventory lose sound effect zen cart review dreamweaver zen cart 000webhost instaling qbmsin zencart shipping zen cart zen cart search how zen cart insert images zencart zencart easy help zen cart items modifying zen cart paypal zencart site map cpanel tutorial oracle database quickbooks stamps easy shopping cart ackburn zencart dropdown box restorem zencart oscommerce ecc zen cart installing zencart cpanel zen cart bluehost zen cart payment new zencart theme online store query cache zencart moodle zencart homepage message zen cart demo zen cart banners big cartel customization zencart ezpages category image zencart ssl zen cart zen cart godaddy modules zen cart customize zen cart zen cart mods brian zen paypal logo tutour magiczoom zencart install zencart template change header zencart gucci mane joomla vs drupal joozen joomla beginners guide queenie chan r57 shell 1.3 zen cart layout newegg 12 leaves bubble head zencart creating subcategories excel selling price hacking oscommerce simple seo installing zencart product attributes apsona godaddy shopcms siteground zen cart attributes jason muraz curl.php.txt attributes zen cart aircondition contact form zencart day and nighbt joomla shopping cart police officer slapped excel populate boghos create a subdomain installing zencart_full.sql shopify reviews zen cart banner prestashop amazing zencart define pages shopping cart software zencart demo dreamweaver php template change zencart template godaddy web hosting zen cart help instaling zencart advertise your website elegance zen cart magento vs zencart learn zen cart
Views: 185 Len Farneth
QMF Best Practice: QMF 11 Classic...Saving Session Settings
QMF version 11 provides a new global variable that can save your session settings when you exit a QMF session and initialize them when you re-enter a QMF session. DSQEC_USERGLV_SAV is used to set up this behavior. Also, DSQEC_SESSGLV_SAV can be used to save values entered on QMF command prompt panels from session to session.
Views: 554 World of Db2
Data Optimization
POIM's Data Optimization and Enhancement services are an integral component for Customer Data Integration (CDI), and a critical success factor for effective customer relationship management, business intelligence, and sales and marketing execution.
Views: 123 phindspoim
What's new in Microsoft Excel: Machine learning-powered insights new data types new - BRK2122
As the world’s more popular spreadsheet, Excel has continued to evolve and grow with its users. We have added new features, adapted them based on your feedback and continued to make the functionality in Excel better, faster & more efficient. Join us to learn more about the innovations coming in 2018 - Machine Learning-Powered Insights, New Data Types, New Visualizations, Custom Functions and More! From business analysts to line of business specialists, if you use Excel this is a session you don’t want to miss.
Views: 326 Microsoft Ignite
MS in Business Analytics Webinar
Learn about Cal Poly's new MS in Business Analytics launching fall 2016. Leaders from the Orfalea College of Business, Google and Oracle discuss trends in data analysis and why this degree is in demand by major employers. More info: http://www.cob.calpoly.edu/gradbusiness/degree-programs/ms-business-analytics/
Lumension Patch Tuesday Security Briefing - January 2014
This month's Patch Tuesday aligns with January's of past... issuing a low number of patches and giving IT a reprieve to start the year. We have just 4 new bulletins this month covering 6 CVEs. None of the bulletins are rated critical and only one bulletin was known to have active exploits prior to today's release. After you deploy the few needed patches this month, consider taking the extra time to get caught up on what you may have missed over the holidays. First on your list of priorities should be MS14-002 which is a patch for the elevation of privilege vulnerability discovered in late November with active exploits against Windows XP and Windows Server 2003 users. This bulletin addresses one CVE and has only been seen used in conjunction with a vulnerability in Adobe Reader and Acrobat that was patched in May as part of Adobe Security Bulletin APSB 13-15. This was typically exploited by an attacker sending your user a spear phishing email with a bad Adobe link. Once clicked, that attacker could then gain administrator access to the machine. Keeping your Adobe applications fully patched will mitigate this vulnerability, but it's important to apply MS14-002 as a defense in depth. MS14-002 replaces Security Advisory 2914486. This bulletin is only given a severity of "Important" for a variety of reasons, including the fact that Microsoft will end support for XP in April. If you're still using XP, this will be an important patch to deploy. And, hopefully you are working on your platform migration plan. Second on your list of priorities should be MS14-001. It's a vulnerability in Office that could allow a remote code execution and it covers 3 CVEs. While there are no known active attacks, the vulnerability has an exploitability index of 1 meaning exploit code is likely within the next 30 days. This bulletin is applicable to all currently supported versions of Microsoft Word on Windows. Microsoft Office for Mac is unaffected. MS14-003 is a vulnerability that could lead to an elevation of privilege in Windows Kernel mode drivers. It covers one CVE for Windows 7 and Server 2008 R2 and has no known active attacks. Microsoft gives a deployment priority of 2 and should be third on your list this month. Finally, MS14-004 is a vulnerability in Microsoft Dynamics that could allow a denial of service. It covers one CVE as well and there are no known active attacks. The exploitability index is 3. This is a server side vulnerability and note that the updated service will not automatically restart, so if you are applicable, it would be best practice to manually restart the impacted service after applying the update. In addition to the 4 patches, Microsoft has also re-released MS13-081. There were stability issues in some cases with 3rd party USB drivers so we recommend reinstalling the update to ensure you have the latest version of that patch. They have also released Security Advisory 2755801 for updates to vulnerabilities in Adobe Flash Player for IE.
Views: 256 Lumension
Snow Tha Product - “Nights" (feat. W. Darling)
Snow Tha Product - “Nights" (feat. W. Darling) Download: http://smarturl.it/DownloadNights Stream: http://smarturl.it/StreamNights Connect with Snow https://twitter.com/SnowThaProduct https://www.facebook.com/SnowThaProduct https://www.instagram.com/snowthaproduct https://soundcloud.com/snowthaproduct http://www.snowthaproduct.com/
Generating Searchable Public-Key Ciphertexts with Hidden Structures for Fast Keyword Search
Generating Searchable Public-Key Ciphertexts with Hidden Structures for Fast Keyword Search To get this project in ONLINE or through TRAINING Sessions, Contact:JP INFOTECH, Old No.31, New No.86, 1st Floor, 1st Avenue, Ashok Pillar, Chennai -83. Landmark: Next to Kotak Mahendra Bank. Pondicherry Office: JP INFOTECH, #45, Kamaraj Salai, Thattanchavady, Puducherry -9. Landmark: Next to VVP Nagar Arch. Mobile: (0) 9952649690 , Email: [email protected], web: www.jpinfotech.org Blog: www.jpinfotech.blogspot.com Existing semantically secure public-key searchable encryption schemes take search time linear with the total number of the ciphertexts. This makes retrieval from large-scale databases prohibitive. To alleviate this problem, this paper proposes Searchable Public-Key Ciphertexts with Hidden Structures (SPCHS) for keyword search as fast as possible without sacrificing semantic security of the encrypted keywords. In SPCHS, all keyword-searchable ciphertexts are structured by hidden relations, and with the search trapdoor corresponding to a keyword, the minimum information of the relations is disclosed to a search algorithm as the guidance to find all matching ciphertexts efficiently. We construct a SPCHS scheme from scratch in which the ciphertexts have a hidden star-like structure. We prove our scheme to be semantically secure in the Random Oracle (RO) model. The search complexity of our scheme is dependent on the actual number of the ciphertexts containing the queried keyword, rather than the number of all ciphertexts. Finally, we present a generic SPCHS construction from anonymous identity-based encryption and collision-free full-identity malleable Identity-Based Key Encapsulation Mechanism (IBKEM) with anonymity. We illustrate two collision-free full-identity malleable IBKEM instances, which are semantically secure and anonymous, respectively, in the RO and standard models. The latter instance enables us to construct an SPCHS scheme with semantic security in the standard model.
Views: 218 jpinfotechprojects
Sponge Plugin Tutorial: Setting up your Workspace | Episode 1 | 1.10.x
Hello! This is our first Sponge Plugin Tutorial! We are planning on doing plenty more Sponge development tutorial in the coming weeks, so stay tuned! Sorry the audio for HassanS6000 was too loud in this episode, we'll have it fixed in the ones yet to come. Negafinity Social Media: Website: http://www.negafinity.com/index.html Twitter: https://twitter.com/Negafinity Facebook: https://www.facebook.com/negafinity GitHub: https://github.com/NEGAFINITY Links: JDK 8 Downloads: http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html Setting up JAVA_HOME for Windows: https://confluence.atlassian.com/doc/setting-the-java_home-variable-in-windows-8895.html Setting up JAVA_HOME for Mac OS X: https://www.mkyong.com/java/how-to-set-java_home-environment-variable-on-mac-os-x/ Eclipse Website: http://www.eclipse.org/home/index.php Gradle Website: https://gradle.org/ Sponge Docs: https://docs.spongepowered.org/ Oracle Documentation on Annotations: https://docs.oracle.com/javase/tutorial/java/annotations/ Sponge Website: https://www.spongepowered.org/ We used the Spongie mascot in our thumbnail under the rights given in the documentation here: https://docs.spongepowered.org/master/en/about/assets.html Thanks for watching! Don't forget to drop a like, and subscribe. Feel free to ask questions in the comments!
Views: 3362 Negafinity
iOS and Podcasts with Rob Walch
Listen to the full episode here: http://softwareengineeringdaily.com/2017/05/30/ios-and-podcasts-with-rob-walch/ Apple controls the iOS ecosystem. As an accident of history, Apple also controls the podcasting ecosystem. Unlike most ecosystems within Apple’s dominion, podcasts remain open. A podcaster merely has to record an mp3, distribute it via RSS feed, and submit that RSS feed to the iTunes podcast portal. Podcasting has thrived in recent years, but very few technology companies have managed to take advantage of that growth. Libsyn is the most popular place to host a podcast. Libsyn is a combination of a CDN, a hosting service, analytics, and place to get an RSS feed for a podcaster. There have been many clones of Libsyn over the years, but the company remains the industry standard. For people who are confused–iTunes does not host any audio files. It is just an index of feeds. A podcaster needs to host audio files somewhere in order to give iTunes access. Today’s guest Rob Walch joins the show to talk about podcasts–including his podcast Today in iOS. I had a great time meeting Rob at the Microsoft Build conference. Special thanks to Bharat Bhat for organizing the podcast booths at Microsoft Build. Transcript Transcript provided by We Edit Podcasts. Software Engineering Daily listeners can go to weeditpodcasts.com/sed to get 20% off the first two months of audio editing and transcription services. Thanks to We Edit Podcasts for partnering with SE Daily. Please click here to view this show’s transcript. Sponsors Dice.com will help you accelerate your tech career. Whether you’re actively looking for a job or need insights to grow in your role, Dice has the resources you need. Dice’s mobile app is the fastest and easiest way to get ahead. Search thousands of jobs from top companies. Discover your market value based on your unique skill set. Manage your tech career and download the Dice Careers app on Android or iOS today. And to check out the Dice website and support Software Engineering Daily, go to dice.com/sedaily. Oracle Dyn provides DNS that is as dynamic and intelligent as your applications. Dyn DNS gets your users to the right cloud service, CDN, or data center, using intelligent response to steer traffic based on business policies, as well as real-time internet conditions, like the security and performance of the network path. Get started with a free 30-day trial for your application by going to dyn.com/sedaily.  After the free trial, Dyn’s developer plans start at just $7 a month for world-class DNS. Rethink DNS. Go to dyn.com/sedaily to learn more and get your free trial of Dyn DNS. Ready to build your own stunning website? Go to Wix-DOT-com and start for free! With Wix, you can choose from hundreds of beautiful, designer-made templates. Simply drag and drop to customize anything and everything. Add your text, images, videos and more. Wix makes it easy to get your stunning website looking exactly the way you want. Plus, your site is mobile optimized, so you’ll look amazing on any device. Whatever you need a website for, Wix has you covered. So, showcase your talents. Start that dev blog, detailing your latest projects. Grow your network with Wix apps made to work seamlessly with your site. Or, simply explore and share new ideas. You decide. Over one-hundred-million people choose Wix to create their website – what are you waiting for? Make yours happen today. It’s easy and free. And when you’re ready to upgrade, use the promo code SEDaily for a special SE Daily listener discount. Terms and conditions apply. For more details, go to Wix.com/wix-lp/SEdaily. Create your stunning website today with Wix.com, that’s W-I-X-DOT-com.
Views: 3 Software Daily
Hadoop Tutorial - Create Hive tables and load quoted CSV data in Hue
Hue (http://gethue.com) makes it easy to create Hive tables. With HUE-1746, Hue guesses the columns names and types (int, string, float...) directly by looking at your data.
Views: 13536 gethue

Undergraduate dissertation methodology guidelines
Essay on samajik ekta patel
Free rubric for research paper middle school
Lies in huck finn essay prompt
Plaidoirie badinter contre la peine de mort dissertation