Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


This course is designed for people who are familiar with the Windows environment and any Office productivity application, and who wish to acquire competency in performing basic database operations and administration using the MySQL RDBMS.


 
Course Outline
Storing and accessing data are part of a person's day-to-day activities. One of the most efficient and powerful ways of managing data is by using databases. Information can be stored, linked, and managed using a database application such as MySQL 5.1. In the Fundamentals of Databases Using MySQL course, you will work with the databases using MySQL.

Course Objective

You will work with databases by identifying the fundamental concepts of databases, creating a preliminary database design, applying normalization techniques, and familiarizing yourself with relational database management systems. Using various SQL commands, indexes, and views, you can work with and modify data efficiently within a database. Using features such as Enterprise Monitor and MySQL Administrator, you can manage users and administer and monitor a database.

Target Student

This course is designed for people who are familiar with the Windows environment and any Office productivity application, and who wish to acquire competency in performing basic database operations and administration using the MySQL RDBMS or various similar SQL-based RDBMS products. The other student profile would be IT systems managers who will be working within a MySQL RDBMS-based enterprise IT department and need to interact in a productive manner with MySQL RDBMS technical professionals. It can also be used by students who wish to gain familiarity with database system terminologies and usage so as to pursue a career as a MySQL RDBMS technical professional.

Objectives

Upon successful completion of this course, students will be able to:
  • identify the fundamental concepts of databases and explore the MySQL RDBMS interface elements.
  • create a preliminary database design.
  • apply normalization techniques to a database.
  • use SQL commands to execute simple queries.
  • use SQL compound statements to query efficiently.
  • manage databases by creating views, indexes, and transactions.
  • administer and maintain a database.
Outline

Lesson 1: Familiarizing Yourself with the Fundamentals of Databases

  • Topic 1A: Identify the Database Development Life Cycle
  • Topic 1B: Explore the MySQL RDBMS
Lesson 2: Creating a Preliminary Database Design
  • Topic 2A: Analyze Database Requirements
  • Topic 2B: Identify Key Fields
  • Topic 2C: Create Entity Relationship Diagrams
Lesson 3: Applying Normalization Techniques
  • Topic 3A: Normalize Tables
  • Topic 3B: Denormalize Tables
Lesson 4: Using the SQL Commands to Work with Tables
  • Topic 4A: Discuss Structured Query Language (SQL)
  • Topic 4B: Create Tables Using the Data Definition Language (DDL) Commands
  • Topic 4C: Modify Data Using Data Manipulation Language (DML) Commands
Lesson 5: Working with Databases
  • Topic 5A: Use SQL Compound Statements
  • Topic 5B: Create Triggers
Lesson 6: Managing Databases
  • Topic 6A: Create Indexes
  • Topic 6B: Create Views
  • Topic 6C: Create Transactions
Lesson 7: Administering a Database
  • Topic 7A: Perform Database Administration
  • Topic 7B: Perform Backup and Recovery



 
Prerequisites & Certificates
Pre-Requisites

To be successful in this course, you should have some familiarity with the Microsoft Windows environment, Microsoft Office applications, or similar office productivity applications. The following ON-TRACK Computer Training courses or equivalent experience is suggested: - Introduction to Personal Computers: Using Windows Vista - Windows XP Professional: An Introduction In addition, some experience with a programming language such as C++ is helpful but not required. The following ON-TRACK Computer Training course or equivalent experience is suggested: - Introduction to Programming Using C++

Certificates offered


