SQL in MySQL Training Course

Description

• Type

  Course

Description

How to build a query?
What opportunities has the SQL in a MySQL database?
What is a relational database?
What is the structure and SQL commands?

About this course

Requirements

Computer literacy
Knowledge of any operating system

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

Send

We will only publish your name and question

Request information

We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.

Thank you!

We are reviewing your question. We will publish it shortly.

Or do you prefer the center to contact you?

Request information

Reviews

Have you taken this course? Share your opinion

Subjects

• MySQL
• Database
• SQL
• Database training

Course programme

Relational database models

• Relational operators
• Characteristics of declarative SQL language
• SQL syntax
• Division language DQL, DML, DDL, DCL

Data Query Language

• SELECT queries.
• Aliases columns of tables
• Service date (DATE types, display functions, formatting)
• Group Features
• Combining internal and external tables (JOIN clause)
• UNION operator
• Nested Subqueries (the WHERE clause, the table name, column name)
• Correlated subqueries

Data Modification Language

• Inserting rows (INSERT clause)
• Inserting rows by request
• Variation of the rows (UPDATE)
• Delete rows (DELETE)

Data Definition Language

• Creating, altering and dropping objects (CREATE, ALTER, DROP)
• Creating tables using subquery (CREATE TABLE .... AS SELECT...)

CONSTRAINTS

• Options NULL and NOT NULL
• CONSTRAINT clause
• ENUM type
• type SET
• PRIMARY KEY condition
• UNIQUE condition
• FOREIGN KEY condition
• DEFAULT clause

Transactions

• The command COMMIT, ROLLBACK, SAVEPOINT

Additional information

14 hours (usually 2 days including breaks)

See related categories

• SQL courses
• Distance learning SQL courses
• Courses in England
• Oracle sql courses
• Data analysis sql courses
• Sql intermediate courses
• Transact sql courses
• Database leeds courses
• PHP courses
• Distance learning PHP courses
• Distance learning Course
• Courses in West Yorkshire
• Courses in Bradford
• Nobleprog Limited courses