v

您的位置:VeryCD教育计算机


《CBT Nuggets MySQL CMA认证数据库管理教程》(CBT Nuggets MySQL CMA Database Administrator Associate)[光盘镜像]

  • 状态: 精华资源
  • 摘要:
    发行日期2010年
    对白语言英语
    文字语言英文
  • 时间: 2010/09/30 20:05:43 发布 | 2010/10/01 13:28:33 更新
  • 分类: 教育  计算机 

xiaochenjia

精华资源: 673

全部资源: 675

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名CBT Nuggets MySQL CMA认证数据库管理教程
英文名CBT Nuggets MySQL CMA Database Administrator Associate
资源格式光盘镜像
发行日期2010年
地区美国
对白语言英语
文字语言英文
简介

IPB Image

资源简介

CBT Nuggets 出品的 MySQL CMA Database Administrator Associate 数据库管理员培训视频教程.

官网链接:http://www.cbtnuggets.com/series?id=508

教程名称:MySQL CMA Database Admin Associate——Covers Exam Packs 010-002

主讲人:Timothy L. Warner

教学时长:10个小时 共20个小节教程内容

如果你对开发和管理开源数据库应用程序有兴趣.MySQL是你的选择. Tim Warner的 "MySQL Administrator: Associate"系列教程是你获得MySQL基本要素最快的方法.

Tim''s 的视频教程是为你的MySQL Associate (CMA)认证考试而准备的. 演示了如何管理MySQL 数据库服务器。 对MySQL应用程序开发有个很好的入门介绍. 阐述了如何在任何一个平台下设计和建立关系型数据库......

If you''re interested in developing and administering open-source database applications, MySQL is your ticket to ride. And this "MySQL Administrator: Associate" training by Tim Warner is the fastest way to get your MySQL basics down pat.

Tim''s video series prepares you for the MySQL Associate (CMA) certification exam, shows you how to administer a MySQL database server, gives you an excellent intoduction to MySQL application development and explains how to design and build relational databases on any platform.
IPB Image



目录

What You'll Learn
Video 1: Series Overview|16:52
Setting Expectations. Understanding this Series. Tackling the MySQL Associate Exam.

Video 2: What is MySQL?|38:06
Understanding the Product. Reviewing MySQL Architecture. Relevant Exam Objectives: Client/Server Concepts; Database and Database Objects. In this nugget we learn this history of MySQL and review the underpinnings of the MySQL client/server technology.

Video 3: Client/Server Concepts|44:54
Using Client Applications. Accessing Help. Using MySQL Server Modes. Relevant Exam Objectives: Client/Server Concepts; Database and Database Objects; Recurring SQL Constructs. Description: In this nugget we familiarize ourselves with the myriad client applications used to access the MySQL Server. We also learn how to make use of online help, as well as to set the appropriate SQL mode to meet our specific business requirements.

Video 4: Understanding Data Types|42:17
Introducing Data Types. Using String, Numeric, and Date/Time Data Types. Implementing Data Types in Tables. Relevant Exam Objectives: Databases; Data Types; Tables. Description: In this nugget we learn the data types that are supported by MySQL 5.x. We also learn how to use data types in the creation of table columns.

Video 5: Managing Databases Part 1|39:16
Planning Databases. Creating databases. Relevant Exam Objectives: Databases; Data Types; Tables. Description: In this nugget we learn some of the principles the underlie database design. We also learn how to create database objects in MySQL.

Video 6: Managing Databases Part 2|27:21
Altering Databases. Database Administration Statements. Relevant Exam Objectives: Databases; Data Types; Tables. Description: In this nugget we learn how to alter the structure of schema (database) objects in MySQL. We also begin to develop stronger skills with administrator-specific SQL commands in MySQL Server.

Video 7: Managing Databases Part 3|33:00
Dropping Databases. Accessing Database Metadata. Relevant Exam Objectives: Databases; Data Types; Tables. Description: In this nugget we learn how to permanently decommission databases by dropping them from the server. We also learn how to access metadata, or data about data, for all objects in our MySQL server instance.

Video 8: Managing Tables and Indexes Part 1|40:29
Setting Table Properties. Creating Tables. Altering Tables. Dropping Tables. Relevant Exam Objectives: Tables; Constraints and Indexes; Adding data; Modifying data; Removing data; Searching data. Description: In this nugget we learn all aspects of table management in MySQL Server: creating, altering, and dropping table objects, as well as configuring table properties.

Video 9: Managing Tables and Indexes Part 2|31:59
Understanding Indexes. Creating and Managing Indexes. Checking Index . Operation with EXPLAIN. Relevant Exam Objectives: Tables; Constraints and Indexes; Adding data; Modifying data; Removing data; Searching data. Description: In this nugget we delve into what is probably the number one factor in optimizing query performance in any relational database system: the index. Here we understand indexing theory, and then learn how to create and manage indexes in MySQL. Finally, we use the EXPLAIN keyword to parse query execution plans to fine-tune index and query performance.

