В любой момент
2 месяца
Стоимость курса
399 USD
Подробности и регистрация

Learn SQL

Навыки, которые вы получите:
Databases SQL

Master SQL, the core language for Big Data analysis, and enable insight-driven decision-making and strategy for your business.

Necessary preparation

  • Familiarity with Operating systems (Windows and MacOS).
  • Familiarity and comfort using word processing programs (Microsoft Word, Google Docs, PDF).
  • Comfortable using presentation software (PowerPoint, Keynote, Google Slides).
  • Comfortable using Spreadsheet programs (Microsoft Excel, Google Spreadsheets).
  • Comfortable identifying the type of data held in a data table.

For those who want to

  • Master SQL.
  • Make decisions based on analysis.

The Program 

  1. Introduction to SQL.
  2. PROJECT  -Deforestation Exploration.
  3. Management of Relational & Non-Relational Databases.
  4. PROJECT — Udiddit, A Social News Aggregator.

What will you learn

  • How to execute core SQL commands to define.
  • Select, manipulate, control access, aggregate and join data and data tables. 
  • Understand when and how to use subqueries, several window functions, as well as partitions to complete complex tasks.
  •  Clean data, optimize SQL queries, and write select advanced JOINs to enhance analysis performance. 
  • Explain which cases you would want to use particular SQL commands, and apply the results from queries to address business problems.
  • Build normalized, consistent, and performant relational data models.
  • Use SQL Database Definition Language (DDL) to create the data schemas designed in Postgres and apply SQL Database Manipulation Language (DML) to migrate data from a denormalized schema to a normalized one.
  • Understand the tradeoffs between relational databases and their non-relational counterparts, and justify which one is best for different scenarios.
  • Learn about MongoDB and Redis to get an understanding of the differences in behaviors and requirements for non-relational databases.
Нам нужен ваш фидбек!
Честный и беспристрастный