Booking options
£19
£19
On-Demand course
All levels
This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement.
The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.
Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements.
Benefits of CPD
Improve your employment prospects
Boost your job satisfaction
Promotes career advancement
Enhances your CV
Provides you with a competitive edge in the job market
Demonstrate your dedication
Showcases your professional capabilities
The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill.
Benefits of IPHM
It will help you establish a positive reputation in your chosen field
You can join a network and community of successful therapists that are dedicated to providing excellent care to their client
You can flaunt this accreditation in your CV
It is a worldwide recognised accreditation
This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.
Benefits of Quality License Scheme
Certificate is valuable
Provides a competitive edge in your career
It will make your CV stand out
Introduction | |||
Course Overview! | 00:04:00 | ||
Installation And Getting Started | |||
The Final Milestone! | 00:01:00 | ||
Installing and setting up PostgreSQL | 00:09:00 | ||
Case Study : Demo | |||
Case Study Part 1 | 00:04:00 | ||
Case Study Part 2 | 00:06:00 | ||
Fundamental SQL statements | |||
CREATE | 00:11:00 | ||
Exercise 1: Create DB and Table | 00:01:00 | ||
INSERT | 00:09:00 | ||
Import data from File | 00:05:00 | ||
Exercise 2: Inserting and Importing | 00:01:00 | ||
SELECT statement | 00:03:00 | ||
SELECT DISTINCT | 00:06:00 | ||
WHERE | 00:04:00 | ||
Logical Operators | 00:06:00 | ||
Exercise 3: SELECT & WHERE | 00:01:00 | ||
UPDATE | 00:05:00 | ||
DELETE | 00:04:00 | ||
ALTER | 00:17:00 | ||
Exercise 4: Updating Table | 00:01:00 | ||
Restore And Back-Up | |||
Restore and Back-up | 00:07:00 | ||
Exercise 5: Restore and Back-up | 00:01:00 | ||
Selection Commands: Filtering | |||
IN | 00:04:00 | ||
BETWEEN | 00:05:00 | ||
LIKE | 00:08:00 | ||
Exercise 6: In, Like & Between | 00:01:00 | ||
Selection Commands: Ordering | |||
Side Lecture: Commenting in SQL | 00:01:00 | ||
ORDER BY | 00:07:00 | ||
LIMIT | 00:03:00 | ||
Exercise 7: Sorting | 00:01:00 | ||
Alias | |||
AS | 00:03:00 | ||
Aggregate Commands | |||
COUNT | 00:05:00 | ||
SUM | 00:03:00 | ||
AVERAGE | 00:03:00 | ||
MIN & MAX | 00:04:00 | ||
Exercise 8: Aggregate functions | 00:01:00 | ||
Group By Commands | |||
GROUP BY | 00:12:00 | ||
HAVING | 00:05:00 | ||
Exercise 9: Group By | 00:01:00 | ||
Conditional Statement | |||
CASE WHEN | 00:05:00 | ||
Joins | |||
Introduction to Joins | 00:02:00 | ||
Inner Join | 00:08:00 | ||
Left Join | 00:07:00 | ||
Right Join | 00:06:00 | ||
Full Outer Join | 00:05:00 | ||
Cross Join | 00:04:00 | ||
Except | 00:03:00 | ||
Union | 00:03:00 | ||
Exercise 10: Joins | 00:01:00 | ||
Subqueries | |||
Subqueries | 00:14:00 | ||
Exercise 11: Subqueries | 00:01:00 | ||
Views And Indexes | |||
VIEWS | 00:07:00 | ||
INDEX | 00:06:00 | ||
Exercise 12: Views | 00:01:00 | ||
String Functions | |||
LENGTH | 00:03:00 | ||
Upper Lower | 00:02:00 | ||
REPLACE | 00:04:00 | ||
TRIM, LTRIM, RTRIM | 00:07:00 | ||
CONCATENATION | 00:03:00 | ||
SUBSTRING | 00:06:00 | ||
LIST AGGREGATION | 00:05:00 | ||
Exercise 13: String Functions | 00:02:00 | ||
Mathematical Functions | |||
CEIL & FLOOR | 00:03:00 | ||
RANDOM | 00:05:00 | ||
SETSEED | 00:04:00 | ||
ROUND | 00:02:00 | ||
POWER | 00:02:00 | ||
Exercise 14: Mathematical Functions | 00:01:00 | ||
Date-Time Functions | |||
CURRENT DATE & TIME | 00:04:00 | ||
AGE | 00:03:00 | ||
EXTRACT | 00:08:00 | ||
Exercise 15: Date-time functions | 00:01:00 | ||
Pattern (String) Matching | |||
PATTERN MATCHING BASICS | 00:07:00 | ||
ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) | 00:15:00 | ||
Exercise 16: Pattern Matching | 00:01:00 | ||
Data Type Conversion Functions | |||
Converting Numbers/ Date to String | 00:11:00 | ||
Converting String to Numbers/ Date | 00:06:00 | ||
User Access Control Functions | |||
User Access Control | 00:13:00 | ||
Bonus Section: Nail That Interview! | |||
Tablespace | 00:05:00 | ||
PRIMARY KEY & FOREIGN KEY | 00:05:00 | ||
ACID compliance | 00:06:00 | ||
Truncate | 00:04:00 | ||
Performance Tuning Tips | |||
TIP 1 (EXPLAIN) | 00:04:00 | ||
TIP 2 | 00:01:00 | ||
TIP 3 | 00:02:00 | ||
TIP 4 (VACCUM) | 00:01:00 | ||
TIP 5 | 00:02:00 | ||
TIP 6 (STRING FUNCTIONS) | 00:02:00 | ||
TIP 7 (JOINS) | 00:02:00 | ||
TIP 8 (SCHEMAS) | 00:04:00 | ||
Bonus Section : Database Basics | |||
What is SQL | 00:02:00 | ||
Tables and DBMS | 00:03:00 | ||
Types of SQL commands | 00:04:00 | ||
PostgreSQL | 00:02:00 | ||
The Final Milestone! | 00:01:00 | ||
Supplementary Resources | |||
Supplementary Resources - SQL Masterclass | 00:00:00 | ||
Assessment | |||
Assessment - SQL Masterclass | 00:10:00 | ||
Certificate of Achievement | |||
Certificate of Achievement | 00:00:00 | ||
Get Your Insurance Now | |||
Get Your Insurance Now | 00:00:00 | ||
Feedback | |||
Feedback | 00:00:00 |