|Beginner-Level SQL Nanodegree From Udacity|
|Written by Sue Gee|
|Tuesday, 16 June 2020|
Udacity has added SQL to the range of programming languages in which you can gain a Nanodegree and currently you can enroll in this program with a 30% discount.
According to research from Burning Glass from earlier this year, SQL heads the list of most-requested tech skills, with over twice as many employers looking for those with experience with SQL skills than with Python. Of course employers generally specify a range of skills that job applicants need - but it certainly looks as though adding SQL to your resume is a wise career move.
Aimed at beginners who might have the long-term aim of a career in data analysis, the 2-month SQL Nanodegree program is intended to enable its participants to:
It has two modules, each with a practical project to complete. The first module, Introduction to SQL has as its project Deforestation Exploration. In it:
you will act as a data analyst for an organization on a mission to reduce deforestation around the world and to raise awareness about this important environmental topic. First, you’ll clean any erroneous values in a table, join that table to another lookup table to bring in a new categorical and quantitative variable, and return a new view of all categories greater than a reference value. Then, you will create and execute SQL queries to perform calculations using variables from those disparate data sets to answer questions for stakeholders ... compile your answers and summarize your analysis into a report.
In the second module, Management of Relational & Non-Relational Databases, students will 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. They will also learn about MongoDB and Redis to get an understanding of the differences in behaviors and requirements for non-relational databases. Its project has the snappy title Udiddit, A Social News Aggregator and requires the student to create a new normalized database using DDL based on the denormalized one that is provided and to write DML queries to migrate the data from the denormalized schema to their normalized schema.
As this is only a two-month program it isn't eligible for the offer we reported in Udacity Offers Free Access To Nanodegree Programs, whereby students can have 30 days free access. Instead it has a 40% offer on 2 months access, allowing you to switch to the monthly price should you require more time. Or if you want to pay as you go, one month at a time there's a 30% discount. This is a limited time offer so enroll as soon as possible and you can start immediately.
Summer SALE Kindle 9.99 Paperback $10 off!!
or email your comment to: firstname.lastname@example.org
|Last Updated ( Wednesday, 16 September 2020 )|