MySQL 5 Development - Part 1
Information
Course:MySQL 5 Development (Part 1)
Author:David Swain
Release Date:2011-05-27
Duration:11 hrs / 129 tutorials
Subject: Databases
MySQL 5 Development - Part 2
Information
Author:David Swain
Release Date:2011-11-22
Duration:17.5 hrs / 184 tutorials
Description
As with any significant software product, MySQL is a broad subject for study and there is a lot we must know to be able to use it effectively. David Swain's MySQL 5 Development Part 1 course for VTC is the first in a training series intended to provide a solid foundation on which to build MySQL mastery. In this introductory course, we learn a number of non-destructive, read-only techniques for retrieving data from a MySQL database, as well as some useful history and practical background information about MySQL. We focus on statement and expression syntax and "why" those elements are written in a specific way. Further study exercises are provided for many of the hands-on lessons. Click the movie links below to get started now!
Table of Contents
Introduction
* Welcome (04:34)
* What This Course Will Cover (05:09)
* System Requirements (02:56)
* A Brief History of MySQL (06:07)
* Help on the MySQL Web Site (03:27)
* Online Manual Demonstration pt. 1 (05:56)
* Online Manual Demonstration pt. 2 (01:54)
Database Basics
* Definitions (04:28)
* Client/Server Systems (06:04)
* Tables/Columns/Rows (03:21)
* Database Design in a Nutshell (06:21)
* Indexes (03:45)
* Databases in MySQL (05:43)
Installation
* Installation Basics (07:19)
* Windows (07:16)
* Mac OS X (02:58)
* Linux (02:00)
* What We Installed (05:27)
* Starting and Stopping MySQL (02:19)
Configuration
* MySQL Server Configuration (02:18)
* Server Startup Options (05:53)
* MySQL Configuration File (05:25)
* Important Configuration Options (06:00)
Client Programs
* Command Line Operations (05:48)
* Using a Command Line Client (04:05)
* Command Line Client Help File (06:06)
* MySQL Client Batch Mode (06:27)
* MySQL Client Interactive Mode pt. 1 (06:01)
* MySQL Client Interactive Mode pt. 2 (04:32)
* MySQL Client Interactive Mode pt. 3 (06:02)
* Executing Scripts (06:49)
* Exploring Databases and ables (07:11)
SELECT Statement Basics
* SELECT Arithmetic (06:18)
* Selecting More Than One Column (04:42)
* Operators and Functions (05:03)
* Column Aliases (05:50)
* NULL (05:01)
* Data Type Basics (05:24)
Variables
* What is a Variable? (03:55)
* User Variables (01:42)
* Assignment Operator (02:50)
* SET Statement (05:53)
* System Variables (04:36)
* Variable Scope (07:12)
Calculations and Expressions
* New Values From Old (02:35)
* Operators and Operands (03:45)
* Arithmetic Operators (03:39)
* String Operators (05:12)
* Comparison Operators (05:28)
* Logical Operators (06:22)
* Order of Precedence (02:59)
* Functions and Parameters (03:28)
* Useful Numeric Functions (06:31)
* Useful Character String Functions (07:10)
* Temporal Operations (05:33)
* Useful Temporal Functions (05:09)
* Decision-Making Functions (07:27)
* NULL-Related Functions (04:52)
* Useful System Functions (02:41)
Querying SQL Data
* Using a Database (05:02)
* Selecting FROM a able (04:59)
* Targeting Rows Using WHERE (05:08)
* Complex WHERE Criteria (06:59)
* Sorting Results Using ORDER BY (05:56)
* Going to Extremes Using LIMIT (03:38)
* Avoiding Duplicates Using DISTINCT (03:54)
* Aggregation Queries (04:52)
* Subtotals Using GROUP BY (06:10)
* Filter Derived Columns with HAVING (02:43)
* Multilevel Sums Using WITH ROLLUP (05:17)
* Summarizing SELECT Clauses (06:44)
* Some Clauses Cannot Coexist (03:07)
Databases and Tables
* Databases in MySQL (04:42)
* Creating a Database (06:57)
* Aspects of a Table (02:47)
* Creating a Table (05:12)
* Table Options (05:08)
* Column Options (06:35)
* Auto-Incrementation (05:29)
* Altering a Table (04:54)
* Adding and Dropping Columns (03:43)
* Altering a Column (06:09)
* Dropping a Table (04:27)
* Dropping a Database (04:26)
Data Type Details
* Dataype Categories (02:23)
* Integer Numbers (07:00)
* Floating Point Numbers (07:36)
* Fixed Decimal Numbers (04:49)
* BIT Data Type (07:24)
* Strings (03:13)
* Basic Character Strings (05:45)
* ENUM Character Strings (06:35)
* SET Character Strings (06:08)
* Character Sets (06:54)
* Collations (06:51)
* Fonts and Keystroke Mapping (07:00)
* Binary Strings (05:21)
* Temporal Data (05:43)
* Timestamp and Time Types (06:16)
Storage Engines
* Storage Engine Basics (06:29)
* Discovering Storage Engines (04:34)
* MyISAM (06:20)
* InnoDB (06:36)
* Memory (05:31)
* Example (01:54)
* CSV (03:53)
* Archive (02:38)
* Federated (04:41)
* Blackhole (02:27)
* Third Party Engines (02:27)
Exporting Data
* Basic Export Concepts (02:57)
* Exporting Using SQL Commands pt. 1 (04:44)
* Exporting Using SQL Commands pt. 2 (05:06)
* Exporting on the Shell Command Line (05:03)
* Using MySQLDUMP for Scripts (07:02)
* Using MySQLDUMP for Exporting (07:21)
Prepared Statements
* Prepared Statement Basics (07:53)
* Prepared Statement Demonstration (07:00)
* Commands That Can Be Prepared (03:32)
* When to Use Them (03:26)
Server Information
* Metadata (07:07)
* SHOW Commands (06:39)
* DESCRIBE Command (03:07)
* MySQLSHOW Command Line Client (06:58)
* Information_Schema Database pt. 1 (04:55)
* Information_Schema Database pt. 2 (06:40)
Conclusion
* What We Covered (03:00)
* Where to Go from Here (03:08)
==========================================================
MySQL 5 Development - Part 2 of 2
Course:MySQL 5 Development (Part 2)
Author:David Swain
Release Date:2011-11-22
Duration:17.5 hrs / 184 tutorials
This MySQL 5 Development Part 2 course continues the introduction to MySQL we began with Part 1.
Table of Contents
Introduction
* Welcome (05:44)
* What the Course Will Cover (04:47)
* System Requirements (03:20)
* Brief Review of Part 1 (02:15)
Configuration
* Startup Options (06:02)
* Configuration File (05:30)
* Important Configuration Options (06:00)
Manipulating Data
* Data Manipulation Basics (03:16)
* Warnings and Errors (07:39)
* SQL Modes (06:40)
* Changing Syntax Interpretation (06:56)
* Elevating Warnings to Errors (07:02)
* Interpreting Error Messages (05:45)
* Note Warnings (04:23)
* System Error Warnings (05:24)
Inserting Data
* Inserting Data (06:19)
* Inserting Data Archaic Syntax (04:29)
* INSERT Demonstrations (07:39)
* Default Values on Insert (05:01)
* AUTO_INCREMENT on Insert (05:13)
* AUTO_INCREMENT Issues (06:06)
* LAST_INSERT_ID Function (07:04)
* Common INSERT Errors (04:47)
Deleting Data
* Deleting Data (06:08)
* DELETE with WHERE (06:25)
* DELETE with LIMIT (06:43)
* DELETE with ORDER BY (04:01)
* DELETE Result Messages (03:03)
Updating Data
* Updating Data (07:48)
* UPDATE with WHERE (05:02)
* UPDATE with LIMIT (07:09)
* UPDATE with ORDER BY (03:36)
* UPDATE Result Messages (05:25)
Other MySQL DML Commands
* REPLACE Command (05:02)
* REPLACE Demo (05:54)
* ON DUPLICATE KEY UPDATE Option (05:15)
* ON DUPLICATE KEY UPDATE Demo (05:22)
* TRUNCATE Command (03:48)
* TRUNCATE Demonstration (05:56)
* Safe Updates Mode (07:14)
Importing Data
* Importing Data (07:29)
* Basic Import Demonstrations (06:35)
* Importing Non-Tab Formats (06:58)
* Skipping Header Lines on Import (04:13)
* Changing Import Column Order (07:14)
* Converting Data on Import pt. 1 (04:35)
* Converting Data on Import pt. 2 (04:47)
* Importing on the Shell Command Line (06:33)
Deriving New Tables
* New Tables from Existing Tables (06:40)
* CREATE TABLE Using SELECT (06:09)
* Including Other Features (06:41)
* CREATE TABLE Using LIKE (04:12)
* Populating Derived Tables (03:24)
* Temporary Tables (06:48)
* Altering Derived Tables (05:54)
Multi-Table Queries
* Addressing Multiple Tables (08:04)
* Column Name Conflicts (04:35)
* Resolving Column Name Conflicts (04:13)
* Table Name Conflicts (05:03)
* Resolving Table Name Conflicts (06:31)
======================================================================
This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV
=======================================================================
Payment mode : Pay on my account ,Buying via ebay or Paypal
Shipping : By Courier through all over India
Shipping charge : Rs 50/- Flat Rate shipping anywhere in India
You can get with in two days
Any Advanced Graphic Design Software Tutorials, IT Software Tutorials, Multimedia Software Tutorials, All Engineering purpose Software Tutorials & All Software Tutorials Available
For more details
Email : digitalcollections4u@gmail.com
https://www.facebook.com/TutorialsDvDs
No comments:
Post a Comment