title
Introduction To MySQL Workbench | MySQL Workbench Tutorial | SQL Basics For Beginners | Simplilearn

description
🔥Post Graduate Program In Data Analytics: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=SQLWorkBench&utm_medium=Descriptionff&utm_source=youtube 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=SQLWorkBench&utm_medium=Descriptionff&utm_source=youtube 🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=SQLWorkBench&utm_medium=Descriptionff&utm_source=youtube 🔥Data Analyst Masters Program (Discount Code - YTBE15): https://www.simplilearn.com/data-analyst-masters-certification-training-course?utm_campaign=SQLWorkBench&utm_medium=Descriptionff&utm_source=youtube This MySQL Workbench Tutorial video will give you an introduction to MySQL workbench and how to install MySQL windows. You learn the different functionalities of MySQL workbench and the editions available for use. You will understand how to set up a connection, and look at the different panes available on the MySQL workbench. You will get hands-on experience working with basic SQL commands. Below are the topics that you will learn: 00:00 What is MySQL Workbench? 01:05 MySQL Workbench functionalities 02:57 MySQL Workbench editions 04:02 MySQL Installation 07:10 MySQL Demo✅Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH ⏩ Check out the SQL training videos: https://www.youtube.com/watch?v=pFq1pgli0OQ&list=PLEiEAq2VkUUKL3yPbn8yWnatjUg0P0I-Z #MySQLWorkbenchTutorial #MySQLWorkBench #WhatIsMySQLWorkBench #IntroductionToSQLWorkbench #SQL #SQLForBeginners #SQLTutorial #SQLCourse #SQLTraining #Simplilearn ➡️ About Post Graduate Program In Data Analytics This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects. ✅ Key Features - Post Graduate Program certificate and Alumni Association membership - Exclusive hackathons and Ask me Anything sessions by IBM - 8X higher live interaction in live online classes by industry experts - Capstone from 3 domains and 14+ Data Analytics Projects with Industry datasets from Google PlayStore, Lyft, World Bank etc. - Master Classes delivered by Purdue faculty and IBM experts - Simplilearn's JobAssist helps you get noticed by top hiring companies - Resume preparation and LinkedIn profile building - 1:1 mock interview - Career accelerator webinars ✅ Skills Covered - Data Analytics - Statistical Analysis using Excel - Data Analysis Python and R - Data Visualization Tableau and Power BI - Linear and logistic regression modules - Clustering using kmeans - Supervised Learning 👉 Learn More at: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=SQLWorkBench&utm_medium=Description&utm_source=youtube 🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=SQLWorkBench&utm_medium=Description&utm_source=youtube 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688

detail
{'title': 'Introduction To MySQL Workbench | MySQL Workbench Tutorial | SQL Basics For Beginners | Simplilearn', 'heatmap': [{'end': 610.511, 'start': 332.08, 'weight': 0.95}, {'end': 1299.215, 'start': 1153.819, 'weight': 0.856}], 'summary': 'This mysql workbench tutorial covers the basics, features, and usage of mysql workbench, including functionalities, numeric and string manipulation functions, creating and querying a student table, sql and mysql functions with practical examples, and mysql string operations, providing comprehensive insights for beginners.', 'chapters': [{'end': 118.743, 'segs': [{'end': 97.125, 'src': 'embed', 'start': 30.428, 'weight': 0, 'content': [{'end': 35.01, 'text': "First, let's understand what is MySQL Workbench or MySQL Workbench.", 'start': 30.428, 'duration': 4.582}, {'end': 42.885, 'text': 'MySQL Workbench is a graphical tool for working with MySQL servers and databases.', 'start': 38.402, 'duration': 4.483}, {'end': 50.571, 'text': 'You may use the MySQL Workbench for server administration, for creating entity relationship diagrams and for running SQL queries.', 'start': 43.886, 'duration': 6.685}, {'end': 60.738, 'text': 'MySQL server is cross-platform meaning that it can run on number of different platforms such as Windows, Linux, macOS and others.', 'start': 52.312, 'duration': 8.426}, {'end': 67.16, 'text': 'Now, we will see the MySQL Workbench functionalities.', 'start': 62.617, 'duration': 4.543}, {'end': 71.583, 'text': 'So first, we have SQL development or SQL development.', 'start': 68.001, 'duration': 3.582}, {'end': 76.266, 'text': 'MySQL Workbench enables you to create and manage connections to database servers.', 'start': 72.304, 'duration': 3.962}, {'end': 79.869, 'text': 'Along with enabling you to configure connection parameters.', 'start': 76.947, 'duration': 2.922}, {'end': 85.873, 'text': 'MySQL Workbench provides the capability to execute SQL queries on the database connections using the built-in SQL editor.', 'start': 79.869, 'duration': 6.004}, {'end': 88.975, 'text': 'Next, we have data modeling.', 'start': 87.354, 'duration': 1.621}, {'end': 97.125, 'text': 'The data modeling functionality of MySQL allows you to create models of your database schema, graphically reverse and forward,', 'start': 89.818, 'duration': 7.307}], 'summary': 'Mysql workbench is a graphical tool for mysql servers, facilitating server administration, sql development, and data modeling.', 'duration': 66.697, 'max_score': 30.428, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc30428.jpg'}], 'start': 8.237, 'title': 'Mysql workbench basics', 'summary': 'Covers the basics of mysql workbench, including its functionalities such as sql development, data modeling, and server administration, and the cross-platform capability of mysql servers.', 'chapters': [{'end': 118.743, 'start': 8.237, 'title': 'Mysql workbench basics', 'summary': 'Covers the basics of mysql workbench, including its functionalities such as sql development, data modeling, and server administration, and the cross-platform capability of mysql servers.', 'duration': 110.506, 'highlights': ['MySQL Workbench is a graphical tool for working with MySQL servers and databases, allowing server administration, creating entity relationship diagrams, and running SQL queries.', 'MySQL server is cross-platform, capable of running on various platforms such as Windows, Linux, macOS, and others.', 'MySQL Workbench enables the creation and management of connections to database servers, along with the execution of SQL queries using the built-in SQL editor.', 'The data modeling functionality of MySQL allows the creation of database schema models, graphical reverse and forward engineering, and comprehensive editing of database aspects using the Table Editor.']}], 'duration': 110.506, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc8237.jpg', 'highlights': ['MySQL Workbench enables the creation and management of connections to database servers, along with the execution of SQL queries using the built-in SQL editor.', 'MySQL server is cross-platform, capable of running on various platforms such as Windows, Linux, macOS, and others.', 'MySQL Workbench is a graphical tool for working with MySQL servers and databases, allowing server administration, creating entity relationship diagrams, and running SQL queries.', 'The data modeling functionality of MySQL allows the creation of database schema models, graphical reverse and forward engineering, and comprehensive editing of database aspects using the Table Editor.']}, {'end': 598.942, 'segs': [{'end': 170.573, 'src': 'embed', 'start': 119.764, 'weight': 0, 'content': [{'end': 128.41, 'text': 'It enables you to administer MySQL Server instances by administering users performing backup and recovery, inspecting audit data,', 'start': 119.764, 'duration': 8.646}, {'end': 131.612, 'text': 'viewing database health and monitoring the MySQL Server performance.', 'start': 128.41, 'duration': 3.202}, {'end': 135.895, 'text': 'Fourth, we have data migration.', 'start': 134.174, 'duration': 1.721}, {'end': 147.43, 'text': 'This functionality of MySQL Workbench allows you to migrate from Microsoft SQL Server, Microsoft AccessDB, Sybase, SQLite, SQLanywhere,', 'start': 137.848, 'duration': 9.582}, {'end': 153.032, 'text': 'PostgreSQL and other relational database management system tables, objects and data to MySQL.', 'start': 147.43, 'duration': 5.602}, {'end': 158.153, 'text': 'Migration also supports migrating from earlier versions of MySQL to the latest releases.', 'start': 153.932, 'duration': 4.221}, {'end': 162.609, 'text': 'And finally, we have MySQL Enterprise support.', 'start': 159.448, 'duration': 3.161}, {'end': 170.573, 'text': 'The MySQL Workbench has support for enterprise products such as MySQL Enterprise Backup, MySQL Firewall, and MySQL Audit.', 'start': 163.37, 'duration': 7.203}], 'summary': 'Mysql workbench administers users, performs data migration from various databases to mysql, and supports enterprise products.', 'duration': 50.809, 'max_score': 119.764, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc119764.jpg'}, {'end': 295.699, 'src': 'embed', 'start': 264.935, 'weight': 2, 'content': [{'end': 270.2, 'text': 'so we will install the community edition of MySQL workbench.', 'start': 264.935, 'duration': 5.265}, {'end': 278.201, 'text': 'if I click on this, it will take you to another page where you have all the mysql community downloads,', 'start': 270.2, 'duration': 8.001}, {'end': 282.225, 'text': 'and here you will find something called as mysql installer for windows.', 'start': 278.201, 'duration': 4.024}, {'end': 291.314, 'text': "i'll click on this and here you can see we have the mysql installer 8.0 version.", 'start': 282.225, 'duration': 9.089}, {'end': 293.917, 'text': 'please go ahead and install from this link.', 'start': 291.314, 'duration': 2.603}, {'end': 295.699, 'text': 'you can just click on download.', 'start': 293.917, 'duration': 1.782}], 'summary': 'Install mysql workbench community edition 8.0 for windows.', 'duration': 30.764, 'max_score': 264.935, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc264935.jpg'}, {'end': 486.131, 'src': 'embed', 'start': 426.796, 'weight': 3, 'content': [{'end': 433.683, 'text': 'so let me open my mysql workbench, where we will perform some hands-on demonstrations and look at how to use mysql functions.', 'start': 426.796, 'duration': 6.887}, {'end': 435.966, 'text': "write different commands and we'll see the results.", 'start': 433.683, 'duration': 2.283}, {'end': 441.086, 'text': "So here on the search bar I'll type MySQL.", 'start': 438.584, 'duration': 2.502}, {'end': 445.089, 'text': 'So it says MySQL Workbench 8.0 version.', 'start': 441.987, 'duration': 3.102}, {'end': 445.77, 'text': 'Let me open it.', 'start': 445.13, 'duration': 0.64}, {'end': 453.817, 'text': 'Okay You can see I have a local instance connection.', 'start': 449.934, 'duration': 3.883}, {'end': 457.86, 'text': "I'll connect to this and I'll enter the password.", 'start': 454.397, 'duration': 3.463}, {'end': 461.904, 'text': 'So this is how my MySQL Workbench interface looks like.', 'start': 458.601, 'duration': 3.303}, {'end': 464.786, 'text': 'Let me just drag this to the top.', 'start': 462.144, 'duration': 2.642}, {'end': 467.45, 'text': 'Okay, now,', 'start': 465.827, 'duration': 1.623}, {'end': 477.802, 'text': 'the white workspace that you see here is called the sql visual editor and below you will have the result pane and the history output window.', 'start': 467.45, 'duration': 10.352}, {'end': 486.131, 'text': "i'll show you once i run a query and on the right hand side you can see we have a help pane or a help window.", 'start': 477.802, 'duration': 8.329}], 'summary': 'Demonstration of mysql workbench with version 8.0, showing sql visual editor, result pane, history output window, and help pane.', 'duration': 59.335, 'max_score': 426.796, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc426796.jpg'}], 'start': 119.764, 'title': 'Mysql workbench features and usage', 'summary': 'Provides an overview of mysql workbench, including its features such as administering users, backup and recovery, data migration, and support for enterprise products. it also demonstrates the installation process on windows and how to create and test mysql connections, navigate through mysql workbench, create a new database, and execute sql queries.', 'chapters': [{'end': 342.445, 'start': 119.764, 'title': 'Mysql workbench: features and installation', 'summary': 'Provides an overview of mysql workbench, including its features such as administering users, backup and recovery, data migration, and support for enterprise products. it also covers the availability of different editions of mysql workbench and demonstrates the installation process on windows.', 'duration': 222.681, 'highlights': ['MySQL Workbench provides features such as administering users, performing backup and recovery, inspecting audit data, viewing database health, and monitoring MySQL Server performance.', 'MySQL Workbench allows data migration from various relational database management systems, including Microsoft SQL Server, Microsoft AccessDB, Sybase, SQLite, SQLanywhere, PostgreSQL, and earlier versions of MySQL to the latest releases.', 'MySQL Workbench offers support for enterprise products such as MySQL Enterprise Backup, MySQL Firewall, and MySQL Audit.', 'MySQL Workbench is available in editions such as Community, Standard, and Enterprise, each offering different features and support options.', 'The installation process of MySQL Workbench on Windows is demonstrated, including the download of the Community edition and the launch of MySQL Workbench.']}, {'end': 598.942, 'start': 343.2, 'title': 'Creating and testing mysql connections', 'summary': 'Demonstrates how to create a new mysql connection, successfully test the connection, and navigate through mysql workbench while also showcasing the creation of a new database and executing sql queries.', 'duration': 255.742, 'highlights': ["Successfully testing the MySQL connection and creating a new database named 'sql workbench' with the execution of queries", 'Step-by-step process of creating a new MySQL connection and entering into a database', 'Explaining the components of MySQL Workbench interface and demonstrating the usage of help window and administration options']}], 'duration': 479.178, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc119764.jpg', 'highlights': ['MySQL Workbench provides features such as administering users, backup and recovery, data migration, and support for enterprise products.', 'MySQL Workbench allows data migration from various relational database management systems to the latest releases.', 'The installation process of MySQL Workbench on Windows is demonstrated, including the download of the Community edition and the launch of MySQL Workbench.', "Successfully testing the MySQL connection and creating a new database named 'sql workbench' with the execution of queries", 'Explaining the components of MySQL Workbench interface and demonstrating the usage of help window and administration options']}, {'end': 1024.632, 'segs': [{'end': 657.424, 'src': 'embed', 'start': 625.002, 'weight': 3, 'content': [{'end': 635.17, 'text': "so for using the absolute function, I'll write select abs and inside this abs function I'll pass in a value, let's say 22.", 'start': 625.002, 'duration': 10.168}, {'end': 650.679, 'text': 'now, if I run this, it gives me a result that is 22, since the absolute value of 22 is 22, because 22 we have passed in as a positive value.', 'start': 635.17, 'duration': 15.509}, {'end': 656.643, 'text': "now let's say I'll pass in minus 22 and let's run it.", 'start': 650.679, 'duration': 5.964}, {'end': 657.424, 'text': 'there you go.', 'start': 656.643, 'duration': 0.781}], 'summary': 'Using the abs function with a value of 22 returns 22 as the result, demonstrating the absolute value calculation.', 'duration': 32.422, 'max_score': 625.002, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc625002.jpg'}, {'end': 720.404, 'src': 'embed', 'start': 685.359, 'weight': 2, 'content': [{'end': 699.723, 'text': "so if I write select mod and I want to divide 10 by 4, let's run this and see the result.", 'start': 685.359, 'duration': 14.364}, {'end': 706.405, 'text': 'you can see, it has returned me 2, because the remainder for 10, divided by 4, is 2.', 'start': 699.723, 'duration': 6.682}, {'end': 709.645, 'text': 'you can also give an alias name to this.', 'start': 706.405, 'duration': 3.24}, {'end': 711.626, 'text': "I'll write as remainder.", 'start': 709.645, 'duration': 1.981}, {'end': 720.404, 'text': 'the reason why I am giving an alias name is because the result we have got, if you see the column, this is not very readable.', 'start': 713.16, 'duration': 7.244}], 'summary': "Using sql, 'select mod' divides 10 by 4, returning the remainder 2, with the option to assign an alias for clarity.", 'duration': 35.045, 'max_score': 685.359, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc685359.jpg'}, {'end': 991.311, 'src': 'embed', 'start': 801.323, 'weight': 0, 'content': [{'end': 803.084, 'text': "let's see the result.", 'start': 801.323, 'duration': 1.761}, {'end': 804.225, 'text': "I'll run it.", 'start': 803.084, 'duration': 1.141}, {'end': 807.687, 'text': 'it gives me 16, which is correct.', 'start': 804.225, 'duration': 3.462}, {'end': 811.395, 'text': "let's see.", 'start': 809.013, 'duration': 2.382}, {'end': 817.301, 'text': "I'll write select power 10 raised to 3.", 'start': 811.395, 'duration': 5.906}, {'end': 819.944, 'text': 'you can already think of the result.', 'start': 817.301, 'duration': 2.643}, {'end': 820.525, 'text': 'it should be 1000.', 'start': 819.944, 'duration': 0.581}, {'end': 828.421, 'text': 'okay, now like how you use the power function.', 'start': 820.525, 'duration': 7.896}, {'end': 830.962, 'text': 'similarly, you can use the square root function.', 'start': 828.421, 'duration': 2.541}, {'end': 834.963, 'text': 'in mysql, the square root function is written as sqrt.', 'start': 830.962, 'duration': 4.001}, {'end': 840.605, 'text': 'so you can get the square root of a number by using the sqrt function.', 'start': 834.963, 'duration': 5.642}, {'end': 845.046, 'text': "let's say i want to find the square root of 4.", 'start': 840.605, 'duration': 4.441}, {'end': 849.027, 'text': 'if i run this, it gives me 2, which is the square root of 4.', 'start': 845.046, 'duration': 3.981}, {'end': 849.967, 'text': "i'll edit here itself.", 'start': 849.027, 'duration': 0.94}, {'end': 861.064, 'text': "let's say i want to find the square root of 144, where on this it gives me 12, which is the square root of 144.", 'start': 849.967, 'duration': 11.097}, {'end': 867.448, 'text': "now, moving ahead, let's say you want to find the greatest number within a range of numbers.", 'start': 861.064, 'duration': 6.384}, {'end': 872.871, 'text': 'you can use the greatest function that is available in MySQL.', 'start': 867.448, 'duration': 5.423}, {'end': 876.693, 'text': "I'll write select greatest.", 'start': 872.871, 'duration': 3.822}, {'end': 877.794, 'text': "I'll give a range of numbers.", 'start': 876.693, 'duration': 1.101}, {'end': 887.794, 'text': "let's say 2, 5, 18, 6 and let's say 12.", 'start': 877.794, 'duration': 10}, {'end': 891.315, 'text': 'you give a semicolon and let me run it.', 'start': 887.794, 'duration': 3.521}, {'end': 898.217, 'text': 'it returns me 18, because 18 is the largest or the greatest number in my range of numbers.', 'start': 891.315, 'duration': 6.902}, {'end': 901.738, 'text': 'similarly, you can also find the least number.', 'start': 898.217, 'duration': 3.521}, {'end': 904.419, 'text': 'for that you can use the least function.', 'start': 901.738, 'duration': 2.681}, {'end': 907.92, 'text': 'this will return me the minimum number present in my range of numbers.', 'start': 904.419, 'duration': 3.501}, {'end': 909.981, 'text': 'in this case it is 2.', 'start': 907.92, 'duration': 2.061}, {'end': 916.45, 'text': "all right, There's another function that is available in MySQL is truncate.", 'start': 909.981, 'duration': 6.469}, {'end': 921.295, 'text': 'So the truncate function truncates a number to the specified number of decimal places.', 'start': 916.93, 'duration': 4.365}, {'end': 926.441, 'text': 'So suppose I write select truncate 22.897 comma 1.', 'start': 922.276, 'duration': 4.165}, {'end': 928.082, 'text': "Let's see the output.", 'start': 926.441, 'duration': 1.641}, {'end': 938.606, 'text': 'okay, you can see here.', 'start': 936.084, 'duration': 2.522}, {'end': 947.474, 'text': 'so the truncate function has returned us 22.8 and it has truncated the rest of the decimal places.', 'start': 938.606, 'duration': 8.868}, {'end': 950.617, 'text': 'i want to truncate up to two decimal places.', 'start': 947.474, 'duration': 3.143}, {'end': 952.539, 'text': "let's see the result again.", 'start': 950.617, 'duration': 1.922}, {'end': 954.181, 'text': 'you can see here.', 'start': 952.539, 'duration': 1.642}, {'end': 960.106, 'text': 'it has given us 22.89.', 'start': 954.181, 'duration': 5.925}, {'end': 963.628, 'text': 'next we have another function called round.', 'start': 960.106, 'duration': 3.522}, {'end': 968.872, 'text': 'so the round function in mysql is used to round a number to a specified number of decimal places.', 'start': 963.628, 'duration': 5.244}, {'end': 976.998, 'text': 'if no specified number of decimal places is provided to round of function, the round of function rounds the number to the nearest integer.', 'start': 968.872, 'duration': 8.126}, {'end': 979.64, 'text': "so let's see a few examples.", 'start': 976.998, 'duration': 2.642}, {'end': 981.441, 'text': 'suppose i want to round the value 22.897.', 'start': 979.64, 'duration': 1.801}, {'end': 991.311, 'text': 'this time i am not passing the specified number of decimal places.', 'start': 981.441, 'duration': 9.87}], 'summary': 'Mysql functions demonstrated: power, sqrt, greatest, least, truncate, round', 'duration': 189.988, 'max_score': 801.323, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc801323.jpg'}], 'start': 598.942, 'title': 'Mysql numeric and number manipulation functions', 'summary': 'Explores mysql numeric functions such as absolute, mod, power, and square root, demonstrating their usage and results. it also covers functions for number manipulation including greatest, least, truncate, and round, showcasing their practical applications with examples and outputs.', 'chapters': [{'end': 861.064, 'start': 598.942, 'title': 'Mysql numeric functions', 'summary': 'Explores numeric functions in mysql, including absolute, mod, power, and square root functions, with examples and demonstrations, showcasing their usage and results.', 'duration': 262.122, 'highlights': ['The absolute function in MySQL returns the absolute value of a number, dropping the negative sign, with examples of positive and negative values like 22 and -22.', 'The mod function in MySQL returns the remainder of a division, demonstrated with examples like 10 divided by 4, 15 divided by 3, and 50.6 divided by 2.', 'The power function in MySQL calculates the power of a number, demonstrated with examples like 4 raised to 2 and 10 raised to 3, showcasing the results of 16 and 1000.', 'The square root function in MySQL returns the square root of a number, demonstrated with examples like the square root of 4 and 144, showcasing the results of 2 and 12.']}, {'end': 1024.632, 'start': 861.064, 'title': 'Mysql functions for number manipulation', 'summary': 'Covers the usage of greatest, least, truncate, and round functions in mysql for finding the largest, smallest, truncating decimal places, and rounding numbers with examples and outputs.', 'duration': 163.568, 'highlights': ['The greatest function in MySQL can be used to find the largest number within a range of numbers, such as selecting greatest 2, 5, 18, 6, 12, returning the result 18 as the largest number.', 'The round function in MySQL can round a number to a specified number of decimal places, for example rounding 22.897 to 2 decimal places results in 22.90.', 'The least function in MySQL returns the minimum number present in a range of numbers, such as least 2, 5, 18, 6, 12, resulting in 2 as the minimum number.', 'The truncate function in MySQL truncates a number to the specified number of decimal places, for example truncating 22.897 to 1 decimal place results in 22.8.']}], 'duration': 425.69, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc598942.jpg', 'highlights': ['The power function in MySQL calculates the power of a number, demonstrated with examples like 4 raised to 2 and 10 raised to 3, showcasing the results of 16 and 1000.', 'The square root function in MySQL returns the square root of a number, demonstrated with examples like the square root of 4 and 144, showcasing the results of 2 and 12.', 'The mod function in MySQL returns the remainder of a division, demonstrated with examples like 10 divided by 4, 15 divided by 3, and 50.6 divided by 2.', 'The absolute function in MySQL returns the absolute value of a number, dropping the negative sign, with examples of positive and negative values like 22 and -22.', 'The greatest function in MySQL can be used to find the largest number within a range of numbers, such as selecting greatest 2, 5, 18, 6, 12, returning the result 18 as the largest number.', 'The least function in MySQL returns the minimum number present in a range of numbers, such as least 2, 5, 18, 6, 12, resulting in 2 as the minimum number.', 'The round function in MySQL can round a number to a specified number of decimal places, for example rounding 22.897 to 2 decimal places results in 22.90.', 'The truncate function in MySQL truncates a number to the specified number of decimal places, for example truncating 22.897 to 1 decimal place results in 22.8.']}, {'end': 1478.384, 'segs': [{'end': 1059.069, 'src': 'embed', 'start': 1024.632, 'weight': 3, 'content': [{'end': 1036.415, 'text': "all right now let's create a students table and store it in our mysql workbench.", 'start': 1024.632, 'duration': 11.783}, {'end': 1042.916, 'text': "so i'll just give a comment called student table or students table.", 'start': 1036.415, 'duration': 6.501}, {'end': 1056.127, 'text': 'alright. so the way to create a table in a database in MySQL workbench is you write create table, followed by the table name that you want.', 'start': 1044.201, 'duration': 11.926}, {'end': 1059.069, 'text': "in this case I'm going to create a student's table.", 'start': 1056.127, 'duration': 2.942}], 'summary': "Creating a student table in mysql workbench using 'create table' command.", 'duration': 34.437, 'max_score': 1024.632, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc1024632.jpg'}, {'end': 1299.215, 'src': 'heatmap', 'start': 1088.437, 'weight': 0, 'content': [{'end': 1097.983, 'text': 'so the primary key will uniquely identify each record in a table and it cannot have any duplicate values.', 'start': 1088.437, 'duration': 9.546}, {'end': 1107.416, 'text': 'so ideally, if you think all the students in a school will have a unique roll number, no two students will have the same roll number.', 'start': 1097.983, 'duration': 9.433}, {'end': 1110.438, 'text': 'next column I want is the student name.', 'start': 1107.416, 'duration': 3.022}, {'end': 1118.284, 'text': "now the name is of type Varkar and I will give the length as, let's say, 25.", 'start': 1110.438, 'duration': 7.846}, {'end': 1120.506, 'text': 'then I want the age of the student.', 'start': 1118.284, 'duration': 2.222}, {'end': 1126.151, 'text': 'age is also of type integer and I will write in the same line.', 'start': 1120.506, 'duration': 5.645}, {'end': 1127.772, 'text': 'then I need the gender.', 'start': 1126.151, 'duration': 1.621}, {'end': 1133.685, 'text': 'gender of the student should be of type character and the size.', 'start': 1129.042, 'duration': 4.643}, {'end': 1137.548, 'text': "i'll give us one.", 'start': 1133.685, 'duration': 3.863}, {'end': 1144.873, 'text': 'then we have doa, which stands for date of admission and it is of type date.', 'start': 1137.548, 'duration': 7.325}, {'end': 1153.819, 'text': 'then we have the city to which the student belongs to, then city is also of type varchar.', 'start': 1144.873, 'duration': 8.946}, {'end': 1158.001, 'text': 'all right, you close the bracket and give a semicolon.', 'start': 1153.819, 'duration': 4.182}, {'end': 1158.622, 'text': "let's run this.", 'start': 1158.001, 'duration': 0.621}, {'end': 1161.087, 'text': 'there you go.', 'start': 1160.086, 'duration': 1.001}, {'end': 1167.031, 'text': 'here you can see in the history window it says the table was created successfully.', 'start': 1161.087, 'duration': 5.944}, {'end': 1172.856, 'text': "now let's just refresh this again so that you can see the table here.", 'start': 1167.031, 'duration': 5.825}, {'end': 1177.94, 'text': 'under mysql workbench database, under tables, you can see we have a students table.', 'start': 1172.856, 'duration': 5.084}, {'end': 1183.224, 'text': 'let me expand this further so that you can see the columns that we have.', 'start': 1177.94, 'duration': 5.284}, {'end': 1184.244, 'text': 'there you go.', 'start': 1183.224, 'duration': 1.02}, {'end': 1188.888, 'text': 'we have the student id, the student name, age, gender, date of admission and the city.', 'start': 1184.244, 'duration': 4.644}, {'end': 1197.123, 'text': "okay, now it's time to insert a few records to this table.", 'start': 1190.64, 'duration': 6.483}, {'end': 1201.344, 'text': 'for that you need to write the insert statement.', 'start': 1197.123, 'duration': 4.221}, {'end': 1205.086, 'text': "now i'm going to open a notepad where i have already written the insert statement.", 'start': 1201.344, 'duration': 3.742}, {'end': 1208.027, 'text': 'so let me just copy paste it here.', 'start': 1205.086, 'duration': 2.941}, {'end': 1212.869, 'text': 'okay, so here on my notepad i have my insert statement already written.', 'start': 1208.027, 'duration': 4.842}, {'end': 1217.971, 'text': "i'll just copy this and i'll paste it on my workspace.", 'start': 1212.869, 'duration': 5.102}, {'end': 1227.059, 'text': 'okay, if i go to the top, you can see this is how my insert into command look like.', 'start': 1219.398, 'duration': 7.661}, {'end': 1230.52, 'text': 'you have insert into, followed by the table name, which is students.', 'start': 1227.059, 'duration': 3.461}, {'end': 1235.941, 'text': 'then you have the values keyword and we have the set of records.', 'start': 1230.52, 'duration': 5.421}, {'end': 1246.463, 'text': "so the first value represents the student id or the roll number, then you have the student's name, you have the age, you have the gender,", 'start': 1235.941, 'duration': 10.522}, {'end': 1251.606, 'text': 'then we have the date of admission and then we have the city to which the student belongs.', 'start': 1246.463, 'duration': 5.143}, {'end': 1260.31, 'text': 'to all right now let me go ahead and run my insert query.', 'start': 1251.606, 'duration': 8.704}, {'end': 1264.331, 'text': "i'll just select everything and i'll hit on execute.", 'start': 1260.31, 'duration': 4.021}, {'end': 1270.874, 'text': 'you can see here we have successfully inserted 20 rows of information to our table.', 'start': 1264.331, 'duration': 6.543}, {'end': 1285.228, 'text': 'now, if you want to check all the records in a table, SQL command is select star from table name, that is, students.', 'start': 1270.874, 'duration': 14.354}, {'end': 1288.489, 'text': 'if I run this, this is my output.', 'start': 1285.228, 'duration': 3.261}, {'end': 1293.472, 'text': 'you can see we have the student id, the student name, each gender, date of admission and city.', 'start': 1288.489, 'duration': 4.983}, {'end': 1299.215, 'text': 'if I scroll down, there are total 20 rows of information in my table.', 'start': 1293.472, 'duration': 5.743}], 'summary': "Created a table 'students' with 20 records, each containing student id, name, age, gender, date of admission, and city.", 'duration': 69.564, 'max_score': 1088.437, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc1088437.jpg'}, {'end': 1293.472, 'src': 'embed', 'start': 1264.331, 'weight': 4, 'content': [{'end': 1270.874, 'text': 'you can see here we have successfully inserted 20 rows of information to our table.', 'start': 1264.331, 'duration': 6.543}, {'end': 1285.228, 'text': 'now, if you want to check all the records in a table, SQL command is select star from table name, that is, students.', 'start': 1270.874, 'duration': 14.354}, {'end': 1288.489, 'text': 'if I run this, this is my output.', 'start': 1285.228, 'duration': 3.261}, {'end': 1293.472, 'text': 'you can see we have the student id, the student name, each gender, date of admission and city.', 'start': 1288.489, 'duration': 4.983}], 'summary': "Successfully inserted 20 rows; sql command 'select * from students' displays student data.", 'duration': 29.141, 'max_score': 1264.331, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc1264331.jpg'}, {'end': 1440.699, 'src': 'embed', 'start': 1400.895, 'weight': 6, 'content': [{'end': 1405.237, 'text': 'in the output you can see there are total four students who are from pune.', 'start': 1400.895, 'duration': 4.342}, {'end': 1412.2, 'text': 'you have joseph, anubhav, akshay and anand, all right.', 'start': 1405.237, 'duration': 6.963}, {'end': 1422.409, 'text': "now let's say you want to filter only those students who are from Miami and their gender is male.", 'start': 1412.2, 'duration': 10.209}, {'end': 1428.913, 'text': 'again you are going to use the WHERE clause and along with the WHERE clause we will use the AND operator.', 'start': 1422.409, 'duration': 6.504}, {'end': 1440.699, 'text': "so I'll write SELECT star from students WHERE city equal to.", 'start': 1428.913, 'duration': 11.786}], 'summary': 'There are four students from pune; filtering for miami male students using where and and operators.', 'duration': 39.804, 'max_score': 1400.895, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc1400895.jpg'}], 'start': 1024.632, 'title': 'Creating and querying a student table in mysql', 'summary': 'Covers creating a student table in mysql workbench with columns for student id, name, age, gender, date of admission, and city, along with performing sql queries to insert 20 records and retrieve specific data using the where clause.', 'chapters': [{'end': 1158.001, 'start': 1024.632, 'title': 'Creating student table in mysql workbench', 'summary': 'Demonstrates the process of creating a student table in mysql workbench, specifying columns including student id, name, age, gender, date of admission, and city with their respective data types and constraints.', 'duration': 133.369, 'highlights': ['The primary key, student ID, is defined as an integer type to uniquely identify each record in the table, ensuring no duplicate values.', 'The student name column is set as Varchar with a length of 25, while the age is specified as an integer data type.', 'The process also includes defining the gender column as a character with a size of one, and specifying the date of admission and city columns with their respective data types.', 'The chapter details the creation of a student table in MySQL Workbench, outlining the process of specifying columns including student ID, name, age, gender, date of admission, and city with their respective data types and constraints.']}, {'end': 1478.384, 'start': 1158.001, 'title': 'Creating mysql table and performing sql queries', 'summary': 'Demonstrates the creation of a student table in mysql, insertion of 20 records, and execution of sql queries to retrieve specific data such as student names, ages, and cities, along with the usage of the where clause for filtering records based on conditions.', 'duration': 320.383, 'highlights': ['The chapter demonstrates the creation of a student table in MySQL and insertion of 20 records.', 'Execution of SQL queries to retrieve specific data such as student names, ages, and cities.', 'Usage of the WHERE clause for filtering records based on conditions, such as displaying only the records of students from Pune or Miami with specific genders.']}], 'duration': 453.752, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc1024632.jpg', 'highlights': ['The primary key, student ID, is defined as an integer type to uniquely identify each record in the table, ensuring no duplicate values.', 'The student name column is set as Varchar with a length of 25, while the age is specified as an integer data type.', 'The process also includes defining the gender column as a character with a size of one, and specifying the date of admission and city columns with their respective data types.', 'The chapter details the creation of a student table in MySQL Workbench, outlining the process of specifying columns including student ID, name, age, gender, date of admission, and city with their respective data types and constraints.', 'The chapter demonstrates the creation of a student table in MySQL and insertion of 20 records.', 'Execution of SQL queries to retrieve specific data such as student names, ages, and cities.', 'Usage of the WHERE clause for filtering records based on conditions, such as displaying only the records of students from Pune or Miami with specific genders.']}, {'end': 2173.106, 'segs': [{'end': 1612.014, 'src': 'embed', 'start': 1503.07, 'weight': 0, 'content': [{'end': 1514.439, 'text': "so here, instead of Miami, I'll write Boston, I'll use an or clause or an or operator, and instead of gender equal to male,", 'start': 1503.07, 'duration': 11.369}, {'end': 1519.283, 'text': "I'll again write or city equal to Chicago.", 'start': 1514.439, 'duration': 4.844}, {'end': 1526.612, 'text': 'Let us run the SQL query and see what we have.', 'start': 1522.85, 'duration': 3.762}, {'end': 1534.276, 'text': 'So there are total six students who are either from city, Chicago or from Boston.', 'start': 1527.392, 'duration': 6.884}, {'end': 1537.197, 'text': 'We also have a female student, Eliana.', 'start': 1534.516, 'duration': 2.681}, {'end': 1538.858, 'text': 'All right.', 'start': 1538.558, 'duration': 0.3}, {'end': 1547.282, 'text': "Moving further, let's say you want to display the records of the students.", 'start': 1541.599, 'duration': 5.683}, {'end': 1552.976, 'text': 'belong to any city rather than chicago.', 'start': 1548.653, 'duration': 4.323}, {'end': 1556.458, 'text': 'in that case you are going to use the not operator.', 'start': 1552.976, 'duration': 3.482}, {'end': 1568.686, 'text': "so i'll write select star from students where not city equal to chicago.", 'start': 1556.458, 'duration': 12.228}, {'end': 1570.827, 'text': "let's run it and see the result.", 'start': 1568.686, 'duration': 2.141}, {'end': 1573.271, 'text': 'all right, you can see.', 'start': 1572.25, 'duration': 1.021}, {'end': 1584.276, 'text': 'total we have returned 17 rows of information, which means there are total 17 students who belong to other cities apart from Chicago.', 'start': 1573.271, 'duration': 11.005}, {'end': 1593.781, 'text': "if you see the result, you won't find any student who is from Chicago City.", 'start': 1584.276, 'duration': 9.505}, {'end': 1608.233, 'text': "okay now there's another important feature of mysql where you can group certain rows of information based on a particular column or columns.", 'start': 1593.781, 'duration': 14.452}, {'end': 1612.014, 'text': "so let's see how to use group by in mysql.", 'start': 1608.233, 'duration': 3.781}], 'summary': "Sql query returns 6 students from chicago or boston. using 'not' operator returns 17 students not from chicago.", 'duration': 108.944, 'max_score': 1503.07, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc1503070.jpg'}, {'end': 1721.471, 'src': 'embed', 'start': 1692.099, 'weight': 3, 'content': [{'end': 1696.202, 'text': 'and this total students column has the total number of students from each city.', 'start': 1692.099, 'duration': 4.103}, {'end': 1702.528, 'text': 'so if you see here, New York has 4 students, Pune has 4 students, in Miami,', 'start': 1696.202, 'duration': 6.326}, {'end': 1708.833, 'text': 'Chicago we have 4 and 3 students and in Detroit we have 2 students respectively.', 'start': 1702.528, 'duration': 6.305}, {'end': 1721.471, 'text': 'all right, the next clause we are going to see is having, now having and where are kind of similar, but there are certain differences.', 'start': 1710.325, 'duration': 11.146}], 'summary': 'Total students: new york 4, pune 4, miami 4, chicago 3, detroit 2', 'duration': 29.372, 'max_score': 1692.099, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc1692099.jpg'}, {'end': 2000.325, 'src': 'embed', 'start': 1926.796, 'weight': 4, 'content': [{'end': 1937.462, 'text': "similarly, let me just copy this and I'll show you if you want to convert a string into a lower case, you can use the lower function.", 'start': 1926.796, 'duration': 10.666}, {'end': 1939.422, 'text': "I'll run this.", 'start': 1937.462, 'duration': 1.96}, {'end': 1943.168, 'text': 'you can see the result Everything is in lowercase now.', 'start': 1939.422, 'duration': 3.746}, {'end': 1945.908, 'text': 'Of course, I need to change the alias name to lowercase.', 'start': 1943.228, 'duration': 2.68}, {'end': 1954.65, 'text': 'Instead of using lower as the function, there is another function that MySQL provides, which is called the lcase.', 'start': 1948.109, 'duration': 6.541}, {'end': 1957.731, 'text': "I'll just edit this and write lcase.", 'start': 1955.491, 'duration': 2.24}, {'end': 1965.013, 'text': "And let's say I'll write India in uppercase.", 'start': 1959.111, 'duration': 5.902}, {'end': 1966.453, 'text': "Let's run it.", 'start': 1965.913, 'duration': 0.54}, {'end': 1968.454, 'text': 'It returns me the same result.', 'start': 1967.093, 'duration': 1.361}, {'end': 1979.202, 'text': "Cool Moving on, let's say you want to find the length of a string, you can use the character length function.", 'start': 1969.714, 'duration': 9.488}, {'end': 1994.089, 'text': "I'll write select, use the function character length and I'm again going to pass in my string as India as let's say total length.", 'start': 1980.783, 'duration': 13.306}, {'end': 2000.325, 'text': "let's run it.", 'start': 1999.184, 'duration': 1.141}], 'summary': 'Demonstrated string manipulation functions in mysql, including lower and lcase, with practical examples.', 'duration': 73.529, 'max_score': 1926.796, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc1926796.jpg'}], 'start': 1478.384, 'title': 'Sql and mysql functions', 'summary': "Demonstrates the use of or and not operators in sql to filter student records based on cities, yielding a total of six students from either boston or chicago, and displaying records of students not belonging to chicago. it also discusses the application of mysql functions including 'group by' and 'order by' to analyze student data, revealing a total of 17 students from six different cities, with new york, pune, and miami having more than 3 students each. additionally, it covers string functions in mysql, including converting strings to upper and lower case, finding string length, applying functions to tables, and using concat function, with examples and quantifiable data.", 'chapters': [{'end': 1573.271, 'start': 1478.384, 'title': 'Sql operators for filtering data', 'summary': 'Demonstrates the use of or and not operators in sql to filter student records based on cities, yielding a total of six students from either boston or chicago, and displaying records of students not belonging to chicago.', 'duration': 94.887, 'highlights': ['A total of six students are from either Chicago or Boston, including a female student named Eliana.', 'The SQL query using the NOT operator displays records of students not belonging to Chicago.']}, {'end': 1860.651, 'start': 1573.271, 'title': 'Mysql group by and order by', 'summary': "Discusses the application of mysql functions including 'group by' and 'order by' to analyze student data, revealing a total of 17 students from six different cities, with new york, pune, and miami having more than 3 students each.", 'duration': 287.38, 'highlights': ["The chapter illustrates the use of 'group by' in MySQL to count the total number of students in each city, revealing 6 cities with a total of 17 students, with New York and Pune having 4 students each, and Miami and Chicago having 4 and 3 students respectively.", "Furthermore, it demonstrates the application of the 'having' clause to identify cities with more than 3 students, resulting in the retrieval of records for Pune, New York, and Miami.", "Additionally, it explains the functionality of the 'order by' clause to sort the records in either ascending or descending order based on a specific column, showcasing the alphabetical ordering of cities, and then demonstrating the descending order sorting based on the city column."]}, {'end': 2173.106, 'start': 1860.651, 'title': 'Mysql string functions', 'summary': 'Covers string functions in mysql, including converting strings to upper and lower case, finding string length, applying functions to tables, and using concat function, with examples and quantifiable data.', 'duration': 312.455, 'highlights': ['The chapter covers string functions in MySQL, including converting strings to upper and lower case, finding string length, applying functions to tables, and using concat function.', "The character length function is demonstrated with the example of finding the length of the string 'India', which returns a length of 5.", "The chapter demonstrates applying the character length and charLength functions to a table, providing the length of each student's name.", "The usage of the concat function is illustrated with an example of concatenating the strings 'India is in Asia', with a resulting concatenated string 'India is in Asia'."]}], 'duration': 694.722, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc1478384.jpg', 'highlights': ['A total of six students are from either Chicago or Boston, including a female student named Eliana.', 'The SQL query using the NOT operator displays records of students not belonging to Chicago.', "The chapter illustrates the use of 'group by' in MySQL to count the total number of students in each city, revealing 6 cities with a total of 17 students, with New York and Pune having 4 students each, and Miami and Chicago having 4 and 3 students respectively.", "Furthermore, it demonstrates the application of the 'having' clause to identify cities with more than 3 students, resulting in the retrieval of records for Pune, New York, and Miami.", 'The chapter covers string functions in MySQL, including converting strings to upper and lower case, finding string length, applying functions to tables, and using concat function.', "The character length function is demonstrated with the example of finding the length of the string 'India', which returns a length of 5."]}, {'end': 2750.415, 'segs': [{'end': 2274.608, 'src': 'embed', 'start': 2216.937, 'weight': 1, 'content': [{'end': 2221.081, 'text': 'okay, you see, here the result is very clear.', 'start': 2216.937, 'duration': 4.144}, {'end': 2229.047, 'text': 'we have the student id, the student name and the concatenated column that we created, which was name, underscore age,', 'start': 2221.081, 'duration': 7.966}, {'end': 2235.986, 'text': 'where we have the student name with a space followed by the age of the student.', 'start': 2229.047, 'duration': 6.939}, {'end': 2239.288, 'text': 'if you scroll down, you can see the rest of the results.', 'start': 2235.986, 'duration': 3.302}, {'end': 2248.034, 'text': "cool, now moving ahead, let's see how the reverse function works in mysql.", 'start': 2239.288, 'duration': 8.746}, {'end': 2252.518, 'text': 'so the mysql reverse function returns a string with the characters printed in reverse order.', 'start': 2248.034, 'duration': 4.484}, {'end': 2256.599, 'text': 'So suppose I write select reverse.', 'start': 2253.297, 'duration': 3.302}, {'end': 2259.06, 'text': "I'll use the same string again.", 'start': 2257.619, 'duration': 1.441}, {'end': 2262.061, 'text': "Let's say I have India.", 'start': 2259.46, 'duration': 2.601}, {'end': 2265.083, 'text': "Let's run it.", 'start': 2264.503, 'duration': 0.58}, {'end': 2269.425, 'text': 'You will see all the characters printed in reverse order.', 'start': 2265.923, 'duration': 3.502}, {'end': 2274.608, 'text': 'Again, you can perform the same operation on a table as well.', 'start': 2270.025, 'duration': 4.583}], 'summary': 'Demonstrated concatenation of student names and ages, and usage of reverse function in mysql.', 'duration': 57.671, 'max_score': 2216.937, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc2216937.jpg'}, {'end': 2410.37, 'src': 'embed', 'start': 2352.485, 'weight': 0, 'content': [{'end': 2356.086, 'text': 'and it is going to replace my word vegetable with fruit.', 'start': 2352.485, 'duration': 3.601}, {'end': 2358.407, 'text': "let's run it and see the output.", 'start': 2356.086, 'duration': 2.321}, {'end': 2359.467, 'text': 'there you go.', 'start': 2358.407, 'duration': 1.06}, {'end': 2363.428, 'text': 'now this is correct, which is oranges of fruit.', 'start': 2359.467, 'duration': 3.961}, {'end': 2365.229, 'text': 'all right.', 'start': 2363.428, 'duration': 1.801}, {'end': 2369.11, 'text': 'now, mysql also provides some trim functions.', 'start': 2365.229, 'duration': 3.881}, {'end': 2373.071, 'text': 'you can use the left trim, right trim and just the trim function.', 'start': 2369.11, 'duration': 3.961}, {'end': 2377.245, 'text': 'So let me show you how this left trim works.', 'start': 2373.922, 'duration': 3.323}, {'end': 2384.611, 'text': 'Left trim or L trim removes the leading space characters from a string passed as an argument.', 'start': 2379.086, 'duration': 5.525}, {'end': 2390.636, 'text': "So say I write select, I'll use the left trim function, which is L trim.", 'start': 2385.952, 'duration': 4.684}, {'end': 2397.642, 'text': "And then I'm going to purposely give a few spaces in the beginning of the string.", 'start': 2391.637, 'duration': 6.005}, {'end': 2400.244, 'text': "I'll give a word, let's say India.", 'start': 2397.943, 'duration': 2.301}, {'end': 2410.37, 'text': "and then I'll give some space after the word India and see how the L trim works.", 'start': 2401.241, 'duration': 9.129}], 'summary': 'Demonstrating the use of left trim function in mysql.', 'duration': 57.885, 'max_score': 2352.485, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc2352485.jpg'}, {'end': 2628.207, 'src': 'embed', 'start': 2558.28, 'weight': 4, 'content': [{'end': 2564.163, 'text': 'in MySQL, the position function returns the position of the first occurrence of a substring in a string.', 'start': 2558.28, 'duration': 5.883}, {'end': 2568.966, 'text': 'so if the substring is not found with the original string, the function will return 0.', 'start': 2564.163, 'duration': 4.803}, {'end': 2573.509, 'text': "so let's say I'll write select position.", 'start': 2568.966, 'duration': 4.543}, {'end': 2593.711, 'text': 'I want to find where fruit is in my string that is orange is a fruit.', 'start': 2577.219, 'duration': 16.492}, {'end': 2597.253, 'text': 'I will give an alias as name.', 'start': 2593.711, 'duration': 3.542}, {'end': 2599.655, 'text': 'there is some error here.', 'start': 2597.253, 'duration': 2.402}, {'end': 2601.016, 'text': 'it should be within double quotes.', 'start': 2599.655, 'duration': 1.361}, {'end': 2604.835, 'text': "now let's run it and see the result.", 'start': 2601.994, 'duration': 2.841}, {'end': 2614.28, 'text': 'okay, it says at the 13th place or at the 13th position we have the word fruit in our string, which is orange is a fruit.', 'start': 2604.835, 'duration': 9.445}, {'end': 2617.722, 'text': 'now the final function we are going to see is called ASCII.', 'start': 2614.28, 'duration': 3.442}, {'end': 2621.644, 'text': 'so the ASCII function returns the ASCII value for a specific character.', 'start': 2617.722, 'duration': 3.922}, {'end': 2628.207, 'text': "let's say I write select ASCII of the letter small a.", 'start': 2621.644, 'duration': 6.563}], 'summary': "Mysql position function finds 'fruit' at 13th place, ascii of 'a' is 97.", 'duration': 69.927, 'max_score': 2558.28, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc2558280.jpg'}], 'start': 2173.106, 'title': 'Mysql string and operations', 'summary': 'Covers mysql operations like concatenation, reversing strings, and replacing substrings, along with string functions such as ltrim, rtrim, trim, position, and ascii, showcasing examples and their impact on string manipulation and length, as well as covering other numeric and sql functions.', 'chapters': [{'end': 2377.245, 'start': 2173.106, 'title': 'Mysql functions and operations', 'summary': 'Covers operations like concatenation, reversing strings, and replacing substrings in mysql. it demonstrates the use of these functions on a table, providing clear examples and results.', 'duration': 204.139, 'highlights': ["The REPLACE function in MySQL replaces all occurrences of a substring within a string with a new substring, demonstrated by replacing 'vegetable' with 'fruit', resulting in 'oranges of fruit'.", 'The REVERSE function in MySQL returns a string with characters printed in reverse order, exemplified by reversing the names of students in a table.', "The chapter illustrates the use of CONCATENATION in MySQL to merge student names with their ages, generating a new column 'name_age' in the result set."]}, {'end': 2750.415, 'start': 2379.086, 'title': 'Mysql string functions', 'summary': 'Demonstrates the usage of string functions in mysql, including ltrim, rtrim, trim, position, and ascii, showcasing examples and their impact on string manipulation and length, and also covers other numeric and sql functions.', 'duration': 371.329, 'highlights': ['The chapter demonstrates the usage of LTRIM, RTRIM, and TRIM functions in MySQL with examples and their impact on string manipulation and length.', 'The chapter showcases the usage of the POSITION function to find the position of a substring within a string and explains its behavior when the substring is not found.', 'The chapter covers the ASCII function to retrieve the ASCII value of specific characters in a string, providing examples and their corresponding ASCII values.']}], 'duration': 577.309, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fUK94jOFwBc/pics/fUK94jOFwBc2173106.jpg', 'highlights': ["The REPLACE function in MySQL replaces all occurrences of a substring within a string with a new substring, demonstrated by replacing 'vegetable' with 'fruit', resulting in 'oranges of fruit'.", "The chapter illustrates the use of CONCATENATION in MySQL to merge student names with their ages, generating a new column 'name_age' in the result set.", 'The REVERSE function in MySQL returns a string with characters printed in reverse order, exemplified by reversing the names of students in a table.', 'The chapter demonstrates the usage of LTRIM, RTRIM, and TRIM functions in MySQL with examples and their impact on string manipulation and length.', 'The chapter covers the ASCII function to retrieve the ASCII value of specific characters in a string, providing examples and their corresponding ASCII values.', 'The chapter showcases the usage of the POSITION function to find the position of a substring within a string and explains its behavior when the substring is not found.']}], 'highlights': ['MySQL Workbench enables creation and management of database connections and execution of SQL queries.', 'MySQL server is cross-platform, running on Windows, Linux, macOS, and others.', 'MySQL Workbench provides data modeling functionality for creating database schema models.', 'MySQL Workbench allows data migration from various relational database management systems.', 'Demonstrating the installation process of MySQL Workbench on Windows and creating a new database.', 'Explaining the components of MySQL Workbench interface and demonstrating the usage of help window.', 'The power function in MySQL calculates the power of a number with practical examples.', 'The square root function in MySQL returns the square root of a number with examples.', 'The mod function in MySQL returns the remainder of a division with practical examples.', 'The absolute function in MySQL returns the absolute value of a number with examples.', 'The greatest function in MySQL finds the largest number within a range of numbers.', 'The least function in MySQL returns the minimum number present in a range of numbers.', 'The round function in MySQL can round a number to a specified number of decimal places.', 'The truncate function in MySQL truncates a number to the specified number of decimal places.', 'The chapter details the creation of a student table in MySQL Workbench with specified columns and data types.', 'Demonstrating the creation of a student table in MySQL and insertion of 20 records.', 'Execution of SQL queries to retrieve specific data such as student names, ages, and cities.', 'Usage of the WHERE clause for filtering records based on conditions.', "Illustrating the use of 'group by' in MySQL to count the total number of students in each city.", "Demonstrating the application of the 'having' clause to identify cities with more than 3 students.", 'The chapter covers string functions in MySQL, including converting strings to upper and lower case.', "The character length function is demonstrated with the example of finding the length of the string 'India'.", 'The REPLACE function in MySQL replaces all occurrences of a substring within a string with a new substring.', 'Illustrating the use of CONCATENATION in MySQL to merge student names with their ages.', 'The REVERSE function in MySQL returns a string with characters printed in reverse order.', 'Demonstrating the usage of LTRIM, RTRIM, and TRIM functions in MySQL with examples.', 'The chapter covers the ASCII function to retrieve the ASCII value of specific characters in a string.', 'Showcasing the usage of the POSITION function to find the position of a substring within a string.']}