its correct functionality and cannot be turned off. Optional cookies are used to improve the page with analytics, by
Contact Us Below to Learn More about our Enterprise Solutions
Master SQL, the core language for Big Data analysis, and enable insight-driven decision-making and strategy for your business.
At 10 hrs/week
Basic understanding of data types
Perform analysis on data stored in relational and non-relational database systems to power strategic decision-making. Learn to determine, create, and execute SQL and NoSQL queries that manipulate and dissect large scale datasets. Begin by leveraging the power of SQL commands, functions, and data cleaning methodologies to join, aggregate, and clean tables, as well as complete performance tune analysis to provide strategic business recommendations. Finally, apply relational database management techniques to normalize data schemas in order to build the supporting data structures for a social news aggregator.
In this project, 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.
Udiddit, A Social News Aggregator
In this project, you will build the supporting data structures for Udiddit, a social media news aggregator site. First, you’ll investigate the provided data model for potential errors such as lack of normalization, consistency rules, and proper indexing. Then, you will create a new, normalized database using DDL based on the denormalized one that is provided. Lastly, you will write DML queries to migrate the data from the denormalized schema to their normalized schema.