title
MySQL Workbench Tutorial | Introduction To MySQL Workbench | MySQL DBA Training | Edureka

description
🔥 MYSQL DBA Certification Training (Use Code "𝐘𝐎𝐔𝐓𝐔𝐁𝐄𝟐𝟎"): https://www.edureka.co/search This Edureka tutorial video on MySQL Workbench explains all the fundamentals of MySQL Workbench with examples. The following are the topics covered in this tutorial: [00:28] What is MySQL Workbench? [02:05] MySQL Workbench Functionaltites [04:18] MySQL Workbench Editions [06:27] The Three Modules of Workbench [07:19] 1. SQL Development [26:51] 2. Data Modelling [35:27] 3. Migration Wizard [37:39] Data Import & Export MySQL Installation Video: https://www.youtube.com/watch?v=GIRcpjg-3Eg Subscribe to our Edureka YouTube channel and hit the bell icon to get video updates: https://goo.gl/6ohpT -------------------------------------------------------------------------------------------------------- Instagram: https://www.instagram.com/edureka_learning Facebook: https://www.facebook.com/edurekaIN/ Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka ------------------------------------------------------------------------------------------------------- How does it work? 1. This is a 4 Week Instructor-led Online Course. 2. The course consists of 24 hours of online classes, 25 hours of assignment, 20 hours of project 3. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course. 4. You will get Lifetime Access to the recordings in the LMS. 5. At the end of the training, you will have to complete the project based on which we will provide you with a Verifiable Certificate! - - - - - - - - - - - - - - About the Course MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data. - - - - - - - - - - - - - - Who should go for this course? This course can be beneficial for people having the below professional background: Database Developers Application Developers Database Designers Database Administrators - - - - - - - - - - - - - - Project In the project you will be creating a Database using MySQL on SALARY MANAGEMENT SYSTEM :- • Employee list to be maintained having id, name, designation, experience • Salary details having employee id, current salary • Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee • Salary increment to be given by next year if any depending upon constraints • Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted. - - - - - - - - - - - - - - Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For more information, Please write back to us at sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll-free).

