The Complete SQL from Scratch: Bootcamp

Description

Imagine the power of interacting with databases, organising vast information, and extracting valuable insights - all at your fingertips. This might seem like a formidable task, but SQL, or Structured Query Language, brings this within reach. It is one of the most in-demand skills in the tech industry, with a projected 10% job growth rate over the next decade. Our course, The Complete SQL from Scratch: Bootcamp, provides a thorough understanding of SQL, irrespective of your prior familiarity with it.

This comprehensive course walks you through the journey from the fundamentals of databases to the intricate functionalities of SQL. The curriculum includes detailed discussions on database creation, table manipulation, SQL statements, and utilisation of various operators.

Moreover, it also covers essential operations like data backup and restoration, thus preparing learners for real-life database management scenarios. The course design ensures a smooth transition from one concept to another, enabling learners to solidify their understanding at each step.

Enrol today and start learning SQL!

The Complete SQL from Scratch: Bootcamp course is suitable for anyone interested in diving into the world of databases or enhancing their skills further. Beginners with no prior knowledge and professionals seeking an in-depth understanding of SQL would equally benefit from the course.

Through The Complete SQL from Scratch: Bootcamp , you will learn:

The Complete SQL from Scratch: Bootcamp course is reviewed as a top choice among learners, and is recently updated to match the trending industry needs. By enrolling, you will acquire a set of skills that are crucial in today's data-centric world, enhancing your employability and competitive edge.

After successfully completing the course, you will receive a CPD certificate, signifying your expertise in SQL. This course is your stepping stone to becoming a proficient database professional.

Enrol and Lets get started!

12 sections • 56 lectures • 06:39:00 total length

•Introduction: 00:04:00

•Course Curriculum overview: 00:04:00

•Overview of Databases: 00:08:00

•PostgreSQL Installation: 00:13:00

•Connecting to PostgreSQL using psql: 00:04:00

•Connecting to PostgreSQL using PgAdmin: 00:07:00

•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

•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

•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

•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

•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

•Overview of Databases and Tables: 00:02:00

•Creating a Database backup: 00:03:00

•Restoring a Database from backup: 00:04:00

•Overview Assessment Test: 00:02:00

•Mock Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00

•Final Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00