The Complete SQL from Scratch: Bootcamp

The Complete SQL from Scratch: Bootcamp

get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer

Learning Outcome

Description

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!

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
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
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
0
    0
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon