SQL Server working with database

Microsoft SQL SERVER working with database

This course is intended for users who will work with the SQL SERVER database.

Minimal input knowledge: None in the ara of relational databases.

Topics for the course SQL SERVER working with database

• overview and familiarization with the Microsoft SQL Server environment
• installation and basic setup
• databases - creation and modification of databases, explanation and division by types
• tables - creating and editing tables, setting data types
• keys and relational relationships between tables
• creation of database diagrams
• working with data, creating and editing views, advantages of their use, working with data in tables
• ensuring data integrity
• working with data, filtering, working with multiple tables, connections, views, stored procedures, Triggers, transactions, types of locks and their use
• SQL language syntax
• T-SQL commands SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, ALTER TABLE
• interaction with MS Excel and MS Access
• discussion

Output knowledge: After completing the course, you will be able to work with SQL Server at the user level, i.e. understand the relational database system, be able to create a database, table, view and diagram and you will be able to use basic T-SQL commands