SQL Programming Training Course

By: NobleProg (UK) Limited  24/03/2011
Keywords: computer training, IT consultancy, computer education

SELECT clause

Column aliases

Table aliases

Date types and Date functions

Group function

Table joins

JOIN clause

UNION operator

Nested queries

Correlated subqueries

Inserting rows (INSERT)

Inserting rows using subquery

Updating rows (UPDATE)

Deleting rows (DELETE)

Creating, altering and dropping objects (CREATE, ALTER, DROP)

Creating tables using subquery (CREATE TABLE .... AS SELECT...)

NULL i NOT NULL

CONSTRAINT clause

ENUM type

SET type

PRIMARY KEY

UNIQUE

FOREIGN KEY

DEFAULT clause

COMMIT

ROLLBACK

SAVEPOINT

Implicit and explicit rollbacks and commits

MySQL

Microsoft Access and SQL Server

Oracle and PostgreSQL

Keywords: computer education, computer training, IT consultancy, it consultants, it training

Contact NobleProg (UK) Limited

Email

Print this page

Other products and services from NobleProg (UK) Limited

24/03/2011

JMeter Fundamentals Training Course

This course covers the creation and implementation of functional and unit testing with Apache JMeter, the free application testing software from The Apache Software Foundation. The purpose of the course is to allow organisations to completely automate their various testing requirements, saving time, money and helping to minimise the risk of human error in testing. The programme explores the concepts of designing and creating test plans for real-world web applications using Apache J


24/03/2011

Strategic Planning in Practice Training Course

This training course has been created for investors, business owners, directors, managers, executives and analysts who need to develop strategic planning skills. It is not designed for academic purposes, but to start realizing your dreams today. This course focuses on strategic planning for technology-based businesses in which flexibility and constant learning is the most important thing. The main emphasis is corporate and investment strategy using current real-world examples. Each c


24/03/2011

MySQL Database Administration Training Course

MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties. The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your datab


24/03/2011

Excel VBA Introduction Training Course

This course has been created for anyone who works with Excel and wants to automate most of their tasks. The course covers procedural programming in VBA. Students will learn which objects are available in Excel and how to use them. They will also learn how to write their own worksheet functions, debug programs and write complete applications using VBA forms.


24/03/2011

Java Fundamentals Training Course

The course covers the basics of Java development. It introduces students to Java technology and teaches them basic Java syntax and concepts, leading to the creation of a simple program. Training goes through the essential concepts and features of the Java Programming Language, focusing on exceptions, basic input/output, concurrency, regular expressions, Java collections framework and the platform environment. The course finishes when all basic Java features have been explained and