title
SQL For Data Science Tutorial | Learn SQL Database For Data Science | Edureka

description
** ** Data Science Master Program: https://www.edureka.co/masters-program/data-scientist-certification ** This Edureka session on SQL for Data Science will help you understand how SQL can be used to store, access and retrieve data to perform data analysis. Here’s a list of topics covered in this session: 1. Introduction To Data Science 2. Why Is SQL Needed For Data Science? 3. What Is SQL? 4. Basics Of SQL 5. Installing MySQL 6. Hands-On Do subscribe to our channel and hit the bell icon to never miss an update from us in the future: https://goo.gl/6ohpTV Check out the entire Machine Learning Playlist: https://bit.ly/2NG9tK4 Instagram: https://www.instagram.com/edureka_learning/ Facebook: https://www.facebook.com/edurekaIN/ Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka Slideshare: https://www.slideshare.net/EdurekaIN/ #Edureka #DataScienceEdureka #sqlfordatascience #datasciencetutorial Introducing Edureka Elevate, a one of its kind software development program where you only pay the program fees once you get a top tech job. If you are a 4th year engineering student or a fresh graduate, this program is open to you! Learn more: http://bit.ly/2vQKVu6 ------------------------------------- About the Masters Program Edureka’s Machine Learning Engineer Masters Program makes you proficient in techniques like Supervised Learning, Unsupervised Learning and Natural Language Processing. It includes training on the latest advancements and technical approaches in Artificial Intelligence & Machine Learning such as Deep Learning, Graphical Models and Reinforcement Learning. The Master's Program Covers Topics LIke: Python Programming PySpark HDFS Spark SQL Machine Learning Techniques and Artificial Intelligence Types Tokenization Named Entity Recognition Lemmatization Supervised Algorithms Unsupervised Algorithms Tensor Flow Deep learning Keras Neural Networks Bayesian and Markov’s Models Inference Decision Making Bandit Algorithms Bellman Equation Policy Gradient Methods ---------------------- Prerequisites There are no prerequisites for enrolment to the Masters Program. However, as a goodwill gesture, Edureka offers a complimentary self-paced course in your LMS on SQL Essentials to brush up on your SQL Skills. This program is designed and developed for an aspirant planning to build a career in Machine Learning or an experienced professional working in the IT industry. -------------------------------------- Please write back to us at sales@edureka.in or call us at IND: 9606058406 / US: 18338555775 (toll-free) for more information

