大家论坛

 找回密码
 注册
查看: 34575|回复: 63

MySQL 5 超经典视频教程 LinuxCBT DBMS Edition feat. MySQL 5

[复制链接]

222

主题

1175

帖子

7298

金币

大家网研究生二年级

Rank: 19Rank: 19Rank: 19

积分
5756

社区建设奖创作大师解答高手优秀斑竹

发表于 2008-8-2 13:25 | 显示全部楼层 |阅读模式
LinuxCBT DBMS Edition feat. MySQL 5视频教程全面涵盖MySQL 5安装、配置、维护、优化、开发等各个方面,该套视频全程30小时,DVD为3.06GB的ISO格式文件。绝对难得的MySQL数据库管理系统的权威学习典藏级视频教程。

推荐指数:★★★★★

下载地址(建议使用迅雷下载):
LinuxCBT.DBMS.Edition.feat.MySQL.5

LinuxCBT DBMS Edition feat. MySQL 5 focuses on the ubiquitous, high-performance, low-maintenance, highly-available and scaleable MySQL 5 Database Management System (DBMS).

LinuxCBT DBMS Edition establishes the foundation for successful deployments and administration of MySQL 5 by exploring many of its features including but not limited to DML & DDL Statements, Terminal Monitor, shell-based clients, graphical clients, MyODBC, storage engines, data imports & exports, and PHP integration.

LinuxCBT DBMS Edition is unparalleled in content, depth and expertise. It entails 30-hours, or 4+ days of classroom training. LinuxCBT DBMS Edition prepares you for successfully deploying MySQL-based DBMS solutions.



