SQL Tutorial for Beginners | Stock Market Analysis скачать в хорошем качестве

SQL Tutorial for Beginners | Stock Market Analysis

In this 5th session of the 7-session Definitive Guide to Data Analytics series, we demonstrate some of the main parts of a SQL query by walking through an analysis of the impact of weather on stock market performance. After downloading the files at the link below, you should be able to follow along and build your own SQL queries and analysis alongside the video. Link to the Definitive Guide to Data Analytics - Session 5 (Introduction to SQL) page where you can download the files used: https://valuedrivenanalytics.com/sess... ______________________________________________ CHAPTERS: 0:00:00 Introduction to SQL 0:03:20 What are some ways analysts and data scientists use SQL? 0:10:24 How to launch Jupyter Notebook 0:16:10 How to use pandasql to write SQL against Pandas in Python 0:16:35 How to install a Python package from a Jupyter Notebook 0:20:30 How to write a SQL query 0:21:25 How to select all the columns in a table using SQL 0:24:35 How to select specific columns with spaces or special characters in the name 0:27:23 How to rename columns by adding an alias 0:29:15 How to sort data in SQL 0:31:45 How to add a where statement to a SQL query 0:40:00 What is an in statement in SQL 0:43:50 How to filter on null or missing values in SQL 0:45:30 How to use functions to create new columns in SQL 0:46:25 How to extract year, month, and day from a date in SQLite 0:49:45 How to write if logic using a case when statement in SQL 0:56:50 How to get distinct values in SQL 0:58:24 :How to aggregate in SQL 1:01:00 How to check for duplicate rows in a table in SQL 1:02:40 How to group data using a group by statement in SQL 1:13:13 How to join tables together in SQL ______________________________________________ ADDITIONAL VIDEOS YOU MAY LIKE: Please subscribe to get updates on the latest analytics training videos available! Whether you’re looking for training on technical skills or soft skills, whether you’re an aspiring analyst or an analytics executive, we have the perfect analytics training video for you! Check out our free training videos at https://valuedrivenanalytics.com/comp... ______________________________________________ ABOUT VALUE DRIVEN ANALYTICS: Value Driven Analytics is your source of rigorous, affordable, and fast analytics consulting and transformation. If you need an interactive dashboard, analysis, data science model build, automated data process, analytics or leadership training, analytics team management, analytics transformation, or 1-hour analytics consultation (troubleshooting, project advice, career advice), give us a call at 1-877-VAL-DRVN (1-877-825-3786) or learn more about our services at https://valuedrivenanalytics.com/serv... Stay connected with us! LinkedIn:   / value-driven-analytics   Twitter:   / vda_consulting   Facebook:   / 61550273999898   If you need help troubleshooting code, project advice, or personalized career advice, consider booking a 1-hour analytics consultation with me. You'll be amazed by what we can accomplish in just 1 hour! https://valuedrivenanalytics.com/hour... If your organization would like customized and more advanced analytics training, you can read more about the Value Driven Analytics analytics & leadership trainings offered here: https://valuedrivenanalytics.com/anal... ______________________________________________ KEYWORDS: sql,, sql tutorial, sql course, sql for beginners, learn sql, structured query language, sql course for beginners, free sql course, sql tutorial for beginners, sql full course, how to use sql, sql beginner tutorial, sql basics, how to learn sql, sql beginner, learn sql for beginners, learning sql, sql introduction, sequel, database, sql in python, pandasql, sql in pandas, sql basics, pandas sql, sql for beginners, sql tutorial sql course, sql crash course, sql beginners, sql programming, sql analysis, stock market analysis, weather analysis #SQL #SQLTutorial #SQLCourse #SQLforBeginners #LearnSQL #StructuredQueryLanguage #SQLCourseforBeginners #FreeSQLCourse #SQLTutorialforBeginners #SQLFullCourse #HowToUseSQL #SQLBeginnerTutorial #SQLBasics #HowToLearnSQL #SQLBeginner #LearnSQLforBeginners #LearningSQL #SQLIntroduction #Sequel #Database #SQLinPython #PandasQL #SQLinPandas #SQLBasics #SQLforBeginners #SQLTutorial #SQLCourse #SQLCrashCourse #SQLBeginners #SQLProgramming #SQLAnalysis #StockMarketAnalysis #WeatherAnalysis