Tutorial mainly uses syntax constructions of SQL-92 standard. It will help you to master in wide and varied possibilities for formulating queries of arbitrary complexity to relational databases. Each topic of the tutorial is followed by numbers of exercises, which may be solved online while the system controls the correctness of solutions. Some structures specific for MS SQL Server 2005 are also considered, in particular, the string and temporal functions.
This fourth installment covers data warehouse with multiple SQL requesters, the human roles in DBMS, when to use SQL, scaling, speed, price, universality, and analytic capabilities, among other areas. This book provides the reader with a firm grasp of SQL concepts.
Your boss has given you a mission. It sounds simple enough - you just need to create a few custom reports on your intranet that connect to your company-wide database. Well, what if suddenly you discover the database is a legacy monstrosity filled with arcane language and structures? What if, heavens forbid, nobody can understand it? How will you keep your job?
Now that you've learned exactly what SQL is (in my previous column), and how to use the standard SELECT functions, it's time to move ahead to other features. In this section, I'll be covering special grouping, logical and mathematical functions. These functions build upon what you've hopefully already learned, and allow you to leverage that to use SQL in your work.
In the previous two parts of this series, we looked at the underlying concepts of SQL and many of the basic SQL query components. In this, the third and final installment of the series, we'll look at why you'd want to use SQL, and an example of it in action, via the Microsoft Visual InterDev 6.0 programming environment.
This book will furnish readers with a firm grasp of SQL concepts that you can work with straight away, as well as provide solid foundations and challenging ideas with which you can later develop more advanced SQL techniques. This first excerpt covers the history of SQL, standards, terminology and the current state of SQL
This second installment covers procedural versus declarative languages, SQL's place in the data center and obtaining SQL. This book will furnish readers with a firm grasp of SQL concepts that you can work with straight away, as well as provide solid foundations and challenging ideas with which you can later develop more advanced SQL techniques.
This third installment covers configurations for using SQL, two and three tier architecture on a LAN, n-tier architecture on the Web, mainframe and terminals, and mainframe to mainframe. This book provides the reader with a firm grasp of SQL concepts
17 times | category:
this：1/125records total:9 Start Previous Next Last goto:
92 times | 
category: 