Modules:

    * MySQL Installation
          o Introduction to MySQL 5
          o Discuss DBMS system specifications
          o Identify existing MySQL-installed components
          o Explore file-system layout
          o Identify & discuss the various downloadable formats /source|binary|packaged/
          o Download MySQL packages to a local repository
          o Discuss the key DBMS components
          o Confirm md5sums of components
          o Install MySQL server package and examine defaults
          o Identify key server-side administrative utilities
          o Inspect the contents of the default DBMS data-directory
          o Install MySQL Client package and explore its contents

    * Terminal Monitor Shell Client
          o Discuss Terminal Monitor concepts
          o Explain the default privileges configuration
          o Connect to the DBMS using anonymous privileges
          o Explore Terminal Monitor's help facility and useful escape sequences
          o Identify the default schemas
          o Execute useful SQL functions
          o Demonstrate how to execute SQL queries from the shell in non-interactive mode

    * User Administration
          o Identify the currently logged-in user
          o Connect to MySQL DBMS as root and explore the interface
          o Attempt to connect to the DBMS as invalid users and discuss the results
          o Attempt to connect from a remote host and evaluate results
          o Discuss the primary methods of tightening the default security scheme
          o Tighten the default privileges for the root user
          o Explore the global 'user' grant table & discuss attributes
          o Secure anonymous user accounts
          o Remove anonymous privileges and confirm enhanced security policy
          o Discuss and explore the grant tables and applicable attributes
          o Identify the ancillary grant tables that permit granular filtration
          o Create new DBMS users and confirm connectivity
          o Remove superfluous user accounts
          o Discuss permissible host values when defining users
          o Create remote super users and test connectivity
          o Discuss privileges scopes concepts & applications
          o Identify grant tables related to privileges scopes
          o Use GRANT to create and manipulate user-privileges
          o Create unprivileged accounts and explore capabilities
          o Use REVOKE to remove privileges
          o Use DROP to discard superfluous accounts
          o Maintain user passwords using SET and UPDATE

    * Show Commands & Options Files
          o Explain the usages of key SHOW commands
          o Expose DBMS privileges for currently authenticated user
          o Expose DBMS privileges for other defined users
          o List all databases available on the system
          o Show the DDL statements used to create various MySQL-managed databases
          o Examine the default supported character sets
          o Reveal the structure of defined tables
          o Show the DDL statements used to create various tables
          o List the supported Storage Engines by the current binary-build of MySQL
          o Examine the MyISAM Storage Engine tables on the file system & discuss key file types
          o Show the schemas of various tables and discuss the results
          o Examine the currently executing processes, including connected users
          o Initiate & KILL connections listed in the process-list table
          o Examine key status variables on the running server
          o Show table status information, revealing used-space, length, create-time, etc.
          o Discuss the default search-path for options files by MySQL clients
          o Examine and secure the MySQL history file to prevent superfluous disclosure of queries
          o Define a personal MySQL options file
          o Explain the supported section headers in MySQL options files
          o Define useful run-time directives for MySQL clients and examine results
          o Define a useful, custom MySQL prompt on a global and per-user basis & examine usefulness
          o Set default database variable in per-user options files and examine results

    * Key MySQL Client Utilities
          o Focus on mysql terminal monitor utility
          o Discuss & demonstrate mysql client modes
          o Discuss command-line option types
          o Output queries to standard /HTML|XML|TXT/ formats
          o Exclude column-headers from output for easy import into other applications
          o Use options file to control startup variables
          o Focus on mysqladmin utility
          o Compare & contrast mysqladmin batch-mode to mysql interactive mode
          o Confirm the status of DBMS servers using mysqladmin
          o Ascertain remote DBMS process list
          o Create & drop remote databases using mysqladmin
          o Administer remote user credentials using mysqladmin
          o Focus on mysqldump utility
          o Discuss mysqldump applications, features & benefits
          o Dump all databases and related objects to an ASCII text backup file
          o Examine the resulting dump file
          o Dump select databases and examine resulting file
          o Dumpy DBMS databases to a remote MySQL instance using mysqldump
          o Focus on mysqlimport utility
          o Create database container and table structure for subsequent imports
          o Create matching data-feed for import by mysqlimport
          o Import data-feed using default delimiters and record-separators
          o Discuss mysqlimport defaults regarding data-directory and table names
          o Examine importing duplicate records

    * Key Data Manipulation Language (DML) Statements
          o Discuss common DML statements
          o Focus on SELECT DML statement
          o Optimize SELECT statements with WHERE clauses to define criteria
          o Discuss SELECT operators /=|<=|>=|!=|etc/
          o Perform pattern matching using WHERE clause with LIKE operator & wildcards
          o Influence the order of SELECT output using ORDER BY
          o Extend criteria definition and optimize queryies using AND clause
          o Return result-set INTO output ASCII text file using SELECT INTO
          o Redirect result-set to AWK and extract interesting fields
          o Use LIMIT with SELECT to return n number of rows
          o Return total number of rows including LIMIT value
          o Alias column headers using SELECT
          o Concatenate results returned using SELECT
          o Focus on INSERT DML statement
          o Explain supported INSERT statements /VALUES|SET|SELECT/
          o Describe table structure to determine column constraints
          o INSERT VALUES specifying column names
          o INSERT VALUES one-to-one without defined column headers
          o Use SET with INSERT to indicate interesting columns
          o Use VALUES to INSERT multiple rows in one statement
          o Discuss INSERT SELECT applications
          o Create table structure for using INSERT SELECT
          o Populate newly-created table with data
          o Use SELECT INSERT to move data between tables & evaluate results
          o Focus on UPDATE DML statement
          o Perform global table UPDATE with simple DML statement
          o Specify columns to be updated and evaluate affected rows
          o UPDATE interesting rows using criteria
          o UPDATE n number of records using the LIMIT criteria operator
          o Focus on DELETE DML statement
          o Remove interesting records using WHERE clause and applicable critieria
          o Intro to the ALTER Data Definition Language (DDL) statement

    * Key Data Types
          o Focus on Numeric data-types
          o Use describe to expose defined data-types for columns
          o Discuss unsigned and auto incremented column attributes
          o Discuss /TINYINT|SMALLINT|MEDIUMINT|INT|BIGINT/ capacity and applications
          o Discuss FLOAT capacity and applications
          o Discuss DOUBLE capacity and applications
          o Discuss DECIMAL capacity and applications
          o Discuss BIT capacity and applications
          o Define a table with TINYINT column
          o Populate TINYINT column with INSERT and exceed its limits and evaluate resutls
          o Use ALTER to increase the capacity of the TINYINT column to SMALLINT
          o Populate SMALLINT column and evaluate results
          o ALTER table and add columns with greater numeric capacity
          o Define a DECIMAL column and store values
          o Focus on String data-types
          o Explain features and limitations of CHAR type fields
          o INSERT strings with unpreserved characters and evaluate results
          o Compare & contrast VARCHAR & CHAR type fields; fixed vs. varaible-length
          o ALTER table to convert interesting fields from CHAR to VARCHAR
          o Create Perl script to generate values for VARCHAR columns and evaluate results
          o Discuss /TEXT|TINYTEXT|MEDIUMTEXT|LONGTEXT/ column types
          o Discuss /BLOB|TINYBLOB|MEDIUMBLOB|LONGBLOB/ column types
          o ALTER table to support LONGTEXT and import data and evaluate results
          o Discuss /BINARY|VARBINARY/ usages and limits
          o Explain the usages of ENUM column types
          o Explore predefined ENUM column types in system tables
          o Define ENUM fields, insert data and evaluate DBMS behavior
          o Focus on Date data-types
          o Discuss DATE column type features (resolution & range)
          o ALTER table structure to support DATE-based column
          o INSERT invalid date and evaluate results
          o Discuss DATETIME column type features (resolution & range)
          o ALTER table structure to support DATETIME-based column
          o INSERT valid date & time value and evaluate results
          o Discuss how MySQL implements dummy dates
          o ALTER table structure to support TIMESTAMP-based column
          o Discuss TIMESTAMP column type features (resolution & range)
          o Discuss NULL-enabled auto-timestamp (dummy-time) invocated columns
          o Explain MySQL's default date syntax
          o Insert Date & Time values into MySQL columns using mixed delimiters
          o Insert Date & Time values into MySQL columns without delimiters
          o Recap supported data-types

    * Key Data Definition Language (DDL) Statements
          o Focus on CREATE DDL statement
          o Describe how MySQL maps database containers to the file system
          o CREATE DATABASE container to house new tables
          o Define the requirements /auto_increment|primary key|etc/ of new base tables
          o Define the CREATE TABLE syntax for new base tables based on selected data types
          o Execute statement and evaluate results of recently-created tables
          o Use SHOW CREATE TABLE to examine DDL syntax for reference
          o CREATE TABLE with NOT-NULL column enforcements
          o Populate tables with useful values and evaluate results
          o INSERT VALUES with DEFAULT for auto-populated columns and evaluate results
          o Duplicate table structure using CREATE TABLE and evaluate results
          o Populate destination table with data from the source table using INSERT
          o Discuss Temporary tables features and applications
          o CREATE TEMPORARY TABLES and populate with useful data
          o Rename tables using RENAME TABLE as an alternative to ALTER TABLE
          o Focus on DROP DDL statement
          o Describe the objects that are affected using DROP
          o DROP DBMS objects and evaluate file system implications
          o Focus on CREATE INDEX DDL statement
          o Discuss the importance of indexes to improved data-retrieval
          o Discuss MyISAM storage engine per-index limits
          o Identify default MyISAM index files
          o Explore defined indices
          o Define UNIQUE indices
          o Compare & contrast table & index storage requirements
          o Generate data-set to be imported into an indexed column
          o Compare & contrast query-execution times with and without indices

    * JOINS
          o Discuss the features & benefits of using JOINS to access normalized data
          o Normalize the data structure, using ALTER TABLE, to prepare for using joins
          o Use seq to generate normalized data and import using mysqlimport
          o Discuss the various types of supported JOINS /EQUI|NATURAL|LEFT|RIGHT|INNER|OUTER/
          o Define and execute EQUIJOINS
          o Define and execute NATURAL JOINS
          o Define JOINS using fully-justified DBMS object names
          o Use table and column aliases with JOINS

    * VIEWS & TRIGGERS
          o Discuss the features & benefits of using VIEWS
          o Use DESCRIBE to identify interesting VIEW candidate-columns
          o Explain VIEW-creation syntax
          o Create useful VIEWS and evaluate results
          o Create VIEWS using column-aliases
          o Update VIEWS using CREATE OR REPLACE VIEW & ALTER VIEW
          o Create VIEWS based on EQUIJOINS
          o Demonstrate how to UPDATE base-table data using VIEWS
          o Remove superfluous VIEWS using DROP VIEW
          o Focus on TRIGGERS
          o Discuss MySQL's TRIGGER implementation rules
          o Discuss TRIGGER timing & events
          o Discuss TRIGGER statements
          o Define a TRIGGER to update a secondary table upon INSERT INTO primary table
          o INSERT INTO primary table and examine TRIGGER response
          o Log table updates using TRIGGERS
          o Use SHOW to reveal defined TRIGGERS ON tables
          o Create & evaluate multiple statement triggers using BEGIN .. .END
          o Redefine MySQL statement delimiters to support multiple statement triggers

    * Stored Routines (Functions & Procedures)
          o Discuss Stored Routines components and applications
          o Focus on Stored Procedures
          o Discuss required privileges
          o Explain how to invoke stored procedure
          o Define useful stored procedures
          o Use SHOW to reveal stored procedures and important attributes
          o Create multiple statement stored procedures
          o Redirect stored procedure output to memory for easy reuse
          o Focus on Functions
          o Discuss ideal uses for functions
          o Describe function syntax
          o Define functions based on date calculations and evaluate results

    * Replication Configuration
          o Explore uses of replication
          o Illustrate MySQL Master-Slave replication model
          o Discuss binary logging requirements
          o Updated configuration on Master & Slave servers to reflect replicaiton requirements
          o Create replication accounts on Master & Slave servers
          o Create a snapshot of the master server's databases
          o Transport the snapshot to slave servers using SCP
          o Record replication position
          o Configure server IDs on Master & Slave servers
          o Use DDL to enable Master & Slave servers
          o Confirm replication status via DDLs, the process list and system table
          o Committ updates to the master server and confirm replication to the slave servers
          o Configure an additional slave server and confirm replication

    * Logging
          o Explain MySQL logging /ERROR|QUERY|BINARY|SLOW/
          o Discuss the default log file nomenclature
          o Explain & examine the contents of the ERROR log file
          o Restart MySQL and examine log entries
          o Enable the QUERY log file
          o Explain & examine the contents of the QUERY log file
          o Discuss the BINARY log file
          o Discuss the SLOW log file
          o Enable the SLOW log file
          o Use mysqlbinlog to examine the contents of binary logs

    * Win32 Integration
          o Connect to Windows 2003 host and download MySQL Administrator
          o Install MySQL Administrator
          o Connect to Linux-based MySQL instance and explore key variables
          o Download and install MySQL Query Browser
          o Explore Query Browser interface & features
          o Execute remote queries with Query Browser
          o Download & install MyODBC
          o Connect MS Access to MySQL using MyODBC
          o Import data into MS Access from MySQL
          o Link Tables in MS Access to MySQL using MyODBC

    * Storage Engines
          o Discuss the MyISAM storage engine
          o Explain the usages and limitations of the Memory storage engine
          o Confirm Memory storage engine support
          o Create memory-based tables using the Memory storage engine
          o Focus on the CSV storage engine
          o Confirm support for the CSV storage engine
          o Define CSV-based tables and evaluate results
          o Focus on the Federated storage engine
          o Explain the applications of remote tables using the Federated storage engine
          o Implement Federated tables and evaluate results
          o Focus on the Archive storage engine
          o Confirm support for the Archive storage engine
          o Describe the applications of compressed tables using the Archive storage engine
          o Implement compressed tables and evaluate results
          o Import data-set into compressed table and evaluate storage requirements
          o Focus on the InnoDB storage engine
          o Discuss the benefits /Transactional|Scalability/ of InnoDB-based tables
          o Confirm support for InnoDB tables
          o Explain InnoDB storage architecture and identify default data & log files
          o Update /etc/my.cnf configuration file to support InnoDB tables
          o Load large data-set and examine resulting data & log files
          o Define custom InnoDB data & log files
          o Extend the data & log files and evaluate results
          o Distribute data & log files across multiple partitions
          o Create a raw device for InnoDB data & log files
          o Define InnoDB data & log files on a RAW device

    * phpMyAdmin
          o Discuss the benefits and applications of phpMyAdmin
          o Install & configure Apache HTTPD
          o Download & install phpMyAdmin
          o Secure phpMyAdmin's access to MySQL DBMS
          o Explore phpMyAdmin's interface
          o Perform many shell-based queries, graphically

    * PHP5 Integration
          o Uninstall PHP 4.x
          o Download & install PHP 5.x packages & relevant modules /MySQL|SSL|etc./
          o Explore the PHP Command Line Interface (CLI)
          o Interface PHP CLI to MySQL & return results
          o Implement PHP->MySQL error handling using conditions & OO-functions
          o Execute useful PHP->MySQL methods
          o Define HTML forms
          o Process HTML forms using PHP
          o Store data in MySQL using PHP

