Be taught SQL Fundamentals for Knowledge Science Specialization

WHAT YOU WILL LEARN

• U​se SQL instructions to filter, type, & summarize knowledge; manipulate strings, dates, & numerical knowledge from totally different sources for evaluation

• A​ssess and create datasets to unravel your small business questions and issues utilizing SQL

• U​se the collaborative Databricks workspace and create an end-to-end pipeline that reads knowledge, transforms it, and saves the consequence

• ​Develop a venture proposal & choose your knowledge, carry out statistical evaluation & develop metrics, and p​resent your findings & make suggestions

---

SKILLS YOU WILL GAIN

• Knowledge Evaluation
• Apache Spark
• Delta Lake
• SQL
• Knowledge Science
• Sqlite
• A/B Testing
• Question String
• Predictive Analytics
• Presentation Abilities
• creating metrics
• Exploratory Knowledge Evaluation

About this Specialization

This Specialization is meant for a learner with no earlier coding expertise looking for to develop SQL question fluency. By 4 progressively tougher SQL tasks with knowledge science purposes, you’ll cowl matters equivalent to SQL fundamentals, knowledge wrangling, SQL evaluation, AB testing, distributed computing utilizing Apache Spark, Delta Lake and extra. These matters will put together you to use SQL creatively to research and discover knowledge; show effectivity in writing queries; create knowledge evaluation datasets; conduct function engineering, use SQL with different knowledge evaluation and machine studying toolsets; and use SQL with unstructured knowledge units.