Skip to content

SQL, SQL Course


eTrain

Summary

Price
£22 inc VAT
Study method
Online
Duration
1 day · Self-paced
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

Overview

Have you ever been interested in learning about SQL Databases or a keen developer wishing to pursue a career in databases/programming or someone who needs an online course where you can learn at your own pace with a course that teaches you everything you need to know about SQL, than look no further, ENROL TODAY!

This course will be sent to you via email/pdf format you will have unlimited and lifetime access to this course, so you can refer back to it at anytime you wish.

PDF document only this is not an interactive course.

Description

What you will learn:

DB Approach & Applied Technologies (introduction)

PART 1: DB Approach & Applied Technologies - Databases, separation and isolation of data, duplication of data, history or database systems, DBMS environment/components, roles, database designs, data mapping and independence, database languages

PART 2: The Relational Model - Terminology, mathematics, data independence, low redundancy, database integrity types, domain constraints, SQL data manipulation, MIN, MAX and AVG functions

PART 3: SQL Data Manipulation Language - Grouping, having, ISO, sophisticated SQL, queries, JOIN, UNION, INTERSECT, EXCEPT

PART 4: Conceptual Database Design - Entity-Relationship Modelling CORE CONCEPTS, constraints, EER introduction, ER/EER Modelling Process

PART 5: Logical Design for Relational Databases - Logical design for relational databases, Derive Relations for Logical Data Model, rules

PART 6:SQL Data Definition Language (DDL) - Data Types, Database Integrity, SQL Statements, Views & Privileges

You are not permitted to, in anyway, copy this course (all it's contents) for re-sale or to gain profits from this course. This course is solely for the purpose of learning and is to be used by only the purchaser of this course.

Who is this course for?

This course would suit anyone wishing to pursue a career in programming, or anyone looking to build a career within SQL databases.

Must have some knowledge of SQL language.

Career path

Go onto further studies.

Questions and answers


No questions or answers found containing ''.


J asked:

THE COURSE'S DURATION IS ONE DAY. Could one still log on and review continuously the course go through it and understand?

Answer:

Hello J, As it's a PDF you will have it forever so you can take your time and go over and over it as many times as you like there is no time limit as once you pay for the course and we send it to you it's yours to keep. eTrain

This was helpful. Thank you for your feedback.
Joanna asked:

What system capability is required? Are any packages required?

Answer:

Hi Joanna, No it's just a PDF course no systems are included. eTrain

This was helpful. Thank you for your feedback.
Jubed asked:

Hi, I have no prior knowledge with SQL or programming, would this be the right course to learn the fundamentals?

Answer:

Yes it would be. Regards, eTrain London

This was helpful. Thank you for your feedback.

Certificates

Certificate of completion

Digital certificate - Included

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.