- CBT Nuggets MySQL CMA Database Administrator Associate DVD
- Simple Computer Tune-up: Speed Up Your PC (Windows)
- Head First HTML with CSS & XHTML
- WordPress MU 2.8: Beginner’s Guide
- eZ Publish 4: Enterprise Web Sites Step-by-Step
- Foundation Joomla!
- Cisco 360 Learning Program for CCIE R&S – Lesson Troubleshooting
- Cartoon Smart Carousel Navigation Tutorial
- 870+ Java Mobile Games
- Train Signal CWNA Training |
Posted: 15 Jan 2010 01:54 PM PST
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.
By the time you’re done you’ll understand the following topics about MySQL Database Administrator Associate:
* Series Overview
* What is MySQL?
* Client/Server Concepts
* Understanding Data Types (free video!)
* Managing Databases Part 1
* Managing Databases Part 2
* Managing Databases Part 3
* Managing Tables and Indexes Part 1
* Managing Tables and Indexes Part 2
* Implementing Constraints
* Using Views
* Data Manipulation Language (DML) Part 1
* Data Manipulation Language (DML) Part 2
* Data Manipulation Language (DML) Part 3
* Data Manipulation Language (DML) Part 4
* Advanced DML Operations Part 1
* Advanced DML Operations Part 2
* Advanced DML Operations Part 3
* Managing Transactions
* Administering Data Import/Export
Here’s what you’ll learn in each video of the MySQL Database Administrator Associate series:
Video 1 – “Series Overview” – Setting Expectations. Understanding this Series. Tackling the MySQL Associate Exam
Video 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.
NVideo 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.
Video 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.
Video 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.
Video 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.
Video 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.
Video 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.
Video 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.
Video 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.
Video 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.
Video 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.
Video 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.
Video 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 updating existing row data by using the UPDATE DML statement.
Video 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.
Video 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.
Video 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.
Video 18 – “Advanced DML Operations Part 3″ – Why us 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” – 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” – Importing 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.
Posted: 15 Jan 2010 11:59 AM PST
Forgoing the “techie-talk,” CA explains how PC Pitstop Optimize performs four main functions: it removes “junk” files to free up disk space, adjusts Internet settings for better performance, removes invalid registry keys, and adjusts several registry settings that can
Posted: 15 Jan 2010 11:55 AM PST
O’Reilly | ( PDF | 658 pages | 059610197X
Tired of reading HTML books that only make sense after you’re an expert? Then it’s about time you picked up Head First HTML with CSS & XHTML and really learn HTML. You want to learn HTML so you can finally create those web pages you’ve always wanted, so you can communicate more effectively with friends, family, fans, and fanatic customers. You also want to do it right so you can actually maintain and expand your web pages over time, and so your web pages work in all the browsers and mobile devices out there. So what are you waiting for? Leave those other dusty books behind and come join us in Webville. Your tour is about to begin.
Posted: 15 Jan 2010 11:53 AM PST
300 pages | Packt Publishing (November 17, 2009) | ISBN: 1847196543 | PDF
Build your own blog network with unlimited users and blogs, forums, photo galleries, and more!
Posted: 15 Jan 2010 11:50 AM PST
300 pages | Packt Publishing (October 18, 2009) | ISBN: 1904811647 | PDF
Master eZ Publish’s flexible web development for the enterprise
Created specifically for newcomers to eZ Publish, and using an example Magazine web site, this book focuses on designing, building and deploying eZ Publish to create an enterprise site quickly and easily.
This tutorial takes eZ Publish’s steep learning curve head-on, and walks you through the process of designing and building content-rich web sites. It makes the unrivalled power and flexibility of eZ Publish accessible to all developers.
The book is organized around technical topics, which are handled in depth, with a general progression that follows the learning experience of the reader, and features a single magazine web site project from installation to completion and deployment. This hands-on guide helps the reader to understand the Content Management System to create a web 2.0-ready web site by creating new extensions or overriding the existing ones. In turn, it helps you to become confident when working in the eZ Publish administration area and offers an environment in which you can practice while working through the chapters.
What you will learn from this book?
Who this book is written for?
Even if you are not a PHP-guru, and you don’t want to study eZ Publish core functionality – this book is for you. In general, however, you’ll get more out of the book if you know a little PHP, have some concept of Object-Oriented Programming, and have a general familiarity with CMS concepts.
Posted: 15 Jan 2010 11:47 AM PST
Posted: 15 Jan 2010 11:18 AM PST
The centerpiece of this Lesson Module is the Troubleshooting video on demand (VoD) instruction. The split-screen format of each VoD module provides the powerful learning experience of shadowing a Cisco CCIE who is configuring and explaining a Troubleshooting process.
Duration: Seven Hours
Each VoD is approximately 15 30 minutes in length, and the approximately seven hours of VoD modules are grouped into three blocks. A set of supporting “Spot the Issues” soft assessment quizzes are included in each block. In addition, two hands-on, technology-focused practice labs on the subject of the Troubleshooting are available in this Lesson Module.
The Troubleshooting lesson is for professional-level networking engineers who have 3 5 years of network engineering experience or who have completed the Cisco CCNP certification. This self-paced Lesson Module is for engineers who need to master CCIE-level problems that involve:
* Formulating a structured and consistent troubleshooting process
Recommended Prerequisites and Corequisites
A CCNP level of understanding of network troubleshooting are required. It is also recommended that this lesson be completed with these lessons
* CCIE R&S Lesson: Data Link Layer Technologies
Lesson Module Objectives
Upon completion of this self-paced Lesson Module, learners should be able to formulate well-defined mental simulations to perform the following Troubleshooting tasks with the minimally described parameters that are commonly found in CCIE-level tasks.
* Formulate an end-to-end opening moves strategy for troubleshooting tasks
Lesson Module Outline
The VoDs in this Lesson Module discuss these topics:
* Block 1: Troubleshooting Tools and Techniques Introduction to Troubleshooting
This Lesson Module contains two hands-on labs that focus on the Troubleshooting topics in the VoDs. Learners must supply the lab equipment that is required to run the labs. Each of these hands-on, technology-focused scenarios consists of:
* A scenario written with CCIE-level troubleshooting tasks
The following minimal topology is required to perform the Troubleshooting Lesson Module labs.
Posted: 15 Jan 2010 02:05 AM PST
How to Program a Flash Rotating Carousel Gallery for Actionscript 2 and Actionscript 3
Posted: 15 Jan 2010 01:39 AM PST
These Are .jar Files. Only Java Supported Mobiles Can Play these games.
1 – Connect Mobile with PC.
Posted: 15 Jan 2010 12:07 AM PST
Interested in learning about wireless networking or preparing for CWNA certification? Then Train Signal's CWNA video training course is your one stop solution! With over 9 hours of video instruction, Train Signal's course will teach you wireless networking, administration, and security by watching the configuration of a real live network by your expert instructor! This is the proven "Total Experience" training Train Signal's students know and love!
|You are subscribed to email updates from Download Free Computer Ebooks - NET BOOKS |
To stop receiving these emails, you may unsubscribe now.
|Email delivery powered by Google|
|Google Inc., 20 West Kinzie, Chicago IL USA 60610|