For SELECT queries, views, procedures, indexes, backing up databases and more. IT Specialist OD 201 (previously 98-364)
Instructed by Phillip Burton 9 hours on-demand video, 23 articles & 11 downloadable resources
After completing the course, you will…
-
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
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.
Recommended Courses
- MS SQL Server 2019. Programación de Bases de Datos con T-SQL
- SQL for Data Analysis – with SQL Server
- SQL Server T-SQL Veri Yönetimi ve Raporlama Eğitimi
- SQL and Transact-SQL (T-SQL) For Beginners
Deal Score+2
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.