Introduction to MySQL Development and Administration
Details
This MySQL Training course allows you to take advantage of the leading open source relational database management system that is extensively deployed around the world. MySQL runs on a variety of platforms, including UNIX/Linux, Windows and MacOS X. The combination of its low cost, ease of maintenance and high speed makes MySQL ideal for many application areas. This course provides a comprehensive introduction to the MySQL RDBMS.
You will learnhow to:- Understand the features and benefits of MySQL
- Understand the basics of relational databases
- Understand the SQL and MySQL languages
- Understand Data/Column types with regard to efficient database design
- View a database design structure
- Extract basic database information using the SELECT command
- Delete or modify a database
- Delete or modify table row data
- Grouping query data using aggregation
- Connect data from multiple table rows using JOIN
- Perform nested sub-queries
- Use simple functions (String, Date, Numerical)
- Backup and restore the database
- Understand the MySQL storage engines, transactions and concurrency
- Administer databases with native tools like MySQL Administrator and MySQL Query Browser
- Enhance database performance using stored procedures and triggers (NEW!)
Who Should Attend:
This course is valuable for anyone involved in administering and developing on a MySQL relational database management system (RDBMS). Basic familiarity with database concepts is helpful, but not essential.
Outline
- Introduction to MySQL
- Database Design Basics
- Normalization
- Data Definition Language
- Retrieving Data
- Inserting, Modifying and Deleting Data
- Working with Multiple Tables
- Advanced Queries
- Subqueries, Indexes, and Views
- MySQL Functions
- Concurency and Transactions
- MySQL Administration
- User Management and Access Privileges
- Backup and Restore
- Stored Procedures and Triggers
ActiveLearning, Inc. is the Philippines' leading provider of Information Technology and Project Management education, where thousands of students take courses from Application Development to Project Management to Network Security, and much more. Our courses are taught by expert instructors, and learning is enhanced through a blend of in-depth lectures, workshops, and hands-on exercises.
Expert Instructors
Learn from expert instructors who practice what they teach. Our instructors are involved in constant research and development, who constantly apply the lessons they teach, and who know the same technical issues you face every day.
Superior Courseware
Our courseware go through rigorous evaluation before they are released for instruction. By constantly monitoring industry developments, we make sure that you get course materials that are up to date.
Interactivity
More than just classroom lectures, practical, hands-on exercises are carefully developed for you to immediately put in to practice what you learn. By being immersed in a classroom setting, you get to participate, inquire, and be involved - all essential in expediting the learning process. Aspects you won't find in Computer-Based-Training and self-study. ...
Related Courses
