Mastering SQL Programming

Course Overview: Learn how to make a genuine difference in your life by taking our popular Mastering SQL Programming Course. …

Mastering SQL Programming

£25 ex VAT

Exclusive Deal! 94% Off, Today Only!

TAKE THIS COURSE

1 Year Access
Intermediate
11 Students
11 hours, 50 minutes

Buy 1 or more contact sale

£25 ex VAT
1 year
Intermediate
Number of Units118
Number of Quizzes0
11 hours, 50 minutes

Gift this course

14-Day Money-Back Guarantee

Course Overview:

Learn how to make a genuine difference in your life by taking our popular Mastering SQL Programming Course. Our commitment to online learning and our technical experience has been put to excellent use within the content of these educational modules. By enrolling today, you can take your knowledge of Mastering SQL Programming to a whole new level and quickly reap the rewards of your study in the field you have chosen.

We are confident that you will find the skills and information that you will need to succeed in this area and excel in the eyes of others. Do not rely on substandard training or half-hearted education. Commit to the best, and we will help you reach your full potential whenever and wherever you need us.

Please note that Mastering SQL Programming provides valuable and significant theoretical training for all. However, it does not offer official qualifications for professional practice. Always check details with the appropriate authorities or management.

Learning outcomes:

Instant access to verified and reliable information
Participation in inventive and interactive training exercises
Quick assessment and guidance for all subjects
CPD accreditation for proof of acquired skills and knowledge
Freedom to study in any location and at a pace that suits you
Expert support from dedicated tutors committed to online learning

Your Path to Success

By completing the training in Mastering SQL Programming, you will be able to significantly demonstrate your acquired abilities and knowledge of Mastering SQL Programming. This can give you an advantage in career progression, job applications, and personal mastery in this area.

Is This Course Right for You?

This course is designed to provide an introduction to Mastering SQL Programming and offers an excellent way to gain the vital skills and confidence to start a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Full-time and part-time learners are equally supported, and the study periods are entirely customisable to your needs.

Assessment Process

Once you have completed all the modules in the Mastering SQL Programming course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.

Show off Your New Skills with a Certification of Completion

The learners have to successfully complete the assessment of this Mastering SQL Programming course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. Learners can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39.

Course Curriculum

Unit 01: Introduction
	Introduction	00:02:00
	Tools Used in This Course	00:04:00
Unit 02: Setting up Course Tools
	Download PostgreSQL	00:02:00
	Install PostgreSQL	00:03:00
	Download SQLectron	00:03:00
	Install SQLectron	00:01:00
	Connect to PostgreSQL – Credentials	00:01:00
	Connect to PostgreSQL Using SQLectron	00:02:00
	Import Course Data Using SQLectron	00:03:00
	FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data	00:08:00
Unit 03: Browsing & Filtering Data
	Check Imported Data	00:08:00
	What is a Database?	00:02:00
	SQL Data Types	00:02:00
	Finally Some Fun! Extracting Data Based on Requirements	00:04:00
	Filtering Data using WHERE Keyword	00:08:00
	Filter Data by Range Using BETWEEN	00:03:00
	Filter Data by Set of Values Using IN	00:03:00
	Filter Data by Date	00:07:00
	More Filtering by Date	00:04:00
	Another Query Filtering by Date	00:01:00
	Filter Data by Strings	00:05:00
	More Filtering by Strings	00:06:00
	More Filtering by Strings 2	00:10:00
	More Filtering by Strings 3	00:02:00
	How to Ignore Caps when Filtering by String	00:05:00
Unit 04: Filter Data with AND, OR, NOT Operators
	AND Operator	00:10:00
	OR Operator	00:12:00
	NOT Operator	00:09:00
	AND, OR & NOT Operators: Which Has the Highest Priority?	00:06:00
Unit 05: Math Operations
	Basic Math Operations	00:06:00
	Modulo Operator	00:04:00
	Calculate The Net Salary for Employees	00:06:00
	Filter Data with Math Equations	00:05:00
Unit 06: String Concatenation
	Concatenate Strings with ‘\|\|’ Operator	00:06:00
	Concatenate Strings with Numbers	00:02:00
Unit 07: Tidy Up Your Results: Sorting, Alias Names, Limit Records
	Give Your Report Fields A Cool Name	00:04:00
	A Report for Payroll	00:10:00
	Order Records by Column	00:08:00
	Order Records by Multiple Columns	00:15:00
	How Alias Names Cannot Be Used with WHERE	00:03:00
	LIMIT Record Count Fetched by Your Query	00:10:00
Unit 08: NULL, DISTINCT & CASE Statements
	Fetch A Field’s Unique Values Using DISTINCT	00:03:00
	Using DISTINCT Keyword with Multiple Columns	00:08:00
	What is a NULL Value Anyway?	00:05:00
	Build More Sophisticated Queries with CASE Statements	00:10:00
	Your Knowledge So Far Under A Great Test	00:10:00
Unit 09: Functions in SQL: Multiple-Row Functions
	Let Me Introduce You to Functions	00:04:00
	SUM Function	00:04:00
	AVG (Average) Function	00:04:00
	COUNT Function	00:07:00
	MIN & MAX Functions	00:06:00
	How To Count Your Field’s Unique Values	00:06:00
	GROUP BY Clause: Use Functions with Dimensions	00:08:00
	GROUP BY More Than One Dimension	00:06:00
	Now For Some Tough Workout	00:10:00
	Filter By Aggregate Functions with HAVING Clause	00:08:00
