Immerse yourself in the realm of database administration with the SQL Database Administrator at QLS Level 5 course. Gain mastery over SQL environment setup, statement fundamentals, advanced commands, and database creation. From optimizing queries to managing databases and tables, this course equips you with the skills to excel as a proficient SQL Database Administrator.
Learning Outcomes
This SQL Database Administrator at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.
After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.
Endorsed Certificate of Achievement from the Quality Licence Scheme
Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10.
Endorsement
The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards.
Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses.
Course Introduction | |||
Introduction | 00:04:00 | ||
Course Curriculum Overview | 00:05:00 | ||
Overview of Databases | 00:10:00 | ||
SQL Environment Setup | |||
MySQL Installation | 00:16:00 | ||
MySQL Workbench Installation | 00:09:00 | ||
Connecting to MySQL using Console | 00:09:00 | ||
SQL Statement Basics | |||
Overview of Challenges | 00:04:00 | ||
SQL Statement Basic | 00:16:00 | ||
SELECT Statement | 00:09:00 | ||
SELECT DISTINCT | 00:05:00 | ||
Column AS Statement | 00:12:00 | ||
COUNT built-in Method usage | 00:11:00 | ||
SELECT WHERE Clause – Part One | 00:05:00 | ||
SELECT WHERE Clause – Part Two | 00:11:00 | ||
SQL Statement Basic | 00:16:00 | ||
SQL Limit Clause Statement | 00:09:00 | ||
SQL Using BETWEEN with Same Column Data | 00:11:00 | ||
How to Apply IN Operator | 00:11:00 | ||
Wildcard Characters with LIKE and ILIKE | 00:11:00 | ||
GROUP BY Statements | |||
Overview of GROUP BY | 00:06:00 | ||
Aggregation function SUM() | 00:09:00 | ||
Aggregation MIN() and MAX() | 00:05:00 | ||
GROUP BY – One | 00:09:00 | ||
GROUP BY – Two | 00:12:00 | ||
HAVING Clause | 00:05:00 | ||
JOINS | |||
Overview of JOINS | 00:04:00 | ||
Introduction to JOINS | 00:04:00 | ||
AS Statement table | 00:03:00 | ||
INNER Joins | 00:14:00 | ||
FULL Outer Join | 00:11:00 | ||
LEFT Outer JOIN | 00:08:00 | ||
RIGHT JOIN | 00:08:00 | ||
Union | 00:07:00 | ||
Advanced SQL Commands / Statements | |||
Timestamps | 00:12:00 | ||
EXTRACT from timestamp | 00:10:00 | ||
Mathematical Functions | 00:12:00 | ||
String Functions | 00:22:00 | ||
SUBQUERY | 00:13:00 | ||
Creating Database and Tables | |||
Basic of Database and Tables | 00:06:00 | ||
DataTypes | 00:10:00 | ||
Primarykey and Foreignkey | 00:06:00 | ||
Create Table in SQL Script | 00:13:00 | ||
Insert | 00:11:00 | ||
Update | 00:07:00 | ||
Delete | 00:04:00 | ||
Alter Table | 00:09:00 | ||
Drop Table | 00:05:00 | ||
NOT NULL Constraint | 00:08:00 | ||
UNIQUE Constraint | 00:09:00 | ||
Databases and Tables | |||
Creating a Database backup | 00:12:00 | ||
10a Overview of Databases and Tables | 00:05:00 | ||
10c Restoring a Database | 00:07:00 | ||
Assignment | |||
Assignment – SQL Database Administrator at QLS Level 5 | 04:00:00 | ||
Order your QLS Endorsed Certificate | |||
Order your QLS Endorsed Certificate | 00:00:00 |
Step into the world of seamless content creation with The OBS Course for Recording, your gateway to professional-quality video production. …
0
Delve deeper into the powerful world of Java with Java Mastery Intermediate: Methods, Collections, and Beyond. This course is designed …
0
Take your Java programming skills to new heights with Mastering Advanced Java with Object-Oriented Programming. This course delves deep into …
0