SQL for Beginners: Learn the Structured Query Language for the Most Popular Databases including Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, and OraclePreston Prescott
Audible Hörbuch
Knowing how to craft S Q L queries and navigate your way around a database is an essential skill if are a Database Administrator, System Administrator, or Programmer. This book guides you step-by-step by teaching you how to create databases, populate those databases with data, extract just the data you need, and much more. The book uses plain, clear, and concise language all geared to helped you learn S Q L in the easiest manner possible. Here is just some of what you'll learn when you listen to S Q L for Beginners:
How to create and delete databases.
How to design tables and what data types to use when.
Ways to populate your database and tables with data.
How to change a table after it's been created.
How to extract all, or just some, of the data from a database.
How to retrieve and sort data.
Perform mathematical calculations using S Q L such as averaging, finding the largest number in a set, and more.
Format the data in a database including returning the data as all uppercase, lowercase, and more.
How to write efficient S Q L statements and clauses.
How and why to create relationships in your databases.
The difference between and inner, outer, right, and left join.
How to perform S Q L sub-queries.
How to construct complex S Q L statements using multiple clauses and operators
Ways to summarize the data in your databases.
And much more. . . .
Works with Microsoft S Q L Server, My S Q L, Maria D B, S Q Lite, I B M D B2, Postgre S Q L, Microsoft Access, and Oracle. You can use the S Q L queries and concepts found in S Q L for Beginners work on any S Q L database including S Q L Server, My S Q L, Postgre S Q L, and Oracle. Invaluable to computer programmers. . . . All but the simplest of computer programs interact with a database.
|