Learning SQL : generate, manipulate, and retrieve data / Alan Beaulieu.
Material type: TextPublisher: Sebastopol, CA ; O'Reilly Media, Inc., 2020Edition: 3rd edDescription: xvi, 360 pages : illustrations ; 24 cmISBN: 9789352139781Other title: Learning Structured Query LanguageSubject(s): SQL (Computer program language) | Relational databasesDDC classification: 005.758Item type | Current location | Call number | Status | Date due | Barcode |
---|---|---|---|---|---|
Books | Institute of Public Enterprise, Library S Campus | 005.758 BEA (Browse shelf) | Available | 46646 | |
Books | Institute of Public Enterprise, Library S Campus | 005.758 BEA (Browse shelf) | Available | 46647 | |
Books | Institute of Public Enterprise, Library S Campus | 005.758 BEA (Browse shelf) | Checked out | 05/14/2024 | 46648 |
Includes index.
A little background
Creating and populating a database
Query primer
Filtering
Querying multiple tables
Working with sets
Data generation, manipulation, and conversion
Grouping and aggregates
Subqueries
Joins revisited
Conditional logic
Transactions
Indexes and constraints
Views
Metadata
Analytic functions
Working with large databases
SQL and Big Data
As data floods into your company, you need to put it to work right away-and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports.
There are no comments on this title.