Unit 10: Functions in SQL: Single-Row Functions
	Character Functions – UPPER, LOWER & INITCAP	00:10:00
	Character Functions – CONCAT & LENGTH	00:10:00
	Character Functions – LPAD & RPAD	00:13:00
	Character Functions – TRIM	00:04:00
	Character Functions – REPLACE	00:12:00
	Character Functions – SUBSTR	00:10:00
	Number Functions – MOD & ROUND	00:11:00
	Number Functions – TRUNC	00:09:00
Unit 11: Nested Queries
	Selectception: A Select Query inside another Select Query!	00:06:00
Unit 12: Casting & Data Conversion
	Auto Data Conversion in SQL	00:11:00
	Cast Date to Character	00:10:00
	Cast Number to Character	00:09:00
	Cast Timestamp to Character	00:07:00
	Cast Character to Number	00:09:00
	Cast Character to Date & Timestamp	00:09:00
Unit 13: Combination Relationships
	UNION	00:03:00
	UNION ALL	00:02:00
	Important Note about Combining Queries	00:02:00
	INTERSECT	00:01:00
	EXCEPT	00:01:00
Unit 14: Joins in SQL
	Employees & Departments Tables Revised	00:04:00
	Entity Relationship Diagram (ERD)	00:10:00
	Cartesian Join	00:09:00
	Table Aliases with Joins	00:07:00
	Why I Don’t Recommend Cartesian Joins	00:08:00
	Inner Join	00:09:00
	In-Depth Look into Join Types in SQL	00:03:00
	Outer Join – Right, Left & Full	00:09:00
Unit 15: Data Manipulation (DML)
	INSERT a New Record to a Table	00:09:00
	Insert Without Specifying Column Names	00:11:00
	UPDATE a Record’s Field Values	00:07:00
	CAUTION! How an UPDATE Query Can Go Wrong	00:07:00
	Update a Record Using Single-Row Functions	00:04:00
	A Good Exercise: Extract Employee’s Email Address	00:02:00
	Solution: Extract Employee’s Email Address	00:13:00
	DELETE a Table’s Record	00:07:00
	Insert Records with Nested Select Queries	00:06:00
Unit 16: SQL Data Definition Language (DDL)
	SQL Data Types Revised	00:13:00
	Bookstore Data Set: Let’s Move It to Database	00:04:00
	Create Your First Table!	00:09:00
	Insert Data to Your New Table	00:08:00
	Change Column Data Type	00:07:00
	Rename Column	00:04:00
	Add a New Column to Table	00:04:00
	Constraints in SQL	00:01:00
	Primary Keys	00:14:00
	NOT NULL Constraint	00:05:00
	UNIQUE Constraint	00:04:00
	DEFAULT Constraint	00:04:00
	Foreign Keys	00:08:00
	Use Foreign Keys with Joins – Books & Publishers	00:06:00
	Foreign Keys – Properties	00:06:00
	Drop Column	00:01:00
	DROP Table	00:01:00
	Create a New Table with Select Statement	00:05:00
	A Trick to Create an Empty Table with Select Statement	00:03:00
	Insert New Records Using Select Statement	00:06:00
	Views	00:03:00
	Schemas	00:02:00
	Create & Use Schemas	00:04:00
Assignment
	Assignment -Mastering SQL Programming	00:00:00
Order Your Certificate
	Order your Certificate.	00:00:00

How do our courses work?

Purchase and payment

Once you've confirmed the details, proceed to complete the payment using your preferred payment method (credit/debit card, PayPal, etc.).

Course access

Upon completing the purchase, you'll receive an email containing instructions on how to access the course.

Certificate

After completing all the required modules or assessments within the course, you may be eligible to receive a certificate of completion.

Course Assistance

If you encounter any difficulties or have questions while taking the course, you can typically reach out to the course instructor or support team for assistance.

Chat with usLiveChat

Popular Courses

Login Now

Mastering SQL Programming

Mastering SQL Programming

Course Overview:

Learning outcomes:

Your Path to Success

Is This Course Right for You?

Assessment Process

Course Curriculum

How do our courses work?

Purchase and payment

Once you've confirmed the details, proceed to complete the payment using your preferred payment method (credit/debit card, PayPal, etc.).

Course access

Upon completing the purchase, you'll receive an email containing instructions on how to access the course.

Certificate

After completing all the required modules or assessments within the course, you may be eligible to receive a certificate of completion.

Course Assistance

If you encounter any difficulties or have questions while taking the course, you can typically reach out to the course instructor or support team for assistance.

Follow Us

Important Links

Ready to Go Courses

Certificate Code Validator

Mastering SQL Programming

Mastering SQL Programming

Course Overview:

Learning outcomes:

Your Path to Success

Is This Course Right for You?

Assessment Process

Course Curriculum

How do our courses work?

Purchase and payment

Once you've confirmed the details, proceed to complete the payment using your preferred payment method (credit/debit card, PayPal, etc.).

Course access

Upon completing the purchase, you'll receive an email containing instructions on how to access the course.

Certificate

After completing all the required modules or assessments within the course, you may be eligible to receive a certificate of completion.

Course Assistance

If you encounter any difficulties or have questions while taking the course, you can typically reach out to the course instructor or support team for assistance.

Related Courses

Start an IT Asset Department

View More

Follow Us

Important Links

Ready to Go Courses

Certificate Code Validator