Birmingham - Bristol - Cambridge - Coventry - Edinburgh - Glasgow - Kingston - Leeds - London - Manchester - Slough

SQL training courses and schools
SQL Programming

School: Learning Tree International Ltd.
[All Courses]

SQL Server® High Availability
Course Format: Classroom
You Will Learn How To Leverage SQL Server 2008 technologies to achieve high availability databases Design a Service Level Agreement that matches business requirements Plan, prepare and install a SQL Server 2008 failover cluster Maintain a warm standby server with log shipping Mirror a database to ensure disaster recovery Employ replication as a high availability solution Course...
 

SQL Server ®2008 Reporting Services
Course Format: Classroom
You Will Learn How To Leverage SQL Server 2008 Reporting Services to extract business intelligence from your data Design reports and display your data graphically with enhanced visualisation features Integrate parameters, filters and interactive components into report design Deploy and deliver relevant reports across the entire enterprise through Report Server and SharePoint Safeguar...
 

SQL Server® 2008 Database Administration
Course Format: Classroom
You Will Learn How To Administer SQL Server 2008 with SQL Server Management Studio and Transact-SQL Build databases and upgrade from prior versions Implement login security and authorise database access Manage complex access requirements with permissions and roles Develop backup strategies to recover from disasters Import and export data with SQL Server Integration Services Cou...
 

SQL Server® 2008 Skills
Course Format: Classroom
You Will Learn How To Leverage new SQL Server 2008 features and tools to support database administration and development Simplify server-side programming with new Transact-SQL commands Enforce standards to ensure compliance with policy-based management Monitor and log data changes for auditing compliance Enhance security and high availability through improved encryption and replicati...
 

School: Harbrook
[All Courses]

Oracle SQL PL
Course Format: Classroom
After completing this course, the student should be able to: Write programs which use some or all of the primary PL/SQL programming constructs. Course outline Program Blocks Variables and Constants Data Types Using SQL Statements within PL/SQL Programs Generating SQL*Plus and SQL Developer Output IF THEN ELSIF ELSE Statements CASE Expressions Basic Loops The WHILE and ...
 

Oracle SQL Advanced
Course Format: Classroom
After completing this course, the student should be able to: Use SQL Developer as an alternative to SQL*Plus Manage Schema Objects with Data Dictionary Views Write Multiple Column Subqueries Manage Large Data Sets with Subqueries Construct Hierarchical Queries Use the ROLLUP, CUBE and GROUPING SETS Group By Extensions Manage Data in Different Time Zones Use Regular Expression ...
 

Oracle SQL
Course Format: Classroom
After completing this course, the student should be able to: Describe the basic structure of a relational database Use the command line features of SQL*Plus Use SQL Developer to access an Oracle Database Create SQL statements to select data from an Oracle Database Use SQL run time parameters Use aggregate functions Use numeric, character, date, conversion and miscellaneous funct...
 

MySQL Database Administration
Course Format: Classroom
After completing this course, the student should be able to: This course is designed to give administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of MySQL databases and services. Administrators will gain practical experience in setting up, administering and troubleshooting MySQL databases. They will gain an understanding of the architec...
 

MySQL
Course Format: Classroom
After completing this course, the student should be able to: Outline the structure of a MySQL database Use the MySQL Client Program and other interfaces Create a MySQL database Write SQL statements to select data from a MySQL database Use joins, subqueries, grouping and aggregate functions Use SQL expressions and basic functions Insert, update, delete and replace data Create a...
 

School: Highlander Ltd.
[All Courses]

PHP / MySQL
Course Format: Classroom
The PHP language combined with the MySQL database is a powerful and popular combination for web development these days and is the foundation of a lot of well known sites not to mention millions of those that are lessor known. It is also the technology behind many of the more succesful open source packages such as Drupal, SugarCRM, Moodle, OSCommerce and more.
 

Page(s):- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 ... [ Popular Topics ] [ Schools Only ]