detail
{'title': 'MySQL Workbench Tutorial | Introduction To MySQL Workbench | MySQL DBA Training | Edureka', 'heatmap': [{'end': 597.672, 'start': 567.071, 'weight': 0.807}, {'end': 814.713, 'start': 760.606, 'weight': 1}], 'summary': "The tutorial covers mysql workbench functionalities, database connections, dashboard view, sql table execution, query output, features, and data modeling, explaining various capabilities, such as creating, executing, and optimizing queries, managing connections, executing sql queries, manipulating query results, data modeling, and forward engineering in mysql, providing a comprehensive understanding of the tool's features and functionalities.", 'chapters': [{'end': 365.874, 'segs': [{'end': 94.814, 'src': 'embed', 'start': 66.819, 'weight': 0, 'content': [{'end': 70.241, 'text': "I'll tell you what exactly all the options of this workbench mean.", 'start': 66.819, 'duration': 3.422}, {'end': 74.244, 'text': 'How do they work and how you can use this workbench to make your work easier, right?', 'start': 70.281, 'duration': 3.963}, {'end': 79.308, 'text': 'So before I get into the depth of these functionalities and the features of the MySQL workbench,', 'start': 74.705, 'duration': 4.603}, {'end': 88.792, 'text': 'Let me tell you that you know the MySQL workbench is available for the Microsoft Windows, Linux and also Mac OS on 32-bit and 64-bit systems,', 'start': 79.648, 'duration': 9.144}, {'end': 90.132, 'text': 'so you can download from here.', 'start': 88.792, 'duration': 1.34}, {'end': 94.814, 'text': 'So let me just open that so you can download the MySQL workbench from here.', 'start': 90.192, 'duration': 4.622}], 'summary': 'Exploring mysql workbench options for windows, linux, and mac os, available in 32-bit and 64-bit systems.', 'duration': 27.995, 'max_score': 66.819, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ466819.jpg'}, {'end': 239.558, 'src': 'embed', 'start': 213.301, 'weight': 2, 'content': [{'end': 220.545, 'text': 'this allows you to migrate from the Microsoft SQL Server, Microsoft Access Syways, ASCs, SQLite SQL Anywhere,', 'start': 213.301, 'duration': 7.244}, {'end': 226.189, 'text': "PostgreSQL and other relational database management systems from tables, objects and data's to the my sequel.", 'start': 220.545, 'duration': 5.644}, {'end': 228.471, 'text': 'So let me tell you one thing over here,', 'start': 226.569, 'duration': 1.902}, {'end': 235.376, 'text': 'that the migration also supports migrating from the earlier versions of my sequel to the latest releases right now,', 'start': 228.471, 'duration': 6.905}, {'end': 239.558, 'text': 'moving on to the last functionality, that is basically a my sequel Enterprise support.', 'start': 235.376, 'duration': 4.182}], 'summary': 'Migration tool supports various databases to mysql, including earlier versions to latest releases, and offers mysql enterprise support.', 'duration': 26.257, 'max_score': 213.301, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ4213301.jpg'}, {'end': 288.51, 'src': 'embed', 'start': 251.727, 'weight': 1, 'content': [{'end': 259.233, 'text': 'These are basically the sequel development, the data modeling, the server administration, the data migration and the MySQL Enterprise support.', 'start': 251.727, 'duration': 7.506}, {'end': 260.776, 'text': 'now, apart from the functionalities,', 'start': 259.233, 'duration': 1.543}, {'end': 265.46, 'text': "Let me mention over here that you know, they're basically three types of additions in workbench.", 'start': 261.096, 'duration': 4.364}, {'end': 270.598, 'text': 'That is basically the Community Edition the standard Edition and the Enterprise Edition.', 'start': 266.135, 'duration': 4.463}, {'end': 288.51, 'text': 'So the Community Edition is freely available from the MySQL official website and the standard Edition is basically a commercial version that builds on the Community Edition by adding Enterprise features such as the schema and model validation and the generation of database models and lastly come into the Enterprise Edition.', 'start': 271.078, 'duration': 17.432}], 'summary': 'Mysql workbench has 3 editions: community, standard, and enterprise, offering different features and support.', 'duration': 36.783, 'max_score': 251.727, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ4251727.jpg'}], 'start': 11.388, 'title': 'Mysql workbench functionalities', 'summary': 'Covers the various functionalities and features of mysql workbench, including creating, executing, and optimizing queries, designing databases, and configuring servers, available for various operating systems. it also provides an overview of features such as sql development, data modeling, server administration, and data migration, highlighting the capabilities and benefits of each feature, as well as the differences between different editions and their specific features.', 'chapters': [{'end': 104.138, 'start': 11.388, 'title': 'Mysql workbench tutorial', 'summary': 'Covers the various functionalities and features of mysql workbench, including its capabilities for creating, executing, optimizing queries, designing databases, and configuring servers. it also highlights the availability of mysql workbench for various operating systems and system architectures.', 'duration': 92.75, 'highlights': ['MySQL Workbench is a tool for working with MySQL servers and databases, providing visualization modules for creating, executing, and optimizing queries, designing, modeling, and generating databases, and configuring servers, administrating users, and viewing database health.', 'MySQL Workbench is available for Microsoft Windows, Linux, and Mac OS on 32-bit and 64-bit systems, offering flexibility for users across different operating systems and architectures.', 'The session will cover the options and functionalities of MySQL Workbench, aiding users in understanding and utilizing the tool to simplify their work.', 'The chapter emphasizes the availability of MySQL Workbench for a wide range of operating systems, including Windows, Linux, and Mac OS, catering to users with diverse platform requirements.']}, {'end': 213.301, 'start': 104.138, 'title': 'Mysql workbench: features and functionalities', 'summary': 'Provides an overview of mysql workbench, highlighting functionalities such as sql development, data modeling, server administration, and data migration, while emphasizing the capabilities and benefits of each feature.', 'duration': 109.163, 'highlights': ['MySQL Workbench provides functionalities for SQL development, data modeling, server administration, and data migration. Emphasizes the various core functionalities of MySQL Workbench.', 'It enables users to create and manage connections to database servers, configure connection parameters, and execute SQL queries using the built-in SQL editor. Highlights the capabilities of MySQL Workbench for SQL development.', 'Data modeling feature allows graphical creation of database schema models, reverse and forward engineering, and comprehensive table editing. Emphasizes the capabilities of MySQL Workbench for data modeling, including graphical schema creation and comprehensive table editing.', 'Server administration functionality facilitates tasks such as administering users, backup and recovery, inspecting audit data, viewing database health, and monitoring server performance. Highlights the various administrative tasks that can be performed using MySQL Workbench.']}, {'end': 365.874, 'start': 213.301, 'title': 'Mysql workbench overview', 'summary': 'Provides an overview of mysql workbench, including its functionalities such as sql development, data modeling, server administration, data migration, and mysql enterprise support, as well as the differences between the community, standard, and enterprise editions and the specific features they offer.', 'duration': 152.573, 'highlights': ['MySQL Workbench provides support for migrating from various relational database management systems to MySQL, including Microsoft SQL Server, Microsoft Access, SQLite, PostgreSQL, etc. The migration functionality of MySQL Workbench supports migration from various relational database management systems such as Microsoft SQL Server, Microsoft Access, SQLite, SQL Anywhere, PostgreSQL, and others to MySQL.', 'MySQL Workbench supports migrating from earlier versions of MySQL to the latest releases. The migration functionality also includes support for migrating from earlier versions of MySQL to the latest releases.', 'MySQL Workbench offers Enterprise support for products such as MySQL Enterprise backup, MySQL Enterprise firewall, and MySQL Enterprise audit. The Enterprise support functionality of MySQL Workbench includes support for products like MySQL Enterprise backup, MySQL Enterprise firewall, and MySQL Enterprise audit.', 'MySQL Workbench has three editions: Community, Standard, and Enterprise, each with different features and support. MySQL Workbench is available in three editions: Community Edition, Standard Edition, and Enterprise Edition, each offering different features and support.', 'The Enterprise Edition of MySQL Workbench provides additional features not available in the Community Edition or the Standard Edition. The Enterprise Edition of MySQL Workbench offers additional features that are not available in the Community Edition or the Standard Edition.']}], 'duration': 354.486, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ411388.jpg', 'highlights': ['MySQL Workbench is available for Microsoft Windows, Linux, and Mac OS on 32-bit and 64-bit systems, offering flexibility for users across different operating systems and architectures.', 'MySQL Workbench provides functionalities for SQL development, data modeling, server administration, and data migration. Emphasizes the various core functionalities of MySQL Workbench.', 'MySQL Workbench provides support for migrating from various relational database management systems to MySQL, including Microsoft SQL Server, Microsoft Access, SQLite, PostgreSQL, etc.', 'The Enterprise Edition of MySQL Workbench offers additional features that are not available in the Community Edition or the Standard Edition.']}, {'end': 653.402, 'segs': [{'end': 439.173, 'src': 'embed', 'start': 366.454, 'weight': 0, 'content': [{'end': 374.043, 'text': 'So, since this session mainly aims to teach you how to use workbench and how you can play around with the various functionalities and make it easy to use,', 'start': 366.454, 'duration': 7.589}, {'end': 375.625, 'text': "we're going to use the Community Edition.", 'start': 374.043, 'duration': 1.582}, {'end': 379.37, 'text': 'So the Community Edition provides all these features that I just mentioned.', 'start': 375.946, 'duration': 3.424}, {'end': 380.251, 'text': "So don't worry.", 'start': 379.75, 'duration': 0.501}, {'end': 381.733, 'text': "We'll be looking at them one by one.", 'start': 380.291, 'duration': 1.442}, {'end': 382.869, 'text': 'All right.', 'start': 382.609, 'duration': 0.26}, {'end': 388.713, 'text': "So now that you've understood the various editions of my sequel workbench, let's move on to the next topic.", 'start': 383.289, 'duration': 5.424}, {'end': 391.234, 'text': 'That is basically the three modules of workbench.', 'start': 388.733, 'duration': 2.501}, {'end': 397.197, 'text': 'So the three modules of workbench are the SQL development the data modeling and the migration wizard.', 'start': 391.654, 'duration': 5.543}, {'end': 402.461, 'text': 'So the SQL development basically consists of all the query editors, where you can write queries,', 'start': 397.618, 'duration': 4.843}, {'end': 408.304, 'text': 'create databases and also perform server administration tasks, such as you know, you can monitor and configure database.', 'start': 402.461, 'duration': 5.843}, {'end': 414.367, 'text': 'Moving on to data modeling data modeling is basically used to model your data so you can create your ER diagrams.', 'start': 408.744, 'duration': 5.623}, {'end': 418.429, 'text': 'You can also perform forward engineering and the reverse engineering.', 'start': 414.647, 'duration': 3.782}, {'end': 422.091, 'text': 'and finally, coming to the third module, that is the migration wizard,', 'start': 418.429, 'duration': 3.662}, {'end': 429.154, 'text': 'so you can migrate data of a database from a connection to another database or you know another connection, or you can also perform the other tasks,', 'start': 422.091, 'duration': 7.063}, {'end': 431.696, 'text': 'such as manual editing, target creation option.', 'start': 429.154, 'duration': 2.542}, {'end': 435.938, 'text': 'You can also create schemas over here and you can finally get a migration report.', 'start': 431.816, 'duration': 4.122}, {'end': 439.173, 'text': 'So guys these were the various modules of workbench.', 'start': 436.491, 'duration': 2.682}], 'summary': 'Session covers using my sequel workbench ce and its three modules: sql development, data modeling, and migration wizard.', 'duration': 72.719, 'max_score': 366.454, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ4366454.jpg'}, {'end': 566.398, 'src': 'embed', 'start': 535.669, 'weight': 7, 'content': [{'end': 538.691, 'text': 'now moving on to the last option, that is basically the default schema.', 'start': 535.669, 'duration': 3.022}, {'end': 542.394, 'text': "So, basically, for the connection that you're creating, you can set up a default schema,", 'start': 538.732, 'duration': 3.662}, {'end': 549.181, 'text': 'So any queries or any scripts that you run will be completely based on the default schema that you said right now over here.', 'start': 542.694, 'duration': 6.487}, {'end': 551.243, 'text': "I'm not mentioning any default schema.", 'start': 549.281, 'duration': 1.962}, {'end': 557.609, 'text': 'Now once that is done, you can just click on OK, right so you can see that you know, your connection has been created now.', 'start': 551.483, 'duration': 6.126}, {'end': 560.972, 'text': 'Let me just open this connection again to show you the advanced options.', 'start': 557.649, 'duration': 3.323}, {'end': 562.074, 'text': 'All right.', 'start': 561.773, 'duration': 0.301}, {'end': 566.398, 'text': "So what I'll do for that is I'll just right click on this connection and choose the edit connection option.", 'start': 562.094, 'duration': 4.304}], 'summary': 'Explaining setting up a default schema for a connection and creating it.', 'duration': 30.729, 'max_score': 535.669, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ4535669.jpg'}, {'end': 624.367, 'src': 'heatmap', 'start': 567.071, 'weight': 5, 'content': [{'end': 573.612, 'text': "So once you choose the edit connection option, you can see that, you know, your basic details that you've mentioned have been stored over here.", 'start': 567.071, 'duration': 6.541}, {'end': 580.174, 'text': 'Now. after that, you can go to the remote management, where you know you can choose if you want to use the remote management or not,', 'start': 573.993, 'duration': 6.181}, {'end': 582.694, 'text': 'and you can also mention the system profile right?', 'start': 580.174, 'duration': 2.52}, {'end': 585.435, 'text': "So that's how you can play around with the connections.", 'start': 583.195, 'duration': 2.24}, {'end': 592.217, 'text': 'Now, you know, if you want to add a new connection, you can simply choose this option new and then you can mention the connections name.', 'start': 585.855, 'duration': 6.362}, {'end': 597.672, 'text': "So let's say, you know we mentioned in test and let's say up connection method is again the same,", 'start': 592.237, 'duration': 5.435}, {'end': 604.736, 'text': "the port number and the host name stand the same and let's say, the username, the password and the default schema stands the same day.", 'start': 597.672, 'duration': 7.064}, {'end': 609.379, 'text': "So once you're done with that, you can just you know, choose this option test connection.", 'start': 605.176, 'duration': 4.203}, {'end': 617.243, 'text': "Once you click on the option test connection, you'll see that a dialog box comes up with, say successfully made the my sequel connection right?", 'start': 610.239, 'duration': 7.004}, {'end': 619.324, 'text': 'So you just click on OK after that.', 'start': 617.643, 'duration': 1.681}, {'end': 624.367, 'text': 'So once you click on OK and close it, you will see that you know test connection has also been created.', 'start': 619.684, 'duration': 4.683}], 'summary': 'Editing and creating connections in the system profile, including successfully testing a new connection.', 'duration': 57.296, 'max_score': 567.071, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ4567071.jpg'}], 'start': 366.454, 'title': 'Mysql workbench and database connections', 'summary': 'Introduces mysql workbench community edition, with three modules: sql development, data modeling, and migration wizard, and covers managing database connections including setting up default schema, editing connections, adding new connections, and managing servers.', 'chapters': [{'end': 535.669, 'start': 366.454, 'title': 'Mysql workbench: modules and functionalities', 'summary': 'Introduces the mysql workbench community edition, highlighting its three modules: sql development, data modeling, and migration wizard, and explains their functionalities, such as query editing, er diagram creation, and migration tasks.', 'duration': 169.215, 'highlights': ['The Community Edition provides all the mentioned features for MySQL Workbench. The Community Edition offers various functionalities for MySQL Workbench, ensuring access to all the mentioned features.', 'The three modules of MySQL Workbench are SQL development, data modeling, and migration wizard. The three essential modules of MySQL Workbench are SQL development, data modeling, and migration wizard, each serving unique purposes.', 'The SQL development module includes query editors, database creation, and server administration tasks. SQL development module encompasses query editors, database creation, and server administration tasks, providing a comprehensive environment for database management.', 'Data modeling allows users to create ER diagrams, perform forward and reverse engineering. Data modeling supports the creation of ER diagrams and enables forward and reverse engineering, facilitating efficient data modeling processes.', 'The migration wizard facilitates data migration between databases and connections, along with other tasks like manual editing and schema creation. The migration wizard streamlines data migration between databases and connections, offering additional functions such as manual editing, schema creation, and migration report generation.', 'The process of adding a new connection involves specifying connection details like name, method, host, port, username, and password. Adding a new connection requires specifying details such as name, method, host, port, username, and password, ensuring a secure and efficient connection setup.']}, {'end': 653.402, 'start': 535.669, 'title': 'Managing database connections', 'summary': 'Covers managing database connections including setting up default schema, editing connections, adding new connections, and managing servers, with a demonstration of creating and testing a new connection.', 'duration': 117.733, 'highlights': ['The chapter covers managing database connections including setting up default schema, editing connections, adding new connections, and managing servers, with a demonstration of creating and testing a new connection.', 'You can set up a default schema for the connection, allowing queries and scripts to be based on the specified default schema.', 'You can edit connections to modify basic details and configure remote management and system profiles.', "Adding a new connection involves specifying the connection's name, method, port number, host name, username, password, and default schema.", 'Testing a connection results in a dialog box confirming the successful creation of the connection.']}], 'duration': 286.948, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ4366454.jpg', 'highlights': ['The Community Edition provides all the mentioned features for MySQL Workbench.', 'The three modules of MySQL Workbench are SQL development, data modeling, and migration wizard.', 'The SQL development module includes query editors, database creation, and server administration tasks.', 'Data modeling allows users to create ER diagrams, perform forward and reverse engineering.', 'The migration wizard facilitates data migration between databases and connections, along with other tasks like manual editing and schema creation.', 'The process of adding a new connection involves specifying connection details like name, method, host, port, username, and password.', 'The chapter covers managing database connections including setting up default schema, editing connections, adding new connections, and managing servers, with a demonstration of creating and testing a new connection.', 'You can set up a default schema for the connection, allowing queries and scripts to be based on the specified default schema.', 'You can edit connections to modify basic details and configure remote management and system profiles.', "Adding a new connection involves specifying the connection's name, method, port number, host name, username, password, and default schema.", 'Testing a connection results in a dialog box confirming the successful creation of the connection.']}, {'end': 1140.022, 'segs': [{'end': 731.477, 'src': 'embed', 'start': 653.402, 'weight': 3, 'content': [{'end': 656.204, 'text': 'this is the particular view of the dashboard that you get right?', 'start': 653.402, 'duration': 2.802}, {'end': 659.347, 'text': 'So, guys, this was the view that you just saw right?', 'start': 657.165, 'duration': 2.182}, {'end': 664.151, 'text': 'So now, over here, there are basically different paints that you have to understand in the dashboard.', 'start': 659.707, 'duration': 4.444}, {'end': 671.357, 'text': 'So, starting with the Navigator pane Navigator pane basically gives you all the options for the performance, for the list of schemas that you have,', 'start': 664.431, 'duration': 6.926}, {'end': 676.161, 'text': 'and also the information about the tables and the columns presented that schema, the server status,', 'start': 671.357, 'duration': 4.804}, {'end': 678.403, 'text': 'the client connections and all those options right?', 'start': 676.161, 'duration': 2.242}, {'end': 684.728, 'text': 'Next, moving on to the output pane, the output pane basically gives you the output of whatever query that you run.', 'start': 678.903, 'duration': 5.825}, {'end': 688.991, 'text': "So once you run any query, you'll see that you know, your output has been printed over here.", 'start': 685.128, 'duration': 3.863}, {'end': 695.156, 'text': "So you'll see that when we do the hands-on part now moving on to the next pane that is basically the snippets pane.", 'start': 689.471, 'duration': 5.685}, {'end': 711.088, 'text': 'The snippets pane is basically used to add your own code snippets and then you can hide those snippets or you can re-execute those snippets and you can perform actions like you can re-execute your code snippets or you can delete your code snippets specifically and so on.', 'start': 695.558, 'duration': 15.53}, {'end': 714.87, 'text': 'And moving on to the last pane that is basically a query pane.', 'start': 711.728, 'duration': 3.142}, {'end': 719.413, 'text': "This is the pane where you'll be writing all the queries that you want to get executed.", 'start': 715.15, 'duration': 4.263}, {'end': 724.755, 'text': "So let me just quickly jump back to our sequel workbench and let me show you how that's happening.", 'start': 719.853, 'duration': 4.902}, {'end': 727.156, 'text': 'So this is basically the screen that I showed you.', 'start': 725.155, 'duration': 2.001}, {'end': 730.217, 'text': 'So as I said before this is the navigator pane.', 'start': 727.716, 'duration': 2.501}, {'end': 731.477, 'text': 'This is the output pane.', 'start': 730.257, 'duration': 1.22}], 'summary': 'Dashboard provides navigator, output, snippets, and query panes for managing queries and data.', 'duration': 78.075, 'max_score': 653.402, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ4653402.jpg'}, {'end': 814.713, 'src': 'heatmap', 'start': 760.606, 'weight': 1, 'content': [{'end': 766.027, 'text': "So in such a way you get a clear view of your query pane, right? So that's all you know, you can hide these panes.", 'start': 760.606, 'duration': 5.421}, {'end': 769.088, 'text': 'So let me just go back and get these panes back.', 'start': 766.427, 'duration': 2.661}, {'end': 769.868, 'text': 'All right.', 'start': 769.568, 'duration': 0.3}, {'end': 771.188, 'text': "Now, let's get started.", 'start': 770.148, 'duration': 1.04}, {'end': 775.169, 'text': "So now what we're going to basically do is we're going to choose our default database.", 'start': 771.468, 'duration': 3.701}, {'end': 779.672, 'text': "So for that what I'll do is I'll just choose this particular database.", 'start': 776.511, 'duration': 3.161}, {'end': 784.332, 'text': "I'll right click on this database and then I'll choose the option set as default schema.", 'start': 779.792, 'duration': 4.54}, {'end': 792.054, 'text': 'So what will happen is whatever queries that I write in this particular query pane will be executed with respect to this particular database, right?', 'start': 784.953, 'duration': 7.101}, {'end': 794.594, 'text': 'So let me just write any particular query.', 'start': 792.534, 'duration': 2.06}, {'end': 798.915, 'text': "Let's say, you know, I create a new table, right? So I'll type in create table.", 'start': 794.654, 'duration': 4.261}, {'end': 804.356, 'text': "Let's say, you know, I mentioned the tables name to be Department, right? So I'll just type in Department.", 'start': 799.975, 'duration': 4.381}, {'end': 814.713, 'text': "So let's say I have the column name, the name of varchar type 20 characters, right? So after that, I'll just close this particular query.", 'start': 805.188, 'duration': 9.525}], 'summary': 'Tutorial on setting default database and executing queries in sql with example of creating a table.', 'duration': 54.107, 'max_score': 760.606, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ4760606.jpg'}, {'end': 912.03, 'src': 'embed', 'start': 882.188, 'weight': 0, 'content': [{'end': 887.13, 'text': "So once you click on this particular option, you'll see that you know, your query has been executed now.", 'start': 882.188, 'duration': 4.942}, {'end': 892.113, 'text': 'Similarly, you can execute this particular statement with the keyboard shortcut that is control enter.', 'start': 887.17, 'duration': 4.943}, {'end': 900.159, 'text': 'So when I press on control enter you can see that, you know, my query is called executed, right? So let me just execute this particular query also.', 'start': 892.393, 'duration': 7.766}, {'end': 902.941, 'text': "So that's how you know, you can execute queries.", 'start': 900.659, 'duration': 2.282}, {'end': 903.502, 'text': 'All right.', 'start': 903.202, 'duration': 0.3}, {'end': 907.105, 'text': "Now since you know, we've created around four tables in the company database.", 'start': 903.842, 'duration': 3.263}, {'end': 912.03, 'text': "Let's go back to a navigators pane over here and let's just click on this company database right?", 'start': 907.225, 'duration': 4.805}], 'summary': 'Executing queries using control enter and navigating through the company database.', 'duration': 29.842, 'max_score': 882.188, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ4882188.jpg'}, {'end': 1010.485, 'src': 'embed', 'start': 983.848, 'weight': 1, 'content': [{'end': 990.629, 'text': "So when I say generating the create table, it's not necessary that you know, we write queries to create new tables or create new columns.", 'start': 983.848, 'duration': 6.781}, {'end': 992.969, 'text': 'We can directly do it from the navigator Spain.', 'start': 990.869, 'duration': 2.1}, {'end': 999.55, 'text': "So let's say I want to create a new table for this particular schema, right? So what I just simply do is I'll go to the tables option.", 'start': 993.369, 'duration': 6.181}, {'end': 1000.511, 'text': "I'll right click here.", 'start': 999.671, 'duration': 0.84}, {'end': 1006.743, 'text': "I'll choose the option create table and then you can see that you know we have been redirected to this particular pane.", 'start': 1000.651, 'duration': 6.092}, {'end': 1010.485, 'text': 'so let me just hide the other pane so that we have a clear view of it.', 'start': 1006.743, 'duration': 3.742}], 'summary': 'Generate new tables and columns from the navigator spain, simplifying the process and improving efficiency.', 'duration': 26.637, 'max_score': 983.848, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ4983848.jpg'}, {'end': 1150.634, 'src': 'embed', 'start': 1118.074, 'weight': 2, 'content': [{'end': 1119.675, 'text': 'you can use the format option.', 'start': 1118.074, 'duration': 1.601}, {'end': 1122.698, 'text': 'suppose you want to zoom in and you want to play with your preferences.', 'start': 1119.675, 'duration': 3.023}, {'end': 1129.944, 'text': "So what you can simply do is you go to edit, you go to preferences, you go to fonts and colors and let's say I want to zoom in right?", 'start': 1123.118, 'duration': 6.826}, {'end': 1133.528, 'text': "So what I'll simply do is I'll change this to 12 and let me change.", 'start': 1130.005, 'duration': 3.523}, {'end': 1140.022, 'text': "the scripting shell also to 12 and editor also to 12, right? I'll just click on OK.", 'start': 1134.116, 'duration': 5.906}, {'end': 1143.286, 'text': 'Now once I click on OK, I have to restart my workbench.', 'start': 1140.423, 'duration': 2.863}, {'end': 1144.487, 'text': 'So let me just do that.', 'start': 1143.486, 'duration': 1.001}, {'end': 1150.634, 'text': 'Right. when you restart your workbench you can see that you know your query editor has been zoomed in.', 'start': 1145.468, 'duration': 5.166}], 'summary': 'Adjust preferences to zoom in by changing font size to 12, then restarting workbench for changes to take effect.', 'duration': 32.56, 'max_score': 1118.074, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41118074.jpg'}], 'start': 653.402, 'title': 'Dashboard view and sql table execution', 'summary': "Explains the dashboard's panes and functionality, such as navigator, output, snippets, and query panes, and covers executing sql queries and creating tables, including keyboard shortcuts and preferences.", 'chapters': [{'end': 766.027, 'start': 653.402, 'title': 'Dashboard view and functionality', 'summary': 'Explains the different panes in the dashboard, including the navigator pane for performance options and schema information, the output pane for query results, the snippets pane for adding and managing code snippets, and the query pane for writing and executing queries.', 'duration': 112.625, 'highlights': ['The Navigator pane provides options for performance, list of schemas, server status, and client connections.', 'The Output pane displays the output of executed queries.', 'The Snippets pane is used to add, manage, and execute code snippets.', 'The Query pane is where queries are written and executed.']}, {'end': 1140.022, 'start': 766.427, 'title': 'Executing and creating tables in sql', 'summary': 'Covers the process of executing sql queries, including keyboard shortcuts, and creating tables directly from the navigator pane, with a demonstration of formatting queries and adjusting preferences.', 'duration': 373.595, 'highlights': ['The process of executing SQL queries, including keyboard shortcuts The speaker demonstrates the process of executing SQL queries, explaining how to choose a default database, write and execute queries in the query pane, and use keyboard shortcuts like control shift enter and control enter for executing multiple and single queries, respectively.', "Creating tables directly from the navigator pane The speaker explains how to create new tables directly from the navigator pane by right-clicking on the tables option, choosing 'create table', adding columns and selecting options such as primary key and not null, then applying the changes to generate a script and create a new table.", "Demonstration of formatting queries and adjusting preferences The speaker demonstrates how to format a SQL statement using the 'format' option and also explains the process of adjusting preferences, such as zooming in and changing font sizes in the scripting shell and editor through the edit and preferences options."]}], 'duration': 486.62, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ4653402.jpg', 'highlights': ['The process of executing SQL queries, including keyboard shortcuts The speaker demonstrates the process of executing SQL queries, explaining how to choose a default database, write and execute queries in the query pane, and use keyboard shortcuts like control shift enter and control enter for executing multiple and single queries, respectively.', "Creating tables directly from the navigator pane The speaker explains how to create new tables directly from the navigator pane by right-clicking on the tables option, choosing 'create table', adding columns and selecting options such as primary key and not null, then applying the changes to generate a script and create a new table.", "Demonstration of formatting queries and adjusting preferences The speaker demonstrates how to format a SQL statement using the 'format' option and also explains the process of adjusting preferences, such as zooming in and changing font sizes in the scripting shell and editor through the edit and preferences options.", 'The Navigator pane provides options for performance, list of schemas, server status, and client connections.', 'The Output pane displays the output of executed queries.', 'The Snippets pane is used to add, manage, and execute code snippets.', 'The Query pane is where queries are written and executed.']}, {'end': 1526.33, 'segs': [{'end': 1197.223, 'src': 'embed', 'start': 1173.745, 'weight': 0, 'content': [{'end': 1180.911, 'text': 'So when I execute this particular query, you see an output that you know this particular values have been inserted into the project table.', 'start': 1173.745, 'duration': 7.166}, {'end': 1187.515, 'text': 'Now, when you right click on this particular response, you see various options, such as copy row, copy action, copy response,', 'start': 1181.351, 'duration': 6.164}, {'end': 1192.859, 'text': 'copy duration and also append selected items to SQL script replace and clear right?', 'start': 1187.515, 'duration': 5.344}, {'end': 1195.421, 'text': 'So you can simply use all these particular options.', 'start': 1193.18, 'duration': 2.241}, {'end': 1197.223, 'text': "So let's say you know what a copy the response.", 'start': 1195.441, 'duration': 1.782}], 'summary': 'Executing a query shows inserted values in project table; various options available for response manipulation.', 'duration': 23.478, 'max_score': 1173.745, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41173745.jpg'}, {'end': 1260.019, 'src': 'embed', 'start': 1231.026, 'weight': 1, 'content': [{'end': 1233.429, 'text': "So let's just click on this particular option in the toolbar.", 'start': 1231.026, 'duration': 2.403}, {'end': 1238.745, 'text': 'and when you click on this option, you see a pane which shows the results grid and the execution plan.', 'start': 1234.182, 'duration': 4.563}, {'end': 1243.028, 'text': 'right, the execution plan is basically how the query is getting executed.', 'start': 1238.745, 'duration': 4.283}, {'end': 1251.274, 'text': 'so you can understand the execution plan as a map or as a roadmap to how the query is getting executed, and the results grid shows the results.', 'start': 1243.028, 'duration': 8.246}, {'end': 1256.197, 'text': "so since you know it's an insert statement, you cannot see the values to be inserted all right.", 'start': 1251.274, 'duration': 4.923}, {'end': 1260.019, 'text': "so let's just view all the values that we've inserted into the project table.", 'start': 1256.197, 'duration': 3.822}], 'summary': 'Understanding execution plan and results grid in query execution.', 'duration': 28.993, 'max_score': 1231.026, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41231026.jpg'}, {'end': 1350.942, 'src': 'embed', 'start': 1321.929, 'weight': 3, 'content': [{'end': 1326.713, 'text': "So I'll just click on this option of insert new row and you'll see that you know, a new row will be added.", 'start': 1321.929, 'duration': 4.784}, {'end': 1329.075, 'text': 'Similarly, we can remove that particular row.', 'start': 1327.054, 'duration': 2.021}, {'end': 1334.578, 'text': "Also, you can also import and export your table, right? So that's how you know, you can play around with this.", 'start': 1329.135, 'duration': 5.443}, {'end': 1341.06, 'text': "Now, one more thing that I like to mention over here is that you can also edit the table from the navigator's pane right?", 'start': 1334.999, 'duration': 6.061}, {'end': 1343.24, 'text': "So let me just go back to the navigator's pane.", 'start': 1341.26, 'duration': 1.98}, {'end': 1345.741, 'text': "Let's say I want to edit the table project.", 'start': 1343.66, 'duration': 2.081}, {'end': 1350.942, 'text': "So what I'll basically do is I'll just right click over here and then I'll choose the option that I want to choose.", 'start': 1346.021, 'duration': 4.921}], 'summary': 'Demonstrates adding, removing, importing, exporting, and editing rows in a table.', 'duration': 29.013, 'max_score': 1321.929, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41321929.jpg'}, {'end': 1421.517, 'src': 'embed', 'start': 1394.035, 'weight': 2, 'content': [{'end': 1397.577, 'text': 'So you see that you know, these three queries have been added on to our snippet.', 'start': 1394.035, 'duration': 3.542}, {'end': 1399.819, 'text': "Now once that is done, I'll choose done.", 'start': 1397.958, 'duration': 1.861}, {'end': 1402.321, 'text': 'So this will be basically stored as my snippet.', 'start': 1400.199, 'duration': 2.122}, {'end': 1407.088, 'text': 'So whenever I choose to execute this statement, I can just go to this particular snippet.', 'start': 1402.745, 'duration': 4.343}, {'end': 1408.329, 'text': 'I can right click over here.', 'start': 1407.208, 'duration': 1.121}, {'end': 1414.773, 'text': 'Then I can either execute this particular snippet, or I can edit this particular snippet, or even I can delete this particular snippet right?', 'start': 1408.369, 'duration': 6.404}, {'end': 1418.315, 'text': "So what I'll simply do is I'll just execute this particular snippet.", 'start': 1415.233, 'duration': 3.082}, {'end': 1421.517, 'text': "So you'll see that, you know, your snippet has been executed.", 'start': 1418.976, 'duration': 2.541}], 'summary': 'Three queries added to snippet, executed successfully.', 'duration': 27.482, 'max_score': 1394.035, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41394035.jpg'}], 'start': 1140.423, 'title': 'Query output and mysql workbench', 'summary': 'Explores the functionality of the output pane, including viewing and manipulating query results, understanding the execution plan, and provides various options such as copy row, copy action, copy response, and how to use mysql workbench to view, filter, edit, add, delete, import, export tables, add code snippets, and execute snippets, with a focus on editing and manipulating table data.', 'chapters': [{'end': 1251.274, 'start': 1140.423, 'title': 'Query output and result grid', 'summary': 'Explores the functionality of the output pane, including viewing and manipulating query results, as well as understanding the execution plan, providing various options such as copy row, copy action, copy response, copy duration, append selected items to sql script, replace and clear, and how to view the results grid and execution plan.', 'duration': 110.851, 'highlights': ['The output pane provides options such as copy row, copy action, copy response, copy duration, append selected items to SQL script, replace, and clear, allowing users to manipulate query results.', "The results grid and execution plan options allow users to view and understand how the query is executed, providing insights into the query's performance.", "Restarting the workbench zooms in the query editor, script editor, and result script, enhancing the user's viewing experience."]}, {'end': 1526.33, 'start': 1251.274, 'title': 'Using mysql workbench', 'summary': 'Covers using mysql workbench to view, filter, edit, add, delete, import, export tables, add code snippets, and execute snippets, with a focus on editing and manipulating table data.', 'duration': 275.056, 'highlights': ['You can edit, add, and delete rows in the table, as well as import and export table data. The tool allows users to manipulate table data by editing, adding, and deleting rows, as well as importing and exporting table data.', 'Ability to create and manage code snippets for executing frequently used queries. Users can create and manage code snippets for executing frequently used queries, enhancing efficiency in query execution.', 'The tool provides options for viewing, filtering, and executing queries on the table data. Users can view, filter, and execute queries on the table data, allowing for efficient data analysis and manipulation.', 'Detailed explanation on using the snippet pane to store and execute code snippets for query execution. The snippet pane enables users to store and execute code snippets for query execution, enhancing the ease of accessing and utilizing frequently used queries.']}], 'duration': 385.907, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41140423.jpg', 'highlights': ['The output pane provides options such as copy row, copy action, copy response, copy duration, append selected items to SQL script, replace, and clear, allowing users to manipulate query results.', "The results grid and execution plan options allow users to view and understand how the query is executed, providing insights into the query's performance.", 'Ability to create and manage code snippets for executing frequently used queries, enhancing efficiency in query execution.', 'You can edit, add, and delete rows in the table, as well as import and export table data. The tool allows users to manipulate table data by editing, adding, and deleting rows, as well as importing and exporting table data.']}, {'end': 1998.369, 'segs': [{'end': 1550.808, 'src': 'embed', 'start': 1527.006, 'weight': 0, 'content': [{'end': 1533.493, 'text': 'So in the file option you have options for creating new model, new query tabs, open model, open sequel script,', 'start': 1527.006, 'duration': 6.487}, {'end': 1536.716, 'text': 'run sequel script and so on from the editors tab.', 'start': 1533.493, 'duration': 3.223}, {'end': 1541.141, 'text': 'You have the undo paste and basically the preferences where you can, you know, zoom in and zoom out.', 'start': 1536.756, 'duration': 4.385}, {'end': 1546.245, 'text': 'that I showed you and also mention all the basic preferences that you want for your mysql workbench.', 'start': 1541.141, 'duration': 5.104}, {'end': 1550.808, 'text': 'similarly, for the view, you can choose what kind of view that you want for your mysql workbench,', 'start': 1546.245, 'duration': 4.563}], 'summary': 'Options for creating, opening, and running queries in mysql workbench, with zoom and view preferences available.', 'duration': 23.802, 'max_score': 1527.006, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41527006.jpg'}, {'end': 1590.549, 'src': 'embed', 'start': 1561.194, 'weight': 1, 'content': [{'end': 1568.099, 'text': 'also gives you other options, such as limiting number of rows in a specific query pane and also collecting the performance schema stats.', 'start': 1561.194, 'duration': 6.905}, {'end': 1575.782, 'text': 'The database option gives you all the options to connect to a database, manage reverse engineering schema, migration wizard and so on.', 'start': 1568.599, 'duration': 7.183}, {'end': 1582.725, 'text': 'The server option gives you all the options such as data export, data import, that is basically from where you can export and import your data.', 'start': 1576.383, 'duration': 6.342}, {'end': 1590.549, 'text': 'You can view your performance reports, the schema setups, the dashboards, the accessing systems and similarly, for tools, we have various utilities,', 'start': 1583.086, 'duration': 7.463}], 'summary': 'The tool offers options like limiting rows, connecting to databases, and exporting/importing data.', 'duration': 29.355, 'max_score': 1561.194, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41561194.jpg'}, {'end': 1615.628, 'src': 'embed', 'start': 1590.549, 'weight': 2, 'content': [{'end': 1597.152, 'text': 'such as you can copy the particular code in the query pane as a PHP code, or, you know, we can just iterate the select results.', 'start': 1590.549, 'duration': 6.603}, {'end': 1600.715, 'text': 'In the scripting option, you can just choose to have a new script,', 'start': 1597.612, 'duration': 3.103}, {'end': 1607.841, 'text': 'or you can open an existing script and in the help option you just have all the documentation files where you can find the help for this workbench right?', 'start': 1600.715, 'duration': 7.126}, {'end': 1613.806, 'text': "So, now that you've understood the SQL development module, it's time that you know we jump on to our next module.", 'start': 1608.442, 'duration': 5.364}, {'end': 1615.628, 'text': 'that is basically our data modeling.', 'start': 1613.806, 'duration': 1.822}], 'summary': 'Workbench allows copying code, opening existing scripts, and accessing documentation for sql development and data modeling.', 'duration': 25.079, 'max_score': 1590.549, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41590549.jpg'}, {'end': 1652.87, 'src': 'embed', 'start': 1627.331, 'weight': 3, 'content': [{'end': 1632.292, 'text': 'or you can also create a model of an existing database by reverse engineering or data.', 'start': 1627.331, 'duration': 4.961}, {'end': 1636.573, 'text': 'modeling also allows you to export your schema design to a MySQL server.', 'start': 1632.292, 'duration': 4.281}, {'end': 1640.554, 'text': "Let me just shift back to my MySQL workbench and show you how that's done.", 'start': 1637.114, 'duration': 3.44}, {'end': 1643.475, 'text': "So we'll just go back to the home tab over here.", 'start': 1641.214, 'duration': 2.261}, {'end': 1646.906, 'text': "and then I'll choose this option of data modeling.", 'start': 1644.384, 'duration': 2.522}, {'end': 1652.87, 'text': 'So, once I choose this option of data modeling, I get three options, that is, basically to add a new model, or, you know,', 'start': 1647.326, 'duration': 5.544}], 'summary': 'Data modeling in mysql workbench allows exporting schema design to mysql server.', 'duration': 25.539, 'max_score': 1627.331, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41627331.jpg'}, {'end': 1954.686, 'src': 'embed', 'start': 1928.15, 'weight': 4, 'content': [{'end': 1932.994, 'text': 'you can erase something, you can place a new layer or you can, you know, place a new image.', 'start': 1928.15, 'duration': 4.844}, {'end': 1936.237, 'text': 'you can change the cardinality ratios between all the tables.', 'start': 1932.994, 'duration': 3.243}, {'end': 1942.022, 'text': 'not only this, but you can also modify and format your tables in such a way that you know you have views to yourself.', 'start': 1936.237, 'duration': 5.785}, {'end': 1950.284, 'text': "Suppose you know if I don't want to see this complete view of the interrelation between all the tables in the database and I just want to see a subset of the objects.", 'start': 1942.342, 'duration': 7.942}, {'end': 1954.686, 'text': "what I can simply do is I'll go back to my MySQL model and then I'll add a new diagram.", 'start': 1950.284, 'duration': 4.402}], 'summary': 'Modify tables, change cardinality ratios, and create new diagrams in mysql model.', 'duration': 26.536, 'max_score': 1928.15, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41928150.jpg'}, {'end': 1994.086, 'src': 'embed', 'start': 1959.887, 'weight': 5, 'content': [{'end': 1965.149, 'text': "So let's just rename it to Sakila EER and then I'll click on OK.", 'start': 1959.887, 'duration': 5.262}, {'end': 1967.649, 'text': 'This particular diagram has been renamed.', 'start': 1965.928, 'duration': 1.721}, {'end': 1972.672, 'text': 'Now, let me just add a new diagram so that you understand how we can see the subset of objects.', 'start': 1968.049, 'duration': 4.623}, {'end': 1977.055, 'text': "I'll double click over here and then I'll go to the Sakila database.", 'start': 1973.133, 'duration': 3.922}, {'end': 1978.536, 'text': 'That is basically the database.', 'start': 1977.315, 'duration': 1.221}, {'end': 1984.62, 'text': "I've been using I'll go to tables and let's see, you know, we choose address, right? So I'll just drag and drop over here.", 'start': 1978.596, 'duration': 6.024}, {'end': 1994.086, 'text': 'Now similarly address has City address has a customer address is related to a country also because country is important in address.', 'start': 1985.1, 'duration': 8.986}], 'summary': 'Renamed sakila eer, added address table to diagram, showing object subset.', 'duration': 34.199, 'max_score': 1959.887, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41959887.jpg'}], 'start': 1527.006, 'title': 'Mysql workbench features and data modeling', 'summary': 'Covers various features in mysql workbench such as creating models, executing queries, and connecting to databases. it also explains data modeling, including reverse engineering and manipulation of the model.', 'chapters': [{'end': 1607.841, 'start': 1527.006, 'title': 'Mysql workbench features', 'summary': 'Outlines the various features and options available in mysql workbench, including creating new models, executing queries, connecting to a database, and accessing utilities and documentation files.', 'duration': 80.835, 'highlights': ['Creating new models and executing queries The file option provides choices for creating new models, new query tabs, open sequel script, and options to execute queries, including limiting the number of rows and collecting performance schema stats.', 'connecting to a database and managing schema migration wizard and data export/import options in the server tab for performance reports and schema setups in the server option and accessing utilities in the tools tab for copying code as PHP or iterating select results in scripting option. The database option offers connectivity to databases, management of reverse engineering schema, and migration wizard, while the server tab includes data export/import, performance reports, schema setups, and accessing utilities for copying code as PHP or iterating select results.', 'viewing documentation files and finding help for the workbench The help option provides access to documentation files, allowing users to find help for the MySQL Workbench.']}, {'end': 1998.369, 'start': 1608.442, 'title': 'Data modeling and reverse engineering', 'summary': 'Discusses the use of data modeling to design databases, including reverse engineering an existing database to create a model, with detailed steps on how to perform reverse engineering and manipulate the model.', 'duration': 389.927, 'highlights': ['Reverse engineering an existing database to create a model The process of reverse engineering an existing database to create a model is detailed, including specifying connection details, retrieving schema, and creating the model.', 'Manipulating the created model by changing object colors and arranging the model layout The ability to change object colors, arrange model layout, and modify table values in the created model is described.', 'Adding a new diagram and grouping a subset of objects in the model The process of adding a new diagram, renaming it, and grouping a subset of objects in the model is explained using the example of the Sakila database.']}], 'duration': 471.363, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41527006.jpg', 'highlights': ['Creating new models and executing queries The file option provides choices for creating new models, new query tabs, open sequel script, and options to execute queries, including limiting the number of rows and collecting performance schema stats.', 'Connecting to a database and managing schema migration wizard and data export/import options in the server tab for performance reports and schema setups in the server option and accessing utilities in the tools tab for copying code as PHP or iterating select results in scripting option. The database option offers connectivity to databases, management of reverse engineering schema, and migration wizard, while the server tab includes data export/import, performance reports, schema setups, and accessing utilities for copying code as PHP or iterating select results.', 'Viewing documentation files and finding help for the workbench The help option provides access to documentation files, allowing users to find help for the MySQL Workbench.', 'Reverse engineering an existing database to create a model The process of reverse engineering an existing database to create a model is detailed, including specifying connection details, retrieving schema, and creating the model.', 'Manipulating the created model by changing object colors and arranging the model layout The ability to change object colors, arrange model layout, and modify table values in the created model is described.', 'Adding a new diagram and grouping a subset of objects in the model The process of adding a new diagram, renaming it, and grouping a subset of objects in the model is explained using the example of the Sakila database.']}, {'end': 2373.552, 'segs': [{'end': 2043.108, 'src': 'embed', 'start': 1998.77, 'weight': 0, 'content': [{'end': 2008.859, 'text': "So now you can specifically save this particular ER diagram saying that we change this name to address group and then I'll click on OK.", 'start': 1998.77, 'duration': 10.089}, {'end': 2012.161, 'text': 'Right So this particular ER diagram is also safe.', 'start': 2009.199, 'duration': 2.962}, {'end': 2015.344, 'text': 'So guys, this is how you know, you can use the data modeling.', 'start': 2012.662, 'duration': 2.682}, {'end': 2019.728, 'text': 'Now one thing that I forgot to mention over here is the forward engineering part.', 'start': 2016.065, 'duration': 3.663}, {'end': 2021.91, 'text': "So let's just quickly cover that part.", 'start': 2020.108, 'duration': 1.802}, {'end': 2027.966, 'text': 'So when I say forward engineering, I mean that you know, you basically export your database to the MySQL server.', 'start': 2022.583, 'duration': 5.383}, {'end': 2030.567, 'text': "Let's just rename this particular database.", 'start': 2028.626, 'duration': 1.941}, {'end': 2031.908, 'text': "So I'll just edit.", 'start': 2031.007, 'duration': 0.901}, {'end': 2040.272, 'text': "I'll just change the schema name to schema new data and then I'll just rename right? So let me just rename.", 'start': 2032.108, 'duration': 8.164}, {'end': 2043.108, 'text': 'So, once the schema has been renamed,', 'start': 2041.286, 'duration': 1.822}], 'summary': 'The transcript covers data modeling and forward engineering for database management.', 'duration': 44.338, 'max_score': 1998.77, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41998770.jpg'}, {'end': 2108.97, 'src': 'embed', 'start': 2080.777, 'weight': 2, 'content': [{'end': 2086.579, 'text': 'Well, you can obviously choose which objects you want to perform forward engineering on and then you click on next.', 'start': 2080.777, 'duration': 5.802}, {'end': 2089.4, 'text': 'once you click on next, your script will be generated.', 'start': 2086.579, 'duration': 2.821}, {'end': 2094.661, 'text': 'so you can copy this particular script and then you can obviously execute on your sequel development module,', 'start': 2089.4, 'duration': 5.261}, {'end': 2096.181, 'text': 'where you can run this particular queries.', 'start': 2094.661, 'duration': 1.52}, {'end': 2097.923, 'text': "but we're just going to, you know, go to next.", 'start': 2096.181, 'duration': 1.742}, {'end': 2100.505, 'text': 'So once you execute this particular script,', 'start': 2098.383, 'duration': 2.122}, {'end': 2108.97, 'text': 'then you just click on close and you see that you have a new database with the name circular new data which contains all the objects and the relationships in the model right?', 'start': 2100.505, 'duration': 8.465}], 'summary': 'Select objects for forward engineering, generate script, execute queries in sequel development module, and create a new database with all objects and relationships.', 'duration': 28.193, 'max_score': 2080.777, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ42080777.jpg'}, {'end': 2183.768, 'src': 'embed', 'start': 2156.103, 'weight': 3, 'content': [{'end': 2159.945, 'text': 'data transfer setup, bulk data transfer and finally the migration report.', 'start': 2156.103, 'duration': 3.842}, {'end': 2163.727, 'text': "So guys, let's just start migrating the database to a different connection.", 'start': 2160.365, 'duration': 3.362}, {'end': 2167.911, 'text': "Let's just go back to the home tab and let me just open migration wizard.", 'start': 2164.307, 'duration': 3.604}, {'end': 2174.198, 'text': 'So when you open this migration wizard, you see a welcome wizard that you know welcome to MySQL migration wizard.', 'start': 2168.472, 'duration': 5.726}, {'end': 2177.781, 'text': 'So, as you can see on the screen, these are the various options that you have.', 'start': 2174.638, 'duration': 3.143}, {'end': 2183.768, 'text': 'so you can start migrating or you can open your ODBC administrator and you can also view the documentation right?', 'start': 2177.781, 'duration': 5.987}], 'summary': 'Migration of database to a different connection using mysql migration wizard with various options available.', 'duration': 27.665, 'max_score': 2156.103, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ42156103.jpg'}, {'end': 2324.697, 'src': 'embed', 'start': 2299.084, 'weight': 4, 'content': [{'end': 2303.905, 'text': "You'll see that you know all your tables have got individually exported into files, right?", 'start': 2299.084, 'duration': 4.821}, {'end': 2305.025, 'text': "So that's how you know.", 'start': 2304.365, 'duration': 0.66}, {'end': 2306.825, 'text': 'you can export your data or your schema.', 'start': 2305.025, 'duration': 1.8}, {'end': 2314.028, 'text': 'Now similarly, if you want to import data, what you do is you go to server you choose data import Then you mention from where do you want to import.', 'start': 2307.065, 'duration': 6.963}, {'end': 2316.77, 'text': "So let's say I want to import from this particular directory.", 'start': 2314.368, 'duration': 2.402}, {'end': 2319.612, 'text': "And then what I'll do is I'll add a new schema.", 'start': 2317.21, 'duration': 2.402}, {'end': 2321.574, 'text': "So let's just add a new schema.", 'start': 2319.673, 'duration': 1.901}, {'end': 2323.356, 'text': "Let's say, you know, example.", 'start': 2321.614, 'duration': 1.742}, {'end': 2324.697, 'text': "And then I'll click on OK.", 'start': 2323.576, 'duration': 1.121}], 'summary': 'Transcript explains exporting and importing data and schema in database.', 'duration': 25.613, 'max_score': 2299.084, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ42299084.jpg'}], 'start': 1998.77, 'title': 'Data modeling and forward engineering in mysql', 'summary': 'Explains using data modeling to modify an er diagram and perform forward engineering to export the database to a mysql server, including renaming the schema and executing the generated script, resulting in a new database with the specified name and containing all the objects and relationships in the model. it also covers the process of forward engineering for data modeling, using the migration wizard to migrate databases, and data import and export functionalities in mysql workbench.', 'chapters': [{'end': 2117.05, 'start': 1998.77, 'title': 'Using data modeling and forward engineering', 'summary': 'Explains how to use data modeling to modify an er diagram and then perform forward engineering to export the database to a mysql server, including renaming the schema and executing the generated script, resulting in a new database with the specified name and containing all the objects and relationships in the model.', 'duration': 118.28, 'highlights': ['Performing forward engineering to export the database to a MySQL server involves renaming the schema and executing the generated script, resulting in a new database with the specified name and containing all the objects and relationships in the model. Exporting the database to MySQL server, creating a new database with the specified name', 'Using data modeling to modify an ER diagram involves saving the changes and ensuring the diagram is safe, showcasing the process of data modeling. Saving the ER diagram with changes', 'Generating a script through forward engineering and executing it on a sequel development module results in the creation of the new database with the specified name and containing all the objects and relationships in the model. Execution of the generated script, creation of the new database']}, {'end': 2373.552, 'start': 2117.291, 'title': 'Mysql workbench: data modeling, migration, import, export', 'summary': 'Covers the process of forward engineering for data modeling, using the migration wizard to migrate databases, and data import and export functionalities in mysql workbench.', 'duration': 256.261, 'highlights': ['The data migration wizard allows for the migration of specific schemas and tables to a different connection, providing a step-by-step process for specifying source and target connection parameters and selecting the objects to be migrated. The data migration wizard guides the user through specifying source and target connection parameters, selecting schemas and tables to be migrated, and generating SQL create statements.', 'The process of exporting data involves selecting a schema and specifying the directory for the export, then initiating the export process, resulting in individual tables being exported into files at the specified directory. Exporting data involves selecting a schema, specifying the export directory, and initiating the export process, resulting in individual tables being exported into files at the specified directory.', 'The import process entails specifying the source directory for the import, adding a new target schema, selecting tables to import, and initiating the import process to import the database into the specified schema. The import process includes specifying the source directory, adding a new target schema, selecting tables to import, and initiating the import process to import the database into the specified schema.']}], 'duration': 374.782, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/uKwR9fWsZJ4/pics/uKwR9fWsZJ41998770.jpg', 'highlights': ['Performing forward engineering to export the database to a MySQL server involves renaming the schema and executing the generated script, resulting in a new database with the specified name and containing all the objects and relationships in the model.', 'Using data modeling to modify an ER diagram involves saving the changes and ensuring the diagram is safe, showcasing the process of data modeling.', 'Generating a script through forward engineering and executing it on a sequel development module results in the creation of the new database with the specified name and containing all the objects and relationships in the model.', 'The data migration wizard allows for the migration of specific schemas and tables to a different connection, providing a step-by-step process for specifying source and target connection parameters and selecting the objects to be migrated.', 'The process of exporting data involves selecting a schema and specifying the directory for the export, then initiating the export process, resulting in individual tables being exported into files at the specified directory.', 'The import process entails specifying the source directory for the import, adding a new target schema, selecting tables to import, and initiating the import process to import the database into the specified schema.']}], 'highlights': ['MySQL Workbench is available for Microsoft Windows, Linux, and Mac OS on 32-bit and 64-bit systems, offering flexibility for users across different operating systems and architectures.', 'MySQL Workbench provides functionalities for SQL development, data modeling, server administration, and data migration. Emphasizes the various core functionalities of MySQL Workbench.', 'The Enterprise Edition of MySQL Workbench offers additional features that are not available in the Community Edition or the Standard Edition.', 'The Community Edition provides all the mentioned features for MySQL Workbench.', 'The three modules of MySQL Workbench are SQL development, data modeling, and migration wizard.', 'The SQL development module includes query editors, database creation, and server administration tasks.', 'Data modeling allows users to create ER diagrams, perform forward and reverse engineering.', 'The migration wizard facilitates data migration between databases and connections, along with other tasks like manual editing and schema creation.', 'The process of adding a new connection involves specifying connection details like name, method, host, port, username, and password.', 'You can set up a default schema for the connection, allowing queries and scripts to be based on the specified default schema.', 'The process of executing SQL queries, including keyboard shortcuts The speaker demonstrates the process of executing SQL queries, explaining how to choose a default database, write and execute queries in the query pane, and use keyboard shortcuts like control shift enter and control enter for executing multiple and single queries, respectively.', "Creating tables directly from the navigator pane The speaker explains how to create new tables directly from the navigator pane by right-clicking on the tables option, choosing 'create table', adding columns and selecting options such as primary key and not null, then applying the changes to generate a script and create a new table.", 'The output pane provides options such as copy row, copy action, copy response, copy duration, append selected items to SQL script, replace, and clear, allowing users to manipulate query results.', "The results grid and execution plan options allow users to view and understand how the query is executed, providing insights into the query's performance.", 'Ability to create and manage code snippets for executing frequently used queries, enhancing efficiency in query execution.', 'Creating new models and executing queries The file option provides choices for creating new models, new query tabs, open sequel script, and options to execute queries, including limiting the number of rows and collecting performance schema stats.', 'Connecting to a database and managing schema migration wizard and data export/import options in the server tab for performance reports and schema setups in the server option and accessing utilities in the tools tab for copying code as PHP or iterating select results in scripting option.', 'Viewing documentation files and finding help for the workbench The help option provides access to documentation files, allowing users to find help for the MySQL Workbench.', 'Reverse engineering an existing database to create a model The process of reverse engineering an existing database to create a model is detailed, including specifying connection details, retrieving schema, and creating the model.', 'Manipulating the created model by changing object colors and arranging the model layout The ability to change object colors, arrange model layout, and modify table values in the created model is described.', 'Performing forward engineering to export the database to a MySQL server involves renaming the schema and executing the generated script, resulting in a new database with the specified name and containing all the objects and relationships in the model.', 'Using data modeling to modify an ER diagram involves saving the changes and ensuring the diagram is safe, showcasing the process of data modeling.', 'Generating a script through forward engineering and executing it on a sequel development module results in the creation of the new database with the specified name and containing all the objects and relationships in the model.', 'The data migration wizard allows for the migration of specific schemas and tables to a different connection, providing a step-by-step process for specifying source and target connection parameters and selecting the objects to be migrated.', 'The process of exporting data involves selecting a schema and specifying the directory for the export, then initiating the export process, resulting in individual tables being exported into files at the specified directory.', 'The import process entails specifying the source directory for the import, adding a new target schema, selecting tables to import, and initiating the import process to import the database into the specified schema.']}