Structured Query Language (T-SQL)

Microsoft SQL server is Microsoft proprietary extension. Learn Microsoft SQL Server from Industry Experts. In this course we will cover Microsoft SQL server development course. You can handle Microsoft SQL server development part after completion of this course.


Curriculum:

  • Introduction to RDBMS concepts
  • Normalization Technique
  • SQL Server Architecture
  • Introduction to Microsoft SQL Server
  • Introduction to SQL Server Management Studio
  • Installation of SQL server Management Studio
  • Introduction of Language Statements (DDL, DML, DCL, TCL)
  • Creating table and DDL commands
  • Introduction of Import and Export Wizard
  • SQL Data Types
  • SQL Constraints
  • SQL Indexing
  • Select Statement
  • SQL Distinct keyword
  • SQL Where Clause
  • SQL wild card concept
  • SQL Group by and Having clause
  • SQL CASE statements
  • Introduction of Join
  • Inner Join
  • Outer Join
  • Left Join
  • Right Join
  • Self Join
  • Cross Join
  • Concept of Nested Join with Where Clause
  • SQL Update Statement
  • SQL Insert Statement
  • SQL Delete Statement
  • SQL Transaction control Language
  • SQL Number Functions
  • SQL Date Functions
  • SQL Text Functions
  • SQL Special Functions
  • SQL Scalar Subqueries
  • SQL Multivalued Sub Queries
  • SQL Table Values Sub Queries
  • SQL Common Table Expression
  • SQL UNION, UNION ALL, INTERSECT AND EXCEPT
  • SQL CROSS APPLY operator
  • SQL RANK function
  • SQL DENSE_RANK function
  • SQL ROW_NUMBER function
  • SQL Over Clause
  • SQL If condition
  • SQL While Loop
  • Creating Stored Procedure
  • Modifying Stored Procedure
  • Creating User Defined Function
  • Modifying User Defined Function
  • SQL Pivot and Unpivot Concept
  • Implementing T-SQL Error Handling
  • Redirecting Errors with Try/Catch
  • Using THROW to pass an error message back to a client
  • Applying Error Handling in Stored Procedure
  • Applying Error Handling in Stored Procedure
  • Introduction of Cursor
  • Creating cursor
  • Modifying cursor
  • Detailed description about Index
  • Query optimization
  • Performance Tuning


Fee:

Online Virtual Class Room

Enroll in any above batch and attend live class at scheduled time

8000      


Offline Class Room

Visit our centre and enrol for the course, The course Fee will vary as per the Metro/ Non Metro or locality.

8000      




Upcoming Batches:



FAQ:

1. Who can learn this course?
Anyone who is interested and having prior computer knowledge can learn SQL Server.
2. What are the prerequisites for this course?
No prerequisite as such, if you have computer knowledge you can learn SQL server.
3. What are career opportunities from this course?
You can apply for jobs like SQL developer, SQL Analyst, database developer after covering this course.
4. How long this course will take?
This course will take 30 hours practical live class. After that you can practice as much as you can.
5. Will you provide soft copy material?
Yes, we will provide soft copy material and we will provide recording of our live classes.
6. I am working on Microsoft Excel, can I learn SQL server to enhance my skills?
Yes, you can learn SQL server and make your career in Data Analytics.
7. I don’t have any technical education; can I apply for this course?
Yes, this is very easy to lean. No technical background is required.
8. Will you start this course from scratch?
Yes. We will start this course from scratch


Reviews:



Jan-06-2021

Neha Sharma

Excellent course with very helpful content. Loved it so much. Learned a lot from this course.

Apr-23-2020

Rahul Gupta

Very interactive and good course for beginner. If it would have had more examples like to build some kind of application than i would be really nice.

Apr-21-2020

Pushpa Kumari

great course for beginner. If you want to learn SQL, this course is for you. If you forget the SQL query, then you should try to solve assignment. Instructor is a great person.

Apr-21-2020

Komal Sharma

Course is really informative, content and assignments are good.

Contact us

Phone: +91-9999468662 +91-9999468661

Email: info@wifilearning.com

Enquiry