Cancellation Policy
Should you postpone or cancel your course you must give 5 business days notice.
Map & Reviews
On Track Computer Training
[ View Provider's Profile ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
I thought the training was extremely helpful.
Reviewed by 2014
It was a very informative course and the instructor was awesome! The only thing I would change would be the positioning of the projector because I couldn't see everything that was going on.
Reviewed by 2014
I would like to see the course separated into categories: Effective Minute Taking: Beginner; Effective Minute Taking: Intermediate; Effective Minute Taking: Advanced. There was a wide variety of skill levels in the course and it dragged for the more experienced participants because of reviewing information that was fairly basic. Overall the course was worthwhile and I certainly did take away some good pointers.
Reviewed by 2014
the organization had no environment consciousness using Styrofoam and not being able to tell me where paper recycling was. The invoice didn't have the times of the seminar which is extremely annoying as I need for PD hours purposes. The end time listed on their site said 4:30? but the instructor said usually 3:30 - 4 so that would be better. Maybe they are trying to seem longer for value purposes but thank goodness it ended at 4. The instructor was not inspiring. I know, coding is the most exciting subject yet I have been to other workshops that was entertaining on way dryer subjects. maybe if he showed some of the capabilities at the beginning to amaze the class it would have helped to motivate the learning of the basic code which by the way the entire morning can be fond in a 15 minute you tube video. If you are looking for cheap PD and you bring something else to do (I had my iPad)and have low expectations then...actually, no I am sure you can find something else.
Reviewed by 2013
Other students slowed down the course, not the instructors fault.
Reviewed by 2013
Beverly was wonderful. My only feedback would be that this should be a 2 day coarse or there should be an "Advanced Communication Skills" workshop.
Reviewed by 2013
Instructor was extremely patient and understanding with a room full of different levels. He explained well and added humour to a long day - thank you!
Reviewed by 2013
Excellent instructor. The location of the facility is difficult to find as there are few street addresses on Georgia. A note stating it is in the bank building would have been helpful.
Reviewed by 2013
Instruction seemed rather disjointed. Instructor's focus could have been better, along with his preparation. First off he couldn't get the projector to work, then couldn't find the examples he wanted to show. When asked a question, he veered off topic and then it was difficult to get back on track.
Reviewed by 2013
Only suggestion I would make it that more time should be spent on some aspects to ensure everyone has a complete grasp of the concepts. Some attendees had difficulty in keeping up with the instructor's coverage of the material.
Reviewed by 2013
The class was a good size to encourage questions and discussion. The instructor was very good at assessing the knowledge and experience of the class and shaped the instruction accordingly (the other value of a relatively small class). I much prefer these full one day intensive courses to 12 weeks of 2 hours a night every Wednesday...
Reviewed by 2012
Overall a positive experience!
Reviewed by 2012
I thought the course was excellent, but think that the material could be better covered over two days instead of one.
Reviewed by 2012
This course was exactly as described and exactly what I wanted. I'm very pleased. the presenter was excellent. I would definitely go to On-Track for more training and recommend them to others.
Reviewed by 2012
Great instructor - made it so much easier to get through a whole day staring at a computer!
Reviewed by 2012
There wasnt enough taught in the course. I didnt find it went into enough detail and the handout is terribly written. The instructor was okay but he focused too much on how "Not to do something" then how to just do it correctly, on certain course material which confused people. I think less breaks, more days added so we can learn more about what MS project has to offer.
Reviewed by 2012
One of the best training that I have ever emcountered.
Reviewed by 2011
The course was great and helped me learn a lot of skills using Excel for work. The instructor was really nice and knowledgable. Although my only complaint and concern is that the course was really rushed and i feel like some people wouldnt be able to keep up with the training.
Reviewed by 2011
I'd like to see a course at this level that is more in depth. More practice excercises, over a longer period of time. I was pleased the instructor made himself available to students even after the course was complete (gave us his email if we had any follow up questions).
Reviewed by 2011
Alan has a done an exceptional job. He is very knowledgeable and goes out of his way to explain everything in details. He is very patient and answers all my questions. He is an awesome teacher!
Reviewed by 2011
I did note body odour of presenter was strong. Only critisism I have. Everything else was excellent.
Reviewed by 2011
Alan was an excellent instructor!
Reviewed by 2011
Excellent Excel 2 course, Alan is a very good instructor. I would take additional courses.
Reviewed by 2011
I wondered why Access 2003 instead of 2010. I should have checked that before I took it. Anyway the course was great and I learned a lot and the Instructor was so nice and kind, I enjoyed his class.
Reviewed by 2011
Haven't really looked over the course book much as I made lots of notes. Only comment re: technlogy was I had no internet connection which was a bit of a hassle during the lunch break as I wanted to check my email and my company website and had to use another desk.
Reviewed by 2011

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 313 times.