title
SQL With Python | Python Database Connectivity Tutorial | SQL Tutorial For Beginners | Simplilearn

description
🔥 IITM Pravartak Professional Certificate Program In Full Stack Development - MERN (India Only): https://www.simplilearn.com/full-stack-developer-course-and-certification-iitm-pravartak?utm_campaign=TempLink1&utm_medium=Descriptionff&utm_source=youtube 🔥Post Graduate Program In Full Stack Web Development: https://www.simplilearn.com/pgp-full-stack-web-development-certification-training-course?utm_campaign=TempLink1&utm_medium=Descriptionff&utm_source=youtube 🔥 Full Stack Developer - MEAN Stack - https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training?utm_campaign=TempLink1&utm_medium=Descriptionff&utm_source=youtube 🔥 Full Stack Java Developer - https://www.simplilearn.com/java-full-stack-developer-certification?utm_campaign=TempLink1&utm_medium=Descriptionff&utm_source=youtube This video on SQL with Python will help you understand Python database connectivity. You will learn to connect a MySQL database with Python Jupyter Notebook. You will see how to write user-defined functions to create server connection, create a database and execute queries. In this SQL tutorial for beginners video, we'll explore some of the most crucial SQL commands using Python programming. ✅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 #SQLQithPython #PythonAndSQL #PythonDatabaseConnection #PythonAndSQLDatabaseConnection #PythonDatabseConnectivityTutotorial #SQLCourse #SQLTraining #Simplilearn What is SQL? SQL is a Structured Query Language to communicate with relational databases. Some of the popular databases available are MySQL, Oracle, MS SQL Server, and PostgreSQL. Using SQL with Python, you can store, retrieve, update, delete and manipulate data. You can permit users to perform specific tasks on tables, procedures, and views. ➡️ 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=SQLWithPython-zrNHkRgWzTI&utm_medium=Descritption&utm_source=youtube 🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=SQLWithPython-zrNHkRgWzTI&utm_medium=Descritption&utm_source=youtube 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688