[ 本帖最后由 leapApple 于 2009-1-22 11:57 编辑 ]

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?注册

x

本帖被以下淘专辑推荐:

回复

使用道具 举报

281

主题

2251

帖子

1万

金币

大家网博士生

Rank: 21Rank: 21Rank: 21

积分
10169

热心会员奖论坛活跃

发表于 2008-8-2 13:43 | 显示全部楼层
这个太好了,mysql 5的,期待,自然是期待

支持apple,发了这么多经典的linuxcbt的视频
回复 支持 反对

使用道具 举报

0

主题

20

帖子

44

金币

大家网小学一年级

Rank: 2Rank: 2

积分
23
发表于 2008-8-2 23:12 | 显示全部楼层
完美的版本,谢谢老大
回复 支持 反对

使用道具 举报

0

主题

1

帖子

21

金币

大家网幼儿园

Rank: 1

积分
1
发表于 2008-8-3 18:28 | 显示全部楼层
谢谢啊
回复 支持 反对

使用道具 举报

222

主题

1175

帖子

7298

金币

大家网研究生二年级

Rank: 19Rank: 19Rank: 19

积分
5756

社区建设奖创作大师解答高手优秀斑竹

 楼主| 发表于 2008-8-3 22:22 | 显示全部楼层
发布完成,可以下载了
回复 支持 反对

