This is an introduction to SQL, the database computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. Chapters cover creating and populating a database; queries; filtering; querying multiple tables; working with sets; data generation, conversion, and manipulation; grouping and aggregates; subqueries; table joins; conditional logic; transactions; indexes and constraints; views; and metadata. Examples and exercises use MySQL, which is freely available, although they also run on Oracle Database and SQL Server.
Check Catalog
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment