Sql Server

No Reviews Yet

Birati, Kolkata

Course ID: 43333

Birati, Kolkata

Students Interested 0 (Seats Left 0)

No Reviews Yet

Date and Time

Not decided yet.

Amitava Majumder picture
Amitava Majumder

B.E (C.S.E)

About Amitava Majumder

I am an experienced Trainer and IT professional with over 10 years of experience in IT Sector and more than 5 years experience in tutoring students in various software technologies like Oracle (PL/SQL), C, C++, Java, Web Technologies, Computer Science/IT across School level students, college level students and working professionals who want to groom their career in IT and want to learn Software Technologies. So far, I have worked as a Senior Software Engineer for the Jubilant Retail, Keane (NTT-Data), TCS, System Solution and Total.
No reviews currently Be the First to Review

About the Course

SQL Server Course Overview


This course trains the students with all the (Transact-SQL) skills that are required to create database objects like Tables, Views, Stored procedures & Functions and triggers in SQL Server. Gives idea about writing Queries & Sub-queries, working with Joins, etc. As well as database management skills like backup, restore, etc.


SQL Server Training Prerequisite



  • 10+ years of experience in the areas of Database Applications using MS SQL server, Oracle in IT/Retail/Pharmacy sector


SQL Server Training Course Objective



  • Learn Database models

  • Overview of SQL Server Management Studio and Transact-SQL language

  • Master writing simple and complex queries that retrieve data from the database

  • Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)

  • Insert, update, and delete data

  • Retrieve data from tables

  • Joins

  • Sub-queries

  • Working with Data Types


SQL Server Training Course Content



  1. Introduction to T-SQL Querying

  2. Querying Tables with SELECT

  3. Querying Multiple Tables with Joins

  4. Using Set Operators

  5. Using Functions and Aggregating Data

  6. Using Subqueries and APPLY

  7. Creating Tables and Enforcing Data Integrity

  8. Using Table Expressions

  9. Grouping Sets and Pivoting Data

  10. Modifying Data

  11. Programming with Transact-SQL

  12. Implementing Transactions, Error Handling, and Dynamic SQL

  13. Designing and Creating Views, Inline Functions, and Synonyms

  14. Using Tools to Analyze Query Performance

  15. Implementing Indexes and Statistics

  16. Understanding Cursors, Sets, and Temporary Tables

  17. Understanding Further Optimization Aspects

  18. Sql server installation and troubleshooting.

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for SQL Server Training Post your requirement now

Enquire

Submit your enquiry for Sql Server

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Amitava

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more