Contact for queries :
91-7259260117
hello

DATA BASE ADMINISTRATION

COURSE DESCRIPTION

TOSS Learning Provides best Database training in Bangalore.Our course includes the SQL/Database concept from basic to advance level.If you are looking for SQL training in Bangalore,TOSS Learning is the best option.
This course will be an advantage for you to perform programming jobs better and also  help you to get to better positions, with confidence, in case you are looking out for jobs.

COURSE SYLLABUS

    1.  Introduction to SQL Server and RDBMS
      Covers an overview of using relational databases. You’ll learn basic terminology used in future modules
    2.  SQL Server Tools overview
      SQL Server Management Studio is the primary tool used to create queries and manage objects in SQL Server databases
    3.  Single Table Queries
      Retrieve data from a single table and craft the result set by filtering rows and columns using the SELECT and WHERE clauses. We also cover using ORDER BY to sort the results.Keywords like Select, Distinct, Where, And & Or,Order By etc.
    4. Keys & Constraints
      Types of keys and constraints we can have a tables and their purpose.keywords like unique,primary ,foreign keys
    5.  Multi Table Queries
      To pull in data from multiple tables in your query. We will learn how to use INNER, SELF, CROSS, and OUTER joins as well as UNIONs,Keywords like Inner Join, Left Join, Right Join, Full Join, Union and MANY MORE…..
    6. Data Types
      We cover what SQL Server has to offer when it comes to storing different types of data. We cover major types that store text, dates, numbers and also look briefly at specialty types,Integer, Char, Varchar, nChar etc
    7. Working with built-in functions
      You’ll become acquainted with many of the built-in functions available in SQL Server.Keywords like Avg(),Count(), First(), Last(), Max(), Min(), Sum() and MANY More..
    8. Summarizing Data
      Cover aggregate functions which let you easily compute things like averages and totals over groups of rows,GROUP BY, HAVING, ROLL UP, CUBE etc..
    9. Modifying Data And Creating Tables, Views and Database
      We delve into the details of inserting, updating, and deleting data,
      Commands to create Tables, Views and Databases and few shortcuts & techniques
    10. Co-related Sub Queries
      Sub queries are a powerful tool for solving difficult problems. In this session, we cover how they work and where you can use them.We look at the various types of user defined functions available in SQL Server, how to use them, and how they compare to stored procedures.
    11. User Defined Functions
      We look at the various types of user-defined functions available in SQL Server, how to use them, and how they compare to stored procedures.
    12. Working with Stored Procedures
      We begin by writing simple stored procs and proceed to more complex procs that incorporate data validation and checking.
    13. T-SQL
      Cover the procedural extensions to the SQL language that allow you to work with variables, control structures, and error handlers.
    14. Introduction to Triggers and Cursors
      Introduction to Triggers and Cursors,Advanced SQL Queries for Analytics ,Merge, Dense Rank, Rank, Partition etc
    15. Advance Topics

    16. Writing dynamic Queries in SQL
      Writing dynamic Queries in SQL,Pivot tables in SQL Server Pivot tables in SQL Server
    17. Pivot tables in SQL Server
    18. Pivot tables in SQL Server
    19. Working with Views, CTE
    20. The common table expression (CTE) is a temporary result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement.
    21. Hierarchical Queries in SQL Server
    22. Manage data’s with hierarchical relation or parent-child relation of a specific table in SQL server.
    23. SQL Server Locks and Transactions
    24. To handle conflicts by wrapping action statements inside a transaction and controlling how aggressively SQL Server goes about locking data
    25. SQL Server and XML
    26. Learn about SQL Server’s XML data type and how XML schemas are used to validate XML data
    27. Advanced SQL Queries for Analytics
    28.  Database Security Basics
    29. SQL SERVER PERFORMANCE TUNING AND QUERY OPTIMIZATION

    30. Efficient Database design
    31. Knowing the way SQL Server platform works; knowing this can give you better long-term scalability, availability, and performance. Choosing the right data types when you’re designing your columns, tables, and indexes is really critical
    32. Performance Tuning Tools
    33. About various SQL server performance tuning tools.
    34. Understanding and Analyzing Execution Plan
    35. Understand and interpret query plans so you can pinpoint performance problems. The course starts by explaining the various methods of capturing query plans for later analysis.
    36. Indexing Basics
    37. Indexes are the most crucial objects of the database. They are the first stop for any DBA and Developer when it is about performance tuning.

Quick Enquiry

The Knowledge Hub

TOSS LEARNING

 

Join us and

Brighten your future.

CONTACT

#162 First floor

Kammanahalli Main Road

Near Kanti Sweets,

Bangalore   560084

7259260117, 080 42164019

 

WORKING HOURS

 

Monday to Saturday

    9 am – 8 pm

top
© Copyright 2018    |   All Rights Reserved   |  TOSS LEARNING
X