video tutorial from ExcelIsFun, the 64th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to Excel's D (i.e., database) functions such as DSUM, DAVERAGE, and DMAX.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 249th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Advanced Filter to extract records from a database (table or list) to a new workbook.
This instructional video explains the basics of Chroma Keying in Final Cut Pro. This is used when you want to remove or key out a specific color from a scene. Created as a component in the Temple University Instructional Video Database.
This screencast tutorial from Geoff Coffey, co-author of FileMaker Pro 9: The Missing Manual, guides you through creating a sub summary report for your FileMaker Pro database.
Information gathering is one of the most important steps in pentesting or hacking, and it can often be more rewarding to run things on the target itself as opposed to just running scripts against it remotely. With an SQL injection, a hacker can compromise a server and, ultimately, upload and run the "unix-privesc-check" script locally in order to further identify possible attack vectors.
Tossing an old Android smartphone with a decent battery into your hacking kit can let you quickly map hundreds of vulnerable networks in your area just by walking or driving by them. The practice of wardriving uses a Wi-Fi network card and GPS receiver to stealthily discover and record the location and settings of any nearby routers, and your phone allows you to easily discover those with security issues.
Now that we've set up Vuforia in Unity, we can work on the more exciting aspects of making physical objects come to life on the HoloLens. In this guide, we will choose an image (something that you physically have in your home), build our ImageTarget database, and then set up our Unity camera to be able to recognize the chosen image so that it can overlay the 3D holographic effect on top of it.
Welcome back, my hacker novitiates! There are many ways to hack databases, and most of these techniques require SQL injection (SQLi), which is a way of sending SQL commands back to the database from a web form or other input. In this tutorial, we will use SQL injection to get access to the underlying server. So instead of getting access to the database and its data, we will use the database as an intermediary to gain access to the underlying server.
Hello my fellow hackers, it's been a while since my last post, I can't get the time now-a-days for the posts but can manage to tend to comments.
Welcome back, my rookie hackers! A short while back, I began a new series on database hacking, and now it's time to continue and extend your education in that field. As you know, the database contains all of the most valuable info for the hacker, including personally identifiable information, credit card numbers, intellectual property, etc. So, it's the ultimate goal of cybercrime and the APT hacker.
In this clip, learn how to access the cool menu screens on your iPod that you never knew existed. This video will walk you through how to get to your 3rd generation iPod's cool colored LCD screen database. This hack is easy, doesn't require codes or tools and won't harm your device, so give it a try!
Use the Quick Start screen to get your FileMaker projects started off on the good foot. Whether you're new to the FileMaker Pro database management program or just want to learn how to take advantage of FileMaker Pro 11's new features, you're sure to benefit from this free video tutorial from the folks at Lynda. Specifically, this software tutorial provides a complete overview of how to use FileMaker's Quick Start screen.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 80th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to highlight an entire record (row) in a database that matches a bounced email addresss. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
In this installment from the Unorthodox Hacking series of Internet security tutorials, you'll learn how to get a shell on a Microsoft SQL Server (or SQL Server Express.) See how easy it is to obtain a shell in a Microsoft SQL database with this how-to.
See how to use CSS and JavaScript to visually design style sheets for publishing XML and database data in Altova StyleVision, a visual style sheet designer for rendering XML and relational data in multiple formats. In this video, you'll learn more about how StylevVision interfaces with CSS and JavaScript.
Gain insight into best practices for SQL Server optimization and ways to alleviate many root causes that can impact performance of your SQL Server database. Kevin also will discuss how to manage for planned and unplanned changes, speed time to implementation of your applications and ensure that your databases are running as they should.
MySQL is a structured query language (hence the 'sql'), and is an open source language published by Oracle. If you want to learn how to manipulate and use databases (such as customer lists or membership rosters), you will need to learn MySQL.
When you use the UNION command, you are stacking one result set on top of another. This is slightly different from the JOIN command, and this video is here to explain what the difference is and the best way to use UNION in your own MySQL database programs.
In this clip, we learn how to update a table with a trigger when using SQLite 3. Whether you're entirely new to the SQLite embedded relational database management system or are a seasoned developer merely looking to brush up on a few of the basics, you're sure to find much to take away. For more information, take a look!
In this clip, we learn how to employ transactions when using SQLite 3. Whether you're entirely new to the SQLite embedded relational database management system or are a seasoned developer merely looking to brush up on a few of the basics, you're sure to find much to take away. For more information, take a look!
In this clip, we learn how to use REPLACE to modify a string when using SQLite 3. Whether you're entirely new to the SQLite embedded relational database management system or are a seasoned developer merely looking to brush up on a few of the basics, you're sure to find much to take away. For more information, take a look!
In this clip, we learn how to match patterns with LIKE when using SQLite 3. Whether you're entirely new to the SQLite embedded relational database management system or are a seasoned developer merely looking to brush up on a few of the basics, you're sure to find much to take away. For more information, take a look!
In this clip, we learn how to get started using SQLite 3 from the standpoint of someone with quite a lot of PHP experience. Whether you're entirely new to the SQLite embedded relational database management system or are a seasoned developer merely looking to brush up on a few of the basics, you're sure to find much to take away. For more information, take a look!
Looking for a quick primer on how to work with Ruby on Rails' migration methods? Let this video be your guide! Whether you're entirely new to Ruby on Rails 3 or are a seasoned developer merely looking to brush up on a few of the basics, you're sure to find much to take away. For more information, take a look!
In this clip, you'll learn how to adjust timestamps from a MySQL database to the ago format (e.g., minutes ago, hours ago or days ago). Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look
In this clip, you'll learn how to adjust database parameters using phpMyAdmin and order MySQL pages with SQL ORDER BY. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.
PHPMyAdmin is a tool for website creators who may not yet be comfortable writing custom database scripts using straight PHP. This tutorial shows you how you might use PHPMyAdmin for your own website and display all the information contained on your website in just one file.
Learn how to create data-entry forms when working in Microsoft Access 2010. Whether you're new to Microsoft's popular database management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using data-entry forms in your own Access projects, watch this free video guide.
Navigate your FileMaker projects more quickly with by adding a Quick Find option to your toolbar. Whether you're new to FileMaker Pro database management program or just want to learn how to take advantage of FileMaker Pro 11's new features, you're sure to benefit from this free video tutorial from the folks at Lynda. Specifically, this software tutorial provides a complete overview of how to work with FileMaker Pro's Quick Find feature.
Looking for a guide on how to set up charts within FileMaker Pro 11? Look no further. Whether you're new to the FileMaker Pro database management program or just want to learn how to take advantage of FileMaker Pro 11's new features, you're sure to benefit from this free video tutorial from the folks at Lynda. Specifically, this software tutorial provides a complete overview of how to work with chart and graph settings in FileMaker Pro 11.
Take control of your FileMaker layouts with the Manage Layouts window. Whether you're new to the FileMaker Pro database management program or just want to learn how to take advantage of FileMaker Pro 11's new features, you're sure to benefit from this free video tutorial from the folks at Lynda. Specifically, this software tutorial provides a complete overview of how to use FileMaker's Manage Layouts window.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 25th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract records from databases that do NOT contain a given text value.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 507th installment in their series of digital spreadsheet magic tricks, you'll learn how to take badly setup data (not in database/table format) and summarize it by date and shipping name into table format report.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 212th installment in their series of digital spreadsheet magic tricks, you'll learn how to records from an Excel database/ table/list with a filter and copy-paste trick.
This video describes how to edit and delete data in PHP and MYSQL. The video is about twenty minutes long and is perfect for anyone learning how to manage databases and websites with PHP or MYSQL. This video is part of a series on learning PHP and MYSQL. However, this video is not intended for anyone who is technically challenged or not a coder and should only be watched after having a good grasp on PHP syntax.
This video shows you how to calculate weighted average cost from a transactional data set using SUMPRODUCT function. It explains things very clearly. If you're working with a very large database transactions the SUMPRODUCT function makes it. It works as text if you do the formatting first and then type the number. We put the number in first and then format as text, then press F2 and ENTER.
OnTime is such a flexible tool and it can be used in a variety of ways, with completely different methodologies. One of the methodologies that works well with OnTime is Scrum. This week we walk through a quick demonstration of setting up a new OnTime database for use with a Scrum methodology.
This first installment from Axosoft's own series of video tutorials on the OnTime Project Management Suite is about Notifications and Alerts—the way OnTime communicates with your employees, your customers, and you about events that occur in your database. Get started using notifications and alerts in your own OnSite projects with this how-to.
If you're new to DreamCoder for MySQL, one of the things you may want to know how to do is create a stored procedure in a remote MySQL database. Happily, this tutorial will walk you, step by step, through the process. For detailed instructions, press play!
This tutorial shows you how to build web services with MapForce. Load an existing WSDL file and build a complete web service by retrieving data from databases or XML files and using a visual function builder. It's easy to build web services in MapForce as this tutorial shows.
