Wednesday, March 7, 2012

Data base learning resources?

Hello:

I'm a beginner in data bases and I'm looking for data base theory,learning, preactices and another resources. Can you recommend me books, e-books, journals, web sites and communities? I'll aprreciate your help.

Thanks.

You might want to start at the top of the posts; there is a listing here.

Give a look to the discussion here. A number of good books are referenced.

|||

My latest book "Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)" (Addison Wesley) is currently holding a 5-star rating on Amazon. It has helped thousands of developers at every skill level from beginner to pro.

I've written a dozen books over the years--many written while I was at Microsoft writing the data access help topics and Data Access Guides for Visual Basic versions 2-5. In my own books I wanted to provide a more independent and comprehensive set of documentation using a style and focus that Microsoft would not permit me to use. Since I focus almost exclusively on Visual Studio and SQL Server readers don’t have to be confused by irrelevant designs or features that don’t apply in their applications.

The 7th Edition is also designed for you--the beginner. It contains content designed to bring your skills up to speed across the wide spectrum of tools and .NET Framework classes you'll need to design, code, build, debug and deploy successful applications and server-side executables. I talk about how to design applications given your and your company's skills, requirements and constraints. I talk about how SQL Server works behind the scenes in a way that makes it easy to understand how to leverage its power. I show how to best use Visual Studio to leverage this power and how to use SQL Server Management Studio and the other SQL Server tools like the Profiler to manage the databases you create. I talk about SQL Server Express, SQL Server Compact Edition and all of the other editions as well, understanding that many readers need to leverage the free versions of SQL Server as they get up to speed or work to prototype a larger application.

Key topic coverage includes:

? Data access architectures and how to choose the best strategy for Windows Forms, ASP.NET, XML Web Services, and SQL Server CLR executables. Where do these make sense and how much will they cost to build and maintain?

? SQL Server and relational database fundamentals and inner-machinery. How does SQL Server work and why is it important that developers know?

? Making the development experience more productive through judicious use of the Visual Studio toolset, and how to know when the wizards can help.

? Using the latest ADO.NET data provider efficiently and safely.

? How to protect the security of your database–and your job–by avoiding common mistakes.

? How to build secure, efficient, scalable applications in less time with fewer resources–how to create faster code faster.

? How to leverage the potential of SQL Server CLR executables and knowing

when these features make sense.

? How to work with your DBA to maintain database integrity and security.

? Working with the new Visual Studio report controls to expose your organization’s data safely and easily with or without leveraging existing SQL Server Reporting Services technology.

The book also contains a GUID that can be used to gain access to the premium area on the book’s unique support website. There I provide additional errata and a question-and-answer area for those needing direct support from me and the other readers. The book includes a DVD that contains a wealth of examples and sample databases that illustrate the points in the book.

I hope this helps.

William Vaughn

Microsoft MVP, Mentor, Author, Dad, Granddad

No comments:

Post a Comment