{"id":467,"date":"2015-10-12T09:12:45","date_gmt":"2015-10-12T09:12:45","guid":{"rendered":"http:\/\/www.quartzbd.com\/?post_type=product&p=467"},"modified":"2015-10-12T09:12:45","modified_gmt":"2015-10-12T09:12:45","slug":"linuxcbt-dbms-edition-feat-mysql-5","status":"publish","type":"product","link":"http:\/\/www.quartzbd.com\/?product=linuxcbt-dbms-edition-feat-mysql-5","title":{"rendered":"LinuxCBT DBMS Edition feat. MySQL 5"},"content":{"rendered":"
\n

LinuxCBT MySQL Edition<\/h1>\n<\/div>\n

 <\/p>\n

 <\/p>\n

\n
\"\"<\/a><\/div>\n
LinuxCBT MySQL Edition<\/b>
\n<\/i><\/div>\n

MySQL – DBMS<\/p>\n

MySQL Installation
\nIntroduction to MySQL 5
\nDiscuss DBMS system specifications
\nIdentify existing MySQL-installed components
\nExplore file-system layout
\nIdentify & discuss the various downloadable formats \/source|binary|packaged\/
\nDownload MySQL packages to a local repository
\nDiscuss the key DBMS components
\nConfirm md5sums of components
\nInstall MySQL server package and examine defaults
\nIdentify key server-side administrative utilities
\nInspect the contents of the default DBMS data-directory
\nInstall MySQL Client package and explore its contents<\/p>\n

Terminal Monitor Shell Client
\nDiscuss Terminal Monitor concepts
\nExplain the default privileges configuration
\nConnect to the DBMS using anonymous privileges
\nExplore Terminal Monitor’s help facility and useful escape sequences
\nIdentify the default schemas
\nExecute useful SQL functions
\nDemonstrate how to execute SQL queries from the shell in non-interactive mode<\/p>\n

User Administration
\nIdentify the currently logged-in user
\nConnect to MySQL DBMS as root and explore the interface
\nAttempt to connect to the DBMS as invalid users and discuss the results
\nAttempt to connect from a remote host and evaluate results
\nDiscuss the primary methods of tightening the default security scheme
\nTighten the default privileges for the root user
\nExplore the global ‘user’ grant table & discuss attributes
\nSecure anonymous user accounts
\nRemove anonymous privileges and confirm enhanced security policy
\nDiscuss and explore the grant tables and applicable attributes
\nIdentify the ancillary grant tables that permit granular filtration
\nCreate new DBMS users and confirm connectivity
\nRemove superfluous user accounts
\nDiscuss permissible host values when defining users
\nCreate remote super users and test connectivity
\nDiscuss privileges scopes concepts & applications
\nIdentify grant tables related to privileges scopes
\nUse GRANT to create and manipulate user-privileges
\nCreate unprivileged accounts and explore capabilities
\nUse REVOKE to remove privileges
\nUse DROP to discard superfluous accounts
\nMaintain user passwords using SET and UPDATE<\/p>\n

Show Commands & Options Files
\nExplain the usages of key SHOW commands
\nExpose DBMS privileges for currently authenticated user
\nExpose DBMS privileges for other defined users
\nList all databases available on the system
\nShow the DDL statements used to create various MySQL-managed databases
\nExamine the default supported character sets
\nReveal the structure of defined tables
\nShow the DDL statements used to create various tables
\nList the supported Storage Engines by the current binary-build of MySQL
\nExamine the MyISAM Storage Engine tables on the file system & discuss key file types
\nShow the schemas of various tables and discuss the results
\nExamine the currently executing processes, including connected users
\nInitiate & KILL connections listed in the process-list table
\nExamine key status variables on the running server
\nShow table status information, revealing used-space, length, create-time, etc.
\nDiscuss the default search-path for options files by MySQL clients
\nExamine and secure the MySQL history file to prevent superfluous disclosure of queries
\nDefine a personal MySQL options file
\nExplain the supported section headers in MySQL options files
\nDefine useful run-time directives for MySQL clients and examine results
\nDefine a useful, custom MySQL prompt on a global and per-user basis & examine usefulness
\nSet default database variable in per-user options files and examine results<\/p>\n

Key MySQL Client Utilities
\nFocus on mysql terminal monitor utility
\nDiscuss & demonstrate mysql client modes
\nDiscuss command-line option types
\nOutput queries to standard \/HTML|XML|TXT\/ formats
\nExclude column-headers from output for easy import into other applications
\nUse options file to control startup variables
\nFocus on mysqladmin utility
\nCompare & contrast mysqladmin batch-mode to mysql interactive mode
\nConfirm the status of DBMS servers using mysqladmin
\nAscertain remote DBMS process list
\nCreate & drop remote databases using mysqladmin
\nAdminister remote user credentials using mysqladmin
\nFocus on mysqldump utility
\nDiscuss mysqldump applications, features & benefits
\nDump all databases and related objects to an ASCII text backup file
\nExamine the resulting dump file
\nDump select databases and examine resulting file
\nDumpy DBMS databases to a remote MySQL instance using mysqldump
\nFocus on mysqlimport utility
\nCreate database container and table structure for subsequent imports
\nCreate matching data-feed for import by mysqlimport
\nImport data-feed using default delimiters and record-separators
\nDiscuss mysqlimport defaults regarding data-directory and table names
\nExamine importing duplicate records<\/p>\n

Key Data Manipulation Language (DML) Statements
\nDiscuss common DML statements
\nFocus on SELECT DML statement
\nOptimize SELECT statements with WHERE clauses to define criteria
\nDiscuss SELECT operators \/=|<=|>=|!=|etc\/
\nPerform pattern matching using WHERE clause with LIKE operator & wildcards
\nInfluence the order of SELECT output using ORDER BY
\nExtend criteria definition and optimize queryies using AND clause
\nReturn result-set INTO output ASCII text file using SELECT INTO
\nRedirect result-set to AWK and extract interesting fields
\nUse LIMIT with SELECT to return n number of rows
\nReturn total number of rows including LIMIT value
\nAlias column headers using SELECT
\nConcatenate results returned using SELECT
\nFocus on INSERT DML statement
\nExplain supported INSERT statements \/VALUES|SET|SELECT\/
\nDescribe table structure to determine column constraints
\nINSERT VALUES specifying column names
\nINSERT VALUES one-to-one without defined column headers
\nUse SET with INSERT to indicate interesting columns
\nUse VALUES to INSERT multiple rows in one statement
\nDiscuss INSERT SELECT applications
\nCreate table structure for using INSERT SELECT
\nPopulate newly-created table with data
\nUse SELECT INSERT to move data between tables & evaluate results
\nFocus on UPDATE DML statement
\nPerform global table UPDATE with simple DML statement
\nSpecify columns to be updated and evaluate affected rows
\nUPDATE interesting rows using criteria
\nUPDATE n number of records using the LIMIT criteria operator
\nFocus on DELETE DML statement
\nRemove interesting records using WHERE clause and applicable critieria
\nIntro to the ALTER Data Definition Language (DDL) statement<\/p>\n

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

Key Data Definition Language (DDL) Statements
\nFocus on CREATE DDL statement
\nDescribe how MySQL maps database containers to the file system
\nCREATE DATABASE container to house new tables
\nDefine the requirements \/auto_increment|primary key|etc\/ of new base tables
\nDefine the CREATE TABLE syntax for new base tables based on selected data types
\nExecute statement and evaluate results of recently-created tables
\nUse SHOW CREATE TABLE to examine DDL syntax for reference
\nCREATE TABLE with NOT-NULL column enforcements
\nPopulate tables with useful values and evaluate results
\nINSERT VALUES with DEFAULT for auto-populated columns and evaluate results
\nDuplicate table structure using CREATE TABLE and evaluate results
\nPopulate destination table with data from the source table using INSERT
\nDiscuss Temporary tables features and applications
\nCREATE TEMPORARY TABLES and populate with useful data
\nRename tables using RENAME TABLE as an alternative to ALTER TABLE
\nFocus on DROP DDL statement
\nDescribe the objects that are affected using DROP
\nDROP DBMS objects and evaluate file system implications
\nFocus on CREATE INDEX DDL statement
\nDiscuss the importance of indexes to improved data-retrieval
\nDiscuss MyISAM storage engine per-index limits
\nIdentify default MyISAM index files
\nExplore defined indices
\nDefine UNIQUE indices
\nCompare & contrast table & index storage requirements
\nGenerate data-set to be imported into an indexed column
\nCompare & contrast query-execution times with and without indices<\/p>\n

JOINS
\nDiscuss the features & benefits of using JOINS to access normalized data
\nNormalize the data structure, using ALTER TABLE, to prepare for using joins
\nUse seq to generate normalized data and import using mysqlimport
\nDiscuss the various types of supported JOINS \/EQUI|NATURAL|LEFT|RIGHT|INNER|OUTER\/
\nDefine and execute EQUIJOINS
\nDefine and execute NATURAL JOINS
\nDefine JOINS using fully-justified DBMS object names
\nUse table and column aliases with JOINS<\/p>\n

VIEWS & TRIGGERS
\nDiscuss the features & benefits of using VIEWS
\nUse DESCRIBE to identify interesting VIEW candidate-columns
\nExplain VIEW-creation syntax
\nCreate useful VIEWS and evaluate results
\nCreate VIEWS using column-aliases
\nUpdate VIEWS using CREATE OR REPLACE VIEW & ALTER VIEW
\nCreate VIEWS based on EQUIJOINS
\nDemonstrate how to UPDATE base-table data using VIEWS
\nRemove superfluous VIEWS using DROP VIEW
\nFocus on TRIGGERS
\nDiscuss MySQL’s TRIGGER implementation rules
\nDiscuss TRIGGER timing & events
\nDiscuss TRIGGER statements
\nDefine a TRIGGER to update a secondary table upon INSERT INTO primary table
\nINSERT INTO primary table and examine TRIGGER response
\nLog table updates using TRIGGERS
\nUse SHOW to reveal defined TRIGGERS ON tables
\nCreate & evaluate multiple statement triggers using BEGIN .. .END
\nRedefine MySQL statement delimiters to support multiple statement triggers<\/p>\n

Stored Routines (Functions & Procedures)
\nDiscuss Stored Routines components and applications
\nFocus on Stored Procedures
\nDiscuss required privileges
\nExplain how to invoke stored procedure
\nDefine useful stored procedures
\nUse SHOW to reveal stored procedures and important attributes
\nCreate multiple statement stored procedures
\nRedirect stored procedure output to memory for easy reuse
\nFocus on Functions
\nDiscuss ideal uses for functions
\nDescribe function syntax
\nDefine functions based on date calculations and evaluate results<\/p>\n

Replication Configuration
\nExplore uses of replication
\nIllustrate MySQL Master-Slave replication model
\nDiscuss binary logging requirements
\nUpdated configuration on Master & Slave servers to reflect replicaiton requirements
\nCreate replication accounts on Master & Slave servers
\nCreate a snapshot of the master server’s databases
\nTransport the snapshot to slave servers using SCP
\nRecord replication position
\nConfigure server IDs on Master & Slave servers
\nUse DDL to enable Master & Slave servers
\nConfirm replication status via DDLs, the process list and system table
\nCommitt updates to the master server and confirm replication to the slave servers
\nConfigure an additional slave server and confirm replication<\/p>\n

Logging
\nExplain MySQL logging \/ERROR|QUERY|BINARY|SLOW\/
\nDiscuss the default log file nomenclature
\nExplain & examine the contents of the ERROR log file
\nRestart MySQL and examine log entries
\nEnable the QUERY log file
\nExplain & examine the contents of the QUERY log file
\nDiscuss the BINARY log file
\nDiscuss the SLOW log file
\nEnable the SLOW log file
\nUse mysqlbinlog to examine the contents of binary logs<\/p>\n

Win32 Integration
\nConnect to Windows 2003 host and download MySQL Administrator
\nInstall MySQL Administrator
\nConnect to Linux-based MySQL instance and explore key variables
\nDownload and install MySQL Query Browser
\nExplore Query Browser interface & features
\nExecute remote queries with Query Browser
\nDownload & install MyODBC
\nConnect MS Access to MySQL using MyODBC
\nImport data into MS Access from MySQL
\nLink Tables in MS Access to MySQL using MyODBC<\/p>\n

Storage Engines
\nDiscuss the MyISAM storage engine
\nExplain the usages and limitations of the Memory storage engine
\nConfirm Memory storage engine support
\nCreate memory-based tables using the Memory storage engine
\nFocus on the CSV storage engine
\nConfirm support for the CSV storage engine
\nDefine CSV-based tables and evaluate results
\nFocus on the Federated storage engine
\nExplain the applications of remote tables using the Federated storage engine
\nImplement Federated tables and evaluate results
\nFocus on the Archive storage engine
\nConfirm support for the Archive storage engine
\nDescribe the applications of compressed tables using the Archive storage engine
\nImplement compressed tables and evaluate results
\nImport data-set into compressed table and evaluate storage requirements
\nFocus on the InnoDB storage engine
\nDiscuss the benefits \/Transactional|Scalability\/ of InnoDB-based tables
\nConfirm support for InnoDB tables
\nExplain InnoDB storage architecture and identify default data & log files
\nUpdate \/etc\/my.cnf configuration file to support InnoDB tables
\nLoad large data-set and examine resulting data & log files
\nDefine custom InnoDB data & log files
\nExtend the data & log files and evaluate results
\nDistribute data & log files across multiple partitions
\nCreate a raw device for InnoDB data & log files
\nDefine InnoDB data & log files on a RAW device<\/p>\n

phpMyAdmin
\nDiscuss the benefits and applications of phpMyAdmin
\nInstall & configure Apache HTTPD
\nDownload & install phpMyAdmin
\nSecure phpMyAdmin’s access to MySQL DBMS
\nExplore phpMyAdmin’s interface
\nPerform many shell-based queries, graphically<\/p>\n

PHP5 Integration
\nUninstall PHP 4.x
\nDownload & install PHP 5.x packages & relevant modules \/MySQL|SSL|etc.\/
\nExplore the PHP Command Line Interface (CLI)
\nInterface PHP CLI to MySQL & return results
\nImplement PHP->MySQL error handling using conditions & OO-functions
\nExecute useful PHP->MySQL methods
\nDefine HTML forms
\nProcess HTML forms using PHP
\nStore data in MySQL using PHP<\/p>\n

Explore Additional MySQL Utilities
\nUse MySQLShow to return useful data
\nUse MyISAMCheck & MySQLCheck
\nCompare and contrast both utilities<\/p>\n

MySQL with SSH Tunnel
\nDiscuss benefits
\nImplement SSH tunnel
\nUse MySQL utilities across secure tunnel
\nEvaluate results<\/p>\n

MySQL on Windows Server
\nInstall MySQL
\nExplore configuration
\nCommunicate between Linux & Windows
\nTransfer data between Linux & Windows
\nImplement MySQL Workbench
\nEvaluate results<\/p>\n

MySQL Instances
\nDiscuss features & benefits
\nConfigure multiple instances
\nTransfer data
\nEvaluate results<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

Delivery system
\n===============
\nFace to face from our office
\nDownload from Dropbox link
\nCourier Service
\nPayment system
\n==============
\nFace to Face
\nbkash-01716197088<\/p>\n

Contact
\n========
\n01919197088
\n01716197088-bkash
\n01552551768-office
\nqrtzcom@gmail.com
\nwww.quartzbd.com
\nwww.facebook.com\/quartz.bd<\/p>\n","protected":false},"featured_media":468,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_cat":[54,62],"product_tag":[],"class_list":{"0":"post-467","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-all-video-tutorials","7":"product_cat-linuxcbt","9":"first","10":"instock","11":"shipping-taxable","12":"purchasable","13":"product-type-simple"},"_links":{"self":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/product\/467"}],"collection":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/product"}],"about":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=467"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/media\/468"}],"wp:attachment":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=467"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_cat&post=467"},{"taxonomy":"product_tag","embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_tag&post=467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}