[Multi] CBT Nuggets - MySQL Database CMA 010-002 (2011) - Dhaka Mobile
 
Dhaka Mobile

Go Back   Dhaka Mobile > Fun, Games and Entertainment > PocketPC,SmartPhone,PALM,PDA Apps/Games
PocketPC,SmartPhone,PALM,PDA Apps/Games Post All PocketPC,Smart-Phone, Palm, PDA... Applications & Games Here
Forums by Category
Reply
 
Thread Tools Search this Thread Display Modes
Old 10-22-2011, 14:13   #1
ElMobd3
Newbie
 
Join Date: Oct 2011
Posts: 7
Status: Offline
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
ElMobd3 is on a distinguished road

[Multi] CBT Nuggets - MySQL Database CMA 010-002 (2011)


CBT Nuggets - MySQL Database CMA 010-002 (2011)



CBT Nuggets - MySQL Database CMA 010-002 (2010) | ISO | 871 MB

CBT Nuggets MySQL Database CMA 010-002
Series Overview
Setting Expectations. Understanding this Series. Tackling the MySQL Associate Exam.
268 00:16:52
2 What is MySQL?
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.
375 0006
3 Client/Server Concepts
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.
354 0054

4 Understanding Data Types
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.
323 00:42:17

5 Managing Databases Part 1
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.
256 00:39:16

6 Managing Databases Part 2
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.
170 0021

7 Managing Databases Part 3
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.
147 00:33:00

8 Managing Tables and Indexes Part 1
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.
176 00:40:29

9 Managing Tables and Indexes Part 2
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.
142 00:31:59

10 Implementing Constraints
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.
145 00:30:31

11 Using Views
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.
128 00:36:41

12 Data Manipulation Language (DML) Part 1
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.
131 00:30:49

13 Data Manipulation Language (DML) Part 2
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.
87 00:23:38

14 Data Manipulation Language (DML) Part 3
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 up****************************** existing row data by using the UPDATE DML statement.
89 0052

15 Data Manipulation Language (DML) Part 4
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.
60 00:11:25

16 Advanced DML Operations Part 1
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.
118 00:34:10

17 Advanced DML Operations Part 2
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.
117 00:22:18

18 Advanced DML Operations Part 3
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.
93 00:28:18

19 Managing Transactions
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.
146 00:35:11

20 Administering Data Import/Export
mporting Data from Files. Exporting Data from Files. Using mysqlimport and mysqldump. Relevant Exam objectives: Tools for Import/Export; SQL for Import/Export.




Code:
http://www.wupload.com/file/649306016/By_ElMobd3_-_xCBT Nuggets - MySQL Database CMA 010-002.part1.rar
http://www.wupload.com/file/649306036/By_ElMobd3_-_xCBT Nuggets - MySQL Database CMA 010-002.part2.rar
http://www.wupload.com/file/649306096/By_ElMobd3_-_xCBT Nuggets - MySQL Database CMA 010-002.part3.rar
http://www.wupload.com/file/649306056/By_ElMobd3_-_xCBT Nuggets - MySQL Database CMA 010-002.part4.rar

Code:
http://www.filesonic.com/file/2685173914/By_ElMobd3_-_xCBT Nuggets - MySQL Database CMA 010-002.part1.rar
http://www.filesonic.com/file/2685178404/By_ElMobd3_-_xCBT Nuggets - MySQL Database CMA 010-002.part2.rar
http://www.filesonic.com/file/2685173934/By_ElMobd3_-_xCBT Nuggets - MySQL Database CMA 010-002.part3.rar
http://www.filesonic.com/file/2685173604/By_ElMobd3_-_xCBT Nuggets - MySQL Database CMA 010-002.part4.rar
FileServe
Code:
http://www.fileserve.com/file/HkFmNcs
http://www.fileserve.com/file/juM86Ae
http://www.fileserve.com/file/twusG86
http://www.fileserve.com/file/eFQXzXk
Password: ElMobd3



* Please say Thank You if you liked my post !
** Search my posts to find more Stuff !
***Use Jdownloader to Download no need wait at 120 site!
**** For high speed and parallel downloads, you can buy premium account !

  Reply With Quote
Collapse Related threads at Dhaka Mobile
Thread Thread Starter Forum Replies Last Post
Free Multi calculator V1.0 Gsm-extreme Universal GSM Software 0 04-08-2013 16:29
23 Nov 2011 Micro-Box AIO V2.0.5.3 - MULTI UPDATE !! MANY MODELS ADDED :) M.Irfan Basic Micro-Box Software Support 0 11-23-2011 13:18
ATF 5.70 Multi-ATF Box Update anowar_virus Advance-Box 1 10-20-2010 14:18
Infinity-Box: Updated "Cables/Pinouts" database v1.50 released M.Irfan Infinity-Box 0 09-05-2010 21:02
Infinity-Box: Updated "Cables/Pinouts" database v1.50 released M.Irfan GSM News & Updates 0 09-05-2010 21:02

Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Resource
Service
Company
Clear Default Style - Mobile Style Clear
All times are GMT +1. The time now is 19:48.
Clear

Follow us below -

Copyright ©2010-2019. Dhaka Mobile
Registered trademark of vBulletin Solutions
An DHAKA MOBILE Company