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


Microsoft Introduces SharePoint Embedded VSCode Extension
22/02/2024

Microsoft has released a preview version of a SharePoint Embedded Visual Studio Code extension, describing it as a new tool for developers who want to get started with SharePoint Embedded application  [ ... ]



pgxman - PostgreSQL Extension Manager
19/02/2024

pgxman is a package manager like npm, but instead of Javascript packages, it is for PostgreSQL extensions. It detects and streamlines extension operations and looks after dependency manageme [ ... ]


More News

raspberry pi books

 

Comments




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

 

 

Last Updated ( Wednesday, 16 September 2020 )