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.46 (1182 reviews)
6,263
students
9.5 hours
content
Dec 2024
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
Screenshots
Related Topics
3373806
udemy ID
7/28/2020
course created date
10/7/2020
course indexed date
Bot
course submited by