Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Mastering SQL Programming has been specially designed to help learners gain a good command of Mastering SQL Programming, providing them with a solid foundation of knowledge to become a qualified professional.
Through this Mastering SQL Programming, you will gain both practical and theoretical understanding of Mastering SQL Programming that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.
Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.
Learning outcome
Familiar yourself with the recent development and updates of the relevant industry
Know how to use your theoretical knowledge to adapt in any working environment
Get help from our expert tutors anytime you need
Access to course contents that are designed and prepared by industry professionals
Study at your convenient time and from wherever you want
Affordable premium-quality E-learning content, you can learn at your own pace.
You will receive a completion certificate upon completing the course.
Internationally recognized Accredited Qualification will boost up your resume.
You will learn the researched and proven approach adopted by successful people to transform their careers.
You will be able to incorporate various techniques successfully and understand your customers better.
Requirements
No formal qualifications required, anyone from any academic background can take this course.
Access to a computer or digital device with internet connectivity.
Course Curriculum
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:02: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
Don't just take our word for it
Amazing workshop.
Very informative for the freshers like me. Learned a lot of things about digital marketing. I'm really thankful.
Aarini Sinha
It was a great experience. The course was jampacked with excellent information. And when I needed help, Skill-up helped me with technical problems instantly. Fast feedback.
Varsha Sivamohan
I am currently signed on to several courses with skill up. I have just finished my second one. The courses are informative and good for all types of learners. I recommend them.
Judith Taylor
The support team was FANTASTIC!!! Very quick to respond and even though I was nervous as I am not good at tests, they made me feel comfortable.
I am very grateful for the support
Charlie Anderson
Completed the Level 3 Mental Health Support Worker course, very good and highly recommend it.
Very good course, enjoyed it thoroughly and important in my line of work as a Support worker.
Parmjit Dosanjh
I am pleased to have completed my online course in Mental Health First Aid with SkillUp. All the modules were detailed & comprehensive with review questions, which really helped me to grasp the information & prepared me well for the mock test & final exam.
Shan
I was a bit nervous about the course but I gave a try,it's perfect and I still can't believe I paid a peanut to acquire such a course,the sliding show and introduction was well understood.i will recommend skill up to anyone interested to persuade a meaningful career,and also to the support team keep doing the good work.💪
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.