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
Duration:00:00:21
Opening credits for learn sql basics for beginners
Duration:00:00:11
Part 1 getting started
Duration:00:27:00
Part 2 querying, sorting, and filtering data
Duration:01:14:01
Part 3 oracle joins
Duration:00:41:54
Part 4 grouping data and subqueries
Duration:00:53:04
Part 5 data definition
Duration:00:35:42
Part 6 set operators and data types
Duration:01:31:48
Closing credits for learn sql basics for beginners
Duration:00:00:19
Opening credits for build complex sql queries
Duration:00:00:12
Introduction
Duration:00:03:07
Chapter 1 introduction to sql
Duration:00:18:06
Chapter 2 basic sql commands
Duration:00:07:43
Chapter 3 data types you can use inside of sql
Duration:00:13:14
Chapter 4 an introduction to numeric data types
Duration:00:10:45
Chapter 5 an introduction to character strings
Duration:00:06:31
Chapter 6 an introduction to datetimes
Duration:00:04:20
Chapter 7 an introduction to intervals
Duration:00:15:18
Chapter 8 manage the objects in your database
Duration:00:09:51
Chapter 9 retrieving data
Duration:00:28:22
Chapter 10 how to work with search results through sql
Duration:00:09:33
Chapter 11 an introduction to joins
Duration:00:23:11
Chapter 12 an introduction to subqueries
Duration:00:07:07
Chapter 13 an introduction to set operators
Duration:00:14:23
Chapter 14 rookie mistakes
Duration:00:10:12
Chapter 15 retrieving information from databases
Duration:00:08:13
Chapter 16 using sql with applications
Duration:00:21:00
Chapter 17 database security
Duration:00:10:08
Chapter 18 sql injections
Duration:00:07:00
Chapter 19 exercise
Duration:00:15:14
Chapter 20 case study
Duration:00:12:31
Conclusion
Duration:00:01:39
Closing credits for build complex sql queries
Duration:00:00:20
Opening credits for advanced sql query optimization techniques
Duration:00:00:11
Chapter 1 structured query language in oracle
Duration:00:29:47
Chapter 2 query processing & query optimization
Duration:00:12:50
Chapter 3 query optimization techniques
Duration:00:29:04
Chapter 4 query optimization tips and tricks
Duration:00:41:18
Chapter 5 using the rule based optimizer
Duration:00:39:26
Chapter 6 using the cost based optimizer and database
Duration:00:30:25
Chapter 7 reading an execution plan
Duration:00:12:14
Chapter 8 sql server query optimization techniques
Duration:00:52:07
Closing credits for advanced sql query optimization techniques
Duration:00:00:19
Ending Credits
Duration:00:00:28