使用道具 举报

281

主题

2251

帖子

1万

金币

大家网博士生

Rank: 21Rank: 21Rank: 21

积分
10169

热心会员奖论坛活跃

发表于 2008-8-3 23:02 | 显示全部楼层
谢谢,非常感谢,分享这么好的视频

apple,永远支持你
回复 支持 反对

使用道具 举报

0

主题

1

帖子

26

金币

大家网幼儿园

Rank: 1

积分
5
发表于 2008-8-5 20:48 | 显示全部楼层
谢谢,非常感谢
回复 支持 反对

使用道具 举报

0

主题

3

帖子

30

金币

大家网幼儿园

Rank: 1

积分
7
发表于 2008-8-9 22:44 | 显示全部楼层

Need Help

Dear All,

Please can any one help me for finding password for this like?

ftp://210.51.180.252/bbs/tp05/co ... .TopSage.com%5D.iso

please help me, I need this CBT.
Thanking u,

Regards,
Vadiraj
please register my name.
回复 支持 反对

使用道具 举报

180

主题

5489

帖子

3万

金币

大家网博士后

Rank: 22Rank: 22Rank: 22Rank: 22

积分
27345
发表于 2008-8-10 07:58 | 显示全部楼层
原帖由 vadiraj 于 2008-8-9 22:44 发表
Dear All,

