The Complete SQL from Scratch: Bootcamp

The Complete SQL from Scratch: Bootcamp

0 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
    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
    TAKE THIS COURSE

    COPYRIGHT © 2020 One Education