Databases
Showing 181–192 of 209 results
SQL Server 2014: T-SQL Fundamentals
This Free Online Course Includes: 4-5 Hours of Learning CPD Accreditation Final Assessment
SQL Server 2014: Tour and Installing
This Free Online Course Includes: 4-5 Hours of Learning CPD Accreditation Final Assessment
SQL Server Core 2016
This Free Online Course Includes: 4-5 Hours of Learning CPD Accreditation Final Assessment
SQL Server Reporting Services Playbook
Looking to generate and share reports with your organization? In this course you'll get up and running with SQL Server Reporting Services quickly, or just refresh yourself on specific techniques when creating reports.
SQL Server: Transact-SQL Basic Data Retrieval
Learn how to construct SELECT statements to retrieve data from SQL Server databases, applicable for developers from SQL Server 2005 onwards
T-SQL Data Manipulation Playbook
Querying is one of the most common operations when working with a database. But to query, you need data. This training covers how to insert, update, and delete data in your Microsoft SQL Server database using T-SQL Data Manipulation Language, or DML.
T-SQL Functions Playbook
In this course you will explore the functions of the T-SQL language that support data access, manipulation, aggregation, and analysis. Completing this course will provide you with the skills to shape and analyze data in SQL Server.
The Data Lifecycle: Following Data from Creation to Insight
Explore the journey of data from creation to insightful analysis. Learn essential skills in data collection, cleaning, storage, and interpretation, equipping you to make informed, data-driven decisions effectively.
Tune queries in Azure Database for PostgreSQL
Database management systems (DBMSs) need systems to understand the data and the queries that are running against this data. It's important to understand how performance tuning works and how you can assess performance metrics.
Tuning SSAS Models
This course explains the tools and techniques that you need to diagnose why multidimensional and tabular queries might be performing slowly and demonstrates the actions you can take to improve query performance.
Understand client-server communication in MySQL
Learn about connection handling in MySQL, back up and restore, and the client interface options available for MySQL.
Understand client-server communication in PostgreSQL
PostgreSQL is a client-server system, which allows many clients to connect to a central server. In this module, you learn how PostgreSQL manages connections from clients, and look at some common PostgreSQL client tools.