
SQL
Andy Vickler
Do you use SQL at work or at home and want to learn how to use the right functions and queries to extract the relevant details in the database? Do you want to learn how to generate the right views and more? If you answered yes, then you are in the right place.
Many companies collect information from different sources and use that information to improve their revenue. It is difficult to work with large volumes of data, but companies have to learn how to collect that information in data warehouses or databases. Only when the data is stored can it be analyzed and used to improve business decisions.
If you are using SQL for the first time, then this book is for you. You can use it as your guide through the various and needed aspects of querying. In this book, you will learn more about the language and how you can use it to extract the necessary information from the dataset. You will learn about:
● SQL and its benefits
● Various data types used in SQL
● How to manage and retrieve the relevant objects and data from the database
● Common mistakes and how to overcome them
● How to protect the database from hacking
● Using Joins, Subqueries, and Set Operators
● And more!
If you want to master SQL, then a little practice is required. Use the examples and exercises in this book to improve your skills and learn how to build complex SQL queries. So, what are you waiting for? Grab a copy of this book now!
Duration - 4h 18m.
Author - Andy Vickler.
Narrator - Helpful Matthew.
Published Date - Thursday, 04 January 2024.
Copyright - © 2021 Andy Vickler ©.
Location:
United States
Description:
Do you use SQL at work or at home and want to learn how to use the right functions and queries to extract the relevant details in the database? Do you want to learn how to generate the right views and more? If you answered yes, then you are in the right place. Many companies collect information from different sources and use that information to improve their revenue. It is difficult to work with large volumes of data, but companies have to learn how to collect that information in data warehouses or databases. Only when the data is stored can it be analyzed and used to improve business decisions. If you are using SQL for the first time, then this book is for you. You can use it as your guide through the various and needed aspects of querying. In this book, you will learn more about the language and how you can use it to extract the necessary information from the dataset. You will learn about: ● SQL and its benefits ● Various data types used in SQL ● How to manage and retrieve the relevant objects and data from the database ● Common mistakes and how to overcome them ● How to protect the database from hacking ● Using Joins, Subqueries, and Set Operators ● And more! If you want to master SQL, then a little practice is required. Use the examples and exercises in this book to improve your skills and learn how to build complex SQL queries. So, what are you waiting for? Grab a copy of this book now! Duration - 4h 18m. Author - Andy Vickler. Narrator - Helpful Matthew. Published Date - Thursday, 04 January 2024. Copyright - © 2021 Andy Vickler ©.
Language:
English
Opening Credits
Duración:00:00:12
Introduction
Duración:00:03:07
Chapter 1 introduction to sql
Duración:00:18:06
Chapter 2 basic sql commands
Duración:00:07:43
Chapter 3 data types you can use inside of sql
Duración:00:13:14
Chapter 4 an introduction to numeric data types
Duración:00:10:45
Chapter 5 an introduction to character strings
Duración:00:06:31
Chapter 6 an introduction to datetimes
Duración:00:04:20
Chapter 7 an introduction to intervals
Duración:00:15:18
Chapter 8 manage the objects in your database
Duración:00:09:51
Chapter 9 retrieving data
Duración:00:28:22
Chapter 10 how to work with search results through sql
Duración:00:09:33
Chapter 11 an introduction to joins
Duración:00:23:11
Chapter 12 an introduction to subqueries
Duración:00:07:07
Chapter 13 an introduction to set operators
Duración:00:14:23
Chapter 14 rookie mistakes
Duración:00:10:12
Chapter 15 retrieving information from databases
Duración:00:08:13
Chapter 16 using sql with applications
Duración:00:21:00
Chapter 17 database security
Duración:00:10:08
Chapter 18 sql injections
Duración:00:07:00
Chapter 19 exercise
Duración:00:15:14
Chapter 20 case study
Duración:00:12:31
Conclusion
Duración:00:01:39
Ending Credits
Duración:00:00:20