MySQL for Beginners

MySQL for Beginners Course Description

Intended Audience for the MySQL for Beginners Course

• 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.

Training Packages & Career Tracks that include the MySQL for Beginners Course

• CMA: Certified MySQL Associate

MySQL for Beginners Course Objectives

• Understand the features and benefits of MySQL
• 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

The MySQL for Beginners Course prepare students for the following Exams

• MySql- Sun : Certified MySQL Associate

Benefits of taking the MySQL for Beginners course at NetCom

• Why choose Sun Training at NetCom Learning?
  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 provides Authorized Training
  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.

  See our comprehensive list of partner authorizations.

• Award winning, world-class Instructors

  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.

  Finnbarr M. - Masters Degree in Computer Science from Boston University along with several certifications. - Over 25 years of experience in the IT field and expert in Unix, GNU/Linux, and Oracle ecosystems. - More than 10 years working as a Software Engineer in multinational companies such as Hewlett-Packard. Bio: Finnbarr has both breadth and in-depth knowledge of Unix, GNU/Linux, and Oracle with 25+ years of experience in operating system internals development, system administration, application development and project management on a wide variety of hardware and software platforms. As a Software Engineer, he developed and managed numerous projects in multinational companies such as Hewlett-Packard. Finnbarr is a member of the Institute of Electrical and Electronic Engineers as well as a Moderator at unix.com. He is also a top Instructor and Subject Matter Expert at NetCom Learning and is well recognized by the students for his knowledge and his great teaching technique.

  Ignacio J. - Designs and architects Microsoft IT solutions since the early 1990s. - Hands-on experience in multiple Microsoft Dynamics products including CRM, GP, SL, AX and NAV since 2004. - Taught over 250 courses at NetCom Learning. Bio: Ignacio is a Senior Solutions Architect, Civil Engineer and Certified Expert Trainer. He has been designing and architecting Microsoft IT solutions since the early 1990s, and has extensive experience developing scalable and high performance integration solutions. In 2004, Ignacio expanded into business management and accounting software as well, where he gained hands-on experience in many Microsoft Dynamics products including CRM, GP, SL, AX and NAV. Ignacio holds a library of industry-wide certifications from Microsoft and other leading IT vendors. He has taught over 250 courses at NetCom Learning and is revered by students for his wide-ranging IT expertise.

  Mark L. - Experience teaching beginner to advanced software engineering and development classes - Architectured NetCom Learning's Mobile Development Professional training package (Android & iPhone) - Acclaimed instructor at NetCom Learning, with evaluation score of 8.7 out of 9. Bio: Mark is an accomplished web and mobile development trainer and Subject Matter Expert. He has been teaching beginner to advanced software engineering and development classes since 2005. With an extensive background in corporate programming he easily understands the impact of new technologies and the knowledge developers need to succeed. Most recently Mark architectured NetCom Learning's Mobile Development Professional training package (Android & iPhone) to much critical acclaim. Mark's passion and aptitude for the subject matter is abundant, and clearly evident in his near-perfect post-class evaluation scores (8.7 out of 9) and praise from clients.

  See more...  
• Actual Client Testimonials

  Jul 23 2011 I felt the training was very good and met my expectations. Arthur was a very good instructor and was easy to understand; very knowledgeable on the subject. Great location. Hotel was great. -Greg F. Course(s) Taken Java / SCJP - Boot Camp

  
  

  Apr 01 2011 My instructor "AG" is very knowledgeable and his presentation is very easy to understand. The accommodations for me was very good. The learning experience for me was worth it. I am currently unemployed and also transitioning my skills from VB to Java (OOP). This training will make me more marketable. -Mark W. Course(s) Taken Java / SCJP - Boot Camp

  
  

  Apr 01 2011 It was a lot to learn. The instructor gave a good coverage and thorough explanation of Java programming language. And it also gave me an opportunity to ask programming questions. Meeting other people in the same class also gave me a good chance to learn from them as well as providing your own opinion. -Sarah L. Course(s) Taken Java / SCJP - Boot Camp

  
  

  Oct 22 2010 Excellent instructor! Thank you for your knowledge and patience. William R. Course(s) Taken Java / SCJP - Boot Camp

  
  

  Oct 22 2010 I took the Java boot camp class. This class was excellent and the instructor was very knowledgeable. It taught all of the "Java Core" constructs. It was a small class and there was a lot of participation. I would highly recommend this class to anyone looking to learn Java and start programming, effectively immediately upon completion. Raymond K. Course(s) Taken Java / SCJP - Boot Camp

  
  

  Jul 05 2010 Training was great. Extremely in depth and informative. Arthur was very knowledgeable friendly and helpful. --Dan L. Course(s) Taken Java / SCJP - Boot Camp

  
  

  Jul 05 2010 Very informative class-learned a lot. He is very knowledgeable about the subject. Taught the class very well. Overall this course was very helpful. It will help me to accomplish my Java goals. --Aron H. Course(s) Taken Java / SCJP - Boot Camp

  
  

  Jul 05 2010 My experience with NetCom was great. From the educational consultant to my hotel and training, I would definitely recommend their services. The instructor always took the time to explain complex issues as well as provide individual attention when needed. The quality of the training was also great. Many practice coding helped visualize the impact of the topic in question. -Johnny A. Course(s) Taken Java / SCJP - Boot Camp

  
  
• Awards won by NetCom
  NetCom Learning is an award winning, customer focused company. We are simply Passionate About Learning!

  See our list of awards.

• Specialized Boot Camp Training

  

  This training is also available as a boot camp. NetCom is world famous for delivering specialized boot camp training to our clients.

  For answers to questions regarding our boot camp training delivery format, please refer to our Boot Camp FAQ section.

Enrollment Options for the MySQL for Beginners course

• Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with an Educational Consultant.

Training Delivery Methods

• Classroom 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.

• Live Online Training (LOT)
  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

• Boot Camp Training
  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

• Private Onsite Training
  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

• Private 1-on-1 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

Call us Toll-free at 1-888-563-8266 FREE Training Inquiry form Website Live Chat Contact us via Email: info@netcomlearning.com