Data Engineering
Showing 637–648 of 829 results
Querying JSON, XML, and Temporal Data with T-SQL
The most common scenario with SQL Server is querying structured data. But many do not know that it also allows storing and querying semi-structured data using XML and JSON; as well as obtaining values from any point in time with temporal tables.
Real-time Web Server Log Analysis with SQL Server
Dive into the world of real-time data with SQL Server. This course will teach you how to configure, analyze, and visualize live web server logs for actionable insights.
Real-world Applications of Hierarchical Queries in SQL Server
Learn real-world applications of hierarchical queries. This course will teach you to manage organization charts using hierarchical queries in SQL Server.
Real-world Scenarios: SQL Server Query Tuning in Action
Unlock the secrets of SQL Server optimization with this course. This course will teach you to optimize databases, master query tuning, and solve real-world performance issues, ensuring efficient SQL Server management.
Real-world Scenarios: Utilizing Triggers in SQL Server
Triggers are awesome. This course will teach you how to make use of Triggers effectively and use them like a pro in your real-world projects.
Realizing Benefits and Reviewing Effectiveness of a GEIT Implementation
In this course, you'll have the opportunity to review essential knowledge on IT Governance and learn what are the challenges, recommended tasks, roles and responsibilities to realizing benefits, and reviewing the effectiveness of a GEIT program.
Recording and Managing Excel 2016 Macros
In this course, Recording and Managing Excel 2016 Macros, we will learn how to develop and edit macros in Excel, which will help us automate a whole host of tedious and time-consuming tasks.
Relational Database Design
This course is for anyone who wants to understand relational database design, or data modeling in general. You will learn how to gather requirements, model them, normalize the model, and transform that model into a fully normalized relational database design.
Relational Database Management System (HP2J48)
In today's data-driven world, proficiency in RDBMS and SQL is highly sought after across industries. Whether you're in technology, finance, healthcare, or any other field, the...
Relational Databases: The Big Picture
In this course, you’ll learn about the core functions and practical use cases for relational databases.
Reporting in SQL
Learn how to build your own SQL reports and dashboards, plus hone your data exploration, cleaning, and validation skills.
Reshaping Data with tidyr
Transform almost any dataset into a tidy format to make analysis easier.