Explore performance-based design
|
Explore normalization for relational databases. Investigate the impact of proper datatype usage. Compare types of indexes.
Explore normal forms and how they affect database design, Choose appropriate datatypes for your data, Evaluate appropriate index types
Prerequisites
Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based.
Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
Basic understanding of structure and usage of SQL Server indexes.
Basic understanding of relational database concepts.
User Reviews
Be the first to review “Explore performance-based design”
Related Products
Data Scientist: Inference Specialist
Inference Data Scientists run A/B tests, do root-cause analysis, and conduct experiments. They use Python, SQL, and R to analyze data.
Business Intelligence Analytics
Gain insights into business intelligence tools and analytics techniques to optimize decision-making.
Firebase Analytics: iOS
Explore Firebase Analytics integration for iOS apps to analyze user behavior and app performance.
Learn Python for Data Science
Get started with Python for Data Science in this beginner-friendly skill path.
Real-Time Analytics with Apache Storm
Study the use of Apache Storm for processing real-time data streams and generating insights on-the-fly.
Discovering Predictive Analytics with Alteryx
Explore predictive analytics techniques and tools using Alteryx to forecast future trends based on historical data.
There are no reviews yet.