SQL
Andy Vickler
Book 1 :
Are you thinking about learning SQL, but not sure where to start?
Big data is prevalent now, with more data than we ever dreamed possible being made available . And all that data needs to be stored in such a way it can be easily...
Location:
United States
Description:
Book 1 : Are you thinking about learning SQL, but not sure where to start? Big data is prevalent now, with more data than we ever dreamed possible being made available . And all that data needs to be stored in such a way it can be easily accessed. That's where databases and SQL come in, providing the means to manage and interpret data easily. SQL is the go-to language for database management, the most reliable and widely used, and it's showing no signs of losing its popularity. This SQL guide for beginners covers all the basics you need to know about working with data and databases. The book is divided into six parts and includes instructions on downloading a sample database to work with throughout. If you are interested in learning SQL, this is the best place to begin and set yourself on course to become a master SQL programmer. Book 2 : 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. Book 3 : Many companies worldwide suffer from one fundamental problem, and that is the inefficient functioning of their databases. While many know of database tuning and work to cover that aspect, professional database developers, managers, and administrators always miss one thing: optimizing their queries to save maximum time and cost and provide the query efficiently. Duration - 14h 12m. Author - Andy Vickler. Narrator - Helpful Matthew. Published Date - Thursday, 04 January 2024. Copyright - © 2021 Andy Vickler ©.
Language:
English
Opening Credits
Duración:00:00:21
Opening credits for learn sql basics for beginners
Duración:00:00:11
Part 1 getting started
Duración:00:27:00
Part 2 querying, sorting, and filtering data
Duración:01:14:01
Part 3 oracle joins
Duración:00:41:54
Part 4 grouping data and subqueries
Duración:00:53:04
Part 5 data definition
Duración:00:35:42
Part 6 set operators and data types
Duración:01:31:48
Closing credits for learn sql basics for beginners
Duración:00:00:19
Opening credits for build complex sql queries
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
Closing credits for build complex sql queries
Duración:00:00:20
Opening credits for advanced sql query optimization techniques
Duración:00:00:11
Chapter 1 structured query language in oracle
Duración:00:29:47
Chapter 2 query processing & query optimization
Duración:00:12:50
Chapter 3 query optimization techniques
Duración:00:29:04
Chapter 4 query optimization tips and tricks
Duración:00:41:18
Chapter 5 using the rule based optimizer
Duración:00:39:26
Chapter 6 using the cost based optimizer and database
Duración:00:30:25
Chapter 7 reading an execution plan
Duración:00:12:14
Chapter 8 sql server query optimization techniques
Duración:00:52:07
Closing credits for advanced sql query optimization techniques
Duración:00:00:19
Ending Credits
Duración:00:00:28