With the SQL Nanodegree program, you will be equipped to know when to utilize SQL to provide data-backed insights into complex business strategies. With Udacity, you will get an in-depth instruction on how to leverage the power of SQL to pull insights from relational databases and learn the situational differences of using relational databases versus non-relational databases like MongoDB and Redis. You won’t just learn how to use SQL, you will get hands-on experience with projects, including building a clone of the popular social news aggregation and discussion web site, Reddit! In fact, there are currently over 440,000 jobs that mention SQL on LinkedIn worldwide, which encompasses the broad range of roles that require knowledge of SQL, including titles like product analyst, data analyst, data scientist, business analyst, product manager, software engineer, and more! Master SQL, the core language for Big Data analysis, and enable insight-driven decision-making and strategy for your business.
Basic understanding of data types (e.g., string, integer, etc.) See detailed requirements.
Introduction to SQL
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.
Management of Relational & Non-Relational Databases
Databases need to be structured properly to enable efficient and effective querying and analysis of data. 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. With a radical shift of paradigms, learn about MongoDB and Redis to get an understanding of the differences in behaviors and requirements for non-relational databases.
I must say that I have enjoyed the first part of this course. It is concise, straight to the point and covers major SQL concepts. So far, I have loved how the teachers of the course use real life instances to further help us grasp these SQL concepts making it easier to learn.
I look forward to learning so much more in the second part of this course.
"The program is going to fantastic but it needs your attention and study plan. My expectation from the course was awesome, mentors are always there to response of any difficulties with the course. So, I could say I got an employable skill from Udacity. Thank you."
I have really enjoyed the program, I like the videos and different teachers. I have learned something different from each of them. I have some experience with SQL and never understood joins until now. It has exceeded my expectations.
I feel really confident about the knowledge that I gained. This meaning that the course is good. Thank you guys for the work you are putting in here. It means a lot to me to be able to learn new skills!