The Complete SQL from Scratch: Bootcamp

Name: The Complete SQL from Scratch: Bootcamp
Price: 25 GBP

8 STUDENTS ENROLLED

Course Overview

The Complete SQL from Scratch: Bootcamp provides learners with the skills and knowledge to establish a successful career in data science. Designed by industry experts, it explores the basic and more advanced commands and SQL queries in-depth, providing real-world skills and up-to-date industry knowledge delivered in an easy to grasp manner. On successful course completion, learners will have the fundamental skills to develop an MSSQL database using SQL language.

Divided into several key modules, this course will take you through everyday tasks such as simplifying reports, preparing data structures, and interacting with the database. You will also learn how to protect, backup and restore your data, with tips and tricks from qualified professionals. Our training covers everything you need to know about SQL programming, with learning material designed for absolute beginners.

We’ve taken this professional diploma in SQL programming and broken it down into fundamental topics, which we believe covers the key concepts every entry-level SQL developer must know – from the fundamentals to more complex subjects. Solidify your career and learn the fundamentals of SQL with this best-selling training program!

Learning Outcomes:

Kickstart an exciting career in SQL programming by gaining real-world knowledge
Understand the core concepts of database design and administration
Learn how to create basic SQL queries and SQL statements
Fully familiarise with some fundamental and more complex commands of SQL
Know how to simplify SQL reports and prepare SQL data structures
Discover how to backup and restore functions through our step-by-step guide
Understand how to filter data rows, find SQL constraints, create tables and much more…

Who is This Course for?

This Complete SQL from Scratch: Bootcamp is for anyone looking to gain a recognised qualification to fast track their career. It is also the perfect refresher training course for those who wish to update their existing skills and learn some new industry best practices. There are no specific entry requirements for this course, which is open to both part-time and full-time learners.

Career Path

On successful completion, learners will have in-demand industry skills needed to kickstart a career in data science. Professions in this field include:

SQL Database Developer
SQL Programmer
SQL Server
Data Analyst
Data Scientist
System Analyst

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