Master SQL, the essential language for data analysis and insight-driven decision-making. This program covers SQL fundamentals, advanced querying, and database management. Learn to work with multiple tables, perform data aggregation and cleaning, use window functions, and optimize queries for large datasets. Apply your skills to real-world projects, analyzing deforestation data and redesigning databases. Gain proficiency in SQL for data analysis, database design, and management, preparing for roles requiring strong data manipulation and insight generation. Ideal for aspiring data analysts, business intelligence professionals, and those seeking to enhance their data querying and management skills.
Overview
Syllabus
- Welcome to the SQL Nanodegree Program
- Welcome to the SQL Nanodegree program! Learn more about the pre-requisites, structure of the program, and getting started!
- Introduction to SQL
- SQL is one of the most versatile tools available for extracting insights from stored data.
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, and 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 and 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.
Taught by
Malavica Sridhar, Ziad Saab and Derek Steer
Related Courses
Related articles
Reviews
4.8 rating, based on 5 Class Central reviews
4.6 rating at Udacity based on 288 ratings
-
My expectations were very well met by the end of the course.
I am happy to have pursued this no cheap program as it has helped me to have acquired many foundational and practical SQL skills I was looking for.
The course is well-structured and focused on practicing each new concept and SQL command easily.
Video explanation have a very appropriate short duration and by going to the point with good brief examples.
Final projects extent, its level of difficulty and of explanation are very well balanced to make challenging submissions but not so hard to take on the task with interest.
Two projects I did during the nanodegree were very helpful to put all SQL course content into practice. -
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.
Cheers! -
"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!
