SQL Programming: The SQL Database Programming Fundamentals Complete Training Course

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?

Requirements

Career path