COURSE OVERVIEW
This course covers both the "whys" and "hows" of the MS SQL Server.
This SQL Server training teaches developers all the Transact-SQL skills they need to create database objects like Tables, Views, Stored procedures & Functions and triggers in SQL Server. Gives idea about writing Queries & Sub-queries, working with Joins, etc. As well as database management skills like backup, restore, etc.
Key Learning Areas
- Learn Database models
- Overview of SQL Server Management Studio and Transact-SQL language
- Master writing simple and complex queries that retrieve data from the database
- Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)
- Insert, update, and delete data
- Retrieve data from tables
- Working with Data Types
- Procedure and Functions
- Understand the different Views
- Design a database
- Maintain databases, tables, and sequences with SQL statements
- Create and manage views
