Mastering SQL Programming
Mastering SQL Programming
Original price was: £425.£29Current price is: £29. ex Vat
Save 93.18 % - End OF Season Sale
OR
Or
Take All courses for £49
1 Year Access 
Intermediate
29 Students -
10 hours, 47 minutes
Get access to 5000+ courses including this for
Learning Outcome
- Start working with PostgreSQL and SQLectron.
- Be able to download, Install, Configure & Import Data if you are a WINDOWS 32-BIT USER.
- Check Imported Data.
- Learn what a database is and familiarise yourself with SQL Data Types.
- Learn how to Filter Data using WHERE Keyword, filter data by Range Using, filter data by Set of Values using INBETWEEN.
- Be able to calculate practically, consuming less time.
- Order records by multiple columns.
Description
The Mastering SQL Programming is the best way for you to gain deep insight and knowledge of this topic. You will learn from industry experts and obtain an accredited certificate after completing the course. Enrol now for a limited-time discounted price.
Like all the courses of One Education, this Mastering SQL Programming is designed with the utmost attention and thorough research. All the topics are broken down into easy to understand bite-sized modules that help our learners to understand each lesson very easily.
We don’t just provide courses at One Education; we provide a rich learning experience. After purchasing a course from One Education, you get complete 1-year access with tutor support.
Our expert instructors are always available to answer all your questions and make your learning experience exquisite.
After completing the Mastering SQL Programming, you will instantly get an e-certificate that will help you get jobs in the relevant field and will enrich your CV.
If you want to learn about this topic and achieve certifications, you should consider this Mastering SQL Programming from One Education.
There are no hidden fees or exam charges. We are very upfront and clear about all the costs of the course.
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
Will I receive a certificate of completion?
Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hard Copy Certificate for £15.
Why study this course
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.
The Mastering SQL Programming is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
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 – Mastering SQL Programming | 00:00:00 | ||
| Assignment | |||
| Assignment -Mastering SQL Programming | 00:00:00 | ||
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
