Microsoft SQL Server 2016 – Database Development
Microsoft SQL servers are used across many organizations to manage their database across the enterprise. Database administration and management are key in operational efficiency and optimization of resources in companies. A Microsoft SQL Server 2016 Certification can boost one’s career and improve the job opportunities offered in systems and database administration as well as infrastructure specialists.
About This Course
Microsoft SQL Server will provide best practices for implementing database and programmability objects in SQL Server 2016. Upon completing this course, students will be able to configure, manage, and troubleshoot database objects.
Certification training includes under this:
- MCSA: SQL Server 2016 Database Development – This course covers the objectives for the 70-762: Developing SQL Databases exam.
Learning Objectives
Design and implement database objects
Implement programmability objects
Manage database concurrency
Optimize database objects and SQL infrastructure
Target Audience
- Web Developers
- Software Developers
- Programmers
- Anyone who wants to pass Exam 70-762
Curriculum
100 Lessons30h
Database Objects
Creating Tables
Dropping Tables
Altering Tables
Adding and Removing Columns
Duplicating Tables
Renaming Tables
Constraints
Naming Conventions
Data Types
Designing for Normalization
Database Denormalization
Practical Exercise
Indexes and Views
Columnstore Index
Programmability Objects
Triggers and Functions
Transactions and Isolation Levels
Managing Database Concurrency
Optimize SQL Database Objects and Infrastructure
Database Instances
SQL Server Performance
