Udemybeginneren

Pearson INF-201: Information Technology Specialist Databases

Learn Microsoft SQL Server T-SQL: SELECT queries, views, procedures, indexes & backups. Prepare for DP-600 certification.

4.7(1,206)
6,330students
9h 7m
Certificate
Phillip Burton • 950000+ students so far
Phillip Burton • 950000+ students so farBest Selling Instructor - over 950,000 students so far

Course Content

Pearson INF-201: Information Technology Specialist Databases is a beginner-level Udemy course taught by Phillip Burton • 950000+ students so far. It runs 9h 7m, is taught in English, and includes a certificate of completion. Learners rate it 4.7 out of 5 from 1,206 reviews, with 6,330 students enrolled. It is a paid course, last updated May 2025.

Get a solid foundation in database fundamentals with this comprehensive course, designed to prepare you for the Pearson IT Specialist Certification ITF-201 (also known as ITS-201 and ITN-201). This course focuses on Microsoft SQL Server and its powerful T-SQL language. In just a few hours, you'll gain practical skills in creating essential database objects like tables, writing effective queries, designing views, procedures, and more.

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

Here's what students are saying:

  • "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." - Seme
  • "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." - Gasper
  • "Explaining SQL on a very easy way! Takes you through everything you need to know nice and calm." - Jonas

What you'll learn:

  • SQL Fundamentals: Master the six clauses of the SELECT statement – SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY.
  • Data Storage & Normalization: Understand how data is structured in tables and the importance of normalization for building efficient and well-organized databases.
  • Data Constraints: Learn to define rules and constraints to ensure data integrity.
  • Data Manipulation: Develop skills in inserting, updating, and deleting data.
  • Database Objects: Create and utilize views, procedures, and functions.
  • Performance Optimization: Discover techniques to speed up queries using indexes.
  • Database Security: Implement basic security measures.
  • Data Backup: Learn how to back up your data.

No prior experience is needed! We'll even guide you through the free installation of SQL Server on your Windows desktop or laptop. Regular quizzes reinforce your learning, ensuring you retain key concepts.

Upon completion of this course, you'll possess a strong introductory understanding of how databases function and be able to construct your own SELECT statements. With practice, you'll be well-prepared to tackle the official IT Specialist exam and add a valuable certification to your CV/resume. Start building your database skills today!

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

5.0
33m
intermediate
pluralsight
5.0
25m
intermediate
pluralsight
5.0(117)
3h 7m
all
5.0(3)
1h 19m
beginner