Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Pearson INF-201: Information Technology Specialist Databases

Name: Pearson INF-201: Information Technology Specialist Databases
Rating: 4.8 (1250 reviews)

For Microsoft SQL Server T-SQL. SELECT queries, views, procedures, indexes, backups. ITF-201. Helps with DP-600

Highest Rated

Created byPhillip Burton • over one million students so far, I Do Data Limited

Last updated 5/2025

English

What you'll learn

create tables in a database, normalize the tables, and ALTER columns in the table.
Know what data type to use in various situations.
retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
JOIN two tables together, finding missing data.
INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table.
Create constraints, views, procedures and triggers
Create backups and restore data, and investigate security

Course content

21 sections • 115 lectures • 9h 17m total length

Introduction2:56
Welcome to Udemy0:35
The Udemy Interface3:05
Do you want auto-translated subtitles in more languages?1:20
Curriculum5:24
Explore database fundamentals with Microsoft SQL Server, detailing design, DDL, DML, data retrieval, normalisation, keys and foreign keys, encapsulation with views and procedures, plus security, backup, and restore.
Resources0:29

3.1i, 3.1j. The SELECT clause9:14
The FROM clause (one table), and how to save and export queries6:21
Practice Activity Number 1 - SELECT and FROM clauses0:25
Practice Activity Number 1 - The Solution3:00
The SELECT and FROM clauses
1.1. Entities, rows/records, columns/fields; NULL and NOT NULL12:18
1a. Understand what a table is and how it relates to the data that will be stored in the database, columns/fields, rows/records
2b. Understand what a relational database is
6a. Purpose of tables
What is NULL?
Table terminology

3.2b-g, 3.2i-n. The WHERE clause - Part 16:45
3.2b-g, 3.2i-o. The WHERE clause - Part 2 - using a subquery6:16
3.2m, 3.2n. The WHERE clause - Part 3 - Text and dates8:20
Explore the where clause with strings and dates, using single-quoted string literals, like with wildcards (% and _), and null checks (is null/not null) for create_date comparisons.
3.1h, 3.2h, 3.3a, 3.3c-g. The GROUP BY clause9:54
Explore how the group by clause creates totals with count, sum, min, max, and avg, handles nulls, uses distinct, and notes top and limit across SQL variants.
Practice Activity Number 2 - WHERE and GROUP BY clauses0:31
Practice Activity Number 2 - The Solution4:11
The WHERE and GROUP BY clauses

Changing to the msdb database0:12
3.3b. The HAVING clause5:41
The having clause filters aggregated results after a group by, enabling conditions on counts and other aggregates; unlike where, it operates after grouping and cannot use select aliases.
3.2a. The ORDER BY clause6:44
Practice Activity Number 3 - The HAVING and ORDER BY clauses0:20
Practice Activity Number 3 - The Solution2:47
The HAVING and ORDER BY clauses

Creating Database and 2.1a. how to create a table3:37
6b. create tables in a database by using proper ANSI SQL syntax
2.1ai, 2.1b. Designing the Employee table, determining the right fields to use8:16
2.1aii, 2.1aiii. Alter and drop tables by using proper ANSI SQL syntax6:06
Entering data using GUI and T-SQL8:50
Creating a second table, the Transaction table5:12
Create the transaction table with amount, date, and employee number using appropriate data types aligned with the employee table. Insert values, save the script, and run it.
Creating our own tables

The need for relational database management systems (RDBMS)4:30
How relations are established11:48
Explore how relations are established between tables using primary and foreign keys, and distinguish one-to-many, many-to-many, and one-to-one relationships, with ad hoc and explicit linking.
3.1a. JOINing two tables using an INNER JOIN8:22
3.1b-3.1e. extract data by using joins - other JOINs5:35
inner join
left join
cross join (Cartesian) - this can be done using SELECT * FROM tblA, tblB
two joins, including a junction table.
Find missing data using IS NULL4:36
3.1f. Self joins5:10
Creating new tables for Practice Activities0:12
Practice Activity Number 4 - Joining tables0:29
Practice Activity Number 4 - The Solution6:25
Practice activity 4 demonstrates creating a database and using inner, left outer, and full outer joins to combine tblStampNames and tblStampPurchases, identify matches and nonmatches, with table aliasing.
Joining tables

1.5a. Understand the reasons for normalization5:42
1.5b. the first three common levels of normalization8:55
When should you use denormalised?
What is OLTP (and OLAP)?
What is data redundancy?
Adding, altering and removing columns5:19
Practice Activity Number 5 - Adding columns, altering and removing columns0:13
Practice Activity Number 5 - The Solution2:38
Alter the table to add a rarity column as varchar, up to 20 characters, allowing nulls; then later change it to 30 characters and drop the column.
Understanding normalization, and adding, altering and removing columns

1.2a. What are Primary keys? and Creating Primary Keys10:35
14a. Understand the reason for keys in a database.
14b. Choose appropriate primary keys.
14c. Select appropriate data type for keys.
Primary keys shortcut5:24
Learn how to create primary keys quickly with inline declarations, compare inline and out-of-line constraints, and note auto-generated names and limitations when altering existing columns.
1.2b. Select appropriate fields for composite keys, and IDENTITY8:59
More about IDENTITY3:33
Practice Activity Number 6 - Primary keys and IDENTITY0:12
Practice Activity Number 6 - The Solution3:48
Primary keys and IDENTITY

Requirements

You need to know how to use a computer, and hopefully know how to use a spreadsheet.
No prior knowledge of SQL Server required.
SSMS cannot be installed on the Mac OS. If you wish to install it on a Mac, you will need either to dual boot into Windows or be running Parallel Desktop.
You don't even need SQL Server installed - I'll show you how to install it on your computer for free!
There is a 30-day refund policy on this Udemy course - see Udemy's refund policy.
Why not have a look at the curriculum below and see what you can learn?

Description

This course is the foundation for the Pearson IT Specialist Certification ITF-201 "Databases Fundamentals", which is also known as ITS-201 and ITN-201, and focuses on Microsoft SQL Server's T-SQL. Learn in just a few hours how to create tables, queries, views, procedures and more.

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.

What do people like you say about it?

Seme says "Thank you very much for your valuable course . I really enjoyed this course . Packed a lot of information , I found it very interesting and useful . Thank you ."

Gasper says "Phillip always does a great job, this is my third course from him. Passionate and informed, I will take as many courses as I can from him."

Jonas says "Explaining SQL on a very easyway! Takes you though everything you need to know nice and calm."

We start off by installing for free on your Windows desktop or laptop SQL Server, and learning how the six clauses of the SELECT statement - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.

We'll examine how data is stored in tables, and see why normalisation is important for the proper building of tables.

We'll then look at constraints, which allows you to set up rules for your data. Following this, how can we insert, update and delete data? We'll also create views, procedures and functions.

Finally, we'll investigate how to speed up your queries using indexes, add security, and back up your data.

No prior knowledge is required - I'll even show you how to install SQL Server on your computer for free!

There are regular quizzes to help you remember the information, so you can be sure that you are learning.

Once finished, you will have a good introductory knowledge of how databases work and be able to construct your own SELECT statements. And with a bit of practice, you could also go for the official IT Specialist exam - wouldn’t that certificate look good on your CV or resume?

Who this course is for:

This SQL course is meant for you, if you have not used SQL Server much (or at all), and want to learn T-SQL.
This course is also for you if you want a refresher on SQL. However, no prior SQL Server knowledge is required.
By the end of this course, after entering the official Practice Tests, you could enter (and hopefully pass) Microsoft's official 98-364 exam.
Wouldn't the "MTA: Database Fundamentals" certification look good on your CV or resume?

Pearson INF-201: Information Technology Specialist Databases

What you'll learn

Explore related topics

Course content

Introduction6 lectures • 14min

Installing SQL Server and SQL Server Management Studio (SSMS)3 lectures • 18min

3.2. Select data - Utilize SELECT queries to extract data from one table5 lectures • 31min

[3.2]. Select data - Utilize SELECT queries to extract data - WHERE and GROUP BY6 lectures • 36min

[3.2]. Select data - Utilize SELECT queries to extract data -HAVING and ORDER BY5 lectures • 16min

Let's explore tables6 lectures • 39min

Creating our own tables5 lectures • 32min

Joining tables9 lectures • 47min

13. Understand normalization5 lectures • 23min

14. Understand primary and composite keys6 lectures • 33min

Requirements

Description

Who this course is for: