Udacity sql project. Then Project Instructions Requirements Your goal is to select a cloud provider for each of the 4 required services - SQL server, S3 storage, web app and NoSQL database. Understand when and how to use subqueries, window functions as well as partitions to complete complex tasks. Practice joins, aggregates, partitions, and window functions while learning to clean data and optimize query performance. Feb 8, 2026 · Enroll in Udacity's Introduction to SQL course and learn the basics of SQL (Structured Query Language) with industry experts and hands-on projects. Your proficiency in data analysis is critical to helping the entire staff better understand their customers, inventory, invoices, and other information that keeps their store running smoothly. sql" files, are supposed to be run in the internal environment of the "SQL for Data Analysis" course. Apply your skills to real-world projects, analyzing deforestation data and Udacity SQL Nanodegree Program In this repo, it contains the projects I worked on for the SQL Nanodegree course on Udacity. png", and then run the SQL statements on it. You could also create a mock database, following the Entity Relationship Diagram (ERD) in "erd. Learn online with Udacity. Learn top tech skills with Udacity’s free courses. In this project, I worked with a relational database while working with SQL. Master SQL, the core language for data analysis and enable insight-driven decision-making and strategy for your business. Learn to determine, create, and execute SQL and NoSQL queries that manipulate and dissect large scale datasets. Apr 23, 2025 · Take Udacity's free SQL for Data Analysis course and learn to use Structured Query Language (SQL) to extract and analyze data stored in databases. Contribute to sukyee88/udacity-sql-project development by creating an account on GitHub. Once you select the appropriate cloud providers, you will need to research specific Terraform modules for your select service and add those modules to the provided Terraform scaffolding. For each directory, all of the required files for each course's project can be found in the directory. 💭 Aug 3, 2020 · Execute core SQL commands to define, select, manipulate, control access, aggregate and join data tables. How to interact with the project The sql statements, that are written in the ". Select PowerShell when prompted. You can restore the toy dataset "parch and posey" to your local machines from the file parch_and_posey_db using the following steps: Open Terminal. Enter PostgreSQL console - psql Create a new database - CREATE DATABASE parch_and_posey; Restore into Learn online and advance your career with courses in programming, data science, artificial intelligence, digital marketing, and more. SQL-Nanodegree (Udacity, 2020) Learning goals: Perform analysis on data stored in relational and non-relational database systems to power strategic decision-making. Completed the entire data analysis process, starting by posing a question, running appropriate SQL queries to answer questions, and finishing by sharing findings. This repository contains the quizzes along with their SQL commands for the concepts taught in the course SQL for Data Analysis by MODE at Udacity. This folder contains the scaffolding Terraform code to deploy your project. This program covers SQL fundamentals, advanced querying, and database management. Jun 4, 2020 · For this project, I’ll be querying the database to gain an understanding of the customer base, such as what are the patterns in movie watching are across different customer groups, how they compare on payment earnings, and how the stores compare in their performance. Gain in-demand technical skills. Join today!. Project Instructions Requirements Your goal is to select a cloud provider for each of the 4 required services - SQL server, S3 storage, web app and NoSQL database. Learn SQL. Explore Python, SQL, AI, product design, and data analysis through projects that build career readiness. Jun 27, 2025 · Take our SQL for Beginners course and learn how databases work including some basic SQL queries to select, manipulate and aggregate data in databases. Also don't forget to consider cost and flexibility of pricing options. Nov 4, 2025 · Master SQL for data analysis. Learn to work with multiple tables, perform data aggregation and cleaning, use window functions, and optimize queries for large datasets. Oct 4, 2019 · First SQL project for Udacity Nanodegree. The content of this Nanodegree program was updated and well-structured. Feb 8, 2026 · SQL Master SQL, the essential language for data analysis and insight-driven decision-making. Dec 25, 2025 · Yes, Udacity SQL Nanodegree is worth it for you if you are planning to change your career to Data Analytics and SQL. Each course is separated into directories. tak eyp rev csi sfl hct evu kfq boe onq mde hej lta xvt yxv