Rout600: Database

Showing posts with label Database. Show all posts

Monday, September 7, 2009

MYSQL VTC Tutorials

Getting Started
Welcome (01:20)
What You Will Need (07:24)

Database Basics
What Is A Database? (03:28)
RDBMSs (05:09)
Tables and Data Pt 1 (05:59)
Tables and Data Pt 2 (05:55)

SQL Basics
Finding Your Way About (05:55)
Creating a Database (02:34)
Creating a Table (04:38)
Column Types-String Pt 1 (05:16)
Column Types-String Pt 2 (04:44)
Column Types-Numeric Pt 1 (08:23)
Column Types-Numeric Pt 2 (06:55)
Retrieving Data With Search Criteria (05:34)
Changing Existing Data (04:35)
Altering A Table (05:53)
Keys And Indexes (05:31)
Basics Syntax Recap (04:24)

Operators in MySQL
Arithmetic Operators (05:03)
Numeric Comparison Operators (08:07)
String Comparison Operators (05:34)
Logical Operators (08:48)
Bitwise Operators (07:21)
Regular Expressions 1 (08:41)
Regular Expressions 2 Pt 1 (06:38)
Regular Expressions 2 Pt 2 (05:10)
Operators Syntax Recap (04:53)

Querying Your Data
Sorting Retrieved Data (03:37)
Specifying Numbers of Results (03:05)
Joining Tables Pt 1 (05:25)
Joining Tables Pt 2 (03:37)
More On Joining Tables (07:55)
Data Aggregation (08:05)
Queries Syntax Recap (03:00)

More Complex SQL
Using Default Data (08:09)
Date And Time 1 Pt 1 (05:16)
Date And Time 1 Pt 2 (04:02)
Date And Time 2 (04:54)
ENUM column type (06:49)
SET column type Pt 1 (06:51)
SET column type Pt 2 (05:28)
Using Variables (03:12)
Conditional: IF() (05:25)
Complex Syntax Recap (03:18)

Good Practices
Using SQL batch files Pt 1 (05:14)
Using SQL batch files Pt 2 (04:41)
Data Modeling Pt 1 (05:17)
Data Modeling Pt 2 (05:55)
Normalization Pt 1 (05:11)
Normalization Pt 2 (03:56)
Optimizations (13:32)

Security
Users And Privileges (07:31)
More About Users And Privileges (08:08)
The mysql Database Pt 1 (04:37)
The mysql Database Pt 2 (04:16)
Encryption (05:43)
Security Syntax Recap (03:25)

Building A Database Application
Planning The Structure (07:12)
Designing The Database Pt 1 (05:33)
Designing The Database Pt 2 (04:49)
Creating The Database Pt 1 (06:25)
Creating The Database Pt 2 (04:33)
Logging In And Out (06:38)
Checking Videos In And Out Pt 1 (05:59)
Checking Videos In And Out Pt 2 (07:06)
Searching For A Video (06:26)
Adding A New Title (08:05)
Signing Up A New Customer (03:51)
Hiring And Firing Employees Pt 1 (04:45)
Hiring And Firing Employees Pt 2 (04:28)
Listing Debtors (08:03)

download:

password=tactools.org


http://rapidshare.com/files/229460050/MYSQL_VTC_Tutorials.rar

Tuesday, August 4, 2009

Lynda.com - SQL Essential Training

Lynda.com - SQL Essential Training
ISO | 2.4 hours training | 177 MB

Whatever a database is being used for—web sites, bookkeeping, sales and inventory, or even the lowly to-do list—it's all about the data. SQL Essential Training is designed to help users understand the most common language for database wrangling—SQL. Beginning with a brief introduction, instructor Bill Weinman teaches the major features of SQL; he offers a solid working knowledge of the language, and how to retrieve and manage data efficiently. He also works through a real-world example of building a CRUD (Create, Read, Update, and Delete) application using SQL. Exercise files accompany the course.

Oracle SQL*Plus: The Definitive Guide

Oracle SQL*Plus: The Definitive Guide (Definitive Guides) by Jonathan Gennick
Number Of Pages: 582 | ISBN-10: 0596007469 | CHM | 2 Mb

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL*Plus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.
The new second edition of "Oracle SQL*Plus: The Definitive Guide" clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQL*Plus--and maybe some you didn't realize you could perform.
With "Oracle SQL*Plus: The Definitive Guide," you'll expertly:
write and execute script files
generate ad hoc reports
extract data from the database
query the data dictionary tables
customize an SQL*Plus environment
and much more
Download from Depositfiles
or
Download from SharingMatrix
or
Download from FileFactory