Video 10: Implementing Constraints|30:31
Handling Invalid Data Values. Can We Use CHECK Constraints? Implementing Table Constraints. Relevant Exam Objectives: Tables; Constraints and Indexes; Adding data; Modifying data; Removing data; Searching data. Description: In this nugget we understand the various and sundry ways that we can configure MySQL to handle missing and/or invalid data values. We also answer the question "Does MySQL Server support the CHECK constraint for table columns?" Finally, we learn how to implement table constraints such as NULL, DEFAULT, and the creative selection of data types for table columns.

Video 11: Using Views|36:41
Why Use Views? Creating and Managing Views. Obtaining View Metadata. Relevant Exam Objectives: Views; Recurring SQL Constructs; Constraints and Indexes; Tables. Description: In this nugget we learn what views are, how to use them, and how to create them in MySQL. We also learn how to obtain view metadata by using both the SHOW and DESCRIBE commands as well as the INFORMATION_SCHEMA views.

Video 12: Data Manipulation Language (DML) Part 1|30:49
Introducing the SELECT Statement. Customizing Column Retrieval. Customizing Row Retrieval. Relevant Exam Objectives: Searching data. Description: In this nugget we begin a detailed consideration of DML SQL commands, beginning with the SELECT statement.

Video 13: Data Manipulation Language (DML) Part 2|23:38
Adding New Records with the INSERT Statement. Using the REPLACE Statement. Relevant Exam Objectives: Adding data. Description: In this nugget we build upon what we learned in the previous nugget by learning how to add new records to a MySQL database table or view by using the INSERT DML statement.

Video 14: Data Manipulation Language (DML) Part 3|27:52
Modifying Existing Records with the UPDATE Statement. Preventing Dangerous Table Updates. Performing Multi-Table Updates. Relevant Exam Objectives: Modifying data. Description: In this nugget we continue to hone our SQL skills by learning how to updating existing row data by using the UPDATE DML statement.

Video 15: Data Manipulation Language (DML) Part 4|11:25
Removing Records with the DELETE Statement.Emptying a Table with the TRUNCATE TABLE Statement. Relevant Exam Objectives: Removing data. Description: In this nugget we conclude our four-part basic DML mini-series by learning how to delete data from MySQL database tables using both the DELETE and TRUNCATE TABLE statements.

Video 16: Advanced DML Operations Part 1|34:10
Understanding Expressions in MySQL.Using Expressions.Deploying Commenting in SQL Code. Relevant Exam Objectives: Expressions; Grouping and Aggregate Functions. Description: In this nugget we begin to work with some more advanced Data Manipulation Language (DML) commands. Here we work with SQL expressions and commenting, the former allowing us to extend the logic of our SQL code, and the latter allowing us to make our code more user-friendly.

Video 17: Advanced DML Operations Part 2|22:18
Aggregating Query Results. Grouping Query Results, Understanding the HAVING Clause. Relevant Exam Objectives: Expressions; Grouping and Aggregate Functions. Description: In this nugget we learn to group and aggregate our query results. Doing so enables us to produce subtotals, grand totals, and other data manipulations that are useful in many business scenarios.

Video 18: Advanced DML Operations Part 3|28:18
Why use Table Joins? Defining Inner Joins. Defining Outer Joins. Relevant Exam Objectives: Joining Tables. Description: In this Nugget we master a crucial concept in relational database theory--the table join. Table joins allow us to extend queries across two or more related tables, and also allow us to perform multi-table updates and deletes. Here we learn to create inner joins and outer joins in MySQL.

Video 19: Managing Transactions|35:11
Understanding Transactions. Controlling Transactions with the InnoDB Storage Engine. Relevant Exam Objectives: Transaction Concepts; SQL for Working with Transactions. Description: In this nugget we focus on the transactional support offered by the MySQL InnoDB storage engine. After a thorough grounding in database transaction theory, we turn to how we can control transactions in MySQL using InnoDB features.

Video 20: Administering Data Import/Export|31:14
mporting Data from Files. Exporting Data from Files. Using mysqlimport and mysqldump. Relevant Exam Objectives: Tools for Import/Export; SQL for Import/Export. Description: In this Nugget we leverage business intelligence (BI) features of MySQL and learn the many ways to export data from MySQL tables and also import data into the same.

代码


