.png)
0 Reviews
17 Students
Course Highlights
Course HighlightsSQL is a programming language for retrieving and managing information stored in the relational database. Our SQL course covers various SQL topics to help you start your database programming.
The SQL Programming course will take you through the fundamental SQL concepts and explain how SQL works. Here, you’ll learn about different SQL tools for data management operations and understand how to install them. Gradually, the course will take you through browsing and filtering data. You’ll understand what a database is and learn about different SQL data types and the various methods for filtering data. Again, you’ll understand how to filter data with logical operators in SQL. The course will also teach you about SQL arithmetic operators and how to concatenate strings in SQL results.
Our SQL Course will also introduce you to different SQL functions. It will teach you about nested queries, casting and data conversion, combination relationships, and SQL joins. The course will also explain DML in SQL and familiarise you with the various DML commands in SQL. Finally, you’ll find a comprehensive SQL Data Definition Language (DDL) guide.
Learning outcome
Learning outcome- Understand the fundamentals of SQL and how to configure tools.
- Browse and filter data efficiently.
- For more complicated queries, use logical operators.
- SQL allows you to perform mathematical computations.
- Use sorting, aliasing, and record limit approaches.
- Handle NULL data by employing DISTINCT and CASE commands.
- Learn complex concepts, including nested queries and data joins.
Course media
Why should I take this course?
Why should I take this course?- Learn SQL from the ground up.
- Develop your data management skills.
- Improve your ability to run complicated data searches.
- Learn SQL functions and operations.
- Increase your chances of getting a job in a data-driven field.
Career Path
- Database Administrator
- Data Analyst
- SQL Developer
- Business Intelligence Analyst
- Data Engineer
- Data Scientist
- Software Developer
Requirements
Requirements- Basic understanding of computers.
- No prior SQL experience is required.
- Access to a computer or digital device with internet connectivity.
Mastering SQL Programming Reviews
A well-organised and highly valuable course with clear, easy-to-understand guidance throughout. I’ve gained knowledge that’s directly relevant to my day-to-day responsibilities. It’s given me greater confidence in applying these skills professionally.
Engaging content delivered in a straightforward and structured format. The examples were realistic and helped reinforce key concepts effectively. I would certainly recommend it to colleagues looking to upskill
Comprehensive, insightful and professionally presented from start to finish. The course materials were clear and well supported. A worthwhile investment for anyone serious about career development
Curriculum
-
Introduction
00:01:00
-
Tools Used in This Course
00:01:00
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:02: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 – Mastering SQL Programming
-
Assignment – Mastering SQL Programming
-
Order Your Certificate
Offer Ends in
TAKE ALL COURSES FOR £99
-
Duration:10 hours, 37 minutes
-
Access:1 Year
-
Units:119
