MSSQL2016

At ITBMS, we recognize that different customers have different training needs. ITBMS meets the specific customer requirements by offering tailored training courses.

 


SQL Developer is a graphical tool for database development. It mainly allows you to browse objects, run SQL statements and SQL scripts and edit and debug PL/SQL statements.
With this tool, you can also run a number of provided reports or make your own and save them. SQL Developer is compatible with any kind of relational database that supports SQL. It supports Oracle, Microsoft SQL Server, Microsoft Access, flat file databases such as DBF, Paradox tables and any other ODBC-compatible database

Microsoft SQL Development 2016

Course 20761B Querying Data with Transact-SQL

                                                                                                    Duration: 40 hours

       Introduction to Microsoft SQL Server 2016
       Introduction to T-SQL Querying
       Writing SELECT Queries
       Querying Multiple Tables
       Sorting and Filtering Data
       Working with SQL Server 2016 Data Types
       Using DML to Modify Data
       Using Built-In Functions
       Grouping and Aggregating Data
       Using Sub queries
       Using Table Expressions
       Using Set Operators
       Using Window Ranking, Offset, and Aggregate Functions
       Pivoting and Grouping Sets
       Executing Stored Procedures
       Programming with T-SQL
       Implementing Error Handling
       Implementing Transactions

Course 20762B Developing SQL Databases

                                                                                                    Duration: 40 hours

       Introduction to Database Development
       Designing and Implementing Tables
       Advanced Table Designs
       Ensuring Data Integrity through Constraints
       Introduction to Indexes
       Designing Optimized Index Strategies
       Column store Indexes
       Designing and Implementing Views
       Designing and Implementing Stored Procedures
       Designing and Implementing User-Defined Functions
       Responding to Data Manipulation via Triggers
       Using In-Memory Tables
       Implementing Managed Code in SQL Server
       Storing and Querying XML Data in SQL Server
       Storing and Querying BLOBs and Text Documents in SQL Server
       SQL Server Concurrency
       Performance and Monitoring

CERTIFICATION:

       Exam 70-761 Querying Data with Transact-SQL
       Exam 70-762 Developing SQL Databases




 


Disclaimer: Course content, version and duration are subject to change without notice as a part of constant upgrade of the product by MICROSOFT TRAINING.

 

 

 

ContactUs.com