The Definitive Guide to SQLite

The Definitive Guide to SQLite
464 pages | PDF| 6 MB

Traditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So for many people, the solution resides in SQLite, an open source embeddable database with an amazingly small footprint (less than 250 kilobytes). SQLite packs a powerful array of features and can handle databases as large as 2 terabytes. It offers a flexible set of datatypes and the ability to perform transactions, and it is supported by languages like C, PHP, Perl, and Python. And because SQLite's databases are completely file based, privileges are granted at the operating system level, allowing for easy and fast user management.
Download from HotFile
or
Download from SharingMatrix
or
Download from FileFactory

Monday, August 3, 2009

Oracle PL/SQL Programming, 4th Edition

Oracle PL/SQL Programming, 4th Edition
1198 pages | CHM | 3 Mb

For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL.

The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers.

The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization.
Co-authored by the world's foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.

Download

Pro SQL Server 2008 XML

Michael Coles, "Pro SQL Server 2008 XML"
Apress | 2008 | ISBN: 1590599837 | 496 pages | PDF | 6 MB

Knowledge and ability to apply XML are de rigueur in today’s world, and SQL Server developers and administrators are no exception to that rule. Pro SQL Server 2008 XML is your key to unlocking the powerful XML feature set first introduced in SQL Server 2005 and since refined in SQL Server 2008. Author Michael Coles shows how to store XML using SQL Server’s built–in XML data type. Learn to query and manipulate XML data using standard technologies such as XQuery and XSLT. No SQL Server database professional can afford to be without knowledge of the XML feature set. Pro SQL Server 2008 XML delivers on the knowledge that you need to remain competitive in your career.
Shows how to store, query, and manipulate XML documents in SQL Server
Provides step–by–step examples showing best practices and advanced features
Accurately discusses how SQL Server’s XML feature set stacks up against the ISO XML standards
What you’ll learn
Store XML documents using SQL Server’s built–in XML data type.
Query those stored documents using SQL/XML and XQuery.
Manipulate and transform XML using XSLT and XPath.
Understand how SQL Server’s XML support compares to the ISO XML standards.
Create SOAP endpoints for use in web services applications.
Create primary and secondary XML indexes to improve performance of XML queries.
Download from:

uploading.com

depositfiles.com

bitroad.net

Tuesday, July 28, 2009

VTC Microsoft SQL Server 2005 Administration Tutorials

VTC Microsoft SQL Server 2005 Administration Tutorials | 166 MB

SQL Server 2005 is Microsoft's latest release of their enterprise database solution product. SQL Server 2005 is the result of five years of research, development and collection of suggestions and wish lists from database administrators and developers. Microsoft continues to drive the enterprise database market with the added features and capabilities of this new product. Microsoft Certified Database Administrator and Certified Trainer Mark Long covers the basics of SQL Server 2005 administration in this course. To begin learning simply click the links.
Download from HotFile
01 | 02 | 03

Download from FileFactory
01 | 02 | 03

Saturday, July 25, 2009

SQL tutorial video by Microsoft certified Systems Engineer

SQL tutorial video
13 MB + 95 MB

This Transact SQL tutorial video is instructed by Microsoft certified Systems Engineer and Database administrator Mark Long. In this tutorial, you will not only learn about this data definition, manipulation, and control language, but you will also become better prepared for the MCDBA certification. It will also help you become a better Database Administrator.
Mark Long begins by introducing you to the origins and capabilities of Transact SQL. He will give a brief history of databases and will cover some language basics, including scripts, batches, functions, and views. From there, he moves onto more advanced ideas by teaching you about TSQL tools, such as the Query Analyzer and the Enterprise Manager. He then goes into great depth explaining the 4 main commands: SELECT, INSERT, UPDATE, and DELETE. You will also learn about indexes, variables, and stored procedures.
To allow you to evaluate the quality of these Microsoft Transact SQL training videos we have made the first 8 chapters of this tutorial available for free viewing online.
Links:
Download part1
Download part2

Rout600