Distance and online learning SQL courses

...Completion Certificate awarded upon completion to show employers your new skills Free upgrade on to our state of the art platform Career Advice available on completion 12 Months unlimited Access Microsoft 70-764 : Administering a SQL Database Infrastructure Preparation for Microsoft Certification... Learn about: Database training, SQL Database...

.... Some of the date-time functions available in the Oracle Database are also covered.Use Development Tools:The main development tool used in this training is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is appropriate for a 10g and 11g audience.Please... Learn about: Database training...

...and Window Functions Working with PIVOT, UNPIVOT, and Grouping Sets Managing Error Handling and Transactions Querying SQL Server System Optimizing Query... Learn about: MCSA training, Database training...

... operation, regular database backups stored effectively, and securing data from unauthorized access is also a candidate for this training course on SQL 2012. Below is a partial list of job functions associated to this CareerMatch training course: Audit SQL Server instances Back up databases Configure... Learn about: Database training...

...This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761... Learn about: Database training...

...Oracle SQL provides an efficient architecture useful to IT Professionals who specialise in databases and need to access, define, and maintain data... Learn about: Database training, Data warehousing, Data Collection...

...Querying Microsoft SQL Server 2012 (Exam 70-461) This exam is intended for SQL Server database administrators, implementers, system engineers, and developers. Primary responsibilities for this role may include but are not limited to: • Apply built-in scalar functions. • Apply ranking functions...

...This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server... Learn about: SQL Database, IT Auditing, Database training...

...with NonClustered Indexes Part2 Improving Performance with NonClustered Indexes Part3 Using Indexes Execution Plans Part1 Execution Plans Demo Execution... Learn about: MCSE training, XML training, Database training...

... topics to prepare students for the 70-432 SQL Server 2008 Implementation and Maintenance exam: how to install and configuring SQL Server 2008, maintaining SQL Server instances, managing SQL Server security, maintaining a SQL Server database, performing data management tasks, monitoring... Learn about: Database training...

...The course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2005, 2008 and 2012. In this course you will learn the details and capabilities of T-SQL in the following areas: Logical Query Processing; Query Tuning; Subqueries, Window Ranking and Offset Functions, Joins...

...the SQL Server Reporting Services Part6 Implementing Reports the SQL Server Reporting Services Part7 Implementing Reports the SQL Server Reporting Services... Learn about: Business Intelligence, MCSE training...

... Data Quality Services ETL Package development for data loading/transfer/transformation Data Synchronization One-time data or application migration Ad-hoc data manipulations, transformations Scheduling ETL jobs Managing, configuring and deploying SQL Server Integration Services (SSIS) packages... Learn about: Quality Training...

... and PowerBI in SQL Server 2016 Describe new and enhanced features in SQL Server performance Describe new and enhanced data access features Describes new and enhanced features in SQL Server security Describe new and enhanced features in SQL Server OLAP Describe what’s new in SQL Server Availability... Learn about: Database training...