SQL Server (Online Courses)
Elevate your career trajectory with our premier online course, designed to sharpen your competitive edge. Explore our curated selection of top-tier digital programs to hone your skills and propel your professional journey forward. Experience transformative learning tailored to empower your career advancement in today's dynamic landscape.
Price on Request
Start Learning
This Course Includes
-
48 hours 25 minutesof self-paced video lessons -
47 Programscrafting your path to success -
Completion Certificateawarded on course completion
Advanced SQL Queries
Price on Request
1 hour 25 minutes
Master advanced queries. Queries in SQL allow you to manipulate databases like a pro. Discover advanced techniques including subqueries, correlated queries, difficult queries, and learn query tips for better efficiency.
Perks of Course
Certificate: Yes
CPD Points: 84
Compliance Standards: AICC
Backup & Recovery Strategies
Price on Request
50 minutes
From an individual to the largest organization, it is crucial that you always back up your data. Discover SQL Server 2014 backup strategies, how to perform a backup, and how to create and maintain a disaster recovery plan.
Perks of Course
Certificate: Yes
CPD Points: 48
Compliance Standards: AICC
Clustering & AlwaysOn
Price on Request
1 hour 30 minutes
SQL Server AlwaysOn Availability Groups are built on WSFC clusters and AlwaysOn Failover Cluster Instances (FCI). Discover how to create, configure, and manage SQL Server AlwaysOn FCIs and AlwaysOn Availability Groups.
Perks of Course
Certificate: Yes
CPD Points: 89
Compliance Standards: AICC
Creating Tabular Data Models
Price on Request
1 hour 20 minutes
Tabular modeling in SQL Server Analysis Services (SSAS) provides fast performance for users. Discover how to implement tabular models in SSAS, including how to create and manage the tables, and how to manage security and backups.
Perks of Course
Certificate: Yes
CPD Points: 78
Compliance Standards: AICC
Design & Install Analysis Services
Price on Request
1 hour 5 minutes
SQL Server Analysis Services (SSAS) lets you use different models to analyze large amounts of data. Explore the benefits each model provides, and how to install and configure SSAS.
Perks of Course
Certificate: Yes
CPD Points: 63
Compliance Standards: AICC
Design & Install Analysis Tools
Price on Request
30 minutes
There are other tools that can be used in conjunction with SQL Server Analysis Services (SSAS). Learn how to install and work with SQL Server Data Tools - Business Intelligence, and how to deploy SQL Server Management Studio.
Perks of Course
Certificate: Yes
CPD Points: 32
Compliance Standards: AICC
Designing Dimensions
Price on Request
1 hour
In SQL Server Analysis Services (SSAS), a dimension is a collection of related objects used to provide the fact data to one or more cubes. Learn how to create dimensions, and how to configure relationships, hierarchies, and attributes.
Perks of Course
Certificate: Yes
CPD Points: 58
Compliance Standards: AICC
Designing Multidimensional Data Sources
Price on Request
1 hour 10 minutes
SQL Server Analysis Services (SSAS) multidimensional models contain objects called cubes, dimensions, and measures. Discover how to design these objects, and create new projects.
Perks of Course
Certificate: Yes
CPD Points: 72
Compliance Standards: AICC
Designing Multidimensional Models
Price on Request
30 minutes
SQL Server Analysis Services (SSAS) uses multidimensional models to analyze large amounts of data. Let's examine the logical and cube architectures of multidimensional models, and how to create data sources.
Perks of Course
Certificate: Yes
CPD Points: 30
Compliance Standards: AICC
Designing Reports & Creating Data Sources
Price on Request
1 hour 10 minutes
You can access SQL Server Reporting Services (SSRS) reports from a variety of sources. Learn how to install and configure the Reporting Services topologies, plan and create reports, and create the data sources for data retrieval.
Perks of Course
Certificate: Yes
CPD Points: 71
Compliance Standards: AICC
Designing Reports & Creating Datasets
Price on Request
35 minutes
To create a SQL Server Reporting Services (SSRS) report, you retrieve the data from a data source into a dataset. Explore different methods of dataset creation, including using stored procedures, and MDX and DAX queries.
Perks of Course
Certificate: Yes
CPD Points: 34
Compliance Standards: AICC
High Availability
Price on Request
45 minutes
High availability is a critical requirement of Oracle RAC. Explore the configuration of client and server components to ensure high availability in RAC database connections.
Perks of Course
Certificate: Yes
CPD Points: 43
Compliance Standards: AICC
High Availability
Price on Request
45 minutes
High availability isn't just a "nice to have" concept; it's absolutely critical. Expand your ability to scale web apps to ensure Azure services are always available and perform optimally.
Perks of Course
Certificate: Yes
CPD Points: 46
Compliance Standards: AICC
High Availability
Price on Request
1 hour 30 minutes
Windows Azure lets you configure and manage a dedicated VM to run an instance of SQL Server. Discover VMs on Windows Azure; how to install, configure and manage SQL Sever on a VM; and high availability options in SQL Server 2014.
Perks of Course
Certificate: Yes
CPD Points: 92
Compliance Standards: AICC
Implementation, Creation, & Troubleshooting
Price on Request
1 hour 25 minutes
Microsoft SQL Server 2014 has new features added to help optimize performance. Discover In-Memory OLTP, how to write scripts to automate backups to the cloud, and how to design and create database and programming objects.
Perks of Course
Certificate: Yes
CPD Points: 84
Compliance Standards: AICC
Implementing & Configuring Cubes
Price on Request
1 hour 25 minutes
A SQL Server Analysis Services (SSAS) cube contains the information required to perform analysis on the data. Learn how to create cubes, measures, measure groups, and other elements including perspectives, hierarchies, and relationships.
Perks of Course
Certificate: Yes
CPD Points: 85
Compliance Standards: AICC
Implementing & Testing Policy
Price on Request
45 minutes
When planning a SQL Server infrastructure, you must include the management of all instances of SQL Server. Discover how to implement policy-based management and how to manage SQL Server using System Center.
Perks of Course
Certificate: Yes
CPD Points: 44
Compliance Standards: AICC
Implementing Custom Logic
Price on Request
50 minutes
Attain better data aggregation and results for the user in SQL Server Analysis Services (SSAS). Learn how with custom logic implementation into a multidimensional model using calculated members, time intelligence, and named sets.
Perks of Course
Certificate: Yes
CPD Points: 50
Compliance Standards: AICC
Implementing Dimensions
Price on Request
1 hour 30 minutes
A SQL Server Analysis Services (SSAS) cube includes measures and measure groups. Explore measures, including how to create and configure them for use in a cube.
Perks of Course
Certificate: Yes
CPD Points: 49
Compliance Standards: AICC
Implementing Partitions
Price on Request
1 hour 15 minutes
In SQL Server Analysis Services (SSAS), partitions are used to provide the physical storage for the fact data in a measure group. Discover how to design, create, and work with both local and remote partitions.
Perks of Course
Certificate: Yes
CPD Points: 75
Compliance Standards: AICC
Managing & Maintaining SSAS
Price on Request
1 hour 10 minutes
Once up and running, the SQL Server Analysis Services (SSAS) multidimensional models and the SSAS databases must be maintained. Learn how to analyze and tune performance, and troubleshoot data analysis issues.
Perks of Course
Certificate: Yes
CPD Points: 68
Compliance Standards: AICC
Managing Reporting Services
Price on Request
1 hour 20 minutes
For optimal performance and security, you must maintain and monitor SQL Server Reporting Services. Learn how to manage the Report Server, including troubleshooting, and performance tuning, and how to configure security.
Perks of Course
Certificate: Yes
CPD Points: 80
Compliance Standards: AICC
Managing Tabular Data Models
Price on Request
1 hour 5 minutes
Tabular modeling in SQL Server Analysis Services (SSAS) lets users access data using DAX queries. Learn how to create calculations and DAX queries, and how to create and manage partitions in a tabular model.
Perks of Course
Certificate: Yes
CPD Points: 64
Compliance Standards: AICC
MDX Queries & Database Deployment
Price on Request
1 hour 15 minutes
Users can query data in dimensions, cubes, and measures using Multidimensional Expressions, MDX. Discover how to create queries using MDX on multidimensional models.
Perks of Course
Certificate: Yes
CPD Points: 75
Compliance Standards: AICC
Multiple SQL Tables
Price on Request
1 hour 20 minutes
Work with multiple tables. Mastering the fundamentals of SQL creates a foundation. Explore multi-table database architecture and design, connecting several tables, using inner/outer joins, and equijoins and non-equijoins.
Perks of Course
Certificate: Yes
CPD Points: 80
Compliance Standards: AICC
Optimization & Troubleshooting
Price on Request
35 minutes
Microsoft SQL Server 2014 includes new features to provide optimal performance for applications. Discover some of these features and see how to optimize both queries and overall security in SQL Server 2014.
Perks of Course
Certificate: Yes
CPD Points: 34
Compliance Standards: AICC
Planning Infrastructure
Price on Request
1 hour 40 minutes
A SQL Server infrastructure must be planned from the hardware up. Discover how to plan both the physical and logical database structures using the Microsoft Planning and Assessment Toolkit.
Perks of Course
Certificate: Yes
CPD Points: 102
Compliance Standards: AICC
Private Cloud Overview
Price on Request
35 minutes
SQL Server 2014 has a number of enhancements and features aimed at private cloud deployment and management of SQL databases. Explore SQL Server consolidation and management of consolidated resources.
Perks of Course
Certificate: Yes
CPD Points: 34
Compliance Standards: AICC
Private Cloud Planning & Implementation
Price on Request
1 hour 10 minutes
SQL Server 2014 includes features for private cloud deployment and management of SQL databases. Explore cloud computing, configuring SQL in a private cloud configuration, and working with prepared instances of SQL Server.
Perks of Course
Certificate: Yes
CPD Points: 68
Compliance Standards: AICC
Process Models & Database Deployment
Price on Request
55 minutes
After creation, multidimensional models need to be processed and the databases deployed for users to access them. Examine what is involved in processing data models and deploying SSAS databases.
Perks of Course
Certificate: Yes
CPD Points: 54
Compliance Standards: AICC
Processing Reports & Creating Subscriptions and Schedules
Price on Request
1 hour
For a SQL Server Reporting Services report to be useful, the data must be up-to-date. Explore different ways to process and view reports, and how to create and manage subscriptions and schedules.
Perks of Course
Certificate: Yes
CPD Points: 61
Compliance Standards: AICC
Recovery Implementation
Price on Request
50 minutes
Should something go wrong, you can always use your SQL Server backup to recover your data. Explore the SQL Server 2014 recovery process, including restoring from Azure and Azure SQL Database.
Perks of Course
Certificate: Yes
CPD Points: 48
Compliance Standards: AICC
Replication Overview
Price on Request
55 minutes
One method for maintaining data integrity and minimizing potential disaster is replication. Discover how to configure, implement, and manage SQL Server replication as part of your backup and recovery plan.
Perks of Course
Certificate: Yes
CPD Points: 53
Compliance Standards: AICC
Report Formatting
Price on Request
1 hour 30 minutes
You can create different types of reports using either SQL Server Data Tools Report Designer and Report Builder. Learn how to use these tools to create reports with different options, including images, charts, and column headers.
Perks of Course
Certificate: Yes
CPD Points: 90
Compliance Standards: AICC
Report Interactivity
Price on Request
40 minutes
SQL Server Data Tools Report Designer and Report Builder are two versatile tools for creating reports. Discovert how to use these tools to add interactivity, such as sorting, filtering, and hyperlinks, to a report.
Perks of Course
Certificate: Yes
CPD Points: 42
Compliance Standards: AICC
SQL Concepts & Queries
Price on Request
1 hour
Master SQL concepts. Learning the core fundamentals creates a foundation. Discover relational databases and Structured Query Language (SQL) database concepts.
Perks of Course
Certificate: Yes
CPD Points: 60
Compliance Standards: AICC
SQL Security Architecture
Price on Request
50 minutes
Mastering security is crucial. Explore one of the most important aspects of SQL security. Discover the lock system, levels of security access and management, privileges and rights, and the setup and installation of security architecture.
Perks of Course
Certificate: Yes
CPD Points: 51
Compliance Standards: AICC
SQL Selecting, Ordering, & Filtering
Price on Request
55 minutes
Manipulating databases is a necessary skill. Explore Structured Query Language (SQL) and dive into the architecture. Discover efficient and easily manageable databases using features like SELECT, data types, UPDATE, and ORDER BY.
Perks of Course
Certificate: Yes
CPD Points: 55
Compliance Standards: AICC
SQL Tables
Price on Request
1 hour
Master SQL tables. Take your first steps in learning about relational databases and Structured Query Language (SQL) tables. Discover how to manage tables, and queries, including complex tables, changing tables, and deleting tables.
Perks of Course
Certificate: Yes
CPD Points: 60
Compliance Standards: AICC
SQL Transaction Locks
Price on Request
40 minutes
Master SQL transaction locks. Explore transaction locks and explore the different levels of locking.
Perks of Course
Certificate: Yes
CPD Points: 40
Compliance Standards: AICC
SQL Transactions
Price on Request
1 hour
Master SQL transactions. Explore transactions and how to group statements, Transact-SQL, and transaction logs.
Perks of Course
Certificate: Yes
CPD Points: 60
Compliance Standards: AICC
SQL Views
Price on Request
40 minutes
Discover SQL views. Explore SQL views in detail, defining various views and their management, from creating views to view types, updating, and dropping views.
Perks of Course
Certificate: Yes
CPD Points: 38
Compliance Standards: AICC
Table Design: Functions & Strings
Price on Request
40 minutes
Master the core functions of SQL strings. Strings are a key component to any database, and you can work magic using fundamental SQL commands. Explore string functions like LENGTH, REVERSE, and TRIM, as well as how to put them together.
Perks of Course
Certificate: Yes
CPD Points: 40
Compliance Standards: AICC
Table Design: Tables, Columns, & Numbers
Price on Request
1 hour 15 minutes
Fundamentals create foundation. Get a clear picture of what SQL is all about. Discover table functions including ALTER and CREATE, as well as column functions and math operators.
Perks of Course
Certificate: Yes
CPD Points: 76
Compliance Standards: AICC
Troubleshooting SSAS
Price on Request
35 minutes
Managing the Analysis Services server helps ensure it runs smoothly and is secure. Explore SSAS management tasks, including security issues, and preparing, backing up, and restoring multidimensional databases.
Perks of Course
Certificate: Yes
CPD Points: 35
Compliance Standards: AICC
Windows Azure SQL Database
Price on Request
2 hour
Meet Microsoft Windows Azure and Windows Azure SQL Database. Explore Windows Azure architecture, services, and storage, and examine Windows Azure SQL Database, including security and migration.
Perks of Course
Certificate: Yes
CPD Points: 119
Compliance Standards: AICC
WSFC Clustering
Price on Request
35 minutes
Windows Server Failover Clustering (WSFC) helps increase the availability of applications and services. Explore WSFC, including processes and cluster storage, and how to create a failover cluster.
Perks of Course
Certificate: Yes
CPD Points: 35
Compliance Standards: AICC