Descriptions
Databases and SQL for Data Science with Python, Working knowledge of SQL (or Structured Query Language) is a must for data professionals like Data Scientists, Data Analysts and Data Engineers. Much of the world’s data resides in databases. SQL is a powerful language used for communicating with and extracting data from databases. In this course you will learn SQL inside out- from the very basics of Select statements to advanced concepts like JOINs. You will: -write foundational SQL statements like: SELECT, INSERT, UPDATE, and DELETE -filter result sets, use WHERE, COUNT, DISTINCT, and LIMIT clauses -differentiate between DML & DDL -CREATE, ALTER, DROP and load tables -use string patterns and ranges. Through hands-on labs and projects, you will practice building SQL queries, work with real databases on the Cloud, and use real data science tools. In the final project you’ll analyze multiple real-world datasets to demonstrate your skills.
What you’ll learn
- Analyze data within a database using SQL and Python.
- Create a relational database on Cloud and work with tables.
- Construct SQL statements including SELECT, INSERT, UPDATE, and DELETE.
- Compose more powerful queries with advanced SQL techniques like views, transactions, stored procedures and joins.
Specificatoin of Databases and SQL for Data Science with Python
- Publisher : Coursera
- Teacher : Rav Ahuja
- Language : English
- Level : Beginner
- Number of Course : 6
- Time frame to complete the course : 20 hours (approximately)
Content of Databases and SQL for Data Science with Python
Requirements
- No prior knowledge of databases, SQL, Python, or programming is required. Suitable for anyone who wants to gain key skillsin Data Science/Analytics.
Pictures
Sample Clip
Installation Guide
Extract the files and watch with your favorite player
Subtitle : English
Quality: 720p
The 2023/11 version has not changed in the number of lessons and duration compared to 2023/10.
Download Links
Password file(s): www.downloadly.ir
File size
194 MB