detail
{'title': 'SQL For Data Science Tutorial | Learn SQL Database For Data Science | Edureka', 'heatmap': [{'end': 893.335, 'start': 858.83, 'weight': 0.848}, {'end': 1128.657, 'start': 1073.385, 'weight': 0.794}, {'end': 1270.727, 'start': 1240.053, 'weight': 0.705}, {'end': 2120.357, 'start': 2035.473, 'weight': 0.895}], 'summary': "Tutorial on sql for data science explores the significance of sql in data science and its role in storing, accessing, and analyzing data, focusing on mysql's ease of use, security, scalability, and open-source nature. it discusses mysql's architecture, sql data types, and querying language, highlighting the importance of sql commands and demonstrating data import, analysis, and querying, making it a crucial skill for aspiring data scientists.", 'chapters': [{'end': 73.29, 'segs': [{'end': 56.124, 'src': 'embed', 'start': 11.494, 'weight': 0, 'content': [{'end': 17.198, 'text': 'Since the time, data science has been ranked at number one for being the most promising job of the era.', 'start': 11.494, 'duration': 5.704}, {'end': 19.88, 'text': "we're all trying to join the race of learning data science.", 'start': 17.198, 'duration': 2.682}, {'end': 26.064, 'text': "Hi everyone, I'm Zulekha from Edureka and I welcome you to this session on SQL for data science.", 'start': 20.62, 'duration': 5.444}, {'end': 33.168, 'text': "Today you'll understand how SQL can be used to store, access, and retrieve data to perform data analysis.", 'start': 26.664, 'duration': 6.504}, {'end': 35.71, 'text': "So let's quickly look at the agenda for today.", 'start': 33.909, 'duration': 1.801}, {'end': 38.86, 'text': "We're going to start with a small introduction to data science.", 'start': 36.32, 'duration': 2.54}, {'end': 42.501, 'text': "After that, we'll discuss why SQL is needed for data science.", 'start': 39.421, 'duration': 3.08}, {'end': 48.062, 'text': "Then we'll see what exactly SQL is and we'll brush up a few basics of SQL.", 'start': 43.061, 'duration': 5.001}, {'end': 56.124, 'text': "Then we'll finally move on and look at a hands-on where we'll import a huge data set and we'll try to perform data analysis on this data set.", 'start': 48.562, 'duration': 7.562}], 'summary': 'Data science is the most promising job, and this session focuses on using sql for data analysis.', 'duration': 44.63, 'max_score': 11.494, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM11494.jpg'}], 'start': 11.494, 'title': 'Sql for data science', 'summary': 'Introduces the significance of data science as the most promising job and explores the usage of sql for storing, accessing, and retrieving data to perform data analysis in a hands-on session.', 'chapters': [{'end': 73.29, 'start': 11.494, 'title': 'Sql for data science', 'summary': 'Introduces the significance of data science as the most promising job, and explores the usage of sql for storing, accessing, and retrieving data to perform data analysis in a hands-on session.', 'duration': 61.796, 'highlights': ['Data science is ranked number one for being the most promising job of the era Data science is acknowledged as the top job in the current era.', 'Introduction to data science and the usage of SQL for data analysis The chapter covers the introduction to data science and the application of SQL for data analysis.', 'Hands-on session to import a huge data set and perform data analysis The session includes a practical exercise where a substantial data set is imported and utilized for data analysis.']}], 'duration': 61.796, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM11494.jpg', 'highlights': ['Data science is ranked number one for being the most promising job of the era', 'Introduction to data science and the usage of SQL for data analysis', 'Hands-on session to import a huge data set and perform data analysis']}, {'end': 394.453, 'segs': [{'end': 97.485, 'src': 'embed', 'start': 73.29, 'weight': 1, 'content': [{'end': 80.772, 'text': 'is the process of deriving useful insights from data in order to solve real-world problems or in order to grow a business.', 'start': 73.29, 'duration': 7.482}, {'end': 86.413, 'text': 'Now data science was introduced because we are generating an immeasurable amount of data.', 'start': 81.532, 'duration': 4.881}, {'end': 95.323, 'text': "For example, there's a fact that we're generating more than 2.5 quintillion bytes of data every day, and at this pace it's only going to grow,", 'start': 87.017, 'duration': 8.306}, {'end': 97.485, 'text': 'because right now everything runs on data.', 'start': 95.323, 'duration': 2.162}], 'summary': 'Data science uses data to solve problems, with over 2.5 quintillion bytes generated daily.', 'duration': 24.195, 'max_score': 73.29, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM73290.jpg'}, {'end': 140.75, 'src': 'embed', 'start': 112.6, 'weight': 0, 'content': [{'end': 120.183, 'text': 'The data is the key in data science and since we are producing so much data, is the perfect time for you to learn data science.', 'start': 112.6, 'duration': 7.583}, {'end': 125.745, 'text': 'and data science basically covers artificial intelligence, machine learning, natural language processing.', 'start': 120.183, 'duration': 5.562}, {'end': 128.005, 'text': 'all of these processes are covered under data science.', 'start': 125.745, 'duration': 2.26}, {'end': 134.308, 'text': "So that is one of the reasons why data science has become so popular because of the amount of data we're generating.", 'start': 128.666, 'duration': 5.642}, {'end': 140.75, 'text': 'we need methods and Technologies that can handle so much data and they can, you know, derive something useful from the data.', 'start': 134.308, 'duration': 6.442}], 'summary': 'Data science encompasses ai, ml, and nlp, driven by the surge in data generation and the need for effective data handling.', 'duration': 28.15, 'max_score': 112.6, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM112600.jpg'}, {'end': 205.438, 'src': 'embed', 'start': 173.25, 'weight': 2, 'content': [{'end': 174.912, 'text': 'Now this is where SQL comes in.', 'start': 173.25, 'duration': 1.662}, {'end': 177.215, 'text': 'SQL can be used to store.', 'start': 175.773, 'duration': 1.442}, {'end': 185.125, 'text': 'It can be used to access and extract massive amounts of data in order to carry out the whole data science process more smoothly.', 'start': 177.575, 'duration': 7.55}, {'end': 187.974, 'text': 'So SQL as acquiring language.', 'start': 185.794, 'duration': 2.18}, {'end': 196.316, 'text': 'it can be used to perform a lot of querying operations, a lot of search operations, extractions and editing and modifying your data.', 'start': 187.974, 'duration': 8.342}, {'end': 205.438, 'text': 'So we need a huge management system and along with that we need a language that can perform all the operations that we want to do on our data.', 'start': 197.096, 'duration': 8.342}], 'summary': 'Sql is used for storing and extracting massive amounts of data, making data science processes smoother.', 'duration': 32.188, 'max_score': 173.25, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM173250.jpg'}, {'end': 364.883, 'src': 'embed', 'start': 334.654, 'weight': 3, 'content': [{'end': 337.655, 'text': 'Apart from this, it is also very secure.', 'start': 334.654, 'duration': 3.001}, {'end': 348.238, 'text': 'actually, MySQL consists of you can see a solid data security layer which will protect all of your sensitive data or your confidential data from any intruders.', 'start': 337.655, 'duration': 10.583}, {'end': 350.158, 'text': 'passwords are encrypted in MySQL.', 'start': 348.238, 'duration': 1.92}, {'end': 354.999, 'text': "So that's a good advantage of using MySQL apart from that, of course, it's open source.", 'start': 350.418, 'duration': 4.581}, {'end': 361.401, 'text': "So it's free to download and to use you can just go to the official website and download it in a matter of minutes.", 'start': 355.079, 'duration': 6.322}, {'end': 364.883, 'text': 'Then, of course, it is scalable as well, right?', 'start': 362.06, 'duration': 2.823}], 'summary': 'Mysql is secure with encrypted passwords, scalable, and open source.', 'duration': 30.229, 'max_score': 334.654, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM334654.jpg'}], 'start': 73.29, 'title': 'Data science and sql', 'summary': 'Introduces the importance of data science, emphasizing the exponential growth of data and the need for tools like sql to handle and analyze massive amounts of data, with a focus on using mysql for its ease of use, security, scalability, and open-source nature.', 'chapters': [{'end': 394.453, 'start': 73.29, 'title': 'Data science and sql for data science', 'summary': 'Introduces the importance of data science, emphasizing the exponential growth of data and the need for tools like sql to handle and analyze massive amounts of data, with a focus on using mysql for its ease of use, security, scalability, and open-source nature.', 'duration': 321.163, 'highlights': ['The exponential growth of data is emphasized, with over 2.5 quintillion bytes of data generated daily, driving the need for methods and technologies like data science to handle and derive useful insights from this vast amount of data. More than 2.5 quintillion bytes of data are generated daily, highlighting the need for methods and technologies to handle and derive insights from this vast amount of data.', 'Data science encompasses artificial intelligence, machine learning, and natural language processing, further highlighting the vast scope and importance of data science in handling the massive amount of data being generated. Data science covers artificial intelligence, machine learning, and natural language processing, emphasizing its vast scope and importance in handling the massive amount of data being generated.', 'SQL is highlighted as a crucial tool for data science, enabling the storage, access, and extraction of massive amounts of data, streamlining the data science process and allowing for querying, search operations, and data manipulation. SQL is crucial for data science, enabling storage, access, and extraction of massive data, streamlining the process, and allowing for querying, search operations, and data manipulation.', 'The advantages of MySQL for data science are outlined, including its ease of use, security features, open-source nature, and scalability to handle large databases up to 50 million rows or more. MySQL is highlighted for its ease of use, security features, open-source nature, and scalability to handle large databases up to 50 million rows or more.']}], 'duration': 321.163, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM73290.jpg', 'highlights': ['Data science covers artificial intelligence, machine learning, and natural language processing, emphasizing its vast scope and importance in handling the massive amount of data being generated.', 'The exponential growth of data is emphasized, with over 2.5 quintillion bytes of data generated daily, driving the need for methods and technologies like data science to handle and derive useful insights from this vast amount of data.', 'SQL is crucial for data science, enabling storage, access, and extraction of massive data, streamlining the process, and allowing for querying, search operations, and data manipulation.', 'MySQL is highlighted for its ease of use, security features, open-source nature, and scalability to handle large databases up to 50 million rows or more.']}, {'end': 817.683, 'segs': [{'end': 467.7, 'src': 'embed', 'start': 436.027, 'weight': 0, 'content': [{'end': 439.649, 'text': 'So basically communication via a local network or the internet.', 'start': 436.027, 'duration': 3.622}, {'end': 447.211, 'text': "Another important point is that there are quite a number of api's and libraries for the development of mysql applications.", 'start': 440.268, 'duration': 6.943}, {'end': 452.353, 'text': 'So, basically, it has support for multiple programming interfaces, right?', 'start': 447.771, 'duration': 4.582}, {'end': 460.477, 'text': 'So, client programming, you can use languages like C, C++, Java, Pearl, PHP, Python and so on at all.', 'start': 452.373, 'duration': 8.104}, {'end': 462.358, 'text': 'These languages are easily compatible.', 'start': 460.517, 'duration': 1.841}, {'end': 467.7, 'text': 'They provide API so that you can integrate and can perform or you can build applications using these languages.', 'start': 462.418, 'duration': 5.282}], 'summary': 'Mysql supports multiple programming interfaces and provides apis for easy integration with languages like c, c++, java, pearl, php, python.', 'duration': 31.673, 'max_score': 436.027, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM436027.jpg'}, {'end': 523.385, 'src': 'embed', 'start': 498.86, 'weight': 2, 'content': [{'end': 505.742, 'text': 'The most important ones are your Mac operating systems Linux Microsoft Windows and so on apart from that.', 'start': 498.86, 'duration': 6.882}, {'end': 507.362, 'text': 'We also have speed right.', 'start': 505.762, 'duration': 1.6}, {'end': 516.724, 'text': 'MySQL is considered a very fast database program and this speed is actually being backed up by a large number of benchmark tests.', 'start': 507.362, 'duration': 9.362}, {'end': 523.385, 'text': "and apart from that, it's highly productive because it uses triggers, it uses stored procedures and views,", 'start': 516.724, 'duration': 6.661}], 'summary': 'Mysql is a fast and productive database program supported by benchmark tests.', 'duration': 24.525, 'max_score': 498.86, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM498860.jpg'}, {'end': 617.516, 'src': 'embed', 'start': 593.479, 'weight': 1, 'content': [{'end': 601.426, 'text': 'Now this is available to specify columns that have very large binary values, such, as you know, maybe images and so on.', 'start': 593.479, 'duration': 7.947}, {'end': 603.368, 'text': 'then we have the Boolean data type.', 'start': 601.426, 'duration': 1.942}, {'end': 606.07, 'text': 'now this data type, as the name suggests itself.', 'start': 603.368, 'duration': 2.702}, {'end': 614.017, 'text': 'It has true or false values and since SQL has null values a three-valued logic is used which is unknown.', 'start': 606.25, 'duration': 7.767}, {'end': 615.298, 'text': "That's the third value.", 'start': 614.457, 'duration': 0.841}, {'end': 617.516, 'text': 'Then we have date and time.', 'start': 616.115, 'duration': 1.401}], 'summary': 'Sql supports large binary values, boolean data type, and date and time data types.', 'duration': 24.037, 'max_score': 593.479, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM593479.jpg'}, {'end': 742.291, 'src': 'embed', 'start': 703.088, 'weight': 3, 'content': [{'end': 712.434, 'text': 'you just use the command use and the name of the database that you created and remember that at the end of each command you have a Terminator,', 'start': 703.088, 'duration': 9.346}, {'end': 713.435, 'text': 'which is a semicolon.', 'start': 712.434, 'duration': 1.001}, {'end': 717.619, 'text': 'and also your commands are usually written in capital letters,', 'start': 714.238, 'duration': 3.381}, {'end': 722.02, 'text': 'so that you can differentiate your commands from your table columns or table names and all of that.', 'start': 717.619, 'duration': 4.401}, {'end': 723.76, 'text': "So it's a good practice.", 'start': 722.56, 'duration': 1.2}, {'end': 727.421, 'text': 'If you write all your commands in capital letters.', 'start': 723.84, 'duration': 3.581}, {'end': 728.841, 'text': 'next we have create table.', 'start': 727.421, 'duration': 1.42}, {'end': 732.241, 'text': 'now tables are the most important part of a database, right?', 'start': 728.841, 'duration': 3.4}, {'end': 739.803, 'text': 'So create table is a simple command that will create a new table for you, and it can contain a lot of data variables of different data types.', 'start': 732.302, 'duration': 7.501}, {'end': 742.291, 'text': 'and so the syntax is simple.', 'start': 740.57, 'duration': 1.721}], 'summary': "Use 'use' command to select database. 'create table' creates new table with various data variables.", 'duration': 39.203, 'max_score': 703.088, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM703088.jpg'}, {'end': 799.738, 'src': 'embed', 'start': 776.803, 'weight': 5, 'content': [{'end': 784.805, 'text': "Now usually what happens is when people insert values into the table, they forget the data type that they've defined under that particular variable.", 'start': 776.803, 'duration': 8.002}, {'end': 789.547, 'text': 'So remember that the values that are inserted must align with the defined data types.', 'start': 785.245, 'duration': 4.302}, {'end': 799.738, 'text': "So, for example, if your variable is age and instead of putting your numerical 3, you've put your character 3, basically you've typed out thre,", 'start': 790.416, 'duration': 9.322}], 'summary': 'Insert values aligned with defined data types to avoid errors.', 'duration': 22.935, 'max_score': 776.803, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM776803.jpg'}], 'start': 394.453, 'title': 'Mysql, sql data types, and database basics', 'summary': "Discusses mysql's client-server architecture, compatibility with multiple operating systems, and support for various programming languages. it also provides an overview of sql data types and basics of sql querying language, emphasizing error-free database operations.", 'chapters': [{'end': 547.64, 'start': 394.453, 'title': 'Mysql: features and benefits', 'summary': 'Discusses the client-server architecture of mysql, its compatibility with multiple operating systems, support for various programming languages, and its speed and productivity, making it one of the most compatible and easiest to use databases for data analysis and application development.', 'duration': 153.187, 'highlights': ['MySQL follows a client-server architecture, compatible with multiple operating systems, and supports various programming languages like C, C++, Java, Pearl, PHP, Python. MySQL follows a client-server architecture, compatible with multiple operating systems, and supports various programming languages like C, C++, Java, Pearl, PHP, Python.', 'MySQL is considered a very fast database program, backed up by a large number of benchmark tests, and highly productive with the use of triggers, stored procedures, and views. MySQL is considered a very fast database program, backed up by a large number of benchmark tests, and highly productive with the use of triggers, stored procedures, and views.', 'MySQL is customizable, platform independent, and can be executed under a number of operating systems, including Mac, Linux, Microsoft Windows, and more. MySQL is customizable, platform independent, and can be executed under a number of operating systems, including Mac, Linux, Microsoft Windows, and more.']}, {'end': 683.507, 'start': 547.74, 'title': 'Sql data types overview', 'summary': 'Provides an overview of various sql data types, including bit string, boolean, date, time, timestamp, interval, numeric, floating point, character strings, and their respective properties and use cases. it also touches upon the basics of sql querying language.', 'duration': 135.767, 'highlights': ['The chapter provides an overview of various SQL data types, including bit string, Boolean, date, time, timestamp, interval, and numeric, along with their specific characteristics and use cases. ', 'It explains the properties of character strings, including fixed or varying number of characters, and introduces the character large object and binary large object data types for handling large text and binary values. ', 'The Boolean data type in SQL supports true, false, and unknown values due to the presence of null values, creating a three-valued logic system. ', 'Details about date and time data types are outlined, covering the components and formats for representing dates, times, and timestamps, with flexibility for customization based on specific requirements. ', 'The timestamp data type includes options for representing decimal fractions of seconds and time zones, while the interval data type allows for specifying relative values that can be used to adjust absolute time or date values. ']}, {'end': 817.683, 'start': 684.067, 'title': 'Sql database: basics and commands', 'summary': 'Covers the basic commands for creating databases and tables, emphasizing the importance of syntax, data types, and alignment of values with data types, ensuring error-free database operations.', 'duration': 133.616, 'highlights': ["The 'create database' command is used to create a new database, and it is essential to use the terminator (semicolon) and write commands in capital letters for differentiation, ensuring smooth database creation.", "The 'create table' command is crucial for creating tables with different data variables and data types, emphasizing the importance of syntax and data type alignment for error-free table creation and management.", "The 'insert into' command is used for inserting new data into tables, highlighting the importance of aligning the inserted values with the defined data types to avoid errors in database operations."]}], 'duration': 423.23, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM394453.jpg', 'highlights': ['MySQL follows a client-server architecture, compatible with multiple operating systems, and supports various programming languages like C, C++, Java, Pearl, PHP, Python.', 'The chapter provides an overview of various SQL data types, including bit string, Boolean, date, time, timestamp, interval, and numeric, along with their specific characteristics and use cases.', 'MySQL is considered a very fast database program, backed up by a large number of benchmark tests, and highly productive with the use of triggers, stored procedures, and views.', "The 'create database' command is used to create a new database, and it is essential to use the terminator (semicolon) and write commands in capital letters for differentiation, ensuring smooth database creation.", "The 'create table' command is crucial for creating tables with different data variables and data types, emphasizing the importance of syntax and data type alignment for error-free table creation and management.", "The 'insert into' command is used for inserting new data into tables, highlighting the importance of aligning the inserted values with the defined data types to avoid errors in database operations."]}, {'end': 1020.628, 'segs': [{'end': 851.245, 'src': 'embed', 'start': 818.425, 'weight': 1, 'content': [{'end': 821.286, 'text': "Now, let's look at our next command which is select.", 'start': 818.425, 'duration': 2.861}, {'end': 828.329, 'text': 'So this is one of the most important commands when it comes to SQL for data science and because mainly,', 'start': 821.907, 'duration': 6.422}, {'end': 834.772, 'text': "it's all about extracting useful insights and extracting particular type of data from your database,", 'start': 828.329, 'duration': 6.443}, {'end': 838.254, 'text': "and we'll see how often we'll use this command when we perform our demo today.", 'start': 834.772, 'duration': 3.482}, {'end': 843.556, 'text': "This is one of the most simplest and in fact, it's one of the most important commands in SQL.", 'start': 838.814, 'duration': 4.742}, {'end': 851.245, 'text': 'Okay, so basically select will select a specified table or a column and it will extract the values from it.', 'start': 844.361, 'duration': 6.884}], 'summary': 'Select command is important in sql for data science, used for extracting specific data from a database.', 'duration': 32.82, 'max_score': 818.425, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM818425.jpg'}, {'end': 922.227, 'src': 'heatmap', 'start': 858.83, 'weight': 2, 'content': [{'end': 867.715, 'text': "So don't worry if you do not know exactly what this does just remember that your select command is for extracting data from your table next.", 'start': 858.83, 'duration': 8.885}, {'end': 868.816, 'text': 'We have the update command.', 'start': 867.755, 'duration': 1.061}, {'end': 874.586, 'text': 'So update will basically allow you to modify any values that are stored in your table,', 'start': 869.463, 'duration': 5.123}, {'end': 878.528, 'text': 'and the where clause here will select the variable or value that you want to change.', 'start': 874.586, 'duration': 3.942}, {'end': 886.111, 'text': "So it's basically it'll highlight the variable or the value or I'll try to identify the value that you want to change next.", 'start': 879.188, 'duration': 6.923}, {'end': 893.335, 'text': 'We have the delete command now delete will basically delete data from your data set or from your table as the name itself suggests.', 'start': 886.151, 'duration': 7.184}, {'end': 901.463, 'text': "So delete from the name of your table and where with a condition it's as simple as that next we have a drop table.", 'start': 894.238, 'duration': 7.225}, {'end': 906.266, 'text': 'So this command is basically used to delete a table and all the rows in the table.', 'start': 901.923, 'duration': 4.343}, {'end': 909.328, 'text': 'So your table will get deleted from your database.', 'start': 906.867, 'duration': 2.461}, {'end': 911.37, 'text': "That's what happens with drop table.", 'start': 909.749, 'duration': 1.621}, {'end': 915.144, 'text': 'These were a couple of commands that I thought you should brush up on.', 'start': 912.242, 'duration': 2.902}, {'end': 922.227, 'text': "I'm sure you guys are already aware of these commands, but in case there are a few few who don't know much about SQL.", 'start': 915.684, 'duration': 6.543}], 'summary': 'Sql commands: select, update, delete, drop table for data manipulation.', 'duration': 63.397, 'max_score': 858.83, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM858830.jpg'}, {'end': 1007.824, 'src': 'embed', 'start': 979.545, 'weight': 0, 'content': [{'end': 985.688, 'text': "So usually there's a humongous data set that needs to be explored and analyzed in order to derive something useful from it.", 'start': 979.545, 'duration': 6.143}, {'end': 987.537, 'text': "So that's what we're going to do today.", 'start': 986.375, 'duration': 1.162}, {'end': 990.984, 'text': "So I've already imported a CSV file.", 'start': 987.558, 'duration': 3.426}, {'end': 992.606, 'text': 'Let me show you what the file looks like.', 'start': 991.124, 'duration': 1.482}, {'end': 998.878, 'text': 'So this is our CSV file and this basically contains details about employees.', 'start': 993.628, 'duration': 5.25}, {'end': 1007.824, 'text': 'So, basically, the name of the employee title is the job title of the employee Department, is the department that the employees working in.', 'start': 999.781, 'duration': 8.043}], 'summary': 'Exploring and analyzing a large dataset of employee details from a csv file.', 'duration': 28.279, 'max_score': 979.545, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM979545.jpg'}], 'start': 818.425, 'title': 'Importance of sql commands', 'summary': 'Covers the significance of sql commands in data science, including select, update, delete, and drop table, and prepares for a demo in mysql workbench to derive insights from a dataset.', 'chapters': [{'end': 1020.628, 'start': 818.425, 'title': 'Sql commands for data science', 'summary': 'Covers the importance of sql commands for data science, such as select for extracting data from tables, update for modifying values, delete for removing data, and drop table for deleting entire tables, preparing for a demo in mysql workbench to derive useful insights from a dataset.', 'duration': 202.203, 'highlights': ["The 'select' command is crucial for extracting specific data from a database, often used for deriving insights, and will be demonstrated in the upcoming session.", "The 'update' command allows modification of values in a table, with the 'where' clause selecting the specific variable or value to be changed.", "The 'delete' command is utilized to remove data from a dataset or table, with the option to specify conditions for deletion.", "The 'drop table' command is used to delete an entire table and all its rows from the database, offering a simple way to handle table deletion.", 'In the upcoming demo using MySQL workbench, the focus is on deriving insights from a pre-imported dataset containing details about employees, emphasizing the need for exploring and analyzing large datasets for data science purposes.']}], 'duration': 202.203, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM818425.jpg', 'highlights': ['In the upcoming demo using MySQL workbench, the focus is on deriving insights from a pre-imported dataset containing details about employees, emphasizing the need for exploring and analyzing large datasets for data science purposes.', "The 'select' command is crucial for extracting specific data from a database, often used for deriving insights, and will be demonstrated in the upcoming session.", "The 'update' command allows modification of values in a table, with the 'where' clause selecting the specific variable or value to be changed.", "The 'delete' command is utilized to remove data from a dataset or table, with the option to specify conditions for deletion.", "The 'drop table' command is used to delete an entire table and all its rows from the database, offering a simple way to handle table deletion."]}, {'end': 1682.109, 'segs': [{'end': 1046.184, 'src': 'embed', 'start': 1021.989, 'weight': 3, 'content': [{'end': 1030.574, 'text': 'So our data set has around 32, 000 observations, right? So this is a very huge data set and I basically downloaded from the internet.', 'start': 1021.989, 'duration': 8.585}, {'end': 1035.858, 'text': 'You can find a lot of data sets on the internet and you can perform all of the data analysis in no time.', 'start': 1030.714, 'duration': 5.144}, {'end': 1042.862, 'text': "So if you don't know how to import a data set in your MySQL workbench quickly show you how it's done.", 'start': 1036.698, 'duration': 6.164}, {'end': 1046.184, 'text': "So I've already created a database here.", 'start': 1042.882, 'duration': 3.302}], 'summary': 'Data set contains 32,000 observations. can be imported into mysql workbench quickly.', 'duration': 24.195, 'max_score': 1021.989, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM1021989.jpg'}, {'end': 1128.657, 'src': 'heatmap', 'start': 1073.385, 'weight': 0.794, 'content': [{'end': 1077.627, 'text': "So we've basically activated our database now for this tutorial.", 'start': 1073.385, 'duration': 4.242}, {'end': 1079.468, 'text': "I've already created a database.", 'start': 1077.687, 'duration': 1.781}, {'end': 1081.589, 'text': "So I'm going to use that database itself.", 'start': 1079.648, 'duration': 1.941}, {'end': 1085.454, 'text': 'Name of my database is students.', 'start': 1082.973, 'duration': 2.481}, {'end': 1097.6, 'text': "And so let's activate this database right now in this I have a couple of tables and we are going to be focusing on this table employee details.", 'start': 1087.995, 'duration': 9.605}, {'end': 1099.74, 'text': 'So this is the table that I imported.', 'start': 1098.1, 'duration': 1.64}, {'end': 1105.243, 'text': "So guys for those of you who don't know how to import a CSV file into your MySQL workbench.", 'start': 1100.321, 'duration': 4.922}, {'end': 1112.126, 'text': 'All you have to do is go to tables right click on any table and go to table data import wizard.', 'start': 1105.643, 'duration': 6.483}, {'end': 1118.134, 'text': 'and click on this and browse for your CSV file.', 'start': 1114.093, 'duration': 4.041}, {'end': 1120.735, 'text': 'Okay, just to take an example.', 'start': 1118.935, 'duration': 1.8}, {'end': 1123.096, 'text': "I'll consider this CSV file.", 'start': 1120.935, 'duration': 2.161}, {'end': 1128.657, 'text': "I'm not going to import the CSV file that we're going to be using right now because that is a very,", 'start': 1123.576, 'duration': 5.081}], 'summary': "Database 'students' activated with table 'employee details'.", 'duration': 55.272, 'max_score': 1073.385, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM1073385.jpg'}, {'end': 1112.126, 'src': 'embed', 'start': 1077.687, 'weight': 0, 'content': [{'end': 1079.468, 'text': "I've already created a database.", 'start': 1077.687, 'duration': 1.781}, {'end': 1081.589, 'text': "So I'm going to use that database itself.", 'start': 1079.648, 'duration': 1.941}, {'end': 1085.454, 'text': 'Name of my database is students.', 'start': 1082.973, 'duration': 2.481}, {'end': 1097.6, 'text': "And so let's activate this database right now in this I have a couple of tables and we are going to be focusing on this table employee details.", 'start': 1087.995, 'duration': 9.605}, {'end': 1099.74, 'text': 'So this is the table that I imported.', 'start': 1098.1, 'duration': 1.64}, {'end': 1105.243, 'text': "So guys for those of you who don't know how to import a CSV file into your MySQL workbench.", 'start': 1100.321, 'duration': 4.922}, {'end': 1112.126, 'text': 'All you have to do is go to tables right click on any table and go to table data import wizard.', 'start': 1105.643, 'duration': 6.483}], 'summary': "A database named 'students' with tables, including 'employee details', is already created and being used.", 'duration': 34.439, 'max_score': 1077.687, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM1077687.jpg'}, {'end': 1270.727, 'src': 'heatmap', 'start': 1240.053, 'weight': 0.705, 'content': [{'end': 1246.737, 'text': "So guys, that's how simple it is to import a CSV file into your MySQL workbench in order to perform data analysis.", 'start': 1240.053, 'duration': 6.684}, {'end': 1248.658, 'text': "So now let's clear this up.", 'start': 1247.458, 'duration': 1.2}, {'end': 1253.422, 'text': "So for this demo, like I said, we'll be using employee details data set.", 'start': 1249.499, 'duration': 3.923}, {'end': 1258.203, 'text': "This is a very huge data set and let's just get started.", 'start': 1254.562, 'duration': 3.641}, {'end': 1263.885, 'text': "I've already imported the data set here as a table right if you take a look at this employee details.", 'start': 1258.223, 'duration': 5.662}, {'end': 1270.727, 'text': 'So these are the columns in my table.', 'start': 1269.206, 'duration': 1.521}], 'summary': 'Imported a csv data set into mysql workbench for analysis, using an employee details data set.', 'duration': 30.674, 'max_score': 1240.053, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM1240053.jpg'}, {'end': 1492.217, 'src': 'embed', 'start': 1461.839, 'weight': 1, 'content': [{'end': 1466.201, 'text': 'So basically this query gave us the unique job roles that are there in our data set.', 'start': 1461.839, 'duration': 4.362}, {'end': 1468.122, 'text': "Now let's try something else.", 'start': 1466.901, 'duration': 1.221}, {'end': 1473.305, 'text': "Let's write a query to display the unique departments with their jobs.", 'start': 1468.722, 'duration': 4.583}, {'end': 1476.347, 'text': "So let's extract that.", 'start': 1474.045, 'duration': 2.302}, {'end': 1481.79, 'text': "So select again since we're trying the unique, we're going to use a distinct keyword.", 'start': 1476.827, 'duration': 4.963}, {'end': 1492.217, 'text': 'and we are going to extract the unique departments and the job titles and from the name of the table.', 'start': 1482.729, 'duration': 9.488}], 'summary': 'Query reveals unique job roles and departments.', 'duration': 30.378, 'max_score': 1461.839, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM1461839.jpg'}, {'end': 1642.807, 'src': 'embed', 'start': 1612.715, 'weight': 4, 'content': [{'end': 1614.557, 'text': "Next, let's try to do something interesting.", 'start': 1612.715, 'duration': 1.842}, {'end': 1621.481, 'text': "Let's say that we want to write a query to list the employees who do not belong to a particular department.", 'start': 1615.277, 'duration': 6.204}, {'end': 1627.565, 'text': "Let's say that we're trying to list out the employee details of employees which are not in the police department.", 'start': 1622.201, 'duration': 5.364}, {'end': 1631.299, 'text': "So for that it's quite similar to our previous query.", 'start': 1628.177, 'duration': 3.122}, {'end': 1635.262, 'text': "So you'll write select star from name of your table again.", 'start': 1631.319, 'duration': 3.943}, {'end': 1642.807, 'text': "Where department not in that's the only difference.", 'start': 1636.923, 'duration': 5.884}], 'summary': 'Query to list employees not in police department.', 'duration': 30.092, 'max_score': 1612.715, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM1612715.jpg'}], 'start': 1021.989, 'title': 'Mysql data import and analysis, sql queries', 'summary': 'Covers importing a dataset of around 32,000 observations into mysql, creating a database, and conducting data analysis. it also highlights the use of sql queries for extracting unique job roles, department details, and employee information for effective data analysis.', 'chapters': [{'end': 1381.017, 'start': 1021.989, 'title': 'Importing and analyzing data in mysql', 'summary': 'Discusses importing a large dataset into mysql workbench, creating a database, importing a csv file, and performing data analysis, with a dataset of around 32,000 observations, and demonstrating how to view the entire table and find the salaries of all the employees.', 'duration': 359.028, 'highlights': ['The dataset contains around 32,000 observations, which was downloaded from the internet. The data set consists of around 32,000 observations, emphasizing the large size of the dataset and the potential for comprehensive analysis.', 'Demonstrating the process of creating a database and activating it, along with importing a CSV file into MySQL workbench and creating a table from it. The transcript illustrates the step-by-step process of creating and activating a database, importing a CSV file into MySQL workbench, and creating a table from it.', 'The demonstration of viewing the entire table and finding the salaries of all the employees in the dataset. The chapter demonstrates how to view the entire table and find the salaries of all the employees in the dataset, showcasing the practical application of data analysis.']}, {'end': 1682.109, 'start': 1382.718, 'title': 'Sql queries for data analysis', 'summary': 'Discusses writing sql queries to extract unique job roles, departments with their job titles, employees in a particular department, and employees not belonging to a specific department, showcasing the simplicity and effectiveness of sql for data analysis.', 'duration': 299.391, 'highlights': ['SQL query to display unique job roles using distinct keyword, showcasing the different job titles in the data set. Extracting unique job roles using the distinct keyword, displaying various job titles such as surgeon, police officer, chief contractor, etc.', 'SQL query to display unique departments with their job titles, demonstrating the distinct departments according to their job titles. Extracting unique departments and their job titles using the distinct keyword, showcasing departments like police department, fleet and facility management, water management department, etc.', "SQL query to list the employees in a specific department, presenting the details of all employees in the fire department. Listing employee details in the fire department using the 'where' clause, displaying employee salaries, hiring dates, and employment categories.", "SQL query to list employees not belonging to a particular department, excluding the police department and displaying details of employees in other departments. Listing employee details not in the police department using 'not in' statement, showing details from departments such as fire, water management, law, streets and sand, finance department, etc."]}], 'duration': 660.12, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM1021989.jpg', 'highlights': ['Demonstrating the process of creating a database and activating it, along with importing a CSV file into MySQL workbench and creating a table from it.', 'SQL query to display unique job roles using distinct keyword, showcasing the different job titles in the data set.', 'SQL query to display unique departments with their job titles, demonstrating the distinct departments according to their job titles.', 'The dataset contains around 32,000 observations, which was downloaded from the internet.', 'SQL query to list employees not belonging to a particular department, excluding the police department and displaying details of employees in other departments.']}, {'end': 2329.65, 'segs': [{'end': 1762.22, 'src': 'embed', 'start': 1712.352, 'weight': 1, 'content': [{'end': 1715.133, 'text': "Okay, let's choose 1st of January 2000.", 'start': 1712.352, 'duration': 2.781}, {'end': 1716.234, 'text': "Let's run this code.", 'start': 1715.133, 'duration': 1.101}, {'end': 1725.148, 'text': "And so when you run this code, you'll find all the employees that were hired before 2000.", 'start': 1720.083, 'duration': 5.065}, {'end': 1728.611, 'text': 'So if you see original hire date, all of this is before 2000.', 'start': 1725.148, 'duration': 3.463}, {'end': 1730.193, 'text': 'Some of them were in 1994, 1996, 1984, and 1987.', 'start': 1728.611, 'duration': 1.582}, {'end': 1742.268, 'text': 'So there are only four employees who were hired before the year 2000, basically before the first of January 2000.', 'start': 1730.193, 'duration': 12.075}, {'end': 1744.069, 'text': "Now, let's try another query.", 'start': 1742.268, 'duration': 1.801}, {'end': 1751.634, 'text': "Let's write a query that will display the average salaries of all the employees who work at a particular department.", 'start': 1744.609, 'duration': 7.025}, {'end': 1754.135, 'text': "Okay, let's choose the surgeon department.", 'start': 1752.134, 'duration': 2.001}, {'end': 1759.478, 'text': "So basically, we're going to display the average salaries of all the employees who are working as surgeons.", 'start': 1754.715, 'duration': 4.763}, {'end': 1762.22, 'text': 'So for that, again, it starts from select.', 'start': 1760.199, 'duration': 2.021}], 'summary': 'Code run found 4 employees hired before 2000. query for surgeon department average salaries.', 'duration': 49.868, 'max_score': 1712.352, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM1712352.jpg'}, {'end': 1898.256, 'src': 'embed', 'start': 1876.97, 'weight': 2, 'content': [{'end': 1886.472, 'text': "Let's write a query to list the employees whose salary is let's say more than 3, 000 after giving a 25% increment to their salary.", 'start': 1876.97, 'duration': 9.502}, {'end': 1888.673, 'text': "Now, let's do a little bit of math.", 'start': 1887.272, 'duration': 1.401}, {'end': 1895.395, 'text': 'So we list down employees whose salary is more than 3, 000 after giving them a 25% increment.', 'start': 1889.273, 'duration': 6.122}, {'end': 1898.256, 'text': "So let's write down a query for that.", 'start': 1896.115, 'duration': 2.141}], 'summary': 'Query to list employees with salary > 3000 after 25% increment', 'duration': 21.286, 'max_score': 1876.97, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM1876970.jpg'}, {'end': 2120.357, 'src': 'heatmap', 'start': 2035.473, 'weight': 0.895, 'content': [{'end': 2038.577, 'text': "Let me write it down for you and then we'll understand what exactly I'm doing.", 'start': 2035.473, 'duration': 3.104}, {'end': 2040.699, 'text': 'So select.', 'start': 2039.658, 'duration': 1.041}, {'end': 2045.864, 'text': "Okay, now we'll define a variable so that we can basically extract a number of columns.", 'start': 2041.239, 'duration': 4.625}, {'end': 2049.208, 'text': "Okay, so let me write this down and then I'll tell you what exactly I did here.", 'start': 2046.205, 'duration': 3.003}, {'end': 2060.936, 'text': "name and let's also get their salary right original hiring date.", 'start': 2049.87, 'duration': 11.066}, {'end': 2085.982, 'text': "then we'll also get the salary from the name of the table where the hiring date Let's say it was lesser than I'll give a random number 0, 1, 0, 2,", 'start': 2060.936, 'duration': 25.046}, {'end': 2086.525, 'text': '2008..', 'start': 2085.982, 'duration': 0.543}, {'end': 2093.552, 'text': "Now, what exactly I'm doing here is I'm basically listing out the name of the employee,", 'start': 2086.527, 'duration': 7.025}, {'end': 2098.535, 'text': 'the hiring date and the salary of all the employees that have joined before a particular date.', 'start': 2093.552, 'duration': 4.983}, {'end': 2100.557, 'text': 'Okay, basically before this date.', 'start': 2099.136, 'duration': 1.421}, {'end': 2101.998, 'text': "That's what I've done here.", 'start': 2101.037, 'duration': 0.961}, {'end': 2105.26, 'text': "Let's run this line of code and let's see if it works.", 'start': 2102.838, 'duration': 2.422}, {'end': 2120.357, 'text': 'Right? So here we have the name the hiring date and the salary of individuals that have joined before a particular date in 2008.', 'start': 2110.632, 'duration': 9.725}], 'summary': 'Extracted employee names, hiring dates, and salaries before 2008.', 'duration': 84.884, 'max_score': 2035.473, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM2035473.jpg'}, {'end': 2237.398, 'src': 'embed', 'start': 2206.753, 'weight': 3, 'content': [{'end': 2210.474, 'text': 'We have select star from name of the table.', 'start': 2206.753, 'duration': 3.721}, {'end': 2219.136, 'text': "Employee details and let's add the where clause and here we will say salary.", 'start': 2212.015, 'duration': 7.121}, {'end': 2228.115, 'text': 'Annual is between Between is another keyboard.', 'start': 2223.217, 'duration': 4.898}, {'end': 2233.877, 'text': "So between two numbers, okay, let's say between on $24, 000 and let's say 50, 000.", 'start': 2228.676, 'duration': 5.201}, {'end': 2237.058, 'text': "All right, let's run this line of code.", 'start': 2233.877, 'duration': 3.181}, {'end': 2237.398, 'text': 'All right.', 'start': 2237.078, 'duration': 0.32}], 'summary': 'Querying employee details with salary between $24,000 and $50,000.', 'duration': 30.645, 'max_score': 2206.753, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM2206753.jpg'}, {'end': 2293.866, 'src': 'embed', 'start': 2267.975, 'weight': 0, 'content': [{'end': 2274.817, 'text': "So if you're an aspiring data scientist and you want to become a professional data scientist, you need to make sure that you are skilled with SQL.", 'start': 2267.975, 'duration': 6.842}, {'end': 2281.94, 'text': 'SQL is one of the most important querying languages that you need to know in order to become a data scientist.', 'start': 2276.136, 'duration': 5.804}, {'end': 2284.242, 'text': 'You look at any job description.', 'start': 2282.521, 'duration': 1.721}, {'end': 2287.384, 'text': "you look at any company that's hiring a data scientist.", 'start': 2284.242, 'duration': 3.142}, {'end': 2290.747, 'text': 'there will always be a prerequisite that you have to know SQL.', 'start': 2287.384, 'duration': 3.363}, {'end': 2293.866, 'text': 'and guys SQL is not difficult at all.', 'start': 2291.644, 'duration': 2.222}], 'summary': 'Aspiring data scientists should be skilled in sql, a prerequisite for most data scientist positions.', 'duration': 25.891, 'max_score': 2267.975, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM2267975.jpg'}], 'start': 1682.129, 'title': 'Querying with sql', 'summary': 'Covers querying with sql, including displaying average salaries of employees, listing employees meeting specific criteria, and emphasizing the importance of sql for aspiring data scientists, with sql being a crucial skill for data science roles.', 'chapters': [{'end': 1742.268, 'start': 1682.129, 'title': 'Query employees joined before 2000', 'summary': 'Explains how to write a query to list employees who joined before january 1, 2000, resulting in finding four employees hired before 2000, with some hired as early as 1984.', 'duration': 60.139, 'highlights': ['The query lists employees who joined before January 1, 2000, resulting in finding four employees hired before 2000, with some hired as early as 1984.', "The code uses a 'where' clause with the original hiring date to filter employees hired before the specified date.", 'The query output shows employees hired before 2000, with hire dates as early as 1984, 1987, 1994, and 1996.']}, {'end': 2329.65, 'start': 1742.268, 'title': 'Querying with sql', 'summary': 'Covers querying with sql, including displaying average salaries of employees, listing employees meeting specific criteria, and emphasizing the importance of sql for aspiring data scientists, with sql being a crucial skill for data science roles.', 'duration': 587.382, 'highlights': ['SQL is essential for aspiring data scientists, with it being a crucial skill for data science roles, mentioned in most job descriptions. SQL is crucial for aspiring data scientists, as it is a prerequisite in most job descriptions and is considered essential for data science roles.', 'Querying average salaries of employees in a specific department, such as surgeons, with the average salary of a surgeon being approximately $106,000. Demonstrates querying average salaries of employees in the surgeon department, revealing the average salary to be around $106,000.', 'Listing employees meeting specific salary criteria, such as those earning more than $3,000 after a 25% increment, showcasing the simplicity of SQL in performing complex tasks. Illustrates listing employees meeting specific salary criteria, such as those earning more than $3,000 after a 25% increment, showcasing the simplicity of SQL in performing complex tasks.', "Querying employees whose annual salary falls within a particular range, showcasing the use of the 'between' keyword and its output of employees within the specified range. Demonstrates querying employees whose annual salary falls within a particular range, utilizing the 'between' keyword to filter employees within the specified salary range."]}], 'duration': 647.521, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/sTiWTx0ifaM/pics/sTiWTx0ifaM1682129.jpg', 'highlights': ['SQL is crucial for aspiring data scientists, as it is a prerequisite in most job descriptions and is considered essential for data science roles.', 'Querying average salaries of employees in a specific department, such as surgeons, with the average salary of a surgeon being approximately $106,000.', 'Illustrates listing employees meeting specific salary criteria, such as those earning more than $3,000 after a 25% increment, showcasing the simplicity of SQL in performing complex tasks.', "Demonstrates querying employees whose annual salary falls within a particular range, utilizing the 'between' keyword to filter employees within the specified salary range.", 'The query lists employees who joined before January 1, 2000, resulting in finding four employees hired before 2000, with some hired as early as 1984.']}], 'highlights': ['SQL is crucial for aspiring data scientists, as it is a prerequisite in most job descriptions and is considered essential for data science roles.', 'The exponential growth of data is emphasized, with over 2.5 quintillion bytes of data generated daily, driving the need for methods and technologies like data science to handle and derive useful insights from this vast amount of data.', 'MySQL is highlighted for its ease of use, security features, open-source nature, and scalability to handle large databases up to 50 million rows or more.', "The 'create table' command is crucial for creating tables with different data variables and data types, emphasizing the importance of syntax and data type alignment for error-free table creation and management.", 'SQL is crucial for data science, enabling storage, access, and extraction of massive data, streamlining the process, and allowing for querying, search operations, and data manipulation.']}