The MySQL Certified Associate credential provides a foundation for further MySQL certification. Unlike other MySQL certifications, the Associate certification is not tied to any particular version of MySQL, but focuses on details of using MySQL that are universal no matter what version of the software you are using.
This training combines and covers materials from the following courses:
Be able to find information about products, support and training
Be able to install and start the MySQL server
Understand the basics of Relational Databases
Understand the SQL and MySQL languages
Understand Data/Column types with regard to efficient database design
Be able to view a database design structure/content
Create a database design using an efficient structure
Be able to extract basic database information using the SELECT command
Be able to troubleshoot syntax and understand typical warnings and errors
Be able to delete or modify a database
Be able to delete or modify table row data
Grouping query data with Aggregation
Connect data from multiple table rows using JOIN
Perform nested sub-queries
Use of Simple Functions (String, Date, Numerical)
Understand the primary methods for exporting and importing data
Describe MySQL connectors, their major features and differences.
Understand MySQL storage engines, transactions and features of the common engines
Why You Should Take the CMA: Certified MySQL Associate
Benefits of Certification
For IT professionals, certification is a third party validation of your skills, that helps distinguish you from your peers. Beyond demonstrating a level of competency and proficiency, certification proves that you are committed to your cause and that you've invested the time and money to prove it. Holding a certification also makes you a more valuable employee, and often results in raises, promotions, and a better career.
For organizations, certifications identify the credentials that can be used to hire the right employee. Having certified employees also increases sales for the organization by proving to prospective clients that the organization has the skills to support its claims.
For the ultimate and complete, all inclusive learning experience, please see our Las Vegas Boot Camp Experience.
What's Included
We take care of all logistics for you, so you can concentrate on learning, acquiring skills and getting certified. We provide instructors, books, computer equipment and software in a comfortable learning environment for most training.
Do you have the right background for CMA: Certified MySQL Associate?
Skills Assessment
We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will tell you so right away. We will also recommend cost-effective solutions that you can use to get ready for the course.
Our required skill-assessments ensure that:
All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.
New or existing users of MySQL, who have little or no previous experience with a relational database management system. Both new MySQL Developers and Database Administrators will benefit from this class.
Benefit of taking CMA: Certified MySQL Associate at NetCom
As a recognition for training excellence, NetCom Learning was chosen by Microsoft as the 2007 Worldwide Learning Solutions Partner of the year out of 1400 training companies.
In addition, we have won numerous other training awards for quality and customer satisfaction by CompTIA, EC-Council and other vendors. We are simply passionate about learning and achieving the highest customer satisfaction in your learning experience!
NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Platinum Partner, EC-Council Accredited Training Center, Adobe Authorized Training Center, Autodesk Authorized Training Center and many others. We are proud to offer the highest quality, authorized training solutions from our many partners for our customers.
Alan M.
- Certified Project Management Professional (PMP) since 2000. - Founding member of the Long Island Chapter of the Project Management Institute (PMI) - Expert in Management Plan development including scope documentation, cost estimating, budget planning, risk management plans and schedule development as well as implementing and managing construction projects, environmental remediation projects, and Information Technology projects.
Bio:
Alan MacIntyre is a Project Management Professional with more than 15 years of project management experience across a wide range of industries. He obtained his certification as a Project Management Professional (PMP) in 2000 and is a founding member of the Long Island Chapter of the Project Management Institute (PMI).
As a trainer Alan has provided essential organizational development services to the Dept. of Energy (DOE), Dept. of Homeland Security (DHS), Dept. of Defense (DoD), Boston University, Johnson & Johnson, and JP Morgan Chase. He currently delivers NetCom Learning's PMP Certification Training program which boasts a 98% pass rate for students who took the class at NetCom Learning.
Amanda G.
- Phenom in the IT industry, earned her first Microsoft certification at age 15. - B.B.A in Management along with numerous Cisco, Microsoft, and CompTIA certifications. - Database designer and network administrator background.
Bio:
Amanda is a phenom in the IT industry. The daughter of NetCom Learning Instructor and Subject Matter Expert, Michael Govinda, Amanda was a Microsoft Certified Systems Engineer at age 15 and began earning Cisco credentials at 17. She also holds a B.B.A in Management and worked as a database designer and network administrator in the IT department of a top New York City publishing firm.
Amanda currently teaches CompTIA A+, Network+, and Security+, as well as Cisco CCNA and CCNA Voice courses at NetCom Learning, garnering much acclaim from her students who enjoy a close-to-perfect pass rate on their certification exams. Amanda is a certified trainer for Cisco and CompTIA, and holds numerous technical certifications including Cisco Certified Network Associate-Security, CCSI, CCNP, CCVP, MCSE, CompTIA A+, CompTIA Net+, and CompTIA Security+.
Amanda G.
- Phenom in the IT industry, earned her first Microsoft certification at age 15. - B.B.A in Management along with numerous Cisco, Microsoft, and CompTIA certifications. - Database designer and network administrator background.
Bio:
Amanda is a phenom in the IT industry. The daughter of NetCom Learning Instructor and Subject Matter Expert, Michael Govinda, Amanda was a Microsoft Certified Systems Engineer at age 15 and began earning Cisco credentials at 17. She also holds a B.B.A in Management and worked as a database designer and network administrator in the IT department of a top New York City publishing firm.
Amanda currently teaches CompTIA A+, Network+, and Security+, as well as Cisco CCNA and CCNA Voice courses at NetCom Learning, garnering much acclaim from her students who enjoy a close-to-perfect pass rate on their certification exams. Amanda is a certified trainer for Cisco and CompTIA, and holds numerous technical certifications including Cisco Certified Network Associate-Security, CCSI, CCNP, CCVP, MCSE, CompTIA A+, CompTIA Net+, and CompTIA Security+.
Amanda G.
- Phenom in the IT industry, earned her first Microsoft certification at age 15. - B.B.A in Management along with numerous Cisco, Microsoft, and CompTIA certifications. - Database designer and network administrator background.
Bio:
Amanda is a phenom in the IT industry. The daughter of NetCom Learning Instructor and Subject Matter Expert, Michael Govinda, Amanda was a Microsoft Certified Systems Engineer at age 15 and began earning Cisco credentials at 17. She also holds a B.B.A in Management and worked as a database designer and network administrator in the IT department of a top New York City publishing firm.
Amanda currently teaches CompTIA A+, Network+, and Security+, as well as Cisco CCNA and CCNA Voice courses at NetCom Learning, garnering much acclaim from her students who enjoy a close-to-perfect pass rate on their certification exams. Amanda is a certified trainer for Cisco and CompTIA, and holds numerous technical certifications including Cisco Certified Network Associate-Security, CCSI, CCNP, CCVP, MCSE, CompTIA A+, CompTIA Net+, and CompTIA Security+.
Arthur G.
- Masters Degree in Operations Research & Applied Mathematics from Columbia University along with several IT certifications. - IT Professional for over 30 years and Software Trainer since 1997. - Engineer and developer for top Wall Street financial firms such as JP Morgan Chase.
Bio:
Arthur has been an IT professional for over 30 years. After receiving his Bachelors in Computer Science from NYU, and Masters degree in Operations Research & Applied Mathematics from Columbia University, Arthur was recruited into the private IT sector. Upon starting his IT career path he quickly progressed into leadership roles as an engineer and developer for JP Morgan Chase.
With more than a decade of successful projects behind him, Arthur's love of academia brought him back to training, where he currently specializes in Java certification training and corporate software development. He holds numerous certifications including the Sun Certified Java Programmer, Sun Certified Web Component Developer, and Advanced PHP Programmer. His passion and aptitude for the subject matter is clearly evident both in and out of the classroom and NetCom Learning students rate him 8.6 out of 9.
Beata B.
- Adobe Certified Expert and Certified Technical Trainer (CTT+) - A.A.S. in Commercial Art - Computer Graphics Specialization. - Graphic Designer Specialist, including advanced photo retouching and color correction, masking, realistic photo collages, preparation of complex digital files for commercial output, digital illustration and complex vector graphics
Bio:
Beata Bogaczewicz is a highly accomplished, results driven Graphic Designer and Certified Technical Trainer (CTT+), bringing over fourteen years of combined graphic design, creative production, technical training and project management experience. She is an Adobe Certified Expert with a multitude of Adobe certifications including Adobe Photoshop Certified Expert and Adobe Illustrator Certified Expert.
Her signature teaching style involves breaking down complex topics to their core basics so they are easily and comfortably understood by each learner. She not only explains how features work but also why and when they should be used to gain the best results. Her hands on approach makes memorizing effortless while promoting creative thinking.
Carmille A.
- Highly-skilled in graphics and web software including Adobe CS3, CS4 & CS5 Photoshop, Dreamweaver, Illustrator, InDesign, Captivate, Acrobat and Quark; - Expert in Microsoft Office, including Excel, Word and PowerPoint. Licensed Application Instructor and Microsoft Certified Trainer since 2000. - Over 20 years of experience as Creative Director for multinational corporations such as McCann Erickson, Lintas, and Publicis.
Bio:
Carmille has been a Licensed Application Instructor and Microsoft Certified Trainer for years. She specializes in web development, business productivity and digital media applications such as SharePoint, Quark and the Adobe Creative Suite as well as numerous programming languages including XML, XHMTL, HTML and CSS.
Carmille is passionate about educating and has a unique talent for making complex design and development principals seem "easy" to students from all levels of expertise. She currently teaches Adobe Graphic and Web Designer, Microsoft Office Specialist, SharePoint End User and the acclaimed Website Development Professional courses at NetCom Learning. Her 20+ years of experience as Creative Director for multinational corporations bring a special and innovative approach to her classes at NetCom Learning.
Carmille A.
- Highly-skilled in graphics and web software including Adobe CS3, CS4 & CS5 Photoshop, Dreamweaver, Illustrator, InDesign, Captivate, Acrobat and Quark; - Expert in Microsoft Office, including Excel, Word and PowerPoint. Licensed Application Instructor and Microsoft Certified Trainer since 2000. - Over 20 years of experience as Creative Director for multinational corporations such as McCann Erickson, Lintas, and Publicis.
Bio:
Carmille has been a Licensed Application Instructor and Microsoft Certified Trainer for years. She specializes in web development, business productivity and digital media applications such as SharePoint, Quark and the Adobe Creative Suite as well as numerous programming languages including XML, XHMTL, HTML and CSS.
Carmille is passionate about educating and has a unique talent for making complex design and development principals seem "easy" to students from all levels of expertise. She currently teaches Adobe Graphic and Web Designer, Microsoft Office Specialist, SharePoint End User and the acclaimed Website Development Professional courses at NetCom Learning. Her 20+ years of experience as Creative Director for multinational corporations bring a special and innovative approach to her classes at NetCom Learning.
Carmille A.
- Highly-skilled in graphics and web software including Adobe CS3, CS4 & CS5 Photoshop, Dreamweaver, Illustrator, InDesign, Captivate, Acrobat and Quark; - Expert in Microsoft Office, including Excel, Word and PowerPoint. Licensed Application Instructor and Microsoft Certified Trainer since 2000. - Over 20 years of experience as Creative Director for multinational corporations such as McCann Erickson, Lintas, and Publicis.
Bio:
Carmille has been a Licensed Application Instructor and Microsoft Certified Trainer for years. She specializes in web development, business productivity and digital media applications such as SharePoint, Quark and the Adobe Creative Suite as well as numerous programming languages including XML, XHMTL, HTML and CSS.
Carmille is passionate about educating and has a unique talent for making complex design and development principals seem "easy" to students from all levels of expertise. She currently teaches Adobe Graphic and Web Designer, Microsoft Office Specialist, SharePoint End User and the acclaimed Website Development Professional courses at NetCom Learning. Her 20+ years of experience as Creative Director for multinational corporations bring a special and innovative approach to her classes at NetCom Learning.
Carmille A.
- Highly-skilled in graphics and web software including Adobe CS3, CS4 & CS5 Photoshop, Dreamweaver, Illustrator, InDesign, Captivate, Acrobat and Quark; - Expert in Microsoft Office, including Excel, Word and PowerPoint. Licensed Application Instructor and Microsoft Certified Trainer since 2000. - Over 20 years of experience as Creative Director for multinational corporations such as McCann Erickson, Lintas, and Publicis.
Bio:
Carmille has been a Licensed Application Instructor and Microsoft Certified Trainer for years. She specializes in web development, business productivity and digital media applications such as SharePoint, Quark and the Adobe Creative Suite as well as numerous programming languages including XML, XHMTL, HTML and CSS.
Carmille is passionate about educating and has a unique talent for making complex design and development principals seem "easy" to students from all levels of expertise. She currently teaches Adobe Graphic and Web Designer, Microsoft Office Specialist, SharePoint End User and the acclaimed Website Development Professional courses at NetCom Learning. Her 20+ years of experience as Creative Director for multinational corporations bring a special and innovative approach to her classes at NetCom Learning.
Easing faxing pains using Right Fax product and the right training.
Published On: 17 March 2006
Customer: Sacred Heart Healthcare System
Location: New York, NY, US
Industry: Health Care
Sacred Heart Hospital is a 243-bed Catholic medical center located in central Allentown. Founded in 1912, Sacred Heart Hospital offers a full range of advanced medical services, ranging from open heart surgery and neuroscience to oncology, orthopedics and women's health. A network of physician practices throughout Lehigh and Northampton counties provide complete primary and pediatric medical care to the region's residents.
Business Needs:
Sacred Heart was looking for a solution for their admission faxes coming from their AS400 system. Currently faxing of about 30 to 40 pages per day was done manually, after printing the information. The desired solution was to fax information about their scheduled patients that included: Patient preparation information, time and date of appointment and directions to the facility. A long term goal was to eventually consolidate and perhaps eliminate the need for fax machines completely.
Solution:
NetCom provided training about the Right Fax product and its offerings. Sacred Heart was looking at a potential $19,000 expense in order to acquire the piece needed to automatically download the faxes from their AS400 system. They were looking into alternate methods of providing this information. NetCom's services revealed that they will be able to achieve a cost-effective solution to scheduling faxes.Sacred Heart was also confident that through their upgrade training they will eventually be able to achieve the long term goal of reducing the number of phone lines needed for faxing. An added bonus was cost savings of employees being able to fax and receive faxes at their desk, therefore eliminating the idle time at the fax machine.
NetCom, through examining the existing set-up and training provided cost savings to Sacred Heart. Having just completed maintenance on an application that was dialing outside to send an internal fax, Sacred Hearet anticipated saving roughly $50 per month. While this savings seems small prior to going to the current Electronic Health System this savings would have been closer to $400 per month. Sacred Heart's existing vendor did not provide them with the same setup after their upgrade. Due to the right training, Sacred Heart anticipates that this information has saved them the cost of implementing 3 additional channels or $ 2,535. Additional savings through future ability to drop phone lines, fax machines and the maintenance and supply cost associated with these items were also anticipated.
NetCom’s classroom training ensures that you have state-of-the-art tools, techniques and practices you need to succeed on the job. Our instructors are active practitioners and true masters in their fields. With convenient classes at multiple learning centers across the US, you never have to go far to get ahead.
NetCom’s premium Live Online Training (we call it LOT) is the ultimate in convenience and cost-effectiveness. LOT combines interactive video instruction via the latest web conference technology, and post-class access to learning labs for a best-in-class learning experience. Learn more about LOT
NetCom’s intensive boot camps are designed to advance your skills in the shortest possible amount of time and get you certified. Boot camps go at a faster pace and often run for longer days, so you must have some level of subject matter experience before enrolling. Boot camps have mandatory assessment tests to ensure no one will slow down the class for other students. Learn more about Boot Camps
With NetCom’s private training programs, you decide where and when courses are held. Tailor the training to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Save money by doing bulk customized training. Learn more about Private Onsite Training
NetCom’s private 1-on-1 training focuses on the highest quality training possible. You get individualized, full attention from the instructor and you decide where and when courses are held. The training is custom tailored to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Learn more about Private 1-on-1 Training
NetCom’s classroom training ensures that you have state-of-the-art tools, techniques and practices you need to succeed on the job. Our instructors are active practitioners and true masters in their fields. With convenient classes at multiple learning centers across the US, you never have to go far to get ahead.
NetCom’s premium Live Online Training (we call it LOT) is the ultimate in convenience and cost-effectiveness. LOT combines interactive video instruction via the latest web conference technology, and post-class access to learning labs for a best-in-class learning experience.
NetCom’s intensive boot camps are designed to advance your skills in the shortest possible amount of time and get you certified. Boot camps go at a faster pace and often run for longer days, so you must have some level of subject matter experience before enrolling. Boot camps have mandatory assessment tests to ensure no one will slow down the class for other students. 
With NetCom’s private training programs, you decide where and when courses are held. Tailor the training to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Save money by doing bulk customized training.
NetCom’s private 1-on-1 training focuses on the highest quality training possible. You get individualized, full attention from the instructor and you decide where and when courses are held. The training is custom tailored to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique.
Need course pricing?
Home
Follow Us
Newsletters
Facebook
Twitter
LinkedIn
YouTube
Google+
Free Assessments
Live Chat