MySQL Workbench: Data Modeling & Development Course Outline | Certstaffix® Training

SQL


MySQL Workbench: Data Modeling & Development Course


Attend Our Classes From Home - No Software Needed - Learn More...

MySQL Workbench: Data Modeling & Development

by Certstaffix® Training

SQL Query Training

Length: 4 day(s)      Public Class Price: $2280/person (USD)      Group Class Price: Request Quote      Course Category: SQL


SQL Training
MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to create and maintain MySQL databases without coding. The course covers the interface and explains how to accomplish each step by illustrating best practices visually.

Clear examples, instructions, and explanations reveal, in a single volume, the art of database modeling. 

Complete coverage
Installation and Configuration; Creating and Managing Connections; Data Modeling Concepts; Creating an ERD; Defining the Physical Schemata; Creating and Managing Tables; Creating and Managing Relationships; Creating and Managing Views; Creating and Managing Routines; Creating and Managing Routine Groups; Creating and Managing User & Groups; Creating and Managing SQL Scripts; Generating SQL Scripts; Forward Engineering a Data Model; Synchronize a Model with a Database; Reverse Engineering a Database; Managing Differences in the Data Catalog; Creating and Managing Model Notes; Editing Table Data; Editing Generated Scripts; Creating New Instances; Managing Import and Export; Managing Security; Managing Server Instances
Course Description: Print It | Download PDF | Email It

Certstaffix® Training public classes are instructor-led, live online training you attend from your location or our training labs. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.

  • A real, live instructor teaching you from another location
  • Hands-on learning with the software/skills you are being taught
  • Interaction with all students in the class at other locations
  • Any needed software for class provided in online lab environment
  • Easy assistance from the instructor
  • Attend from your location or our training labs

 Register ➥   May 31, 2022     
 Register ➥   March 7, 2022     
 Register ➥   July 11, 2022     

Group Onsite Training
At Your Organization

OR

Private Online Training
Live Online Instruction

Have a group of several students needing the same training? Then onsite or private online group training is a perfect option for you. We'll either come onsite to your office or deliver a private live online class so you don't have to travel. You'll be able to fully customize a course to your needs. Lastly, you can save per student versus our public classes.


  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be fully customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)

SQL Training Reviews by Certstaffix® Training

Certstaffix® Training collects detailed class reviews via a formal post-class evaluation in all our instructor-led courses. Below are a sample of abbreviated reviews from real students from our past classes. If you would like more reviews or ones with even further detail, please contact us and we would be happy to show you the high quality of our training services.


Certstaffix® Class Reviews

Student Average:
4.77 out of 5 from 254 students

4.73 out of 5

Wonderful content and instructor. Sheila also assisted me in getting scheduled for the class.I would highly recommend!


- attended our SQL Querying - Basic class

4.71 out of 5

Try to reference the the text more, we did not seem to use the text at all


- attended our SQL Querying - Basic class

4.95 out of 5

This was the best virtual training class I have taken. Instructor kept everyone involved and could tell if anyone was struggling. It required everyone to keep up with the class as if they were in the classroom.The only thing I would say is that I didn't feel this was "Advanced" material. The concepts that were in this class should already be known if you're taking an advanced SQL class. Wish there was a more advanced class maybe more stored procedure driven?


- attended our SQL Querying - Advanced class

4.66 out of 5

This was the best course that I have taken online. Very organized and professionally managed.


- attended our SQL Querying - Basic class

4.41 out of 5

This is the second SQL course I've taken with Serge Belich. He does a great job of explaining the database logic as well as how the topics can be applied in the real world. Serge starts with basic syntax then increases the complexity so you understand how each step impacts the end result. The course is engaging and extremely hands on. I was very pleased with the course and instructor - would definitely recommend to others!


- attended our SQL Querying - Advanced class

5.00 out of 5

This is my second course through Certstaffix and I would gladly sign up for others in the future.


- attended our SQL Querying - Advanced class

4.82 out of 5

This class was great and I feel confident that I can use most of what I have learned in my work environment! I think it would have helped if there was a short summary/review in the beginning to differentiate functions, statements, commands, etc. I still don't understand why some are blue or pink and why some need parenthesis while others don't. However, I have a feeling that with practice and reviewing the manual, I will catch on to the trend and figure this out.


- attended our SQL Querying - Basic class

5.00 out of 5

The SQL Query for beginners course was great. The teacher did a wonderful job in balancing between allowing the students to work on the queries by themselves and stepping in to assist. Also great sense of humor and very willing to answer any questions along the way. Definitely would recommend Cerstaffix.


