edX
Ops
BOOTCAMP
edXOps.COM
MICROSOFT SQL SERVER
04 WEEKS PROGRAM
Production-like Project
18 January 2021
WEEK ➂ - ADVANCED AND PROFESSIONAL PROGRAMMING
DAY ➊ - SQL-BASED SUBQUERIES AND CURSOR TYPES
Create the scalar-valued user-defined functions.
Create the table-valued user-defined functions.
Create the user-defined functions w or w/o XML Data.
Create the user-defined functions w or w/o JSON Data.
Define the DML queries for calling the user-defined functions.
Define the static cursor type for reading the data set.
Define the dynamic cursor type for processing the data set.
OUTCOME: Knows how to define the scalar-valued and table-valued user-defined functions, uses these
functions in the SQL-Based DML queries, and uses the static or dynamic cursors for monitoring the data in
database.
DAY ➋ - IMPLEMENTATION OF SQL-BASED TRANSACTIONS
Define the SQL-Based transaction commands in the Stored Procedures for. - Handling the DML Commands and the committed transaction.
- Handling the DML Commands and the Rollback transaction.
Implementation of the TRY CATCH block for handling the SQL-Based Transactions in the Stored Procedures.
Run and Test the SQL-Based transactions in the Database System.
OUTCOME: Knows how to implement the TRY CATCH block and the SQL-Based Transactions for
handling the rollback or committed transactions in Stored Procedures and READY to join the ADVANCED
DATABASE DEVELOPMENT team.
DAY ➌ - USER-DEFINED FUNCTIONS
Create the user-defined functions with the JSON Data.
Define the DML queries for calling the user-defined functions.
OUTCOME: Knows how to define the scalar-valued and the table-valued user-defined functions, uses
these functions in the SQL-Based DML queries.
DAY ➍ - IMPLEMENTATION OF TRIGGERS FOR DATABASE
SYSTEM
Design and Implement the DML Triggers for the Database Tables.
Design and Implement the of DDL Triggers for the Database Server.
OUTCOME: Proficiency to install and configure the SQL Server database and build the database structure
based on the database schema and READY to join the DATABASE EXPERT team.
DAY ➎ - USE SYSTEM STORED PROCEDURE AND TABLES
Use the SELECT query get information from the system TABLES.
Use the system STORED PROCEDURES to get information of the database.
OUTCOME: Proficiency to access and get information of SQL Server database as well as database
platform and READY to join DATABASE EXPERT team.
WEEK ➃ - DATABASE SECURITY AND ADMINISTRATION
DAY ➊ - BASIC OF DATABASE ADMINISTRATION
Practice the activities of the Backup and Restore the Database.
Practice the activities of the Shrink and Manage the Database Log.
Practice the activities of the SQL Profiler and the Monitor.
OUTCOME: Knows how to manage and control the enterprise database such as the SQL Server or the
Oracle database platform, schedule for execute the SQL-Based or the Stored Procedures and READY to
join the DATABASE ADMINISTRATION team.
DAY ➋ - LINKED SERVERS AND DATABASE REPLICATION
Install and Configure the Linked Servers.
- Making the connection between the database platforms. - Design the synonym for the database objects.
Implementation of the SQL Tuning and the SQL Optimization.
Use the SQL-Based DML queries to populate data from the linked database.
Implementation of the database replication and the distributed database.
OUTCOME: Proficiency to design and deploy the distributed databases and READY to join the
DATABASE EXPERT team.
DAY ➌ - REPORTING SERVICE AND BI REPORT
Install and Configure the Reporting Service.
Design the BI Report with the Stored Procedures.
Integrate the BI Report with the SharePoint Framework.
Integrate the BI Report with the Office 365 Apps.
Integrate the BI Report with the Power BI Apps.
OUTCOME: Proficiency to design and deploy the Reporting and READY to join the BI Report team.
DAY ➍ - INTEGRATION SERVICE AND SERVICE BROKER
Install and Configure the Integration Service.
Install and Configure the Service Broker.
Design the OLAP with the Stored Procedures.
DAY ➎ - DEMOSTRATION OF DATABASE SOLUTION
Design the Database Modeling and Database
Design the Database Schema and Relationship Diagram.
Create the SQL-Based Dynamic Queries.
Create the SQL-Based CRUD Stored Procedures.
Create the BULK XML CRUD Stored Procedures.
Create the BULK JSON CRUD Stored Procedures.
Apply the Cursor Types and two types of Triggers.
Design the Mechanism of Database Security and Storage.
Create the Transactions and Exception Handling.
Design the Reporting Services and SQL Tuning.
