Skills Covered: SQL, PostgreSQL, JOINs, Subqueries, Window Functions, Partitions, Data Cleaning, DDL, DML, Relational and Non-Relational Databases
ABOUT THIS NANODEGREE
The course is kind of an introduction to SQL with SQL commands, control access, and data/data tables. The program consists of two sections. Each of them is broken further into modules.
The course will definitely build up your skills – you will learn fundamental SQL commands, you will use manipulating data tables and structures. A great thing often appreciated by students is the ability to clean and optimize data using SQL. You will understand the power of SQL and it will be easy for you to pull insights from relational databases. You will also get familiar with non-relational databases like MongoDB and Redis. After completing the Learn SQL course, you should have the skills necessary to work as a Data Analyst, Product Analyst, Business Analyst, Software Engineer, etc.
The course takes around 2 months to complete. There is no specific prerequisite knowledge, however, a basic understanding of data types will be beneficial.