Practical Guide to SQL and Advanced Databases

PRACTICAL GUIDE TO
SQL AND ADVANCED
DATABASES
By María Belén Moreno




MATERIAL AND RESUMES OF BIOS SCHOOL OF SYSTEMS AND TECNOLOGIES
Montevideo, Uruguay

, Index
 Introduction and installation of the database environment
 Connecting to the database and stopping the server
 Database components 4
 Creating the database 5
 Definition statements and DML 6
 Querying records 9
 Clauses and Modifiers 9
 Subqueries and Data Types 10
 Server Functions and Stored Procedures 12
 Transactions 15
 Data Concurrency 18
 Users and Roles 21
 Permissions in SQL 23
 Indexes 24
 Views 27
 Inner Join Queries 28
 Outer Join Queries 29
 Acknowledgments and References 31




2