Description
In this course, you will learn :
- SQL architecture, client/server relation, and database types
- Deploying several functions, operators, etc. for designing relational databases
- Modifying data using T-SQL, views, and stored procedures
- The concept of triggers and their creation
- Using records for searching, sorting, indexing, and grouping
- Database administrators, types, and SQL Server tools and services
- Backup and restoration of databases
- Optimizing database objects, managing database concurrency, and ensuring data integrity
Syllabus :
- Introduction to SQL
- Database Normalization and Entity Relationship Model
- SQL Operators
- Working with SQL: Join, Tables, and Variables
- Deep Dive into SQL Functions
- Working with Subqueries
- SQL Views, Functions, and Stored Procedures
- Deep Dive into User-defined Functions
- SQL Optimization and Performance
- Advanced Topics
- Managing Database Concurrency