Databases and SQL for Data Science
День проведения: По запросу
Тип: Электронное обучение
Категория: Анализ данных
SQL is a powerful language which is used for communicating with databases. Before you step into the field of data science, it is vitally important that you set yourself apart by mastering the foundations of SQL. The purpose of this course is to introduce relational database concepts and help you learn and apply knowledge of the SQL language. Learners will also practice building and running SQL queries hands-on using a cloud-based environment as well as learn how to access databases from Jupyter notebooks using Python. If you choose to take this course and earn the Coursera course certificate, you will also earn an IBM digital badge upon successful completion of the course.
Кто может принять участие:
This course is designed for anyone interested in learning SQL, especially those who want to apply SQL for data science. Taking this course does not require any prior knowledge of SQL or databases.
Week 1 - Introduction to Databases and Basic SQL
In Week 1 you will be introduced to databases. You will create a database instance on the cloud. You will learn some of the basic SQL statements. You will also write and practice basic SQL hands-on on a live database.
Graded: Basic SQL
Week 2 - Advanced SQL
By the end of this module you will: (1) earn how to use string patterns and ranges to search data, how to sort and group data in result sets, as well as (2) learn how to work with multiple tables in a relational database using join operations.
Graded: String Patterns, Ranges, Sorting and Grouping
Graded: JOIN operations
Week 3 - Accessing Databases using Python
After completing the lessons in this week, you will learn how to explain the basic concepts related to using Python to connect to databases and then create tables, load data, query data using SQL and analyze data using Python
Graded: Database access from Python
Week 4: Course Assignment
As a hands-on Data Science assignment, you will be working with multiple real world datasets for the city of Chicago. You will be asked questions that will help you understand the data just like a data scientist would. You will be assessed both on the correctness of your SQL queries and results.
Graded: Peer Reviewed Assignment
Taught by: Rav Ahuja, Data Science Program Manager
IBM Cognitive Class
Taught by: Hima Vasudevan, Data Scientist
IBM Digital Business Group
УчастиеКрайний срок регистрации 10 Май 2020
To participate in this training, you can Enroll
Поделись с друзьями
Информация об учебном центре
Тип компании: Другое
Количество сотрудников: 500-1500
Every course on Coursera is taught by top instructors from the world’s best universities and educational institutions. Courses include recorded video lectures, auto-graded and peer-reviewed assignments, and community discussion forums. When you complete a course, you’ll receive a sharable electronic Course Certificate.
- Online and open to everyone
- Learn a new skill in 4-6 weeks
- Priced at about $29-$99
- Earn a Course Certificate
Coursera was founded in 2012 by two Stanford Computer Science professors who wanted to share their knowledge and skills with the world. Professors Daphne Koller and Andrew Ng put their courses online for anyone to take - and taught more learners in a few months than they could have in an entire lifetime in the classroom. Since then, we’ve built a platform where anyone, anywhere can learn and earn credentials from the world’s top universities and education providers.
If you want to master a specific career skill, consider joining a Specialization. You’ll complete a series of rigorous courses, tackle hands-on projects based on real business challenges, and earn a Specialization Certificate to share with your professional network and potential employers.
- Online and open to everyone
- Learn a new skill in 4-6 months
- Priced at $39-$79 per month
- Earn a Specialization Certificate
Real career transformation sometimes requires a university-recognized degree. Coursera believes that transformation should be accessible to everyone, so we’ve worked with our university partners to offer flexible, affordable online degree programs in business, computer science, and data science.
- All online - admission required
- 1-3 years of study
- Currently priced at $15-$25,000
- Earn an accredited master’s degree