.do-"""""'-o.. *
.o"" "".. ***
,,'' ``b. *
d' ``b
d`d: `b. ***
,,dP `Y. ***
d`88 `8. **
8`88' `8 **
Y:d8P 8, **
P,88b ,`8 **
::d888, ,8:8. **
dY88888 `' :: **
8:8888 `b *** *
Pd88P',... ,d888o.8 ***
:88'dd888888o. d8888`88:
,:Y:d8888888888b ,d88888:88:
:::b88d888888888b. ,d888888bY8b ***** * **
b:P8;888888888888. ,88888888888P ****** ** **** *
8:b88888888888888: 888888888888' ** * * ** ****
8:8.8888888888888: Y8888888888P * * * ** * *
YP88d8888888888P' ""888888"Y * * ** *
:bY8888P"""""'' : ** ** ** *
8'8888' d ** ** ** *
:bY888, ,P ** ** ** *
Y,8888 d. ,- ,8' ** ** ** *
`8)888: ' ,P' ** ** ** *
`88888. ,... ,P * ** ***
`Y8888, ,888888o ,P * ***
Y888b ,88888888 ,P' **** **
`888b ,888888888 ,,' * *****
`Y88b dPY888888OP :' * **
:88.,'. `'` p *
)8P, ,b ' . **
:p d,'d`b, ,8
. dP' d8': ,
'8P" d8P' 8 - p *****
d,' ,d8' '' : ******
iNK H0RN Presents .. d' 8P' d' '; ** * * **
,: `' d p. * * * **** *
,dooood88: , ,d `` `b. * * ****
.o8"'""""""Y8.b 8 `"'' .o' ` """ob. ** ** * **
dP' `8: K dP'' "`Yo. ** ** *
dP 88 8b. ,d' ``b ** *****
8. 8P 8""' `" :. ** ** ***
:8: :8' ,: :: ** ** ***
:8: d: d' :: * ** ***
:8: dP ,,' :: * ***
`8: :b dP ,, :: **** ***
,8b :8 dP ,, d * ***** *** *
:8P :8dP d' d 8 * *** ***
:8: d8P d' d88 :P *
d8' ,88' ,P ,d888 d' **
88 dP' ,P d8888b 8
,8: ,dP' 8. d8''88' :8
:8 d8P' d88b d"' 88 :8
d: ,d8P' ,8P""". 88 :P
8 ,88P' d' 88 :8
,8 d8P 8 Rls Date : 15/01/10 88 :8
d: 8P ,: Type : Tech Bookware :88 :8
8',8:,d d' Supplier : iNK H0RN :8: :8
,8,8P'8' ,8 Disks : 1 DVD 8' :8
:8`' d' d' Archive : i-cbtnsqlcmadaa 8' p:
`8 ,P :8 # Files : 15 x 50 MB :8: p:
8, ` d8. :8: 8:
:8 d88: d8: 8
`8, d8888 88b 8
88 ,d::888 888 Y:
YK,oo8P :888 888. `b
`8888P :888: ,888: Y,
``'" `888b :888: `b
8888 888: ::
8888: 888b Y.
8888b :888 `b
88888. `888, Y

dPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPd

: CBT Nuggets - MySQL CMA Database Administrator: Associate,

PdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdP

: DESCRIPTION

If you're interested in developing and administering open-source
database applications, MySQL is your ticket to ride. And this "MySQL
Administrator: Associate" training by Tim Warner is the fastest way
to get your MySQL basics down pat.

Tim's video series prepares you for the MySQL Associate (CMA)
certification exam, shows you how to administer a MySQL database server,
gives you an excellent intoduction to MySQL application development and
explains how to design and build relational databases on any platform

http://cbtnuggets.com/webapp/product?id=508

PdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdP

Interested in joining iNK ? We're currently looking to expand.

: Suppliers - Bookware / Training / Apps
: Suppliers - Online Subscription Accounts
: Suppliers - MCT / MCSE Access
: Other - Cracking / Scripting / Coding Skills

Email - inkhorn@hushmail.com

dPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPd
8 8
8 8
8 : INSTALLATION 8
8 8
8 a. Extract 8
8 b. Mount/Burn 8
8 c. Play & Learn 8
8 8
8 8
PdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdPdP

: RESPECT DUE

DDUiSO .. JGTiSO .. AG .. CFE .. LiBiSO


IPB Image
引用
资源来自网络收集 未经过一一的质量 安全等检测
只是把收集的资源和各位驴友分享 仅作网络学习交流使用 请勿用于商业用途 !
希望各位下载的驴友能多多参与分流保源 happy.gif

正在读取……

这里是其它用户补充的资源(我也要补充):

暂无补充资源
正在加载,请稍等...

点击查看所有25网友评论

 

(?) [公告]留口水、评论相关规则 | [活动]每日签到 轻松领取电驴经验

    小贴士:
  1. 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  2. 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  3. 勿催片。请相信驴友们对分享是富有激情的,如果确有更新版本,您一定能搜索到。
  4. 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
  5. 如果您发现自己的评论不见了,请参考以上4条。