SQL Server

by The XL Academy Claim Listing

SQL Server course is offered by The XL Academy. The XL Academy is a capability-building and training solutions organization with deep industry experience and a flair for coaching.

₹8500

Contact the Institutes

Fill this form

Advertisement

The XL Academy Logo

img Duration

2 Months

Course Details

SQL Server course is offered by The XL Academy. The XL Academy is a capability-building and training solutions organization with deep industry experience and a flair for coaching. We are focused on developing skills in Basic & Advanced Analytics to emerge as “Industry Ready” professionals and enhance their career opportunities.

 

Course Content:

  • 1. SQL Overview
  • 2. RDBMS Concepts
  • 3. The Foundation Statements of T-SQL
  • 4. Started with SELECT Statement
  • 5. Adding Data with the INSERT Statement
  • 6. SQL Commands
  • DDL
  • DML
  • DCL
  • DQL
  • 7. SQL Data Types
  • 8. Basic Commands
  • Create Statement
  • Create Database
  • Create Table
  • Alter Statement
  • Alter Database
  • Alter Table
  • Drop Statement
  • Delete Statement
  • Update Statement
  • 9. SQL Operators
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • 10. Normalization
  • 1NF
  • 2NF
  • 3NF
  • 11. JOINS
  • INNER Join
  • LEFT Join
  • RIGHT Join
  • FULL Join
  • SELF Join
  • CARTESIAN Join
  • 12. SQL Constraints
  • PRIMARY KEY Constraints
  • FOREIGN KEY Constraints
  • UNIQUE Constraints
  • CHECK Constraints
  • DEFAULT Constraints
  • NULL Constraints
  • 13. SQL Clauses
  • WHERE Clause
  • ORDER BY Clause
  • GROUP BY Clause
  • HAVING Clause
  • TOP Clause
  • LIKE Clause
  • UNION Clause
  • UNION ALL Clause
  • 14. Adding More to Our Queries
  • What Is a Sub-Query?
  • Building a Nested Sub-Query
  • Correlated Sub-Queries
  • How Correlated Sub-Queries Work Correlated Sub-Queries in the WHERE Clause
  • 15. The EXISTS Operator
  • 16. Using EXISTS in Other Ways
  • 17. System Defined Functions:
  • AVERAGE
  • COUNT
  • MAX
  • MIN
  • SUM
  • SQRT
  • RAND
  • CONCAT
  • GROUP BY
  • HAVING
  • TRIM
  • LENGTH
  • And more.
  • Bangalore Branch

    GK Arcade, 125/1/18, Ashoka Pillar Rd, 1st Block, Bangalore
  • Pune Branch

    East Court Phoenix Market City, L-29, Clover Park, Pune
  • Mumbai Branch

    7th Floor, Chandak Chambers, Andheri - Kurla Rd, Mumbai
  • Thane Branch

    16th Floor, A Wing, Dev Corpora Cadbury Junction, Thane
  • Gurgaon Branch

    90, Mehrauli-Gurgaon Rd, Industrial Development Area, Sector 14, Gurgaon
  • Noida Branch

    D-9, Vyapar Marg, Block D, Sector 3, Noida

Check out more SQL Server courses in India

SEED Infotech Ltd Logo

SQL

SQL is a standard language for storing, manipulating and retrieving data in databases. SQL is used to communicate with a database. It is the standard language for relational database management systems.

by SEED Infotech Ltd [Claim Listing ]
KVCH Logo

Oracle 10G/11G DBA

Oracle is a system which has been built around a relational database management framework in which data can be accessed by users (or an application front end) without any deviation through a language known as Structured Query Language (SQL).

by KVCH [Claim Listing ]
Hubnet Education Logo

SQL

SQL course is offered by Hubnet Education. All of the Hubnet courses are well designed, adopting a convenient and thorough stack approach for IT job aspirants who need training to be job-ready and for IT professionals waiting to progress in their careers.

by Hubnet Education [Claim Listing ]
Vision Computer Academy Logo

Oracle

Oracle course is offered by Vision Computer Academy. Vision Computer Academy provides some of the most sophisticated, advanced and in-demand courses that will guarantee you an edge over all the computer literates in the market.

by Vision Computer Academy [Claim Listing ]
Prayosha Institute Logo

PL/SQL

PL/SQL course is offered by Prayosha Institute. Prayosha is a foremost Institute for career-oriented vocational courses. The students get trained through one-to-one student-mentor interaction, and intense practical training sessions.

by Prayosha Institute [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy