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 تومان

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

خرید دانلودی فوری

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

تولید کننده: LinkedIn Learning (Lynda)