SQL ADMIN

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 2012/2014

Course 20461D Querying Microsoft SQL Server 2014

                                                                                                    Duration: 40 hours

       Introduction to Microsoft SQL Server 2014
       Introduction to T-SQL Querying
       Writing SELECT Queries
       Querying Multiple Tables
       Sorting and Filtering Data
       Working with SQL Server 2014 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
       Querying data with Stored Procedures
       Programming with T-SQL
       Implementing Error Handling
       Implementing Transactions
       Improving Query Performance
       Querying SQL Server Metadata

CERTIFICATION:

       Exam 70-461 Querying Microsoft SQL Server 2014




 


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