Para aquellos que deseen iniciar con SQL Server les recomiendo el libro "The Practical SQL Handbook: Using SQL Variants" de Judith S. Bowman, Sandra L. Emerson, y Marcy Darnovsky. Adjunto la tabla de contenidos.

 

Chapter 1. SQL and Relational Database Management 
This chapter of the book covers subjects like having a more elite level of english, searching for other routes of viewing data, and the security it need to carry out its duties. 
Chapter 2. Designing Databases 
This chapter of the book covers subjects like how to go about designing something upon a deliberation, knowing the way to do data entries and also the proper ways to review a database design. 
Chapter 3. Creating and Filling a Database 
This chapter of the book covers subjects like the proper ways to go about working with databases and also the ways to create indexes. 
Chapter 4. Selecting Data from the Database 
This chapter of the book covers subjects like seecting an overview about the syntax. 
Chapter 5. Sorting Data and Other Selection Techniques 
This chapter of the book covers subjects like on organizing the query results, order by order. 
Chapter 6. Grouping Data and Reporting from It 
This chapter of the book covers basically everything about NULLs. 
Chapter 7. Joining Tables for Comprehensive Data Analysis 
This chapter of the book covers subjects like what position joins hold in the comprehensive data analysis. 
Chapter 8. Structuring Queries with Subqueries 
This chapter of the book covers subjects like what position the subqueries hold and also if subqueries are better than joins when dealing with structures. 
Chapter 9. Creating and Using Views 
This chapter of the book covers subjects like how to view commands and on how much of an upper hand in viewing has. 
Chapter 10. Security, Transactions, Performance, and Integrity 
This chapter of the book covers subjects like having data security, the transactions it makes, the higher performance it has, and the integrity it has. 
Chapter 11. Solving Business Problems 
This chapter of the book covers subjects like how to properly use the SQL on the job and thinking it the wrong conditions.

 

Slds

Eduardo Castro – SQL Server

http://comunidadwindows.org

Technorati Tags:

LiveJournal Tags: