Pearson INF-201: Information Technology Specialist Databases
For Microsoft SQL Server T-SQL. SELECT queries, views, procedures, indexes, backups. ITF-201. Helps with DP-600
4.56 (1189 reviews)
6 290
students
9.5 hours
content
May 2025
last update
$84.99
regular price
What you will 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 Gallery
Loading charts...
Comidoc Review
Our Verdict
This course provides an exceptional foundation in Microsoft SQL Server T-SQL and is particularly well-suited for individuals pursuing ITF-201 or DP-600 certification. While the expert instruction and wealth of examples contribute to its value, beginners may struggle with the quick pace at times. Despite minor issues, such as occasional ambiguity and disorganization due to examination requirements, it remains a highly relevant and resourceful learning opportunity.
What We Liked
- Comprehensive coverage of Microsoft SQL Server T-SQL, ideal for ITF-201 and DP-600 exam preparation
- Real-world examples and numerous exercises to reinforce understanding
- Expert instructor skilled at differentiating between fundamental and advanced concepts
- Valuable course updates reflecting the latest best practices (as of December 2024)
Potential Drawbacks
- Instructor's rapid pace might intimidate beginners with limited programming experience
- Insufficient focus on formal definitions for logical and comparison operators
- Disjointed flow due to certification exam specifications, leading to some repetition
- Occasional ambiguity regarding exam-specific vs. practical knowledge application
Related Topics
3373806
udemy ID
28/07/2020
course created date
07/10/2020
course indexed date
Bot
course submited by