detail
{'title': 'SQL With Python | Python Database Connectivity Tutorial | SQL Tutorial For Beginners | Simplilearn', 'heatmap': [{'end': 495.388, 'start': 431.454, 'weight': 0.782}, {'end': 2533.633, 'start': 2468.935, 'weight': 1}], 'summary': 'This tutorial covers using python for sql queries in data science and analytics, demonstrating working with databases and tables using sql with python, including creating a mysql database connection, executing sql queries, creating a new database, performing database operations, connecting to a sql database, executing data manipulation, and updating and deleting queries.', 'chapters': [{'end': 76.884, 'segs': [{'end': 54.26, 'src': 'embed', 'start': 8.237, 'weight': 0, 'content': [{'end': 10.957, 'text': 'Hello everyone and welcome to this interesting video by Simply Learn.', 'start': 8.237, 'duration': 2.72}, {'end': 15.058, 'text': 'Today we are going to discuss how to work on SQL queries using Python.', 'start': 11.838, 'duration': 3.22}, {'end': 21.879, 'text': 'Python as you must be aware is a high level general purpose programming language that can be used for data science and analytics.', 'start': 16.018, 'duration': 5.861}, {'end': 27.32, 'text': 'In this tutorial we will learn how to work with databases and tables using SQL with Python.', 'start': 22.8, 'duration': 4.52}, {'end': 34.502, 'text': 'To do this demo we will be using our Jupyter notebook and the MySQL workbench.', 'start': 29.641, 'duration': 4.861}, {'end': 36.242, 'text': 'You can see it here.', 'start': 35.522, 'duration': 0.72}, {'end': 41.929, 'text': 'So we will write our SQL queries in the Jupyter Notebook with Python like syntax.', 'start': 38.286, 'duration': 3.643}, {'end': 48.415, 'text': "If you don't have MySQL or Jupyter Notebook installed, so please go ahead and install them first.", 'start': 44.171, 'duration': 4.244}, {'end': 53.56, 'text': 'While installing the MySQL Workbench, you will be asked to give the username and password.', 'start': 49.436, 'duration': 4.124}, {'end': 54.26, 'text': 'Let me show you.', 'start': 53.64, 'duration': 0.62}], 'summary': 'Learn to work on sql queries using python, demonstrated with jupyter notebook and mysql workbench.', 'duration': 46.023, 'max_score': 8.237, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI8237.jpg'}], 'start': 8.237, 'title': 'Using python for sql queries', 'summary': 'Covers working with sql queries using python for data science and analytics, and demonstrates how to work with databases and tables using sql with python, emphasizing the necessity of installing mysql and jupyter notebook for the process.', 'chapters': [{'end': 76.884, 'start': 8.237, 'title': 'Using python for sql queries', 'summary': 'Covers working with sql queries using python, emphasizing the usage of python for data science and analytics, and demonstrating how to work with databases and tables using sql with python, while highlighting the necessity of installing mysql and jupyter notebook for the process.', 'duration': 68.647, 'highlights': ['The tutorial focuses on working with SQL queries using Python, which is a high level general purpose programming language suitable for data science and analytics.', 'The demonstration includes working with databases and tables using SQL with Python, showcasing the practical application of Python in database management.', 'The necessity of installing MySQL and Jupyter Notebook for executing the SQL queries using Python is emphasized, ensuring a smooth workflow for the demonstration.']}], 'duration': 68.647, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI8237.jpg', 'highlights': ['The tutorial focuses on working with SQL queries using Python, suitable for data science and analytics.', 'The demonstration includes working with databases and tables using SQL with Python.', 'Emphasizes the necessity of installing MySQL and Jupyter Notebook for executing SQL queries using Python.']}, {'end': 631.436, 'segs': [{'end': 156.545, 'src': 'embed', 'start': 76.884, 'weight': 0, 'content': [{'end': 83.326, 'text': 'first and foremost, let me go ahead and import the necessary libraries.', 'start': 76.884, 'duration': 6.442}, {'end': 88.828, 'text': "i'll give a comment as import libraries all right.", 'start': 83.326, 'duration': 5.502}, {'end': 92.509, 'text': "so first i'll import mysql.connector.", 'start': 88.828, 'duration': 3.681}, {'end': 108.419, 'text': 'next, from mysql.connector i am going to import my error method or the error module.', 'start': 96.269, 'duration': 12.15}, {'end': 113.443, 'text': 'next i want to import pandas as pd.', 'start': 108.419, 'duration': 5.024}, {'end': 115.564, 'text': "so let's run this.", 'start': 113.443, 'duration': 2.121}, {'end': 119.047, 'text': 'okay, there is some error here.', 'start': 115.564, 'duration': 3.483}, {'end': 122.41, 'text': 'this should be capital e and not small e.', 'start': 119.047, 'duration': 3.363}, {'end': 127.274, 'text': 'all right, You can see, I have imported my important libraries.', 'start': 122.41, 'duration': 4.864}, {'end': 135.017, 'text': "Now I'm going to create a function that will help us create a server connection.", 'start': 128.935, 'duration': 6.082}, {'end': 139.679, 'text': "So I'll write my user defined function by using the def keyword.", 'start': 136.318, 'duration': 3.361}, {'end': 147.422, 'text': "I'll write create underscore server underscore connection.", 'start': 141, 'duration': 6.422}, {'end': 152.164, 'text': 'This is going to be my function name.', 'start': 148.983, 'duration': 3.181}, {'end': 156.545, 'text': 'and it will take in three parameters.', 'start': 153.303, 'duration': 3.242}], 'summary': 'Transcript: import libraries, fix error, create server connection function.', 'duration': 79.661, 'max_score': 76.884, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI76884.jpg'}, {'end': 322.559, 'src': 'embed', 'start': 268.966, 'weight': 3, 'content': [{'end': 290.503, 'text': 'alright, now I am going to use a print statement and write mysql database connection successful.', 'start': 268.966, 'duration': 21.537}, {'end': 301.097, 'text': "after this I'll give my except block.", 'start': 296.75, 'duration': 4.347}, {'end': 315.995, 'text': "so I'll use the keyword except here I'll write error as ERR, give a colon, and then I'm going to use the print statement.", 'start': 301.097, 'duration': 14.898}, {'end': 320.177, 'text': "here I'm going to use some print formatting techniques.", 'start': 315.995, 'duration': 4.182}, {'end': 322.559, 'text': 'using the F letter.', 'start': 320.177, 'duration': 2.382}], 'summary': 'Demonstrating successful mysql database connection with print statement and error handling using except block with print formatting techniques.', 'duration': 53.593, 'max_score': 268.966, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI268966.jpg'}, {'end': 495.388, 'src': 'heatmap', 'start': 431.454, 'weight': 0.782, 'content': [{'end': 446.62, 'text': 'I will pass in my user defined function name, which is create server connection, and the parameters which are going to be localhost.', 'start': 431.454, 'duration': 15.166}, {'end': 456.004, 'text': 'that is, my host name, my username, which is root, and then I will give pw, which is my password.', 'start': 446.62, 'duration': 9.384}, {'end': 459.605, 'text': 'that is exactly simply at the rate 12345.', 'start': 456.004, 'duration': 3.601}, {'end': 460.946, 'text': "let's just run it now.", 'start': 459.605, 'duration': 1.341}, {'end': 463.961, 'text': 'okay, there is an error here.', 'start': 462.06, 'duration': 1.901}, {'end': 467.942, 'text': 'we need to remove this double quotation.', 'start': 463.961, 'duration': 3.981}, {'end': 473.785, 'text': 'all right, made another mistake here this this should be root.', 'start': 467.942, 'duration': 5.843}, {'end': 480.247, 'text': 'okay, you can see here mysql database connection successful, all right.', 'start': 473.785, 'duration': 6.462}, {'end': 487.63, 'text': 'next, we are now going to create a database that is mysql underscore python.', 'start': 480.247, 'duration': 7.383}, {'end': 488.871, 'text': "so i'll give a comment.", 'start': 487.63, 'duration': 1.241}, {'end': 495.388, 'text': 'create mysql underscore python database again.', 'start': 488.871, 'duration': 6.517}], 'summary': "Successfully created mysql database 'mysql_python' with user-defined function 'create server connection' and parameters 'localhost', 'root', and password '12345'.", 'duration': 63.934, 'max_score': 431.454, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI431454.jpg'}, {'end': 543.278, 'src': 'embed', 'start': 502.173, 'weight': 2, 'content': [{'end': 512.042, 'text': "i'll write the function name as create database, passing the parameters as connection comma query,", 'start': 502.173, 'duration': 9.869}, {'end': 524.285, 'text': "give a semicolon and in the next line I'll write cursor equal to going to make the connection.", 'start': 514.539, 'duration': 9.746}, {'end': 534.993, 'text': "so I'll write connection dot cursor and I'll give the parenthesis.", 'start': 524.285, 'duration': 10.708}, {'end': 543.278, 'text': "so this MySQL's cursor of MySQL connector Python is used to execute statements to communicate with the MySQL database.", 'start': 534.993, 'duration': 8.285}], 'summary': 'Create database function is used to execute mysql statements via mysql connector python.', 'duration': 41.105, 'max_score': 502.173, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI502173.jpg'}], 'start': 76.884, 'title': 'Creating mysql database connection and server connection in python', 'summary': 'Covers importing necessary libraries like mysql.connector and pandas, establishing server connection, creating a mysql database connection, and executing queries using python. it includes details on exception handling, defining functions, and using print statements.', 'chapters': [{'end': 268.966, 'start': 76.884, 'title': 'Importing libraries and creating a server connection', 'summary': 'Covers the process of importing necessary libraries including mysql.connector and pandas, and creating a function to establish a server connection using exception handling techniques.', 'duration': 192.082, 'highlights': ['The chapter covers the process of importing necessary libraries including mysql.connector and pandas. It involves importing mysql.connector and pandas as pd, and correcting error in the code.', "Creating a function to establish a server connection using exception handling techniques. The function 'create_server_connection' takes in three parameters - host name, username, and user password, and uses try and accept blocks for error handling."]}, {'end': 631.436, 'start': 268.966, 'title': 'Mysql database connection & creation', 'summary': 'Explains the process of creating a mysql database connection and creating a database using python, including details such as using print statements, defining functions, and executing queries.', 'duration': 362.47, 'highlights': ['The chapter explains the process of creating a MySQL database connection and creating a database using Python.', 'Print statements and print formatting techniques are used to display messages and handle errors.', 'User-defined functions are defined for creating a server connection and database creation, with specific parameters and queries.']}], 'duration': 554.552, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI76884.jpg', 'highlights': ['The chapter covers the process of importing necessary libraries including mysql.connector and pandas.', 'Creating a function to establish a server connection using exception handling techniques.', 'The chapter explains the process of creating a MySQL database connection and creating a database using Python.', 'Print statements and print formatting techniques are used to display messages and handle errors.', 'User-defined functions are defined for creating a server connection and database creation, with specific parameters and queries.']}, {'end': 1312.377, 'segs': [{'end': 747.165, 'src': 'embed', 'start': 690.439, 'weight': 0, 'content': [{'end': 699.255, 'text': 'the first one is connection and next the query is create underscore database, underscore query.', 'start': 690.439, 'duration': 8.816}, {'end': 705.839, 'text': "let me just copy it and i'm going to paste it here all right.", 'start': 699.255, 'duration': 6.584}, {'end': 718.047, 'text': 'so what i am doing here is i am creating a new function that is to create a new database with the name mysql underscore python,', 'start': 705.839, 'duration': 12.208}, {'end': 719.868, 'text': 'which you can see it here.', 'start': 718.047, 'duration': 1.821}, {'end': 722.83, 'text': 'now this function takes in two parameters connection and query.', 'start': 719.868, 'duration': 2.962}, {'end': 732.023, 'text': 'I am using the connection.cursor function, which is often used to execute SQL statements using Python language,', 'start': 723.681, 'duration': 8.342}, {'end': 735.843, 'text': 'and then I have created my try and exit blocks.', 'start': 732.023, 'duration': 3.82}, {'end': 742.024, 'text': 'so this try block statements will try to create my new database, which is mysql underscore python.', 'start': 735.843, 'duration': 6.181}, {'end': 747.165, 'text': 'in case it fails to create the new database, the exit block will work.', 'start': 742.024, 'duration': 5.141}], 'summary': 'Creating a new database named mysql_python using python language with connection and query parameters.', 'duration': 56.726, 'max_score': 690.439, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI690439.jpg'}, {'end': 827.689, 'src': 'embed', 'start': 771.36, 'weight': 3, 'content': [{'end': 778.822, 'text': 'now you can verify this by checking the MySQL workbench or the MySQL shell.', 'start': 771.36, 'duration': 7.462}, {'end': 789.608, 'text': 'you can see on the mysql workbench here on the left panel under schemas, there is a database called mysql underscore python.', 'start': 780.646, 'duration': 8.962}, {'end': 791.368, 'text': 'let me just expand it now.', 'start': 789.608, 'duration': 1.76}, {'end': 794.889, 'text': "we haven't created any table, so it's not showing it now.", 'start': 791.368, 'duration': 3.521}, {'end': 798.79, 'text': 'the next step we are going to connect to this database now.', 'start': 794.889, 'duration': 3.901}, {'end': 802.27, 'text': "so let's go ahead and connect to our database that we have just created.", 'start': 798.79, 'duration': 3.48}, {'end': 806.151, 'text': "i'll write the comment as connect to database.", 'start': 802.27, 'duration': 3.881}, {'end': 813.379, 'text': "Now, to connect to a database, I'm again going to create a user defined function using the def keyword.", 'start': 808.095, 'duration': 5.284}, {'end': 819.343, 'text': "I'll write create underscore db, which is for database underscore connection.", 'start': 813.459, 'duration': 5.884}, {'end': 827.689, 'text': 'And the parameters it will take is the host name followed by the user name.', 'start': 821.985, 'duration': 5.704}], 'summary': 'Creating a database in mysql workbench and connecting to it using user-defined functions.', 'duration': 56.329, 'max_score': 771.36, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI771360.jpg'}, {'end': 1070.814, 'src': 'embed', 'start': 1016.784, 'weight': 5, 'content': [{'end': 1032.353, 'text': "now. to execute our sql queries i'll use another user defined function, which is execute underscore query,", 'start': 1016.784, 'duration': 15.569}, {'end': 1036.595, 'text': "and i'll pass in the parameters as connection and query.", 'start': 1032.353, 'duration': 4.242}, {'end': 1040.862, 'text': 'give a colon.', 'start': 1039.241, 'duration': 1.621}, {'end': 1050.745, 'text': "I'm going to write cursor equal to connection dot cursor.", 'start': 1040.862, 'duration': 9.883}, {'end': 1056.127, 'text': 'now this is used to establish a connection and run SQL statements.', 'start': 1050.745, 'duration': 5.382}, {'end': 1059.508, 'text': "next we'll use the try and accept block.", 'start': 1056.127, 'duration': 3.381}, {'end': 1070.814, 'text': "so I'll write try cursor dot, execute.", 'start': 1059.508, 'duration': 11.306}], 'summary': 'Executing sql queries using the user-defined function execute_query with connection and query parameters.', 'duration': 54.03, 'max_score': 1016.784, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI1016784.jpg'}, {'end': 1181.184, 'src': 'embed', 'start': 1149.485, 'weight': 6, 'content': [{'end': 1155.989, 'text': "now it's time for us to create our first table inside the mysql underscore python database.", 'start': 1149.485, 'duration': 6.504}, {'end': 1162.673, 'text': "so to do that I'm going to write my create command in SQL.", 'start': 1155.989, 'duration': 6.684}, {'end': 1169.557, 'text': 'so first we are going to assign our SQL command to a Python variable using triple quotes to create a multi-line string.', 'start': 1162.673, 'duration': 6.884}, {'end': 1172.238, 'text': 'so let me show you how to do that.', 'start': 1169.557, 'duration': 2.681}, {'end': 1181.184, 'text': "I'll write my variable name, which is going to be create orders table.", 'start': 1172.238, 'duration': 8.946}], 'summary': 'Creating first table in mysql python database using sql command.', 'duration': 31.699, 'max_score': 1149.485, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI1149485.jpg'}], 'start': 633.248, 'title': 'Creating mysql database and executing sql queries with python', 'summary': "Demonstrates the process of creating a new database named 'mysql_python' using python, including the use of 'create database' sql query, and executing sql queries with detailed commands and variable names.", 'chapters': [{'end': 747.165, 'start': 633.248, 'title': 'Creating mysql database with python', 'summary': "Demonstrates the process of creating a new database named 'mysql_python' using python, including the use of 'create database' sql query and the 'connection.cursor' function, with the try and except blocks for error handling.", 'duration': 113.917, 'highlights': ["The function 'create_database' is utilized to create a new database named 'mysql_python', using the 'create database' SQL query, and it requires two parameters: 'connection' and 'create_database_query'.", "The 'connection.cursor' function is employed to execute SQL statements in Python, facilitating the creation of the new database 'mysql_python'.", "The try block attempts to create the new database 'mysql_python', while the except block handles any potential failures in the creation process."]}, {'end': 1312.377, 'start': 747.165, 'title': 'Creating mysql database and executing sql queries', 'summary': 'Covers creating a mysql database, connecting to it, executing sql queries, and creating a table with detailed sql commands and variable names.', 'duration': 565.212, 'highlights': ["Created a new database using SQL query 'create database' and verified its creation in MySQL workbench or MySQL shell. The transcript details the process of creating a new database using SQL query 'create database' and verifying its successful creation in MySQL workbench or MySQL shell.", "Connected to the newly created database by defining a user-defined function 'create_db' with parameters for host name, user name, user password, and database name. The process of connecting to the newly created database is explained through the definition of a user-defined function 'create_db' with parameters for host name, user name, user password, and database name.", "Defined a user-defined function 'execute_query' to execute SQL queries using parameters 'connection' and 'query', and handled error using try and accept blocks. The definition of a user-defined function 'execute_query' to execute SQL queries using parameters 'connection' and 'query', and handling errors using try and accept blocks is highlighted.", "Demonstrated the creation of a table 'orders' with detailed SQL command and variable names, specifying column names, data types, and constraints. The detailed process of creating a table 'orders' using SQL commands with specified column names, data types, and constraints is demonstrated."]}], 'duration': 679.129, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI633248.jpg', 'highlights': ["The function 'create_database' is utilized to create a new database named 'mysql_python', using the 'create database' SQL query, and it requires two parameters: 'connection' and 'create_database_query'.", "The 'connection.cursor' function is employed to execute SQL statements in Python, facilitating the creation of the new database 'mysql_python'.", "The try block attempts to create the new database 'mysql_python', while the except block handles any potential failures in the creation process.", "Created a new database using SQL query 'create database' and verified its creation in MySQL workbench or MySQL shell. The transcript details the process of creating a new database using SQL query 'create database' and verifying its successful creation in MySQL workbench or MySQL shell.", "Connected to the newly created database by defining a user-defined function 'create_db' with parameters for host name, user name, user password, and database name. The process of connecting to the newly created database is explained through the definition of a user-defined function 'create_db' with parameters for host name, user name, user password, and database name.", "Defined a user-defined function 'execute_query' to execute SQL queries using parameters 'connection' and 'query', and handled error using try and accept blocks. The definition of a user-defined function 'execute_query' to execute SQL queries using parameters 'connection' and 'query', and handling errors using try and accept blocks is highlighted.", "Demonstrated the creation of a table 'orders' with detailed SQL command and variable names, specifying column names, data types, and constraints. The detailed process of creating a table 'orders' using SQL commands with specified column names, data types, and constraints is demonstrated."]}, {'end': 1644.668, 'segs': [{'end': 1393.553, 'src': 'embed', 'start': 1312.377, 'weight': 3, 'content': [{'end': 1315.62, 'text': 'phone number can be kept as of type varying character.', 'start': 1312.377, 'duration': 3.243}, {'end': 1320.543, 'text': 'I have assigned a size of 20.', 'start': 1315.62, 'duration': 4.923}, {'end': 1331.775, 'text': "now let's give a semicolon and will close the triple quotes all right.", 'start': 1320.543, 'duration': 11.232}, {'end': 1335.717, 'text': 'so this is how the syntax would look like.', 'start': 1331.775, 'duration': 3.942}, {'end': 1345.562, 'text': 'next to run this, we are first going to call our create DB function.', 'start': 1335.717, 'duration': 9.845}, {'end': 1346.763, 'text': 'so let me give a comment.', 'start': 1345.562, 'duration': 1.201}, {'end': 1356.989, 'text': "as connect to the database, I'll write connection equal to create underscore DB.", 'start': 1346.763, 'duration': 10.226}, {'end': 1363.794, 'text': 'underscore connection.', 'start': 1356.989, 'duration': 6.805}, {'end': 1376.203, 'text': 'my parameters would be my host name, which is localhost, my username, which is root comma, my password and then my database name,', 'start': 1363.794, 'duration': 12.409}, {'end': 1379.005, 'text': 'which is mysql underscore python.', 'start': 1376.203, 'duration': 2.802}, {'end': 1381.467, 'text': "so I'll write just DB, alright.", 'start': 1379.005, 'duration': 2.462}, {'end': 1392.013, 'text': "finally, let's execute this query using the execute underscore query function that we had created earlier.", 'start': 1383.829, 'duration': 8.184}, {'end': 1393.553, 'text': 'this takes in two parameter.', 'start': 1392.013, 'duration': 1.54}], 'summary': 'Example of creating and executing a query with specific parameters and syntax.', 'duration': 81.176, 'max_score': 1312.377, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI1312377.jpg'}, {'end': 1563.234, 'src': 'embed', 'start': 1434.394, 'weight': 0, 'content': [{'end': 1444.044, 'text': 'if you see, here, in our execute underscore query function, instead of cursor, I have written cursor.', 'start': 1434.394, 'duration': 9.65}, {'end': 1445.145, 'text': 'so R is missing.', 'start': 1444.044, 'duration': 1.101}, {'end': 1449.59, 'text': "let's redone this and now let's run this again.", 'start': 1445.145, 'duration': 4.445}, {'end': 1450.11, 'text': 'there you go.', 'start': 1449.59, 'duration': 0.52}, {'end': 1453.293, 'text': 'you can see here my SQL database connection successful.', 'start': 1450.11, 'duration': 3.183}, {'end': 1454.755, 'text': 'even our query was also successful.', 'start': 1453.293, 'duration': 1.462}, {'end': 1463.298, 'text': 'now, if you want to recheck if the table, that is, orders, was created or not, you can check it on the mysql workbench.', 'start': 1456.735, 'duration': 6.563}, {'end': 1465.559, 'text': 'so let me show you how to do it.', 'start': 1463.298, 'duration': 2.261}, {'end': 1472.403, 'text': 'so i am on my mysql workbench and under mysql underscore python database you have something called as tables.', 'start': 1465.559, 'duration': 6.844}, {'end': 1475.684, 'text': "let me just right click and i'll select refresh all.", 'start': 1472.403, 'duration': 3.281}, {'end': 1478.206, 'text': 'there you go, you can see this arrow.', 'start': 1475.684, 'duration': 2.522}, {'end': 1482.788, 'text': 'just click on this arrow and here you can see we have a table called orders.', 'start': 1478.206, 'duration': 4.582}, {'end': 1484.609, 'text': 'so we have created our table called orders.', 'start': 1482.788, 'duration': 1.821}, {'end': 1487.07, 'text': 'now you can check the columns as well.', 'start': 1485.329, 'duration': 1.741}, {'end': 1488.25, 'text': 'you have the order id.', 'start': 1487.07, 'duration': 1.18}, {'end': 1495.272, 'text': 'you have the order id, the customer name, product name, ordered date, quantity, unit, price and phone number.', 'start': 1488.25, 'duration': 7.022}, {'end': 1501.293, 'text': "now it's time for us to insert a few records to this table, which is orders.", 'start': 1495.272, 'duration': 6.021}, {'end': 1503.614, 'text': "now to insert records, i'll give a comment.", 'start': 1501.293, 'duration': 2.321}, {'end': 1512.056, 'text': "as insert data, i'll start with the variable name.", 'start': 1503.614, 'duration': 8.442}, {'end': 1517.529, 'text': "let's say the variable name is data underscore orders.", 'start': 1512.056, 'duration': 5.473}, {'end': 1524.971, 'text': "i'll give triple quotes.", 'start': 1517.529, 'duration': 7.442}, {'end': 1528.212, 'text': "next i'll write my insert into command.", 'start': 1524.971, 'duration': 3.241}, {'end': 1543.568, 'text': "so i'll write insert into my table name, that is orders, followed by values, and now i'll start entering my records for each of the rows.", 'start': 1528.212, 'duration': 15.356}, {'end': 1547.709, 'text': "so first I'll give 101, which is the order ID.", 'start': 1543.568, 'duration': 4.141}, {'end': 1558.393, 'text': "then I'll give the customer's name, let's say Steve, and the product he had ordered is, let's say, laptop.", 'start': 1547.709, 'duration': 10.684}, {'end': 1563.234, 'text': "then I'll give my date in which the item was ordered.", 'start': 1558.393, 'duration': 4.841}], 'summary': "Successfully connected to sql database, created table 'orders' with specified columns, and inserted records.", 'duration': 128.84, 'max_score': 1434.394, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI1434394.jpg'}], 'start': 1312.377, 'title': 'Mysql database operations', 'summary': "Covers creating a table in mysql database, establishing connection, and inserting records, resulting in a 'orders' table with six customers and their items purchased.", 'chapters': [{'end': 1393.553, 'start': 1312.377, 'title': 'Database connection and query execution', 'summary': 'Covers the syntax for defining a varying character data type for a phone number with a size of 20, followed by the process of creating a database connection and executing a query.', 'duration': 81.176, 'highlights': ['The syntax for defining a varying character data type for a phone number with a size of 20 is explained, followed by the process of creating a database connection and executing a query.', 'The process of creating a database connection is detailed, including the parameters such as hostname, username, password, and database name.', 'Executing a query using the execute_query function is mentioned as the final step in the process.']}, {'end': 1644.668, 'start': 1393.553, 'title': 'Mysql database connection and table creation', 'summary': "Covers the process of creating a table in mysql database, successfully establishing a connection, and inserting records, resulting in a table named 'orders' with six customers and their respective items purchased.", 'duration': 251.115, 'highlights': ["Successfully created a table named 'orders' in the MySQL database with columns 'order id', 'customer name', 'product name', 'ordered date', 'quantity', 'unit price', and 'phone number'. The script demonstrates the successful creation of a table named 'orders' in the MySQL database, including the columns 'order id', 'customer name', 'product name', 'ordered date', 'quantity', 'unit price', and 'phone number'.", "Inserted records for six customers with their respective items and details into the 'orders' table. The transcript details the insertion of records for six customers and their respective items and details into the 'orders' table, such as customer names, product names, ordered dates, quantities, unit prices, and phone numbers.", "Demonstrated the process of refreshing and checking the newly created table 'orders' in MySQL Workbench. The process of refreshing and checking the newly created table 'orders' in MySQL Workbench is demonstrated, ensuring the successful creation of the table and its contents."]}], 'duration': 332.291, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI1312377.jpg', 'highlights': ["Successfully created a table named 'orders' in the MySQL database with columns 'order id', 'customer name', 'product name', 'ordered date', 'quantity', 'unit price', and 'phone number'.", "Inserted records for six customers with their respective items and details into the 'orders' table.", "Demonstrated the process of refreshing and checking the newly created table 'orders' in MySQL Workbench.", 'The process of creating a database connection is detailed, including the parameters such as hostname, username, password, and database name.', 'The syntax for defining a varying character data type for a phone number with a size of 20 is explained, followed by the process of creating a database connection and executing a query.', 'Executing a query using the execute_query function is mentioned as the final step in the process.']}, {'end': 2499.207, 'segs': [{'end': 1674.011, 'src': 'embed', 'start': 1644.668, 'weight': 4, 'content': [{'end': 1648.749, 'text': 'and then we have the unit price and some random phone numbers.', 'start': 1644.668, 'duration': 4.081}, {'end': 1652.607, 'text': "so let's create the connection.", 'start': 1648.749, 'duration': 3.858}, {'end': 1657.388, 'text': "now I'll write connection equal to.", 'start': 1652.607, 'duration': 4.781}, {'end': 1664.35, 'text': "I'll write create underscore DB, underscore connection.", 'start': 1657.388, 'duration': 6.962}, {'end': 1666.43, 'text': "then I'm going to give my same parameters.", 'start': 1664.35, 'duration': 2.08}, {'end': 1672.951, 'text': 'let me just copy it from the top, which is localhost, the host name.', 'start': 1666.43, 'duration': 6.521}, {'end': 1674.011, 'text': 'root is my username.', 'start': 1672.951, 'duration': 1.06}], 'summary': 'Creating a database connection with unit price and phone numbers.', 'duration': 29.343, 'max_score': 1644.668, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI1644668.jpg'}, {'end': 1736.419, 'src': 'embed', 'start': 1702.556, 'weight': 2, 'content': [{'end': 1704.417, 'text': 'there was some mistake here.', 'start': 1702.556, 'duration': 1.861}, {'end': 1707.537, 'text': "let's debug it again.", 'start': 1704.417, 'duration': 3.12}, {'end': 1711.325, 'text': 'this should be triple quotes and not 4.', 'start': 1707.537, 'duration': 3.788}, {'end': 1713.006, 'text': 'now let me rerun it again.', 'start': 1711.325, 'duration': 1.681}, {'end': 1714.006, 'text': 'there you go.', 'start': 1713.006, 'duration': 1}, {'end': 1719.789, 'text': 'you can see here my sql database connection successful and my query was also successful.', 'start': 1714.006, 'duration': 5.783}, {'end': 1728.134, 'text': 'now we will create another user defined function which will help us read query and display the results.', 'start': 1719.789, 'duration': 8.345}, {'end': 1732.717, 'text': "so i'll write my function name as df.", 'start': 1728.134, 'duration': 4.583}, {'end': 1736.419, 'text': 'read underscore query.', 'start': 1732.717, 'duration': 3.702}], 'summary': "Successfully debugged code, established sql connection, and created user-defined function 'df.read_query'.", 'duration': 33.863, 'max_score': 1702.556, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI1702556.jpg'}, {'end': 1890.737, 'src': 'embed', 'start': 1860.256, 'weight': 0, 'content': [{'end': 1867.62, 'text': 'alright, so suppose I want to display all the records that we have inserted into our orders table.', 'start': 1860.256, 'duration': 7.364}, {'end': 1874.024, 'text': "so the way to do is I'll assign my query to a variable, let's say q1.", 'start': 1867.62, 'duration': 6.404}, {'end': 1878.827, 'text': "I'll give triple quotes.", 'start': 1874.024, 'duration': 4.803}, {'end': 1887.592, 'text': "within triple quotes I'll write select star from orders, will give a semicolon followed by the triple quotes.", 'start': 1878.827, 'duration': 8.765}, {'end': 1890.737, 'text': "now we'll establish the connection.", 'start': 1889.016, 'duration': 1.721}], 'summary': 'Describes creating a query to display all records from the orders table, using triple quotes and semicolon.', 'duration': 30.481, 'max_score': 1860.256, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI1860256.jpg'}, {'end': 1963.224, 'src': 'embed', 'start': 1920.008, 'weight': 1, 'content': [{'end': 1926.133, 'text': 'for the query next to display, I am going to use a for loop.', 'start': 1920.008, 'duration': 6.125}, {'end': 1934.661, 'text': 'I will write for results for result.', 'start': 1926.133, 'duration': 8.528}, {'end': 1941.407, 'text': 'in results print I will say result.', 'start': 1934.661, 'duration': 6.746}, {'end': 1945.553, 'text': 'now we are done.', 'start': 1943.792, 'duration': 1.761}, {'end': 1948.475, 'text': "let's just run this query.", 'start': 1945.553, 'duration': 2.922}, {'end': 1949.315, 'text': 'there you go.', 'start': 1948.475, 'duration': 0.84}, {'end': 1955.699, 'text': 'you can see here we have successfully printed all the rows in our table, which is orders.', 'start': 1949.315, 'duration': 6.384}, {'end': 1959.421, 'text': 'you can see we have six records in total.', 'start': 1955.699, 'duration': 3.722}, {'end': 1963.224, 'text': 'now we are going to explore a few more queries.', 'start': 1959.421, 'duration': 3.803}], 'summary': "Using a for loop, successfully printed 6 rows from the 'orders' table.", 'duration': 43.216, 'max_score': 1920.008, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI1920008.jpg'}, {'end': 2062.599, 'src': 'embed', 'start': 2020.945, 'weight': 3, 'content': [{'end': 2022.666, 'text': 'that is,', 'start': 2020.945, 'duration': 1.721}, {'end': 2034.316, 'text': 'in our table we have the order date and from the order date we are only going to display the different years that are present in the order date.', 'start': 2022.666, 'duration': 11.65}, {'end': 2037.419, 'text': 'so to do that i am going to use the year function.', 'start': 2034.316, 'duration': 3.103}, {'end': 2048.027, 'text': "i like this query instead of q1, i'll make it q3, and here i am going to write select here, which is my function name from my column,", 'start': 2037.419, 'duration': 10.608}, {'end': 2062.599, 'text': "which is date ordered from orders, and here i'll change this to q3, q1, q2, q3 are basically query 1, query 2 and query 3.", 'start': 2048.027, 'duration': 14.572}], 'summary': 'Using the year function to display different years from the order date in a query.', 'duration': 41.654, 'max_score': 2020.945, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI2020945.jpg'}, {'end': 2140.602, 'src': 'embed', 'start': 2105.914, 'weight': 5, 'content': [{'end': 2113.508, 'text': "okay, now, moving ahead, Let's write our fifth query, and this time we are going to explore how you can use the WHERE clause.", 'start': 2105.914, 'duration': 7.594}, {'end': 2118.489, 'text': "So I'll change this to Q5 before I write my query.", 'start': 2114.848, 'duration': 3.641}, {'end': 2129.233, 'text': "So let's say you want to display all the orders that were ordered before 31st of December 2018.", 'start': 2119.79, 'duration': 9.443}, {'end': 2133.134, 'text': 'So to filter this we are going to use the WHERE clause.', 'start': 2129.233, 'duration': 3.901}, {'end': 2140.602, 'text': "So I'll write SELECT star from orders.", 'start': 2134.235, 'duration': 6.367}], 'summary': 'Learn to use where clause to filter data in sql queries.', 'duration': 34.688, 'max_score': 2105.914, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI2105914.jpg'}, {'end': 2272.291, 'src': 'embed', 'start': 2241.134, 'weight': 6, 'content': [{'end': 2245.077, 'text': "Let's say you want to display all the columns from the table.", 'start': 2241.134, 'duration': 3.943}, {'end': 2247.618, 'text': "So I'll write select star from orders.", 'start': 2245.377, 'duration': 2.241}, {'end': 2254.037, 'text': "then I'm going to use order by unit price.", 'start': 2249.716, 'duration': 4.321}, {'end': 2260.904, 'text': "I'll give a semicolon.", 'start': 2257.762, 'duration': 3.142}, {'end': 2263.726, 'text': "let's run this query and see the output.", 'start': 2260.904, 'duration': 2.822}, {'end': 2272.291, 'text': 'if you see the result here and you mark the unit price column, the result has been ordered in ascending order of unit price.', 'start': 2263.726, 'duration': 8.565}], 'summary': "Executing 'select star from orders' sorted by unit price asc.", 'duration': 31.157, 'max_score': 2241.134, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI2241134.jpg'}], 'start': 1644.668, 'title': 'Sql database connection and data manipulation', 'summary': 'Covers creating a sql database connection, executing queries, and data manipulation, including a user-defined function, with 6 total records and unique years 2018 and 2019 extracted from the order date column.', 'chapters': [{'end': 1827.563, 'start': 1644.668, 'title': 'Creating sql database connection and user defined function', 'summary': 'Covers the creation of a sql database connection with successful execution and the creation of a user-defined function to read queries and display results.', 'duration': 182.895, 'highlights': ['The SQL database connection was successfully created and the query execution was also successful, demonstrating the effective implementation of the code.', "The user-defined function 'df.read_query' was created to read queries and display results, enhancing the functionality of the SQL database interaction.", 'The process involved using parameters such as host name, username, password, and database name to establish the database connection, showcasing the comprehensive approach to setting up the connection.']}, {'end': 2499.207, 'start': 1828.638, 'title': 'Sql queries and data manipulation', 'summary': 'Covers the execution of sql queries to display, filter, and order data, including examples of creating a data frame from the table, with total records of 6 and unique years extracted from the order date column being 2018 and 2019.', 'duration': 670.569, 'highlights': ['Executing SQL queries to display, filter, and order data, including examples of creating a data frame from the table with a total of 6 records. (6 records displayed with select statement, creating a data frame with 6 records)', 'Extracting unique years (2018 and 2019) from the order date column using the year function. (Successfully extracted the different years present in the order date column, 2018 and 2019)', 'Using the WHERE clause to filter and display orders before and after specific dates. (Displaying 3 orders made before and after 31st December 2018)', 'Utilizing the ORDER BY clause to sort results based on a particular column, with examples of both ascending and descending order. (Ordering results in ascending and descending order based on unit price)']}], 'duration': 854.539, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI1644668.jpg', 'highlights': ['The SQL database connection was successfully created and the query execution was also successful, demonstrating the effective implementation of the code.', 'Executing SQL queries to display, filter, and order data, including examples of creating a data frame from the table with a total of 6 records.', "The user-defined function 'df.read_query' was created to read queries and display results, enhancing the functionality of the SQL database interaction.", 'Extracting unique years (2018 and 2019) from the order date column using the year function.', 'The process involved using parameters such as host name, username, password, and database name to establish the database connection, showcasing the comprehensive approach to setting up the connection.', 'Using the WHERE clause to filter and display orders before and after specific dates.', 'Utilizing the ORDER BY clause to sort results based on a particular column, with examples of both ascending and descending order.']}, {'end': 2902.487, 'segs': [{'end': 2568.661, 'src': 'embed', 'start': 2534.915, 'weight': 0, 'content': [{'end': 2540.177, 'text': "then I'll use my update command, which is update, followed by the table name, that is, orders.", 'start': 2534.915, 'duration': 5.262}, {'end': 2545.578, 'text': "next I'll write set, let's say, unit underscore price.", 'start': 2540.177, 'duration': 5.401}, {'end': 2552.941, 'text': "if you see this, let's say I want to set the unit price of trousers from $50 to, let's say, $45.", 'start': 2545.578, 'duration': 7.363}, {'end': 2555.281, 'text': 'I want to update this particular record.', 'start': 2552.941, 'duration': 2.34}, {'end': 2568.661, 'text': "so I'm going to write set unit price column equal to $45 where the order ID equal to 103.", 'start': 2555.281, 'duration': 13.38}], 'summary': 'Update unit price of trousers from $50 to $45 for order id 103.', 'duration': 33.746, 'max_score': 2534.915, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI2534915.jpg'}, {'end': 2643.899, 'src': 'embed', 'start': 2614.208, 'weight': 1, 'content': [{'end': 2620.053, 'text': 'and this will take into parameters, as always, which is going to be connection followed by the variable name.', 'start': 2614.208, 'duration': 5.845}, {'end': 2620.914, 'text': 'that is update.', 'start': 2620.053, 'duration': 0.861}, {'end': 2623.23, 'text': "let's run it.", 'start': 2621.949, 'duration': 1.281}, {'end': 2627.252, 'text': 'you see here it says MySQL database connection successful query was successful.', 'start': 2623.23, 'duration': 4.022}, {'end': 2631.394, 'text': 'now you can recheck that.', 'start': 2627.252, 'duration': 4.142}, {'end': 2638.657, 'text': "to do it, let me just go to the top and we'll just copy our first query, which is q1.", 'start': 2631.394, 'duration': 7.263}, {'end': 2643.899, 'text': "I'll copy this and I'll paste it here.", 'start': 2638.657, 'duration': 5.242}], 'summary': 'Successful mysql database connection and query execution, with parameters and query copying demonstrated.', 'duration': 29.691, 'max_score': 2614.208, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI2614208.jpg'}, {'end': 2826.014, 'src': 'embed', 'start': 2800.359, 'weight': 3, 'content': [{'end': 2807.824, 'text': 'so first we imported the important libraries mysql connector, then we imported the error function, then we imported pandas using pd.', 'start': 2800.359, 'duration': 7.465}, {'end': 2812.7, 'text': 'We learned how to create a server connection to MySQL database.', 'start': 2809.417, 'duration': 3.283}, {'end': 2816.785, 'text': 'We created a new database that is mysql underscore python.', 'start': 2813.321, 'duration': 3.464}, {'end': 2819.708, 'text': 'And now we connected to that database.', 'start': 2817.585, 'duration': 2.123}, {'end': 2822.811, 'text': 'We created a function to execute our queries.', 'start': 2820.629, 'duration': 2.182}, {'end': 2826.014, 'text': 'We saw how you can write a create table command.', 'start': 2823.411, 'duration': 2.603}], 'summary': 'Imported libraries, connected to mysql, created new database, executed queries, wrote create table command.', 'duration': 25.655, 'max_score': 2800.359, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI2800359.jpg'}, {'end': 2881.459, 'src': 'embed', 'start': 2854.975, 'weight': 2, 'content': [{'end': 2859.536, 'text': 'After that, we used our where clause to filter our table based on specific conditions.', 'start': 2854.975, 'duration': 4.561}, {'end': 2864.276, 'text': 'We saw how to order your results based on a particular column.', 'start': 2860.595, 'duration': 3.681}, {'end': 2871.017, 'text': 'Then we saw how you could convert the table into a data frame using pd.dataframe function.', 'start': 2865.356, 'duration': 5.661}, {'end': 2876.378, 'text': 'Finally, we learned how to use the update command and the delete command.', 'start': 2872.197, 'duration': 4.181}, {'end': 2881.459, 'text': 'Alright, so that brings us to the end of this video tutorial on SQL with Python.', 'start': 2877.118, 'duration': 4.341}], 'summary': 'Tutorial covered filtering, ordering, converting to dataframe, update, delete commands in sql with python.', 'duration': 26.484, 'max_score': 2854.975, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI2854975.jpg'}], 'start': 2499.827, 'title': 'Sql update and delete queries', 'summary': 'Covers using the update command in sql to change the unit price of an order from $50 to $45 for order id 103, and executing the query successfully. it also discusses executing update and delete queries in sql with python, covering the process of updating unit prices and deleting records, and detailing the step-by-step process of connecting to a mysql database and executing different sql commands.', 'chapters': [{'end': 2643.899, 'start': 2499.827, 'title': 'Using the update command in sql', 'summary': 'Covers the usage of the update command in sql to change the unit price of an order, demonstrating the process through a specific example of updating the unit price of an order from $50 to $45 for order id 103, and executing the query successfully.', 'duration': 144.072, 'highlights': ["The update command in SQL is demonstrated by updating the unit price of an order from $50 to $45 for order ID 103, showcasing the process of setting the unit price and using the 'where' clause to specify the record to update.", "The successful execution of the update query is confirmed through the message 'MySQL database connection successful query was successful,' indicating the completion of the update operation."]}, {'end': 2902.487, 'start': 2643.899, 'title': 'Sql with python: update and delete queries', 'summary': 'Discusses executing update and delete queries in sql with python, covering the process of updating unit prices and deleting records, and detailing the step-by-step process of connecting to a mysql database, creating a new database, executing different sql commands, and using update and delete commands.', 'duration': 258.588, 'highlights': ['The chapter discusses executing update and delete queries in SQL with Python Covers the process of updating unit prices and deleting records, demonstrating practical application of SQL with Python.', 'Detailing the step-by-step process of connecting to a MySQL database, creating a new database, executing different SQL commands, and using update and delete commands Provides a comprehensive overview of the practical steps involved in connecting to a MySQL database, creating a new database, executing various SQL commands, and utilizing update and delete commands.', 'Covered the process of updating unit prices and deleting records Demonstrates the specific actions of updating unit prices and deleting records in a SQL database, showcasing practical application of SQL with Python.', 'Explained the process of executing different SQL commands Provides a detailed explanation of executing various SQL commands, enhancing understanding of the SQL with Python functionalities.', 'Demonstrated the step-by-step process of connecting to a MySQL database and creating a new database Provides a detailed demonstration of the process of connecting to a MySQL database and creating a new database, offering practical guidance on database management.']}], 'duration': 402.66, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/zrNHkRgWzTI/pics/zrNHkRgWzTI2499827.jpg', 'highlights': ["The update command in SQL is demonstrated by updating the unit price of an order from $50 to $45 for order ID 103, showcasing the process of setting the unit price and using the 'where' clause to specify the record to update.", "The successful execution of the update query is confirmed through the message 'MySQL database connection successful query was successful,' indicating the completion of the update operation.", 'The chapter discusses executing update and delete queries in SQL with Python Covers the process of updating unit prices and deleting records, demonstrating practical application of SQL with Python.', 'Detailing the step-by-step process of connecting to a MySQL database, creating a new database, executing different SQL commands, and using update and delete commands Provides a comprehensive overview of the practical steps involved in connecting to a MySQL database, creating a new database, executing various SQL commands, and utilizing update and delete commands.', 'Explained the process of executing different SQL commands Provides a detailed explanation of executing various SQL commands, enhancing understanding of the SQL with Python functionalities.']}], 'highlights': ['The tutorial focuses on working with SQL queries using Python, suitable for data science and analytics.', 'The demonstration includes working with databases and tables using SQL with Python.', 'Emphasizes the necessity of installing MySQL and Jupyter Notebook for executing SQL queries using Python.', 'The chapter covers the process of importing necessary libraries including mysql.connector and pandas.', 'Creating a function to establish a server connection using exception handling techniques.', 'The chapter explains the process of creating a MySQL database connection and creating a database using Python.', 'Print statements and print formatting techniques are used to display messages and handle errors.', 'User-defined functions are defined for creating a server connection and database creation, with specific parameters and queries.', "The function 'create_database' is utilized to create a new database named 'mysql_python', using the 'create database' SQL query, and it requires two parameters: 'connection' and 'create_database_query'.", "The 'connection.cursor' function is employed to execute SQL statements in Python, facilitating the creation of the new database 'mysql_python'.", "The try block attempts to create the new database 'mysql_python', while the except block handles any potential failures in the creation process.", "Created a new database using SQL query 'create database' and verified its creation in MySQL workbench or MySQL shell.", "Connected to the newly created database by defining a user-defined function 'create_db' with parameters for host name, user name, user password, and database name.", "Defined a user-defined function 'execute_query' to execute SQL queries using parameters 'connection' and 'query', and handled error using try and accept blocks.", "Demonstrated the creation of a table 'orders' with detailed SQL command and variable names, specifying column names, data types, and constraints.", "Successfully created a table named 'orders' in the MySQL database with columns 'order id', 'customer name', 'product name', 'ordered date', 'quantity', 'unit price', and 'phone number'.", "Inserted records for six customers with their respective items and details into the 'orders' table.", "Demonstrated the process of refreshing and checking the newly created table 'orders' in MySQL Workbench.", 'The process of creating a database connection is detailed, including the parameters such as hostname, username, password, and database name.', 'The syntax for defining a varying character data type for a phone number with a size of 20 is explained, followed by the process of creating a database connection and executing a query.', 'Executing a query using the execute_query function is mentioned as the final step in the process.', 'The SQL database connection was successfully created and the query execution was also successful, demonstrating the effective implementation of the code.', 'Executing SQL queries to display, filter, and order data, including examples of creating a data frame from the table with a total of 6 records.', "The user-defined function 'df.read_query' was created to read queries and display results, enhancing the functionality of the SQL database interaction.", 'Extracting unique years (2018 and 2019) from the order date column using the year function.', 'The process involved using parameters such as host name, username, password, and database name to establish the database connection, showcasing the comprehensive approach to setting up the connection.', 'Using the WHERE clause to filter and display orders before and after specific dates.', 'Utilizing the ORDER BY clause to sort results based on a particular column, with examples of both ascending and descending order.', "The update command in SQL is demonstrated by updating the unit price of an order from $50 to $45 for order ID 103, showcasing the process of setting the unit price and using the 'where' clause to specify the record to update.", "The successful execution of the update query is confirmed through the message 'MySQL database connection successful query was successful,' indicating the completion of the update operation.", 'The chapter discusses executing update and delete queries in SQL with Python Covers the process of updating unit prices and deleting records, demonstrating practical application of SQL with Python.', 'Detailing the step-by-step process of connecting to a MySQL database, creating a new database, executing different SQL commands, and using update and delete commands Provides a comprehensive overview of the practical steps involved in connecting to a MySQL database, creating a new database, executing various SQL commands, and utilizing update and delete commands.', 'Explained the process of executing different SQL commands Provides a detailed explanation of executing various SQL commands, enhancing understanding of the SQL with Python functionalities.']}