MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Genre: eLearning | Language: English | Duration: 38 lectures (7h 42m) | Size: 7.6 GB Master SQL for Job Interview Preparation, Data Analysis and Data Science
What you'll learn: Use of SQL in data science Understanding the databases Querying a database to create the table Aggregating the data using count, min etc. functions Different joins in SQL Inserting, updating and deleting Requirements No prerequisites, you will learn everything in the course. Description This SQL for data science course will introduce you to concepts of Structured Query Language (SQL), Databases, DBMS, etc. with practical demonstrations, so that you not only understand the concepts but also master it practically. The course is designed for beginners to SQL and database management systems. This SQL for Data Science course will help you understand how SQL can be used to store, access and retrieve data to perform data analysis. It is becoming ever more important that companies make data-driven decisions. With big data and data science on the rise, we have more data than we know what to do with. One of the basic languages of data analytics is SQL, which is used for many popular databases including MySQL, Postgres, SQLite, Microsoft SQL Server, Oracle, and even big data solutions like Hive and Cassandra. I'm going to let you in on a little secret. Most high-level marketers and product managers at big tech companies know how to manipulate data to gain important insights. No longer do you have to wait around the entire day for some software engineer to answer your questions - now you can find the answers directly, by yourself, using SQL! Topics covered in this course: What is a Database Installing Postgres Creating Tables SELECT Statement WHERE Clause AND & OR Filtering Operators ORDER BY LIMIT DISTINCT Renaming Columns Functions GROUP BY & HAVING Clauses Aggregation Queries Subqueries CASE Clause Correlated Subqueries Table Joins INNER and OUTER Joins UNION, UNION ALL and EXCEPT Clauses Who this course is for People willing to dive into data science field Homepage