Download Pearson INF-201: Information Technology Specialist Databases For Free!
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
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.
Password - HacksNation.com or Anduril
