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.

udacityLogoNew

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.

sqltop

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:

  • Determine, create, and execute SQL and NoSQL queries to extract insights from relational and non-relational databases, respectively
  • Leverage the power of SQL commands, functions, and data cleaning methodologies to provide strategic business recommendations
  • Complete performance tuning to enhance the speed and outcomes of your data analysis
  • Apply relational database management techniques to normalize data schemas

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.

sqltpic

 

More Information

SQL Nanodegree program

Udacity Program Catalog

Related Articles

Udacity Offers Free Access To Nanodegree Programs

New Udacity Web Developer Nanodegrees

Hiring Landscape Under Scrutiny

The Benefits of A Udacity Nanodegree 

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on, Twitter, Facebook or Linkedin.

 

Banner


npm 7 Will Ship With Node.js 15
19/10/2020

The next version of npm, v7, has been completed and will be shipping with Node.js v15 this week. The new release adds several features requested by developers including support for Workspaces.



Python 3.9 Improves Dictionary Handling
07/10/2020

Python has been updated with a new release that improves dictionary handling and adds new string methods.


More News

square

 



 

Comments




or email your comment to: comments@i-programmer.info

 

 

Last Updated ( Wednesday, 16 September 2020 )