Acerca de este curso: Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. A working knowledge of databases and SQL is a must if you want to become a data scientist. The purpose of this course is to introduce relational database concepts and help you learn and apply knowledge of the SQL language. It is also intended to get you started with performing SQL access in a data science environment. The emphasis in this course is on hands-on and practical learning . As such, you will work with real databases, real data science tools, and real-world datasets. You will create a database instance in the cloud. Through a series of hands-on labs you will practice building and running SQL queries. You will also learn how to access databases from Jupyter notebooks using SQL and Python. No prior knowledge of databases, SQL, Python, or programming is required. Anyone can audit this course at no-charge. If you choose to take this course and earn the Coursera course certificate, you can also earn an IBM digital badge upon successful completion of the course. LIMITED TIME OFFER: Subscription is only $39 USD per month for access to graded materials and a certificate.
Para quién es esta clase: This course is designed for anyone interested in learning SQL, especially those who want to apply SQL for data science. Therefore it is ideal for those aspiring to become data scientists. It is also suitable for those who want to become data analysts, data engineers, database administrators, or a database developers. This course is for beginners in SQL and Data Science. It does not require any prior knowledge of SQL, databases, Python, or programming.
Enseñado por: Rav Ahuja, Data Science Program Manager
IBM
| Información básica | Curso 5 de 9 en IBM Data Science Professional Certificate Specialization |
| Nivel | Principiante |
| Compromiso | 3-4 weeks of study, 2-4 hours/week. |
| Idioma | English |
| Requerimientos de hardware | Only browser access is required. Access to cloud based environment will be provided for hands-on labs. |
| Cómo aprobar | Aprueba todas las tareas calificadas para completar el curso. |
| Calificaciones del usuario |
- Vídeo: Introduction to Databases
- Vídeo: How to create a Database instance on Cloud?
- Leitura: Hands-on LAB: Provision a Cloud hosted Database instance
- Vídeo: CREATE Table Statement
- Vídeo: SELECT Statement
- Leitura: Count, Distinct, Limit
- Vídeo: INSERT Statement
- Vídeo: UPDATE and DELETE Statements
- Leitura: Hands-on LAB: Composing and Running basic SQL queries
- Leitura: About this Optional lesson
- Vídeo: Information and Data Models
- Vídeo: Types of Relationships
- Vídeo: Mapping Entities to Tables
- Vídeo: Relational Model Concepts
- Leitura: Additional Reading
- Teste para praticar: Practice Quiz: Review of Relational Database Concepts
- Teste para praticar: Optional Not Graded Quiz on Relational Concepts
- Vídeo: Sorting Result Sets
- Vídeo: Grouping Result Sets
- Leitura: Hands-on LAB: String Patterns, Sorting & Grouping
- Vídeo: Join Overview
- Vídeo: Inner Join
- Vídeo: Left Outer Join
- Vídeo: Right Outer Join
- Vídeo: Full Outer Join
- Leitura: Hands-on LAB: JOINs
- Leitura: About this Optional lesson
- Vídeo: Relational Model Constraints
- Vídeo: Relational Model Constraints - Advanced
- Leitura: Additional Information on Keys and Constraints
- Teste para praticar: Practice Quiz: Review of Database Constraints
- Teste para praticar: Optional Not Graded Quiz on Constraints
- Vídeo: Writing code using DB-API
- Vídeo: Connecting to a database using ibm_db API
- Item de LTI: Hands-on LAB 1: Connecting to a database instance
- Vídeo: Creating tables, loading data and querying data
- Item de LTI: Hands-on LAB 2: Creating tables, inserting and querying Data
- Item de LTI: Hands-on Tutorial: Accessing databases with SQL magic
- Vídeo: Analyzing data with Python
- Item de LTI: Hands-on LAB 3: Analyzing a real world data set
- Leitura: Working with real-world data sets
- Leitura: Built-in Functions, Dates, Timestamps
- Item de LTI: Hands-on Lab 1: Querying real world datasets
- Item de LTI: Jupyter notebook with problems for Peer Reviewed Assignment
- Leitura: IBM Digital Badge
Cada curso é como um livro didático interativo, com vídeos pré-gravados, testes e projetos.
Conecte-se com milhares de outros aprendizes, debata ideias, discuta sobre os materiais do curso e obtenha ajuda para dominar conceitos.
Obtenha reconhecimento oficial pelo seu trabalho e compartilhe seu sucesso com amigos, colegas e empregadores.
| Comprar curso | |
|---|---|
| Accede a los materiales del curso | Disponible |
| Accede a los materiales con calificación | Disponible |
| Recibe una calificación final | Disponible |
| Obtén un Certificado de curso para compartir | Disponible |
great course, great tools
Apart from errors in the open source tools for the hands on labs, this course is fantastic and well crafted to introduce Databases and SQL. the optional sections are useful for those without good grasp of knowledge about databases and their types. make sure to take them. The labs are good, but always there is connection problems. If they will fix this, it will be one of the best introduction courses out there.
Perfect course to step into Data Science field!!!!
very fun! and it's easy to study with those modules provided :)