Description

Recognised Accreditation

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.

What is CPD?

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

What is IPHM?

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

What is Quality Licence Scheme?

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

Course Curriculum

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

Course Images

Advanced SQL Training Online

By Study Plex

Booking options

Highlights

Description

About The Provider

Tags

Reviews