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).
