• No products in the cart.

The Complete SQL from Scratch: Bootcamp

0( 0 REVIEWS )
14 STUDENTS
course-image

Course Overview

You’ll have an arsenal of skills to lock down your desired career after completing this The Complete SQL from Scratch: Bootcamp course. Moreover, you will have access to all of the materials in this course for free for a whole year and learn a multitude of highly coveted skills to move up the corporate ladder.

With this comprehensive The Complete SQL from Scratch: Bootcamp course, you’ll have all of your questions answered and all of the necessary expertise under your belt. Apart from setting you up for success, this course offers numerous advantages to make your learning experience more pleasurable and less stressful. So, add this The Complete SQL from Scratch: Bootcamp course to the basket and take your expertise up a notch!

Please Note: Thames College is a One Education approved resale partner for Quality Licence Scheme Endorsed courses.

Why Choose Thames College?

Thames College offers you the benefit of —

Who Is This Course For?

Those who want to strengthen their professional skills while training for the desired job should take advantage of the The Complete SQL from Scratch: Bootcamp training! This course will keep you up-to-date with all the latest developments and coach you accordingly. So invest in this The Complete SQL from Scratch: Bootcamp course if you want the best training available.

Certificate of Achievement

CPD Certification

After successfully completing the assessment of this The Complete SQL from Scratch: Bootcamp course, you can apply for the CPD accredited certificates. The PDF version is only £2.99 and the Hardcopy version will cost you £8.99.

Requirements

No formal entry requirements! No prerequisites or relevant experience is required!

This course is accessible to anyone with an eagerness to learn. All you require is—

Career Path

Utilise this all-inclusive course to acquire the skills and expertise you’ll need to thrive in the workplace.

Course Curriculum

The Complete SQL from Scratch: Bootcamp
Course Introduction
Introduction 00:04:00
Course Curriculum overview 00:04:00
Overview of Databases 00:08:00
SQL Environment Setup
PostgreSQL Installation 00:13:00
Connecting to PostgreSQL using psql 00:04:00
Connecting to PostgreSQL using PgAdmin 00:07:00
Creating Database and Tables
Basic of Database and Tables 00:06:00
Data Types 00:07:00
Primary Keys and Foreign Keys 00:04:00
Create Table in SQL Script 00:17:00
Insert 00:05:00
Update 00:05:00
Delete 00:03:00
Alter Table 00:05:00
Drop Table 00:02:00
Check Constraint 00:12:00
NOT NULL Constraint 00:04:00
UNIQUE Constraint 00:06:00
SQL Statement Basics
Overview of Challenges 00:04:00
SQL Statement Basic 00:07:00
SELECT Statement 00:12:00
SELECT DISTINCT 00:10:00
Column AS Statement 00:07:00
COUNT 00:07:00
SELECT WHERE Clause – One 00:06:00
SELECT WHERE Clause – Two 00:11:00
ORDER 00:05:00
LIMIT 00:04:00
BETWEEN keyword usage on real time 00:08:00
IN Operator 00:06:00
LIKE and ILIKE 00:10:00
GROUP BY Statements
Overview of GROUP BY 00:03:00
Aggregation Function 00:12:00
GROUP BY – One 00:05:00
GROUP BY – Two 00:06:00
HAVING on SQL Statement 00:04:00
JOINS
Overview of JOINS 00:07:00
Introduction to JOINS 00:06:00
AS Statement table 00:05:00
INNER Joins 00:14:00
Full Outer Joins 00:04:00
Left Outer join 00:03:00
Right Outer Join 00:05:00
Union 00:05:00
Advanced SQL Commands
Basic of Advanced SQL Commands 00:04:00
Timestamps 00:17:00
Extract from Timestamp 00:05:00
Mathematical Functions 00:06:00
String Functions 00:16:00
SubQuery 00:08:00
Databases and Tables
Overview of Databases and Tables 00:02:00
Creating a Database backup 00:03:00
Restoring a Database from backup 00:04:00
Assessment Test
Overview Assessment Test 00:02:00
Mock Exam
Mock Exam – The Complete SQL from Scratch: Bootcamp 00:20:00
Final Exam
Final Exam – The Complete SQL from Scratch: Bootcamp 00:20:00

Certificate of Achievement

CPD Accredited Certification

You will be eligible for CPD Accredited Certificates after completing this Course successfully.
Certification is available –
  1. In PDF for £2.99
  2. Hard copy for £8.99
Thames-College-Certificate
Thames-college-logo-white-2021

We are a business that specialises in providing CPD & QLS accredited courses for anyone looking to advance their professional career.

Address : 78 Ilford Lane, Ilford, England, IG1 2LA

Email : info@thamescollege.org

Phone Number : ​020 8124 5465

Useful Links

Payment Methods

lead-payment-logos

Copyright © 2024 Thames College. All Right Reserved.

top