Booking options
£12
£12
On-Demand course
10 hours 47 minutes
All levels
17 sections • 117 lectures • 10:47:00 total length
•Introduction: 00:01:00
•Tools Used in This Course: 00:01:00
•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
•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
•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
•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
•Concatenate Strings with '||' Operator: 00:06:00
•Concatenate Strings with Numbers: 00:02:00
•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
•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
•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
•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
•Selectception: A Select Query inside another Select Query!: 00:06:00
•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
•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
•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
•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
•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 - SQL Programming Masterclass: 00:00:00
At Apex Learning, we share the goal of millions of people to mak...