Please can any one help me for finding password for this like?

ftp://210.51.180.252/bbs/tp05/co ... .TopSage.com%5D.iso

please help me, I nee ...

it is not encrypted.
回复 支持 反对

使用道具 举报

0

主题

3

帖子

30

金币

大家网幼儿园

Rank: 1

积分
7
发表于 2008-8-10 16:52 | 显示全部楼层
Dear Sir,

When i am trying to download , I am getting this below mention error. Please help me.

i don't know password for the ftp link.

Internet Explorer cannot display the webpage
   
   Most likely causes:
You are not connected to the Internet.
The website is encountering problems.
There might be a typing error in the address.

   What you can try:
     Diagnose Connection Problems  

     More information

This problem can be caused by a variety of issues, including:

Internet connectivity has been lost.
The website is temporarily unavailable.
The Domain Name Server (DNS) is not reachable.
The Domain Name Server (DNS) does not have a listing for the website's domain.
If this is an HTTPS (secure) address, click Tools, click Internet Options, click Advanced, and check to be sure the SSL and TLS protocols are enabled under the security section.

For offline users

You can still view subscribed feeds and some recently viewed webpages.
To view subscribed feeds

Click the Favorites Center button , click Feeds, and then click the feed you want to view.

To view recently visited webpages (might not work on all pages)

Click Tools , and then click Work Offline.
Click the Favorites Center button , click History, and then click the page you want to view.


thanking u,

Regards,
Vadiraj
please register my name.
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则



诚聘英才|移动端|Archiver|版权声明|大家论坛 ( 京ICP备06071611号,京公网安备11010802018363号 )

GMT+8, 2018-10-15 21:55 , Processed in 0.346805 second(s), 29 queries .

Powered by Discuz!

© Comsenz Inc.

快速回复 返回顶部 返回列表