Sams Teach Yourself
4 total works
This hands on tutorial will provide readers with: - Thorough explanation of database concepts, SQL and low level programming - Complete code listings with output. These listings are followed with analysis that explains exactly what the listings are doing - Real world examples that can be incorporated in other projects - Fast results: Each chapter can be completed in one hour so the reader is productive almost immediately - Beginning-to- Intermediate coverage of SQL, including SQL in an enterprise setting, on the Web and Intranet.
Sams Teach Yourself SQL in 21 Days, Fourth Edition provides a sold foundation in understanding the fundamentals of SQL (Structured Query Language). SQL is the query language used by relational databases such a Oracle, Microsoft Access, and Microsoft SQL Server. The new edition covers object-oriented programming with SQL, ODBC, JDBC, embedded SQL, accessing remote databases, and constructs. All new examples based on an open source database such as MySQL enhance this new edition by making the examples readily useable for readers.
Sams Teach Yourself SQL in One Hour a Day
by Ryan Stephens, Ron Plew, and Arie D. Jones
The Fifth Edition of Sams Teach Yourself SQL in 21 Days
More than 48,000 sold!
In just one hour a day, you’ll have all the skills you need to begin creating effective SQL queries, reports, and database applications. With this complete tutorial, you’ll quickly master the basics and then move on to more advanced features and concepts:
- Quickly apply essential SQL techniques in useful, real-world queries
- Design trustworthy, high-performance databases
- Manipulate your data with views and transactions
- Leverage powerful features including stored procedures, triggers, and cursors
- Work with new objects introduced with the latest SQL standards
- Get practical, expert tips on implementing SQL in your business environment
Learn on your own time, at your own pace
- No previous SQL or database experience required
- Learn techniques that work with any current version of SQL
- Discover how to write faster, more efficient queries
- Secure your data using best practices from experienced database administrators
- Build more powerful databases with features exclusive to Oracle SQL*Plus, Oracle PL/SQL, and Microsoft Transact-SQL
- Write queries for the free, open source MySQL database
- Embed your SQL code in other applications
In just 24 lessons of one hour or less, Sams Teach Yourself SQL in 24 Hours, Sixth Edition, helps you use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security.
This book’s straightforward, step-by-step approach shows you how to work with database structures, objects, queries, tables, and more. In just hours, you will be applying advanced techniques, including views, transactions, web connections, and powerful Oracle and SQL Server extensions. Every lesson builds on what you’ve already learned, giving you a rock-solid foundation for real-world success.
Step-by-step instructions carefully walk you through the most common SQL tasks.
Practical, hands-on examples show you how to apply what you learn.
Quizzes and exercises help you test your knowledge and stretch your skills.
Notes and tips point out shortcuts and solutions.
Learn how to…
• Define efficient database structures and objects
• “Normalize” raw databases into logically organized tables
• Edit relational data and tables with DML
• Manage transactions
• Write effective, well-performing queries
• Categorize, summarize, sort, group, and restructure data
• Work with dates and times
• Join tables in queries, use subqueries, and combine multiple queries
• Master powerful query optimization techniques
• Administer databases and manage users
• Secure databases and protect data
• Use views, synonyms, and the system catalog
• Extend SQL to the enterprise and Internet
• Master important Oracle and Microsoft extensions to ANSI SQL
Register your product at informit.com/register for convenient access to downloads, updates, and corrections as they become available.