Adam Machanic interviews Joe Celko at the 2006 PASS Summit where Joe recalls an old trick that was used before the CASE statement was added to the SQL language.
Duration : 0:0:48
In this demonstration I will show you how simple it is to create a sql database, then a table and also use the insert statement to insert data into your table.
Duration : 0:8:48
Common data scenarios require developers to write and maintain logic to determine whether to insert, update or delete information (sometimes called upsert) such as:
IF FOUND
THEN UPDATE
ELSE
INSERT
SQL Server 2008 provides the new MERGE statement within the SQL language to enable developers to provide this functionality with a single statement. This allows for code reduction and easier maintainability.
Duration : 0:3:28
http://www.embarcadero.com/products/
Embarcadero® DB Optimizer™ offers:
* Graphical visualization of wait-time analysis to easily pinpoint the SQL causing poor database performance
* Hyperlinked drill-downs for locating detailed activity information for an individual SQL statement
* Explain plans for a better understanding of how SQL will be executed and the performance costs
* Real-time Quick Fixes to flag and correct inefficient SQL automatically (Oracle)
* Batch tuning of DML statements, stored routines, entire SQL files and the System Global Area (Oracle
Duration : 0:2:57
http://www.embarcadero.com/products/
Embarcadero® DB Optimizer™ offers:
* Graphical visualization of wait-time analysis to easily pinpoint the SQL causing poor database performance
* Hyperlinked drill-downs for locating detailed activity information for an individual SQL statement
* Explain plans for a better understanding of how SQL will be executed and the performance costs
* Real-time Quick Fixes to flag and correct inefficient SQL automatically (Oracle)
* Batch tuning of DML statements, stored routines, entire SQL files and the System Global Area (Oracle)
Duration : 0:3:1
Found it on vimeo: http://vimeo.com/4634556?pg=embed&sec=&hd=1
Made by John Strand from pauldotcom.com
Sqlmap is an open source command-line automatic SQL injection tool. Its goal is to detect and take advantage of SQL injection vulnerabilities in web applications. Once it detects one or more SQL injections on the target host, the user can choose among a variety of options to perform an extensive back-end database management system fingerprint, retrieve DBMS session user and database, enumerate users, password hashes, privileges, databases, dump entire or user’s specified DBMS tables/columns, run his own SQL statement, read or write either text or binary files on the file system, execute arbitrary commands on the operating system, establish an out-of-band stateful connection between the attacker box and the database server via Metasploit payload stager, database stored procedure buffer overflow exploitation or SMB relay attack and more.
Duration : 0:9:26
A delete action query in Microsoft Access is based upon the delete statement of SQL, and it can be created by clicking on the “Create” tab and the group “Query Design.” Change a query type from a select statement to a delete statement with help from a computer programming teacher in this free video on Microsoft Access.
Duration : 0:3:34