Share Your Knowledge

Write SQL statement for DDL language. Write SQL statement to implement all DMl& TCL Wite SQL statement for key constraints. write SQL statement to join two or more tables. write SQL statement to create,update and drop views write SQL statements for implementing nested queries write SQL statements for implementing set operations.

Here I made study material for unit 3 & 4 study along with your class notes for more information if you have any doubt put it in comments Chapter 3          Chapter 4

Hi Guys; Here I attached study material for joins and views. Have a look and practice it with different tables. Click here to download

Hi guys, Here I uploaded remaining topics of Chapter 2 Have a look, if you have any doubt post your commands!! chapter 2

Hi guys, Here I attached study material of Chapter 1 & Chapter 2, Have a look don't skip any topic  Click here to download   Chapter 1  Chapter 2

Dear students, As we know our unit one is covered and revised two times. Here I also attached few study materials ppt, teaching flow     click here to download  

·         To CREATE DATABASE statement is used to create a new SQL database. CREATE DATABASE databasename ; ·         To Drop Database DROP DATABASE databasename ; ·         To Create Table CREATE TABLE Persons (PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255)); ·                To Drop table DROP TABLE table_name ; ·                 To Alter table ALTER TABLE table_name ADD column_name datatype ; ·         To Add Constrains ALTER TABLE Persons ADD CONSTRAINT PK_Person PRIMARY KEY (ID,LastName); ·         To Drop Constrains ALTER TABLE Persons DROP CONSTRAINT PK_Person ; · ...

Hay there... here i uploaded study material for unit 1 click here to download >>>> follow this ppts to get a clear idea about our class

 Hi, Students! I hope every one gone through our Chapter 1 study material. And to add more value to chapter 1. I come with SQL Introduction and Queries. Have a look it will help us to do our practical section also.   SQL Introduction And Queries

Hello guys, I hope you all learned some important topics from my introduction classes. And I made study materials for beginners and chapter 1. Download and go through it if you have any doubt comment below!! For Beginner Chapter 1

Hi guys, Here you can find our new section syllabus for all courses  (B.TECH, M.TECH, B.Sc, M.Sc, Diploma) Click here to download

COMPARISON OF IBM, GEPHI, TABLEAU, SIMBA, AZURE, LAMBDA, HADOOP, SPARK AND R IBM WATSON ANALYTICS: Watson Analytics is a smart data analysis and visualization service we can use to quickly discover patterns and meaning in our data – all on our own. With guided data discovery, automated predictive analytics and cognitive capabilities such as natural language dialogue, we can interact with data conversationally to get answers we understand. Whether we need to quickly spot a trend or we have a team that needs to visualize report data in a dashboard, Watson Analytics has we covered. Anything with textual data would be a perfect scenario for this product as the ultimate aim for it was to create an instance which would be able to process textual data just like the way humans might do it. It can definitely parse textual data really well. It has some great features associated with it for analyzing the textual data. We don't have to know real world coding ...