Description

Do you need help learning SQL programming and effectively managing and manipulating data in relational databases?

It can be frustrating to feel like you need to make progress or get the results you need from your database queries. With the right skills and knowledge, you may gain valuable insights and opportunities for growth.

Our SQL Programming online course is the solution you've been looking for. With our comprehensive curriculum and expert instructors, you'll gain the skills and knowledge to confidently create and manipulate databases, design and execute complex queries, and optimize database performance.

In addition, our hands-on learning experience and practical exercises will enable you to apply your skills to real-world scenarios, giving you the confidence to tackle challenging SQL programming tasks and advance your career.

Reality Check: By the end of our course, you'll have the skills and knowledge to make informed decisions based on your findings and drive business success through effective data management and analysis. Don't let SQL programming hold you back - sign up for our course today and take your skills to the next level!

Expert Support

Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.

Key Benefits

Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.

Get 24/7 access to all content for a full year.

Each of our students gets full tutor support on weekdays (Monday to Friday)

This masterclass Mastering SQL Programming online training course is designed by industry experts and will give you an in-depth understanding of this topic. The course features easy-to-digest modules that break down each topic and ensure all our students receive an unrivalled and thorough learning experience.

If you want to work in this rapidly growing sector and stand out from the competition, then our Mastering SQL Programming is the perfect place to kickstart your dream career.

On the Mastering SQL Programming course, we guarantee that you will gain relevant skills and acquire tremendous knowledge on the subject. The certificate you'll achieve after completing the course will help you land the job you want in a related field.

Enjoy a pleasant and professional 100% online learning experience and enrol in our Mastering SQL Programming today and take control of your career!

Course Curriculum:

Unit 01: Introduction

Introduction

Tools Used in This Course

Unit 02: Setting up Course Tools

Download PostgreSQL

Install PostgreSQL

Download SQLectron

Install SQLectron

Connect to PostgreSQL - Credentials

Connect to PostgreSQL Using SQLectron

Import Course Data Using SQLectron

FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data

Unit 03: Browsing & Filtering Data

Check Imported Data

What is a Database?

Data Types

Finally Some Fun! Extracting Data Based on Requirements

Filtering Data using WHERE Keyword

Filter Data by Range Using BETWEEN

Filter Data by Set of Values Using IN

Filter Data by Date

More Filtering by Date

Another Query Filtering by Date

Filter Data by Strings

More Filtering by Strings

More Filtering by Strings 2

More Filtering by Strings 3

How to Ignore Caps when Filtering by String

Unit 04: Filter Data with AND, OR, NOT Operators

AND Operator

OR Operator

NOT Operator

AND, OR & NOT Operators: Which Has the Highest Priority?

Unit 05: Math Operations

Basic Math Operations

Modulo Operator

Calculate The Net Salary for Employees

Filter Data with Math Equations

Unit 06: String Concatenation

Concatenate Strings with '||' Operator

Concatenate Strings with Numbers

Unit 07: Tidy Up Your Results: Sorting, Alias Names, Limit Records

Give Your Report Fields A Cool Name

A Report for Payroll

Order Records by Column

Order Records by Multiple Columns

How Alias Names Cannot Be Used with WHERE

LIMIT Record Count Fetched by Your Query

Unit 08: NULL, DISTINCT & CASE Statements

Fetch A Field's Unique Values Using DISTINCT

Using DISTINCT Keyword with Multiple Columns

What is a NULL Value Anyway?

Build More Sophisticated Queries with CASE Statements

Your Knowledge So Far Under A Great Test

Unit 09: Functions in SQL: Multiple-Row Functions

Let Me Introduce You to Functions

SUM Function

AVG (Average) Function

COUNT Function

MIN & MAX Functions

How To Count Your Field's Unique Values

GROUP BY Clause: Use Functions with Dimensions

GROUP BY More Than One Dimension

Now For Some Tough Workout

Filter By Aggregate Functions with HAVING Clause

Unit 10: Functions in SQL: Single-Row Functions

Character Functions - UPPER, LOWER & INITCAP

Character Functions - CONCAT & LENGTH

Character Functions - LPAD & RPAD

Character Functions - TRIM

Character Functions - REPLACE

Character Functions - SUBSTR

Number Functions - MOD & ROUND

Number Functions - TRUNC

Unit 11: Nested Queries

Selectception: A Select Query inside another Select Query!

Unit 12: Casting & Data Conversion

Auto Data Conversion

Cast Date to Character

Cast Number to Character

Cast Timestamp to Character

Cast Character to Number

Cast Character to Date & Timestamp

Unit 13: Combination Relationships

UNION

UNION ALL

Important Note about Combining Queries

INTERSECT

EXCEPT

Unit 14: Joins in SQL

Employees & Departments Tables Revised

Entity Relationship Diagram (ERD)

Cartesian Join

Table Aliases with Joins

Why I Don't Recommend Cartesian Joins

Inner Join

In-Depth Look into Join Types in SQL

Outer Join - Right, Left & Full

Unit 15: Data Manipulation (DML)

INSERT a New Record to a Table

Insert Without Specifying Column Names

UPDATE a Record's Field Values

CAUTION! How an UPDATE Query Can Go Wrong

Update a Record Using Single-Row Functions

A Good Exercise: Extract Employee's Email Address

Solution: Extract Employee's Email Address

DELETE a Table's Record

Insert Records with Nested Select Queries

Unit 16: SQL Data Definition Language (DDL)

SQL Data Types Revised

Bookstore Data Set: Let's Move It to Database

Create Your First Table!

Insert Data to Your New Table

Change Column Data Type

Rename Column

Add a New Column to Table

Constraints in SQL

Primary Keys

NOT NULL Constraint

UNIQUE Constraint

DEFAULT Constraint

Foreign Keys

Use Foreign Keys with Joins - Books & Publishers

Foreign Keys - Properties

Drop Column

DROP Table

Create a New Table with Select Statement

A Trick to Create an Empty Table with Select Statement

Insert New Records Using Select Statement

Views

Schemas

Create & Use Schemas

Course Assessment

To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.

When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.

Exam & Retakes:

It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.

Certification

Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).

Who is this course for?

This Mastering SQL Programming course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.

Requirements

This Mastering SQL Programming course is open to all, with no formal entry requirements.

Career path

Upon successful completion of the Mastering SQL Programming Course, learners will be equipped with many indispensable skills and have the opportunity to grab, such as:

SQL Developer

Database Administrator

Data Analyst

Business Intelligence Developer

Data Engineer

Data Scientist

Database Analyst

ETL Developer

SQL Server Developer

Reporting Analyst

Course Images

SQL Programming: The SQL Database Programming Fundamentals Complete Training Course

By One Education

Booking options

Highlights

Description

About The Provider

Tags

Reviews