وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

SQL Essential Training

سرفصل های دوره

The ubiquity of big data means that now, more than ever, there is a burning need to warehouse, access, and understand the contents of massive databases quickly and efficiently. Attaining proficiency in SQL is essential to prepare for our data-driven present and future. It is also crucial to furthering your skills as a data analyst or application developer. In this course, Walter Shields teaches you: the basic structure of databases—what they are, how they work, and how to successfully navigate them; how to use SQL to retrieve and understand data no matter the scale of a database; and how to master the most important SQL query syntax, along with how and when to use it best.


01. Introduction
  • 001. The data-driven world
  • 002. What you should know

  • 02. The Basics of Database Structures
  • 003. Relational database theory
  • 004. The SQLite database engine

  • 03. The SQL Stack
  • 005. WSDA Music (sample database)
  • 006. The DB Browser software
  • 007. How to install DB Browser
  • 008. Learning tips

  • 04. The SQLite Database Environment
  • 009. How to access the DB Browser for SQLite software
  • 010. Load the sample database file
  • 011. Getting familiar with a database
  • 012. The browse data area
  • 013. The query writing area

  • 05. Composing Queries
  • 014. Query commenting
  • 015. The Query Concept
  • 016. Query composition
  • 017. Query composition best practices
  • 018. Column custom names
  • 019. Sorting query results
  • 020. Limiting query results

  • 06. Discovering Insights in Data
  • 021. Types of SQL operators
  • 022. Filter and analyze numeric data
  • 023. BETWEEN and IN operators
  • 024. Filter and analyze text data
  • 025. Search records without an exact match
  • 026. Filter and analyze using dates
  • 027. Filter records based on more than one condition
  • 028. Logical operator OR
  • 029. Brackets and order
  • 030. IF THEN logic with CASE

  • 07. Accessing Data from Multiple Tables
  • 031. Joins explained
  • 032. How tables share a relationship Part 1
  • 033. How tables share a relationship Part 2
  • 034. Simplifying JOINs
  • 035. Types of JOINs
  • 036. The INNER JOIN
  • 037. The LEFT JOIN
  • 038. The RIGHT JOIN
  • 039. Tables and Entity Relationship diagrams
  • 040. Joining many tables

  • 08. SQL Functions
  • 041. Calculating with functions
  • 042. String, date, and aggregate function types
  • 043. Connecting strings
  • 044. Separating text
  • 045. UPPER and LOWER string functions
  • 046. Date functions
  • 047. Aggregate functions
  • 048. Nesting functions

  • 09. Grouping
  • 049. Grouping your query results
  • 050. Filtering with a grouped condition
  • 051. Grouping with the WHERE clause
  • 052. Grouping with the HAVING clause
  • 053. Grouping with the WHERE and HAVING clause
  • 054. Grouping by many fields

  • 10. Nesting Queries
  • 055. Subqueries and aggregate functions
  • 056. SELECT clause subquery
  • 057. WHERE clause subquery
  • 058. Non-aggregate subqueries
  • 059. IN clause subquery
  • 060. DISTINCT clause subquery

  • 11. Stored Queries
  • 061. View introduction
  • 062. Creating a view
  • 063. Editing a view
  • 064. Joining views
  • 065. Deleting views

  • 12. Adding, Modifying, and Deleting Data
  • 066. Analysis and administration
  • 067. Inserting data
  • 068. Updating data
  • 069. Deleting data

  • 13. Project Missing Money Matters
  • 070. Project challenges
  • 071. Project solution Part 1
  • 072. Project solution Part 2
  • 073. Project solution Part 3

  • 14. Conclusion
  • 074. Next steps and tips
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 10977
    حجم: 2473 مگابایت
    مدت زمان: 284 دقیقه
    تاریخ انتشار: ۱۰ اردیبهشت ۱۴۰۲
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید