The Complete SQL from Scratch: Bootcamp
The Complete SQL from Scratch: Bootcamp
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 | ||
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 | ||
Assessment Test | |||
Overview Assessment Test | 00:02: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 | ||
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 | ||
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 |