indian authors for sql server book
-
Done:
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
[h2]Uurrrpp![/h2]
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Heh... get any on ya, Barry? 😛
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Jeff Moden (5/12/2009)
Heh... get any on ya, Barry? 😛Snacks for later. 😀
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
This is still alive? I thought this thread was dead and buried.
-Roy
-
Roy Ernest (5/13/2009)
This is still alive? I thought this thread was dead and buried.Yep. Dead and buried under a pile of pork chop bones 😉
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi -
Hello Anu1krishna,
You can buy below book on given link .
Structured Query language for all RDBMS and PL/SQL https://www.amazon.in/dp/9351282015/ref=cm_sw_r_em_apan_glt_i_1N5XRAZ9A9W87XAR29DW
with this book you can learn all major database ,not only SQL server.
Happy learning!
This book is available on amazon.com and many other web sites. Available in 44 country.
Kriti Sinha
-
Let's hope that, after nearly 13 years, the OP is still interested. 🙂
Looks like your book is getting some good reviews, Kriti. Congratulations.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Thank you very much Jeff.
Yes. This book is having all rdbms knowledge like Oracle, SQL server, my SQL, postgress, Sybase, MS Access with PL/SQL for all database.
So it is getting more popularity.
Thanks,
Kriti
-
Do you teach people how to count in the book?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Yes. All agrregate function explanation with syntax for all rdbms are available in this book.
-
Hello Jeff,
This book having all required knowledge for engineering students, IT developer, QA , PL/ SQL developer and support people, people preaparing for job interview or people preaparing for Oracle certification.
From basic to mid level, with very simple easy to understand English language.
Thanks,
Kriti
-
Hello Jeff,
Please find all chapter in detail below:
CONTENTS:- ?Acknowledgment and Dedications 11 Chapter 1- Introduction of RDBMS What is RDBMS? 13 1.1 RDBMS 1.2 Table 1.2.1 Max limit for number of column for single table 1.2.2 Properties of the Relational Tables 1.3 Field 1.4 Rows 1.5 Column Chapter 2- Normalization 17 2.1 Types of Normalization 2.1.1 First Normalization form 2.1.2 Second Normalization 2.1.3 Third Normalization 2.1.4 Boyce Codd Normal form 2.2 Benefit Of normalization 2.3 Drawbacks of Normalization 2.4 Relational Types Chapter 3- Introduction of Structured Query Language (SQL) 27 3.1 SQL revisions 3.2 SQL Process 3.3 Type of SQL 3.3.1 Data definition language 3.3.2 Data Manipulation language 3.3.3 Data control language 3.3.4 Transaction Control Language 3.3.5 Data Query Language Chapter 4- Data Types for Various RDBMS 33 4.1 Microsoft Access Data Types 4.2 MY SQL data Types 4.3 SQL server Data Types 4.4 Oracle Data Types Chapter 5- Data Definition Language 45 5.1 Create Table, 5.1.1 Syntax for My SQL 5.1.2 Syntax for SQL Server 5.1.3 Syntax for Microsoft Access 5.1.4 Syntax for Oracle 5.1.5 Creating table from an existing table 5.2 Alter 5.2.1 Alter Table, Column, Data Type and constraints 5.3 Drop 5.3.1 Drop table 5.3.2 Drop a Default constraint 5.4 Truncate Chapter 6- Integrity Constraints 59 6.1 Types of Integrity Constraints 6.2 Default Constraints Chapter 7- Data Manipulation Language 65 7.1 Insert 7.1.1 Insert Into 7.1.2 Insert Data only in specific Columns 7.1.3 Insert into remote data base 7.2 Update 7.3 Delete 7.3.1 Delete specific Data 7.3.2 Delete all data 7.3.3 Modifier for My SQL Delete statement 7.4 Merge Chapter 8- Synonymous 77 8.1 Types of synonyms Chapter 9- Data Control Language 81 9.1 Grant and Revoke. Chapter 10- Transaction Control Language 85 10.1 commit 10.2 Savepoint 10.3 Rollback Chapter 11- Data Query Language 89 11.1 Select 11.2 Order by 11.3 Group By 11.4 Having 11.5 Subquery 11.6 Subqueries with the insert statement 11.7 Subqueries with the Update statement 11.8 Subqueries with the Delete statement 11.9 Subqueries with EXISTS and NOT EXISTS 11.10 Correlated Sub Query Chapter 12- Functions 113 12.1 Aggregate functions 12.2 Built-In scalar functions 12.3 Numeric Functions 12.4 EXTRACT Function 12.5 MY SQL Date Parts Functions 12.6 String Functions 12.7 Vacuum 12.8 Rank 12.9 Dense Rank 12.10 ROW Number 12.11 NULL functions 12.12 Server Supported Functions 12.11.1 Microsoft SQL Server- Server Supported Functions 12.11.2 MY SQL - Server Supported Functions 12.11.3 Oracle Server- Server Supported Functions Chapter 13- Joins 157 13.1 Join Conditions 13.2 Types of Join 13.2.1 Inner Join 13.2.1.1 Equi Join 13.2.1.2 Natural Join 13.2.1.3 Cross Join 13.2.2 Outer Join 13.2.2.1 Left Outer Join 13.2.2.2 Right Outer Join 13.2.2.3 Full Outer Join 13.2.3 Self Join 13.2.4 Anti Join 13.2.5 Semi Join Chapter 14- Wild Cards Character 183 14.1 SQL supported wildcard operators in conjunction with the LIKE operator Chapter 15- Operators 187 15.1 Unary 15.2 Arithmetic Operators 15.3 Concatenation Operator 15.4 Combining AND & OR 15.5 Distinct Chapter 16- Aliases & Dot Notation 195 Chapter 17- Conditional (CASE) Expressions 199 17.1 Searched CASE expression 17.2 Select statement with CASE expression 17.3 Update Statement with CASE expression 17.4 ORDER BY clause with CASE expression 17.5 Having Clause with CASE expression 17.6 DECODE Chapter 18- View 205 18.1 View-Some Important point to keep in mind while creating view 18.2 Types of View 18.2.1 Read only View 18.2.2 Updateable View 18.3 SQL Dropping View 18.4 materialized View 18.4.1 Types of Materialized View Chapter 19- Introduction of PL/SQL 215 19.1Data Types 19.2 Variables or Scalar Variable 19.3 Constants 19.4 Operators 19.5 Conditions 19.6 Loops statement 19.6.1 Simple LOOP 19.6.2 FOR LOOP 19.6.3 REVERSE LOOP 19.6.4 WHILE LOOP Chapter 20- Stored Procedures 221 20.1 Parameters Modes 20.1.1 Parameter IN 20.1.2 Parameter OUT 20.1.3 Parameter IN OUT 20.2 Drop Stored Procedure Chapter 21- Cursor 231 21.1 Types of Cursors 21.1.1 IMPLICIT Cursor 21.1.2 EXPLICIT Cursor 21.2 Attributes of cursor 21.3 Cursor Declaration, Opening, Fetching and closing Chapter 22- Function 235 22.1 Function creation 22.2 Calling function 22.3 Dropping Function Chapter 23- Trigger 237 23.1 Types of Trigger 23.1.1 Statement level Trigger 23.1.2 Row level Trigger 23.1.3 Column level Trigger 23.1.4 For each Row Type Trigger 23.1.5 For each statement level Trigger 23.2 Triggering a Trigger Chapter 24- Collections 241 24.1 Types of Collections 24.1.1 Nested Table 24.1.2 Variables-Size Array or VArray 24.1.3 Index By tables/Associative Array 24.2 Collection Methods 24.2.1 FIRST and LAST 24.2.2 EXISTS 24.2.3 COUNT 24.2.4 LIMIT 24.2.5 EXTEND 24.2.6 TRIM 24.2.7 DELETE Chapter 25- Exceptions 251 25.1 Syntax of Exception handing 25.2 Raising Exceptions 25.3 User Defined Exception 25.4 Pre-Defined Exceptions Chapter 26- Packages 255 26.1 Advantages of package 26.2 Package specification 26.3 Package body 26.4 Using Package elements Chapter 27- DBMS-Output 259 27.1 DBMS_OUTPUT Subprograms Chapter 28- Practice set for Oracle Certification 261 Chapter 29- Some Important questions and answers for SQL and PL/SQL 287 Chapter 30- Glossary
-
Hey Jeff,
You managed to bring life to a post that is a decade old? 😛
-Roy
-
Heh... Nope. It's almost 13 years old and I wasn't the one that necro'd it. 😀 I congratulated the person that posted yesterday and asked a simple question.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 15 posts - 31 through 45 (of 48 total)
You must be logged in to reply to this topic. Login to reply