Don't like banners? Log in and we will make sure you see no banners. For free.
Lynda - Learning SQL Programming [AhLaN]

Lynda - Learning SQL Programming [AhLaN]

Size
185 MB
Seeders
0
Leechers
1
Files
29
Category
Added
at 4:22pm GMT+1
Infohash
08d3a9f387be481af6f17fe4d4c9351b7e421c7c
Don't like banners? Log in and we will make sure you see no banners. For free.

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.








File list
  • Lynda - Learning SQL Programming [AhLaN]
  • 1 - Introduction/01 - Welcome.mp4 5.3 MB
  • 1 - Introduction/02 - Use the exercise files.mp4 5.2 MB
  • 1 - Introduction/03 - Explore DB Browser.mp4 8.7 MB
  • 1 - Introduction/04 - What is a database.mp4 4 MB
  • 1 - Introduction/05 - What is SQL.mp4 9 MB
  • 2 - 1. Ask for Data from a Database/06 - Ask for data with SELECT.mp4 6.9 MB
  • 2 - 1. Ask for Data from a Database/07 - Narrow down a query with WHERE.mp4 6.9 MB
  • 2 - 1. Ask for Data from a Database/08 - Add more criteria to a statement.mp4 12.5 MB
  • 2 - 1. Ask for Data from a Database/09 - Limit responses.mp4 11.5 MB
  • 2 - 1. Ask for Data from a Database/10 - Organize responses with ORDER BY.mp4 5.4 MB
  • 2 - 1. Ask for Data from a Database/11 - Find information about the data.mp4 8.3 MB
  • 3 - 2. Ask for Data from Two or More Tables/12 - Ask for data across two or more tables.mp4 10.7 MB
  • 3 - 2. Ask for Data from Two or More Tables/13 - Understand JOIN types.mp4 11.7 MB
  • 3 - 2. Ask for Data from Two or More Tables/14 - Combine results.mp4 6.7 MB
  • 4 - 3. Data Types, Math, and Helpful Functions/15 - Data types in SQL.mp4 4.6 MB
  • 4 - 3. Data Types, Math, and Helpful Functions/16 - Math in SQL.mp4 10.6 MB
  • 4 - 3. Data Types, Math, and Helpful Functions/17 - Compound Select.mp4 7.7 MB
  • 4 - 3. Data Types, Math, and Helpful Functions/18 - Transform data.mp4 13.8 MB
  • 4 - 3. Data Types, Math, and Helpful Functions/19 - Use aliases to shorten field names.mp4 3.7 MB
  • 5 - 4. Add or Modify Data/20 - Add data to a table.mp4 8.8 MB
  • 5 - 4. Add or Modify Data/21 - Modify data in a table.mp4 6.7 MB
  • 5 - 4. Add or Modify Data/22 - Remove data from a table.mp4 4 MB
  • 6 - Conclusion/23 - Overcome common SQL mistakes.mp4 8.9 MB
  • 6 - Conclusion/24 - Next steps.mp4 2.4 MB
  • Ex_Files_Learning_SQL_Programming/Exercise Files/quizresults.sql 212.3 KB
  • Ex_Files_Learning_SQL_Programming/Exercise Files/results.db 83 KB
  • Ex_Files_Learning_SQL_Programming/Exercise Files/statements.sql 7.1 KB
  • Glossary_Learning_Sql_Programming/Glossary_Learning_Sql_Programming.pdf 111.4 KB
  • Seed Me!!.png 42 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.