SQL
Showing 85–96 of 126 results
Microsoft: Querying Data with Transact-SQL
From querying and modifying data in SQL Server or Azure SQL to programming with Transact-SQL, learn essential skills that employers need.
Optimize Data Manipulation Performance in SQL Server
Boost your SQL Server efficiency. This course will teach you advanced indexing, query tuning, and concurrency control.
Optimizing Query Performance with Columnstore Indexes
Have you considered creating columnstore indexes to defeat slow queries? Well, this course is for you! Take your skills to the next level by learning how columnstore indexes can boost performance in today's busy database environment.
Optimizing SQL Server Procedures: Best Practices and Performance
Manipulating the data from SQL Server is something that every data professional should know. However, manipulating the SQL Server data by using stored procedures in an efficient and performant way is a mastery on its own!
Oracle PL/SQL Fundamentals – Part 1
Get coding quickly and effectively with Oracle PL/SQL, Oracle's database development language. This course is the first of a two part series, covering the essentials and fundamentals of Oracle PL/SQL.
Oracle PL/SQL Fundamentals – Part 2
In this course, we will take an in-depth look at Procedures, Functions, and Packages. These named program units are powerful programming constructs which can greatly enhance and optimize your code.
Oracle: Oracle Autonomous Database Administration Workshop
Learn the fundamentals of Autonomous databases and take your DBA skills knowledge to the next level and learn to deploy and administer Autonomous databases. Explore planning, implementing, and deploying an Oracle Autonomous Database, the first and only autonomous database service in the cloud.In this module you will learn how to create applications on Autonomous Database using SQL, APEX, and Oracle Machine Learning.
Predictive Analysis with SQL Server
Learn to leverage predictive models and methods directly in SQL Server. This course will demonstrate the capabilities of SQL Server related to predictive analytics, including best practices and optimizations.
Querying Data with SQL Server
In this course, you’ll learn essential skills that are needed to become proficient in querying data using T-SQL including logical query execution, creating single table queries to filter and aggregate data, and combining data from multiple 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.