This course is designed for beginners and intermediate developers and administrators and defines the terminology, concepts, and skills you need to understand database modelling and objects, security requirements, SQL Server graphical tools, T-SQL scripts, and writing database queries, in addition to performing basic administration tasks and procedures.
Note: This course is designed for students interested in learning SQL Server 2016, 2017, 2019 or 2022. It covers the new features in SQL Server 2022, but also the important capabilities across the SQL Server data platform.
On successful Completion of this course you will be able to:
Core Database Concepts
Relational Concepts
Creating Databases and Database Objects
Programming with Transact-SQL - Using DDL,DCL & DML Statements
Basic Database Administration
Database and Instances
Instance Architecture
Database Architecture
SQL Server Security
Secure SQL Server databases and Objects
Backup and Recovery
Developing Microsoft SQL Server Databases Workshop