TGx:Lynda - Learning SQL Programming [AhLaN]

Hot Picks

New TV

First Cam

New Movies

1080p x265

Misc

Torrent details for "Lynda - Learning SQL Programming [AhLaN]" Log in to bookmark

Quicknav > Description Read comments 0 Post guest comment

Torrent details

Name:

Lynda - Learning SQL Programming [AhLaN]

Controls:

Report Torrent

Torrent verified by PaladinNites

Category:

Other > Training

Language:

English

Total Size:

184.52 MB

Info Hash:

08d3a9f387be481af6f17fe4d4c9351b7e421c7c

Added By:

abidmail

Added:

17-07-2020 15:20

Views:

594

Update stats Post guest comment 0

Health:

Seeds:

Leechers:

Completed:

File	Size
1 - Introduction/01 - Welcome.mp4	5.28 MB
1 - Introduction/02 - Use the exercise files.mp4	5.22 MB
1 - Introduction/03 - Explore DB Browser.mp4	8.73 MB
1 - Introduction/04 - What is a database.mp4	4.03 MB
1 - Introduction/05 - What is SQL.mp4	8.98 MB
2 - 1. Ask for Data from a Database/06 - Ask for data with SELECT.mp4	6.93 MB
2 - 1. Ask for Data from a Database/07 - Narrow down a query with WHERE.mp4	6.94 MB
2 - 1. Ask for Data from a Database/08 - Add more criteria to a statement.mp4	12.49 MB
2 - 1. Ask for Data from a Database/09 - Limit responses.mp4	11.51 MB
2 - 1. Ask for Data from a Database/10 - Organize responses with ORDER BY.mp4	5.41 MB
2 - 1. Ask for Data from a Database/11 - Find information about the data.mp4	8.33 MB
3 - 2. Ask for Data from Two or More Tables/12 - Ask for data across two or more tables.mp4	10.67 MB
3 - 2. Ask for Data from Two or More Tables/13 - Understand JOIN types.mp4	11.74 MB
3 - 2. Ask for Data from Two or More Tables/14 - Combine results.mp4	6.71 MB
4 - 3. Data Types, Math, and Helpful Functions/15 - Data types in SQL.mp4	4.61 MB
4 - 3. Data Types, Math, and Helpful Functions/16 - Math in SQL.mp4	10.56 MB
4 - 3. Data Types, Math, and Helpful Functions/17 - Compound Select.mp4	7.68 MB
4 - 3. Data Types, Math, and Helpful Functions/18 - Transform data.mp4	13.79 MB
4 - 3. Data Types, Math, and Helpful Functions/19 - Use aliases to shorten field names.mp4	3.70 MB
5 - 4. Add or Modify Data/20 - Add data to a table.mp4	8.76 MB
5 - 4. Add or Modify Data/21 - Modify data in a table.mp4	6.67 MB
5 - 4. Add or Modify Data/22 - Remove data from a table.mp4	4.04 MB
6 - Conclusion/23 - Overcome common SQL mistakes.mp4	8.87 MB
6 - Conclusion/24 - Next steps.mp4	2.41 MB
Ex_Files_Learning_SQL_Programming/Exercise Files/quizresults.sql	212.28 kB
Ex_Files_Learning_SQL_Programming/Exercise Files/results.db	83.00 kB
Ex_Files_Learning_SQL_Programming/Exercise Files/statements.sql	7.07 kB
Glossary_Learning_Sql_Programming/Glossary_Learning_Sql_Programming.pdf	111.40 kB
Seed Me!!.png	42.05 kB

Description

---------------------------------------------------------------------------------

-----------------------------------------------------------------------------------
Proudly Presents
-----------------------------------------------------------------------------------
Lynda - Learning SQL Programming [AhLaN]

SUPPLiER.......: WWW RELEASE DATE......: 17/07/20
Uploader.......: abidmail Collector.........: ThomasKhan

... RELEASE iNFORMATiON ...

GENERAL INFO
Instructor : Scott Simpson
Duration : 1h 27m
Released : 8/15/2017

... About This Course ...

SQL (Structured Query Language) is a common tool for retrieving data from relational databases such as SQL Server, MySQL, MariaDB, and PostgreSQL. This course provides an introduction to this core programming language. Learn how to request data from a server, limit and sort the responses, aggregate data from multiple tables with joins, and edit and delete data. Instructor Scott Simpson also shows how to perform simple math operations and transform data into different formats.
Topics include:
Name the predicate of the following statement: SELECT EyeColor, Age FROM Student WHERE FirstName = 'Tim' ORDER BY LastName ASC;
Explain what to use to enforce the order in which an expression must be evaluated if the WHERE clause contains multiple expressions to evaluate.
Identify the best option to join two tables in a database to be able to display data from both.
List a data type that is not numeric.
Determine the result of running the following statement on a table containing columns col_1 and col_2:
INSERT INTO Box (col_1, col_2) VALUES ('A', 'B'), ('A', 'B'), ('A', 'B'), ('A', 'B');
Determine the best approach of deleting Jon Ramirez (ID 3452) from a Student table.