SQL primer : an accelerated introduction to SQL basics /: an accelerated introduction to SQL basics. ([2018])

• Record Type: Book
• Further Information: Note: Rahul Batra.
• Authors: Batra, Rahul
• Contents: Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: An Introduction to SQL; The Relational Model and SQL; Advantages of Using SQL; SQL Commands Classification; Explaining Tables; Data Types in SQL; Chapter 2: Getting Your Database Ready; Using PostgreSQL; Using SQLite; Creating Your Own Database; Table Creation; Inserting Data; Writing Your First Query; Chapter 3: The Benefit of Constraints; The Null Constraint; Selective Fields INSERT; Check Constraints; Primary Key Constraint; Unique Key Constraints Differences Between a Primary Key and a Unique KeyChapter 4: Operations on Tables; Dropping Tables; Creating New Tables from Existing Tables; Modifying Tables; Showing Table Information in PostgreSQL; Showing Table Information in SQLite; Showing Table Information in Other DBMS's; Chapter 5: Writing Basic Queries; Selecting a Limited Number of Columns; Ordering the Results; Ordering Using Field Abbreviations; Ordering by Multiple Columns; Putting Conditions with WHERE; Combining Conditions; Chapter 6: Manipulating Data; Inserting Data into a Table from Another Table; Updating Existing Data Deleting Data from TablesChapter 7: Organizing Your Data; Normalization; Atomicity; Repeating Groups; Splitting the Table; Chapter 8: Doing More with Queries; Counting the Records in a Table; Using DISTINCT with COUNT; Column Aliases; Order of Execution of SELECT Queries; Using the LIKE Operator; Chapter 9: Calculated Fields; Mathematical Calculations; String Operations; Literal Values; Chapter 10: Aggregation and Grouping; Aggregate Functions; Using the Extreme Functions - MAX and MIN; Grouping Data; Grouping and Aggregate Functions; The HAVING Clause; Chapter 11: Understanding Joins Alternative Join SyntaxResolving Ambiguity in Join Columns; Outer Joins; Cross Joins; Self Joins; Non-Equi Joins; Chapter 12: Subqueries; Types of Subqueries; Existence Tests in Subqueries; Using Subqueries in INSERT Statements; Using ANY and ALL; Chapter 13: Working in Sets; Union; Intersection; Difference; Chapter 14: Views; Why Are Views Needed?; Creating a View; Modifying Data Through Views; Deleting Views; Chapter 15: Indexing; Creating an Index; Using EXPLAIN to See Indexes at Work; Unique Indexes; How Do Indexes Work?; Index Overheads; Deleting an Index Chapter 16: Access Control StatementsCreating New Users in PostgreSQL; Grant Privileges to Users; Revoking Privileges; Appendix A: Further Reading; Appendix B: Database Management Systems and Tools; Relational Database Management Systems; SQL Development Environments; Appendix C: A History of SQL and Relational Databases; The Rise of Sophisticated File-Oriented Systems; The Entry of Database Systems; Genesis of the Relational Model; The Hard Fought Battle of Query Languages; Index
• Publisher Details: New York : Apress
• Publication Date: 2018
• Extent: 1 online resource (xvii, 194 pages)
• Subjects: 005.75/65; Computer science; SQL (Computer program language); Relational databases; COMPUTERS / Programming Languages / SQL; Relational databases; SQL (Computer program language); Computer Science; Database Management; Database management; Computers -- Database Management -- General; Databases; Electronic books
• Languages: English
• ISBNs: 9781484235768; 1484235762; 1484235754; 9781484235751
• Related ISBNs: 9781484235751; 1484235754
• Notes: Note: Online resource; title from PDF title page (EBSCO, viewed June 20, 2018).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.