MySQL is a relational database engine. It lets you enter,
store and search tables of information. Those tables can "relate"
to each other, allowing a complex data set to be stored, and complex searches
made. The database engine does all the hard work of storing and formatting the
data for you - all you have to do is program the engine using the SQL language.
This course introduces you to the world of SQL database engines, and MySQL
in particular - the component parts of the SQL system and how they interact.
We study the SQL language (learning the MySQL flavour) and how it's used from
PHP, Perl and Java. We study administration of MySQL including user account
and security controls, and we study database design so that you'll be putting
together well thought-out, maintainable, expandable databases when you've concluded
this course.
What You Will Learn
Course Content
Course content has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus, or if you have a technical query email .
Duration
2 Days
Who Should Attend
Developers who are looking to gain the skills to develop commercial MySQL databases.
Prerequisite Skills
Good knowledge of your operating system.
Associated Courses
PHP Web Development
· Information organisations.
· What is a relational database?
· What are the parts of a relational database?
· What relational databases are there?
· MySQL, MySQL-Max and MySQL-GUI.
· What is MySQL?
· Why choose it?
· The structure of a database as seen by MySQL.
· SQL introduction.
· Databases, tables, fields, rows and columns.
· Field types and modifiers.
· Initial administration and error handling.
· Commands to enter and edit rows of data - Insert, replace and load.
· Enquiry (select) commands.
· Conditional clauses and writing conditions.
· Command to modify and delete rows.
· DROP, SHOW and others.
· Sources of SQL.
· The mysqld daemon process.
· How MySQL fits into your scheme - stand-alone clients.
· How MySQL fits into your scheme - Web users.
· The mysqladmin and mysql client programs.
· Managing user accounts and priviledges.
· Backing up your database.
· Table types MyIsam, Isam, Hash, InnoDb and BDB.
· Accessing mysqld from around your network
· Interfacing an SQL interface to applications.
· Relational database design.
· Data normalisation.
· First, second and third normal forms.
· Rules for a truly relational database.
· Password issues and other security matters.
· The DBI and DBD Modules (from Perl).
· Mysql.pm (from Perl).
· Using MySQL from PHP.
· JDBC and access to MySQL from Java.
· Accessing MySQL from a C Program.
· Connectivity from Tcl.
· Comparison of MySQL v other SQL engines.
· The MySQL Security Model.
· Login accounts, Access Right, Privilege Types.
· A Straightforward Example.
· Operating System level security - Ownerships and Permissions.
· Worked Example - setting up MySQL as an ISP.
· Configuration files and command line options.
· Running multiple daemons on one system through mysqld_multi.
· MySQL GUIs
· Database Structure.
· Introduction to SQL and MySQL.
· Principles of database programming from PHP.
· Creating tables.
· Adding and changing information.
· Retrieving information from a table and reporting it to a web page.
· Deleting tables.
· Using an alternative database - example Oracle (OCI) calls.
· Other databases and interfaces such as ODBC, Oracle, postgreSQL and
Sybase.
· The JDBC Interface.
· Driver managers and drivers.
· Type 1, 2, 3 and 4 drivers.
· How odbc, jdbc and SQL relate.
· Obtaining and installing JDBC drivers.
· Example - a MySQL jdbc driver class.
· Connection to a database in Java.
· Running enquiries against a relational database.
· Review - flat databases.
· Relational databases through SQL.
· Setting up the DBI and DBD modules.
· Connecting to an SQL server.
· Issuing an enquiry and reading back the results.
· Amending information in a database via SQL.
· Creating new tables.
· Database support including mySQL, Oracle, Sybase, Infomix.
· Interfacing Perl to the Access database.
· Using Tie to access a table as if it was a Perl Hash.
· MySQL table of authorised data editors.
· Administrator and editor login capability.
· Second MySQL table of data to be managed.
· Select and display system for any site visitors.
· Editing system for authorised editors using cookies and carts.
· Authorization through passwords, password edit capability.
· Ability to edit editor list for the administrator
|
|
|