Database Administrator - CPD Certified
StudyHub
Summer Sale : Up to 98% Off | 4 in 1 Exclusive Bundle | PDF Certificate, Transcript, Student ID & Test Included
Summary
- Certificate of completion - Free
- Hard copy certificate - £9.99
- MCQ/Assignment (included in price)
- Tutor is available to students
Add to basket or enquire
Overview
Certificates
Certificate of completion
Digital certificate - Included
Hard copy certificate
Hard copy certificate - £9.99
Hard Copy certificates must be bought separately for an extra £9.99.
Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.
Assessment details
MCQ/Assignment
Included in course price
CPD
Course media
Description
Course Curriculum
**SQL Database Administrator**
Course Introduction
- Introduction
SQL Environment Setup
- MySQL Installation
- MySQL Workbench Installation
- Connecting to MySQL using Console
SQL Statement Basics
- Overview of Challenges
- SQL Statement Basic
- SELECT Statement
- SELECT DISTINCT
- Column AS Statement
- COUNT built-in Method usage
- SELECT WHERE Clause – Part One
- SELECT WHERE Clause – Part Two
- SQL Statement Basic
- SQL Limit Clause Statement
- SQL Using BETWEEN with Same Column Data
- How to Apply IN Operator
- Wildcard Characters with LIKE and ILIKE
GROUP BY Statements
- Overview of GROUP BY
- Aggregation function SUM()
- Aggregation MIN() and MAX()
- GROUP BY – One
- GROUP BY – Two
- HAVING Clause
JOINS
- Overview of JOINS
- Introduction to JOINS
- AS Statement table
- INNER Joins
- FULL Outer Join
- LEFT Outer JOIN
- RIGHT JOIN
- Union
Advanced SQL Commands / Statements
- Timestamps
- EXTRACT from timestamp
- Mathematical Functions
- String Functions
- SUBQUERY
Creating Database and Tables
- Basic
- DataTypes
- Primarykey and Foreignkey
- Create Table in SQL Script
- Insert
- Update
- Delete
- Alter Table
- Drop Table
- NOT NULL Constraint
- UNIQUE Constraint
and 3 more Courses!!
Certification
Following your completion of the course materials, you will be able to take an assignment test to assess your knowledge. You will be able to grab the PDF certificates & transcripts for free after passing the test. Original Hard Copy certificates must be bought separately for an extra £8.
Who is this course for?
This database bundle is suitable for:
- Students
- Recent graduates
- Freelance programmers
- Coders
- Job Seekers
Requirements
There is no formal qualification needed for this Database course.
Career path
After completing the database course, employment opportunities may include working as an:
- Programmer
- IT support technician
- Solutions architect
- Web developer
- Computer games developer
- IT project manager
The average salary for a programmer can be £24,000 to £70,000 per annum for anyone residing in the United Kingdom.
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.