Items related to Structured Query Language
Synopsis
The foundation language to work with relational databases, SQL is the core language of data management. It is also a very good book to have whether you are new to databases or you just want to sharpen your data skills because this book is equipped with the necessary knowledge to be able to retrieve, modify and manage data successfully using SQL.
The book starts with theory of the database, detailing the relational databases and the basic syntax of SQL. It then moves to data retrieval and data manipulation operations, with advanced operations, including joins, subqueries and set operators. You will be taught how to manipulate the objects of a database that have indexes, views, and triggers, understand the advanced features of SQL such as window functions and common table expressions (CTEs) and how to create a query that is best optimized. The book goes on to hand you over to practical projects that put into practice all you have learned into real life situations to get you ready to be applied immediately to a practical situation.
At the end of the book, not only will you be familiar with the syntax and commands of SQL but you will be confident with your newfound knowledge by having introduced you to the world of SQL with guided projects that can simulate real job situations. With this book, you will be able to comfortably deal with relational databases and use SQL in your daily duties with numerous tools and platforms.
WHAT YOU WILL LEARN
* Master SQL basics, syntax and database schema.
* Develop effective and clean SQL statements with core commands.
Retrieval, filtering, sorting and aggregating data of relational databases.
* Add, update and delete records and retain data integrity.
* Combine two or more tables to bring out useful, interrelated data information.
* Manipulation and analysis of data by use of functions, operators, and clauses.
* Process data type, conversions and string manipulation methods.
"synopsis" may belong to another edition of this title.
Search results for Structured Query Language
Stock Image
Structured Query Language (Paperback)
Print on DemandSeller: Grand Eagle Retail, Bensenville, IL, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: new. Paperback. The foundation language to work with relational databases, SQL is the core language of data management. It is also a very good book to have whether you are new to databases or you just want to sharpen your data skills because this book is equipped with the necessary knowledge to be able to retrieve, modify and manage data successfully using SQL. The book starts with theory of the database, detailing the relational databases and the basic syntax of SQL. It then moves to data retrieval and data manipulation operations, with advanced operations, including joins, subqueries and set operators. You will be taught how to manipulate the objects of a database that have indexes, views, and triggers, understand the advanced features of SQL such as window functions and common table expressions (CTEs) and how to create a query that is best optimized. The book goes on to hand you over to practical projects that put into practice all you have learned into real life situations to get you ready to be applied immediately to a practical situation. At the end of the book, not only will you be familiar with the syntax and commands of SQL but you will be confident with your newfound knowledge by having introduced you to the world of SQL with guided projects that can simulate real job situations. With this book, you will be able to comfortably deal with relational databases and use SQL in your daily duties with numerous tools and platforms. WHAT YOU WILL LEARN * Master SQL basics, syntax and database schema. * Develop effective and clean SQL statements with core commands. Retrieval, filtering, sorting and aggregating data of relational databases. * Add, update and delete records and retain data integrity. * Combine two or more tables to bring out useful, interrelated data information. * Manipulation and analysis of data by use of functions, operators, and clauses. * Process data type, conversions and string manipulation methods. This item is printed on demand. Shipping may be from multiple locations in the US or from the UK, depending on stock availability. Seller Inventory # 9798247200437
Stock Image
Structured Query Language
Seller: PBShop.store US, Wood Dale, IL, U.S.A.
Seller rating 5 out of 5 stars
PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # L2-9798247200437
Stock Image
Structured Query Language
Seller: PBShop.store UK, Fairford, GLOS, United Kingdom
Seller rating 5 out of 5 stars
PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # L2-9798247200437
Buy New
US$ 16.48
US$ 4.45 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: Over 20 available
Stock Image
Structured Query Language (Paperback)
Print on DemandSeller: CitiRetail, Stevenage, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: new. Paperback. The foundation language to work with relational databases, SQL is the core language of data management. It is also a very good book to have whether you are new to databases or you just want to sharpen your data skills because this book is equipped with the necessary knowledge to be able to retrieve, modify and manage data successfully using SQL. The book starts with theory of the database, detailing the relational databases and the basic syntax of SQL. It then moves to data retrieval and data manipulation operations, with advanced operations, including joins, subqueries and set operators. You will be taught how to manipulate the objects of a database that have indexes, views, and triggers, understand the advanced features of SQL such as window functions and common table expressions (CTEs) and how to create a query that is best optimized. The book goes on to hand you over to practical projects that put into practice all you have learned into real life situations to get you ready to be applied immediately to a practical situation. At the end of the book, not only will you be familiar with the syntax and commands of SQL but you will be confident with your newfound knowledge by having introduced you to the world of SQL with guided projects that can simulate real job situations. With this book, you will be able to comfortably deal with relational databases and use SQL in your daily duties with numerous tools and platforms. WHAT YOU WILL LEARN * Master SQL basics, syntax and database schema. * Develop effective and clean SQL statements with core commands. Retrieval, filtering, sorting and aggregating data of relational databases. * Add, update and delete records and retain data integrity. * Combine two or more tables to bring out useful, interrelated data information. * Manipulation and analysis of data by use of functions, operators, and clauses. * Process data type, conversions and string manipulation methods. This item is printed on demand. Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability. Seller Inventory # 9798247200437
Buy New
US$ 20.89
US$ 50.05 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 1 available