Descriptions
Databases and SQL for Data Science with Python. Knowledge of SQL (or Structured Query Language) is a must for data professionals such as data scientists, data analysts, and data engineers. Much of the world’s data is in databases. SQL is a powerful language used to communicate with and extract data from databases. In this course, you will learn SQL from scratch – from the basics of select statements to advanced concepts like JOINs. You will: – write basic SQL statements such as: SELECT, INSERT, UPDATE, and DELETE – filter result sets, use WHERE, COUNT, DISTINCT, and LIMIT clauses – distinguish between DML and DDL – CREATE, ALTER, DROP, and load tables – use string patterns and ranges. In hands-on labs and projects, you will practice building SQL queries, work with real databases in the cloud, and use real data science tools. In the final project, you will analyze several real data sets to demonstrate your skills.
What you will learn
- Analyze data in a database using SQL and Python.
- Create a relational database in the cloud and work with tables.
- Create SQL statements including SELECT, INSERT, UPDATE and DELETE.
- Create more powerful queries using advanced SQL techniques such as views, transactions, stored procedures, and joins.
Specifying databases and SQL for data science with Python
- Publisher : Coursera
- Teacher: Rav Ahuja
- Language: English
- Level: Beginner
- Number of courses: 6
- Time frame to complete the course: 20 hours (approximately)
Database and SQL content for Data Science with Python
Requirements
- No prior knowledge of databases, SQL, Python or programming is required. Suitable for anyone who wants to acquire key skills in data science/analytics.
Pictures
Sample clip
installation Guide
Extract the files and watch them with your favorite player
Subtitles: English
Quality: 720p
The 2023/11 version has not changed in terms of the number of teaching hours and duration compared to 2023/10.
Download links
Password file(s): free download software
File size
194MB