SQL for Beginners
- Learn the Structured Query Language for the Most Popular Databases including Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, and Oracle
- Narrated by: Elaine Kellner
- Length: 1 hr and 27 mins
- Unabridged Audiobook
- Release date: 14-05-15
- Language: English
- Publisher: Preston Prescott
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 SQL 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 SQL 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 SQL sub-queries.
How to construct complex SQL statements using multiple clauses and operators
Ways to summarize the data in your databases.
And much more....
Works with Microsoft SQL Server, MySQL, MariaDB, SQLite, IBM DB2, PostgreSQL, Microsoft Access, and Oracle. You can use the SQL queries and concepts found in SQL for Beginners work on any SQL database including SQL Server, MySQL, PostgreSQL, and Oracle. Invaluable to computer programmers.... All but the simplest of computer programs interact with a database.
Regular price: £6.79
Buy Now with 1 Credit
Buy Now for £6.79
Customer ReviewsMost Helpful
By Amazon Customer on 12-05-16
For the information, good, short, to the point.
The title explains it all. This is informative into a technical aspect of databases. I was just learning union statements. I'll give it a second listen.
1 of 1 people found this review helpful
By M.A.KP on 29-01-18
The information was step by step well said and to the point life is good....