Learning SQL

Learning SQL

Updated for the most recent database administration platforms -- together with MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory consultant gets you up and operating with SQL quick. even if you want to write database functions, practice administrative initiatives, or generate stories, Learning SQL, moment variation, can assist you simply grasp the entire SQL fundamentals.

Each bankruptcy provides a self-contained lesson on a key SQL proposal or strategy, with quite a few illustrations and annotated examples. workouts on the finish of every bankruptcy allow you to perform the talents you study. With this booklet, you will:

  • Move quick via SQL fundamentals and research a number of complex features
  • Use SQL information statements to generate, control, and retrieve data
  • Create database gadgets, akin to tables, indexes, and constraints, utilizing SQL schema statements
  • Learn how facts units engage with queries, and comprehend the significance of subqueries
  • Convert and manage information with SQL's integrated services, and use conditional common sense in info statements

Knowledge of SQL is a needs to for interacting with information. With Learning SQL, you will fast easy methods to placed the facility and adaptability of this language to work.

Show sample text content

Download sample