- attended our SQL Querying - Basic class

4.63 out of 5

The presenter was awesome.


- attended our SQL Querying - Basic class

4.85 out of 5

The only issue I had was I already knew much of the material. Otherwise it was a really good course.The instructor was excellent!


- attended our SQL Querying - Basic class



  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Course Topics

Part I Configuration
1. Installing and Configuring
2. Creating and Managing Connections

Part II Data Modeling
3. Data Modeling Concepts
4. Creating and Managing Tables and Relations
5. Creating and Managing Routines
6. Reverse Engineering

Part III SQL Development
7. Editing Data
8. Managing SQL Scripts

Part IV Server Administration
9. Instances
10. Creating and Managing Users and Roles
11. Imports and Exports
12. Migrating Databases

Part V Appendixes and Glossary
A. Mastery Check Answers
B. Extending MySQL Workbench
C. Setting Up SQL Server

Glossary
Index
Course Description: Print It | Download PDF | Email It

SQL Courses By City:

AL - Birmingham       GA - Columbus       NC - Raleigh       RI - Providence      
AL - Huntsville       GA - Savannah       NC - Winston-Salem       SC - Greenville      
AL - Mobile       HI - Honolulu       ND - Fargo       SC - Myrtle Beach      
AR - Bentonville       IA - Des Moines       NE - Lincoln       SC - North Charleston      
BC - Vancouver       IA - Iowa City       NE - Omaha       SD - Sioux Falls      
CA - Bakersfield       ID - Boise       NH - Bedford       SK - Regina      
CA - Fresno       IL - Chicago       NJ - Bridgewater       SK - Saskatoon      
CA - Los Angeles       IN - Fort Wayne       NM - Albuquerque       TN - Chattanooga      
CA - Modesto       IN - Indianapolis       NS - Halifax       TN - Knoxville      
CA - Oakland       KS - Topeka       NV - Henderson       TN - Memphis      
CA - Oxnard       KY - Lexington       NV - Reno       TN - Nashville      
CA - Rancho Cucamonga       KY - Louisville       NY - Albany       TX - Amarillo      
CA - Sacramento       LA - Baton Rouge       NY - Buffalo       TX - Austin      
CA - Salinas       LA - Lafayette       NY - New York City       TX - Beaumont      
CA - San Diego       LA - New Orleans       NY - Rochester       TX - Corpus Christi      
CA - San Jose       LA - Shreveport       NY - Syracuse       TX - Dallas      
CA - Santa Rosa       MA - Burlington       OH - Cincinnati       TX - El Paso      
CA - Stockton       MA - Springfield       OH - Columbus       TX - Fort Worth      
CO - Boulder       MA - Westborough       OH - Dayton       TX - Houston      
CO - Colorado Springs       MB - Winnipeg       OH - Highland Heights       TX - Killeen      
CO - Denver       MD - Largo       OH - Toledo       TX - Laredo      
CT - Cheshire       MD - Laurel       OK - Oklahoma City       TX - Longview      
CT - New Haven       ME - Portland       OK - Tulsa       TX - Lubbock      
CT - Stamford       MI - Ann Arbor       ON - Ottawa       TX - McAllen      
DE - Wilmington       MI - Grand Rapids       ON - Toronto       TX - Midland      
FL - Daytona Beach       MI - Lansing       OR - Beaverton       TX - San Antonio      
FL - Fort Lauderdale       MI - Livonia       OR - Bend       TX - Tyler      
FL - Fort Myers       MN - Minnetonka       OR - Eugene       TX - Waco      
FL - Gainesville       MO - Columbia       OR - Medford       UT - Ogden      
FL - Jacksonville       MO - Kansas City       PA - Allentown       UT - Salt Lake City      
FL - Lakeland       MO - St. Louis       PA - Erie       VA - Glen Allen      
FL - Miami       MS - Biloxi       PA - Harrisburg       VA - Roanoke      
FL - Naples       MS - Jackson       PA - Malvern       VA - Virginia Beach      
FL - Pensacola       MT - Billings       PA - Philadelphia       VT - Burlington      
FL - Sarasota       NB - Moncton       PA - Pittsburgh       WA - Seattle      
FL - Tallahassee       NB - Saint John       PA - Reading       WA - Spokane      
FL - Tampa       NC - Asheville       PA - Scranton-Wilkes Barre       WI - Green Bay      
FL - Winter Park       NC - Charlotte       PA - York       WI - Madison      
GA - Atlanta       NC - Greensboro       QC - Montreal       WI - Milwaukee      
GA - Augusta