PLU | Introduction To SQL (2017 EN)

Discussion in 'Information Technology' started by Kanka, Jul 27, 2019.

  1. Kanka

    Kanka Well-Known Member Loyal User

    Messages:
    16,086
    Likes Received:
    446
    Trophy Points:
    83
    [​IMG]

    Company: Pluralsight
    Author: Jon Flanders
    Full Title: Introduction To SQL
    Year: 2017
    Language: English
    Genre: Educational: Databases
    Skill Level: Beginner
    Price: -
    -
    Files: MP4 (+ Slides .PDF)
    Time: 03:02:07
    Video: AVC, 1280 x 720 (1.778) at 15.000 fps, 200 kbps
    Audio: AAC at 63 Kbps, 2 channels, 44.1 KHz



    The vast majority of applications that use data, are backed by a good relational database system. This course will help to establish a base to those who want to begin learning Structured Query Language (SQL).

    Structured Query Language (SQL) is a special purpose language for interacting with relational databases. In this course, Introduction to SQL (Update), you will learn the basics of Structured Query Language. First, you will learn how to query data and shape results. Next, you will focus on creating and modifying data in your tables. Finally, you will touch on how actually modify the tables themselves. By the end of this course, you'll understand the basics of how to create and use a relational database.


    Lessons:
    1. Course Overview
    01. Course Overview
    2. Introduction
    02. Introduction
    03. The Relational Model
    04. Summary
    3. Understanding Basic SQL Syntax
    05. Introduction
    06. Basic SQL Commands - SELECT
    07. Basic SQL Commands - INSERT
    08. Basic SQL Commands - UPDATE
    09. Basic SQL Commands - DELETE
    10. Course Housekeeping
    11. Summary
    4. Querying Data with the SELECT Statement
    12. Introduction
    13. Demo - SELECT
    14. The SELECT List
    15. SELECT List Wildcard (*)
    16. The FROM Clause
    17. Demo - FROM Clause
    18. How to Constrain the Result Set
    19. DISTINCT and NOT DISTINCT
    20. Demo - Distinct
    21. Summary
    5. Filtering Results with the WHERE Clause
    22. The WHERE Clause
    23. Demo - WHERE Clause
    24. Boolean Operators
    25. The AND Keyword
    26. Demo - AND
    27. The OR Keyword
    28. Demo - OR
    29. Other Boolean Operators
    30. BETWEEN
    31. Demo - BETWEEN
    32. LIKE
    33. Demo - LIKE
    34. IN
    35. Demo - IN
    36. IS
    37. IS NOT
    38. Demo - IS AND IS NOT
    39. Summary
    6. Shaping Results with ORDER BY and GROUP BY
    40. Introduction
    41. ORDER BY
    42. Demo - ORDER BY
    43. Set Functions
    44. Demo - Set Functions
    45. Set Function And Qualifiers
    46. Demo - Set Function And Qualifiers
    47. GROUP BY
    48. Demo - GROUP BY
    49. HAVING
    50. Demo - HAVING
    51. Summary
    7. Matching Different Data Tables with JOINs
    52. Introduction
    53. CROSS JOIN
    54. Demo - CROSS JOIN
    55. INNER JOIN
    56. Demo - INNER JOIN
    57. OUTER JOINs
    58. LEFT OUTER JOIN
    59. Demo - LEFT OUTER JOIN
    60. RIGHT OUTER JOIN
    61. Demo - RIGHT OUTER JOIN
    62. FULL OUTER JOIN
    63. Demo - FULL OUTER JOIN
    64. SELF JOIN
    65. Summary
    8. Adding, Changing, and Removing Data
    66. Introduction
    67. INSERT
    68. Demo - INSERT
    69. BULK INSERT
    70. Demo - BULK INSERT
    71. UPDATE
    72. Demo - UPDATE
    73. DELETE
    74. Demo - DELETE
    75. Summary
    9. Creating Database Tables
    76. Introduction
    77. CREATE DATABASE
    78. Demo - CREATE DATABASE
    79. CREATE TABLE
    80. Demo - CREATE TABLE
    81. NULL Values
    82. PRIMARY KEY
    83. CONSTRAINT
    84. ALTER TABLE
    85. DROP TABLE
    86. Demo - CREATE TABLE
    87. Summary


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