 Название: SQL Essentials For Dummies
Автор: Richard Blum, Allen G. Taylor
Издательство: For Dummies
Год: 2025
Страниц: 211
Язык: английский
Формат: pdf (true), epub
Размер: 10.1 MB
A right-to-the-point guide on all the key topics of SQL programming.
SQL Essentials For Dummies is your quick reference to all the core concepts of SQL—a valuable common standard language used in relational databases. This useful guide is straightforward—with no excess review, wordy explanations, or fluff—so you get what you need, fast. Great for a brush-up on the basics or as an everyday desk reference, this book is one you can rely on.
• Strengthen your understanding of the basics of SQL
• Review what you've already learned or pick up key skills
• Use SQL to create, manipulate, and control relational databases
• Jog your memory on the essentials as you work and get clear answers to your questions
SQL is the internationally recognized standard language for dealing with data in relational databases. SQL isn’t a general-purpose language, such as C++ or Java. Instead, it’s strictly designed to deal with data in relational databases. In this book, we cover how to use SQL to build and work with databases. Using SQL isn’t just about knowing the terms and keywords, it’s also about knowing when and how to use them to maximize performance of your application.
If you’re brand-new to the database world, start out in Chapter 1. It explains why databases are useful, and walks through a few of the different popular database software packages available. If you’re already familiar with database software packages, and you just want to dive into the nuts and bolts of working with databases, Chapters 2 through 5 cover all the things you’ll need to know to get a database up and running.
If you’re already an old hand at SQL and you want to dive into some more advanced topics, Chapters 6 through 8 cover the complicated world of database queries. There are plenty of ways to retrieve data from a database, but not all of them are efficient — especially if you have lots of data to work with!
Chapter 9 examines the dreaded security topic. If you’re just creating a database for your own use, feel free to skip this chapter, but if you work in an environment where lots of people are going to need access to your database, this chapter is a must. Knowing how to protect your data from prying eyes has become a hot topic these days, and it’s important to know just how to protect it. Finally, Chapter 10 provides ten tips for improving your database experience when using SQL to retrieve data.
Perfect for supplementing classroom learning, reviewing for a certification, and staying knowledgeable on the job, SQL Essentials For Dummies is the convenient, direct, and digestible reference you've been looking for.
Contents:
Introduction........ 1
CHAPTER 1: Getting to Know SQL.................. 5
CHAPTER 2: Creating a Database with SQL............... 13
CHAPTER 3: Drilling Down to the SQL Nitty-Gritty.... 27
CHAPTER 4: Values, Variables, Functions, and Expressions................... 51
CHAPTER 5: SELECT Statements and Modifying Clauses......................... 79
CHAPTER 6: Querying Multiple Tables with Subqueries.........................109
CHAPTER 7: Querying Multiple Tables with Relational Operators...............127
CHAPTER 8: Cursors....151
CHAPTER 9: Assigning Access Privileges..........163
CHAPTER 10: Ten Retrieval Tips..................175
Index.......179
Скачать SQL Essentials For Dummies
|
Навигация
Вход на сайт
Реклама
SQL Essentials For Dummies 
