book

Getting Started with SQL

by Thomas Nield

February 2016

Beginner

131 pages

2h 38m

English

O'Reilly Media, Inc.

Book available

Read now

Unlock full access

How to Use This BookConventions Used in This BookUsing Code ExamplesO’Reilly Online LearningHow to Contact UsAcknowledgments
What Is SQL and Why Is It Marketable?Who Is SQL For?
What Is a Database?Exploring Relational DatabasesWhy Separate Tables?Choosing a Database SolutionLightweight DatabasesCentralized Databases
What Is SQLite?SQLiteStudioImporting and Navigating Databases
Retrieving Data with SQLExpressions in SELECT StatementsText ConcatenationSummary
Filtering RecordsUsing WHERE on NumbersAND, OR, and IN StatementsUsing WHERE on TextUsing WHERE on BooleansHandling NULLGrouping ConditionsSummary
Grouping RecordsOrdering RecordsAggregate FunctionsThe HAVING StatementGetting Distinct RecordsSummary
The CASE StatementGrouping CASE StatementsThe “Zero/Null” CASE TrickSummary
Stitching Tables TogetherINNER JOINLEFT JOINOther JOIN TypesJoining Multiple TablesGrouping JOINsSummary

Planning a DatabaseThe SurgeTech ConferenceATTENDEECOMPANYPRESENTATIONROOMPRESENTATION_ATTENDANCEPrimary and Foreign KeysThe SchemaCreating a New DatabaseCREATE TABLESetting the Foreign KeysCreating ViewsSummary
INSERTMultiple INSERTsTesting the Foreign KeysDELETETRUNCATE TABLEUPDATEDROP TABLESummary
Appendix A1 – Literal Expression QueriesAppendix A2 – Mathematical OperatorsAppendix A3 – Comparison OperatorsAPPENDIX A4 – Logical OperatorsAPPENDIX A5 – Text OperatorsAPPENDIX A6 – Common Core FunctionsAPPENDIX A7 – Aggregate FunctionsAPPENDIX A8 – Date and Time FunctionsDate FunctionsTime FunctionsDate/Time Functions
APPENDIX B1 – Further Topics of InterestAPPENDIX B2 – Improving Performance with IndexesAppendix B3 – Transactions

Content preview from Getting Started with SQL

About the Author

Thomas Nield has a business analyst background and works in revenue management at Southwest Airlines. Early in his career, he became fascinated with technology and bought dozens of books to master programming in Java, C#, and database design. He is passionate about sharing what he learns and enabling others with new skillsets, even if they do not work in IT. He enjoys making technical content relatable and relevant to those unfamiliar with or intimidated by it.