UrbanPro
true

MS SQL

LIVE
2 reviews
Ongoing

Course offered by Prashant Kumar

2 reviews
  • 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
  • Procedure and Functions
  • Understand the different Views
  • Working with Triggers
  • Design a database
  • Maintain databases, tables, and sequences with SQL statements
  • Create and manage views
  • Ensure the integrity of multiple, related database updates by using transactions
  • Retrieve data using cursors
  • Manage binary data using BLOBs

Detailed syllabus:

 

  • File Management System And Its Drawbacks
  • Database Management System (DBMS) and Data Models
    • Physical Data Models
    • Logical Data Models
      • Hierarchical Data Model (HDBMS)
      • Network Data Model (NDBMS)
      • Relational Data Model (RDBMS)
      • Object Data Model (ODBMS)
      • Object Relational Data Model (ORDBMS)
  • Conceptual Data Models
    • Entity â?? Relationship (E-R) Model

Introduction To SQL Server

  • Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2
    • Connecting To Server
      • Server Type
      • Server Name
      • Authentication Modes
        • Sql Server Authentication Mode
        • Windows Authentication Mode
        • Login and Password
        • Sql Server Management Studio and Tools In Management Studio
          • Object Explorer
          • Object Explorer Details
          • Query Editor

TSQL (Transact Structured Query Language)


Introduction To TSQL

  • History and Features of TSQL
  • Types Of TSQL Commands
    • Data Definition Language (DDL)
    • Data Manipulation Language (DML)
    • Data Query Language (DQL)
    • Data Control Language (DCL)
    • Transaction Control Language (TCL)
    • Database
      • Creating Database
      • Altering Database
      • Deleting Database
      • Constrains
        • Procedural Integrity Constraints
        • Declarative Integrity Constraints
          • Not Null, Unique, Default and Check constraints
          • Primary Key and Referential Integrity or foreign key constraints
          • Data Types In TSQL
          • Table
            • Creating Table
            • Altering Table
            • Deleting Table

Data Manipulation Language

  • Insert
    • Identity
    • Creating A Table From Another Table
    • Inserting Rows From One Table To Another
    • Update
      • Computed Columns
      • Delete
        • Truncate
        • Differences Between Delete and Truncate

Data Query Language (DQL)

  • Select
  • Where clause
  • Order By Clause
  • Distinct Keyword
  • Isnull() function
  • Column aliases
  • Predicates
    • Between â?¦ And
    • In
    • Like
    • Is Null

Built In Functions

  • Scalar Functions
    • Numeric Functions
    • Character Functions
    • Conversion Functions
    • Date Functions
    • Aggregate Functions
      • Convenient Aggregate Functions
      • Statistical Aggregate Functions
      • Group By and Having Clauses
      • Super Aggregates
      • Over(partition by â?¦) Clause
      • Ranking Functions
        • Common Table Expressions (CTE)

Top n Clause


Set Operators

  • Union
  • Intersect
  • Except

Joins

  • Inner Join
    • Equi Join
    • Natural Join
    • Non-Equi Join
    • Self Join
    • Outer Join
      • Left Outer Join
      • Right Outer Join
      • Full Outer Join
      • Cross Join

Sub Queries

  • Single Row Sub Queries
  • Multi Row Sub Queries
    • Any or Some
    • ALL
    • Nested Sub Queries
    • Co-Related Sub Queries
      • Exists and Not Exists

Indexes

  • Clustered Index
  • NonClustered Index
  • Create , Alter and Drop Indexes
  • Using Indexes

Security

  • Login Creation
    • SQL Server Authenticated Login
    • Windows Authenticated Login
    • User Creation
    • Granting Permissions
    • Revoking Permissions
    • Roles

Views

  • Purpose Of Views
  • Creating , Altering and Dropping Indexes
  • Simple and Complex Views
  • Encryption and Schema Binding Options in creating views

Transaction Management

  • Introduction
  • Begin Transaction
  • Commit Transaction
  • Rollback Transaction
  • Save Transaction
  • Role Of Log File In Transaction Management
  • Implicit Transactions

TSQL Programming

  • Drawbacks Of TSQL that leads to TSQL Programming
  • Introduction To TSQL Programming
  • Control statements In TSQL Programming
    • Conditional Control Statements
      • If
      • Case
  • Looping Control Statements
    • While

Cursors

  • Working With Cursors
  • Types Of Cursors
    • Forward_Only and Scroll Cursors
    • Static, Dynamic and Keyset Cursors
    • Local and Global Cursors

Stored Sub Programs

  • Advantages Of Stored Sub Programs compared to Independent SQL Statements
  • Stored Procedures
    • Creating , Altering and Dropping
    • Optional Parameters
    • Input and Output Parameters
    • Permissions on Stored Procedures
  • User Defined Functions
    • Creating, Altering and Dropping
    • Types Of User Defined Functions
      • Scalar Functions
      • Table Valued Functions
        • Inline Table Valued Functions
        • Multi Statement Table Valued Functions
    • Permissions On User Defined Functions
  • Triggers
    • Purpose of Triggers
    • Differences Between Stored Procedures and User Defined Functions and Triggers
    • Creating, Altering and Dropping Triggers
    • Magic Tables
    • Instead Of Triggers

About the Trainer

Prashant Kumar picture

5 Avg Rating

2 Reviews

5 Students

3 Courses

Prashant Kumar

B.TECH (INFORMATION TECHNOLOGY)

1 Years of Experience

I have good hands of experience of those languages like C, C++, core Java, SQL and C# .
I did my courses from appin industrial, Naresh i tech Hyderabad, NIIT Coimbatore on it.
I have sets of questions on different stages of learning and coding too.
I will enjoy this job as it is related to my area of interest, I have web development knowledge on different Platform like eclipse, Visual studio 2015, Sql Server management studio 2013, aptana.

Reviews (2)

5 out of 5 2 reviews

Prashant Kumar https://p.urbanpro.com/tv-prod/member/photo/3915364-small.png Lado Sarai
5.0052
Prashant Kumar
A

MS SQL

"Mr. Prashant has proper knowledge in SQL, C & java. He is a good guide and prepare well for exams. His support toward his students is quite appreciable. I wish you for future. "

Prashant Kumar
S

MS SQL General

"Prashant sir has hands on experience with projects and that would help me to explore beyond my course. "

Reply by Prashant

Thanks Shashi Kant

View All
Have you attended any class with Prashant?

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

5 out of 5 2 reviews

Prashant Kumar https://p.urbanpro.com/tv-prod/member/photo/3915364-small.png Lado Sarai
5.0052
Prashant Kumar
A

MS SQL

"Mr. Prashant has proper knowledge in SQL, C & java. He is a good guide and prepare well for exams. His support toward his students is quite appreciable. I wish you for future. "

Prashant Kumar
S

MS SQL General

"Prashant sir has hands on experience with projects and that would help me to explore beyond my course. "

Reply by Prashant

Thanks Shashi Kant

Have you attended any class with Prashant?

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

MS SQL by Prashant Kumar

Prashant Kumar picture
LIVE
(2 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

MS SQL by Prashant Kumar

Prashant Kumar picture
LIVE
(2 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 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 7.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