18
- × Vegan and Vegetarian Cooking 1 × $29.50
- × PDF Certificate (Special Gift - 67% OFF) 9 × $7.07
- × Arabic Language for Beginners 1 × $29.50
- × Basic of Accounting 1 × $376.42
- × Selling E-books: Easy Way to Earn Online 1 × $376.42
- × Accounting Crash Course 1 × $376.42
- × Arabic: Speaking 1 × $29.50
- × Nutritional Therapy 1 × $29.50
- × CPA Marketing 1 × $29.50
- × Bash Shell Scripting Level 4 1 × $376.42
Subtotal: $1,716.79

View basket Checkout
LOGIN

Welcome to

Course Cloud

the best place for online learning!

Keep me logged in

Forgot Password?

Don’t have an account yet? Sign Up

Already have an account? Log In

By signing up, I accept Course Cloud’s Terms & Conditions

SQL Programming Masterclass

What Will I Learn? Able to select & filter data using SQL, fetch data for useful reports based on different …

★ ★ ★ ★ ★

0( reviews)

13 enrolled on this course

What Will I Learn?

Able to select & filter data using SQL, fetch data for useful reports based on different requirements.

Create & modify tables with setting constraints to columns.

Join tables using different join types SQL provides.

Manipulate data by adding new records & modifying or deleting existing ones.

Learn some of the most useful built-in functions in SQL, as well as data type conversion.

Brag about how cool they are knowing how to use SQL with their friends.

Course Overview

The comprehensive SQL Programming Masterclass has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the SQL Programming Masterclass today, and learn from the very best the industry has to offer!

This best selling SQL Programming Masterclass has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth SQL Programming Masterclass is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.

The SQL Programming Masterclass is CPD-accredited, so you can be confident you’re completing a quality training course will boost your CV and enhance your career potential. The SQL Programming Masterclass is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.

After successfully completing the SQL Programming Masterclass, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the SQL Programming Masterclass will help you stand out from the crowd. You can also validate your certification on our website.

We know that you are busy and that time is precious, so we have designed the SQL Programming Masterclass to be completed at your own pace, whether that’s part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.

Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Preview

Certification

After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).

Course Curriculum

Unit 01: Introduction
	Introduction	00:01:00
	Tools Used in This Course	00:01:00
Unit 02: Setting up Course Tools
	Download PostgreSQL	00:02:00
	Install PostgreSQL	00:03:00
	Download SQLectron	00:02: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:02:00
	FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data	00:08:00
Unit 03: Browsing & Filtering Data
	Check Imported Data	00:06:00
	What is a Database?	00:01:00
	SQL Data Types	00:02:00
	Finally Some Fun! Extracting Data Based on Requirements	00:01: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:05:00
	More Filtering by Date	00:03:00
	Another Query Filtering by Date	00:01:00
	Filter Data by Strings	00:04:00
	More Filtering by Strings	00:05: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:04: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:03: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:07:00
	Order Records by Column	00:06:00
	Order Records by Multiple Columns	00:12:00
	How Alias Names Cannot Be Used with WHERE	00:02:00
	LIMIT Record Count Fetched by Your Query	00:08: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:06: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:09: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:04:00
	How To Count Your Field’s Unique Values	00:04:00
	GROUP BY Clause: Use Functions with Dimensions	00:06:00
	GROUP BY More Than One Dimension	00:05:00
	Now For Some Tough Workout	00:09: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:08: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:09:00
	Character Functions – SUBSTR	00:10:00
	Number Functions – MOD & ROUND	00:11:00
	Number Functions – TRUNC	00:07: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:08: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:03:00
	Entity Relationship Diagram (ERD)	00:09: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:06:00
	In-Depth Look into Join Types in SQL	00:03:00
	Outer Join – Right, Left & Full	00:08:00
Unit 15: Data Manipulation (DML)
	INSERT a New Record to a Table	00:09:00
	Insert Without Specifying Column Names	00:09:00
	UPDATE a Record’s Field Values	00:07:00
	CAUTION! How an UPDATE Query Can Go Wrong	00:04: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:06: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:08: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
Resources
	Resources – SQL Programming Masterclass	00:00:00
Assignment
	Assignment – SQL Programming Masterclass	00:00:00