Udemy_SQL_-_Beyond_The_Basics

در این آموزش تصویری با دستورات SQL آشنا می شوید.
این دوره آموزشی محصول موسسه Udemy است.

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

  • کار با SQL
  • کار با اصطلاحات کلیدی
  • کار با دستور SELECT
  • کار با دستورات DML
  • نحوه دسترسی به فایل
  • کار با انواع داده ها
  • تبدیل انواع داده ها به یکدیگر
  • ایجاد جدول
  • نحوه استفاده از متغیرها
  • کار با کوئری ها
  • نحوه استفاده از subquery ها
  • نحوه استفاده از کلید واژه
  • کار با دستور case
  • کار با دستور ORDER BY
  • نحوه به روز رسانی داده ها
  • شماره گذاری رکوردها
  • فیلتر کردن گروه برای تعیین رتبه بالا
  • کار با توابع
  • استفاده از توابع UDF
  • استفاده از دستور UNION
  • کار با متغیر های سراسری
  • کار با حلقه ها
  • کار با دستورات SQL
  • مدیریت خطا
  • و…

عنوان دوره: Udemy SQL – Beyond The Basics
سطح: متوسط
مدت زمان: 4 ساعت و 30 دقیقه


توضیحات:

Udemy SQL - Beyond The Basics

Infinite Skills
4.5 hours
Intermediate Level

In this SQL - Beyond the Basics training course, expert author Guy Vaccaro will dive deeper into SQL and covers advanced techniques. This course is designed for users that already have experience with SQL. You will start by learning a variety of useful skills, including how to convert datatypes, create a temporary table, and declare and use variables. From there, Guy will teach you about sub queries, the CASE statement, and numbering and ranking.
This video tutorial also covers using built in functions, creating and using your own functions, and creating views. Finally, you will learn about stored procedures, such as how to create and run a stored procedure, loop with WHILE and IF, and dynamically build SQL statements. Once you have completed this computer based training course, you will have expanded your skills and be able to make more efficient use of SQL.
What are the requirements?
a working knowledge of SQL fundamentals
What am I going to get from this course?
create and interact with SQL databases at an intermediate to advanced level
utilize subqueries, variables, custom functions and more
What is the target audience?
students who have taken the introductory SQL course or who have a basic understanding of SQL


Section 1: The Warm Up
Lecture 1
Important - Download These First - Working Files
Article
Lecture 2
About This SQL Advanced Title
04:59
Lecture 3
Relational Databases And Key Terms Explained
07:45
Lecture 4
Recap Of SQL SELECT Command
07:38
Lecture 5
Overview Of The Other DML Statements
05:29
Lecture 6
How To Access Your Working Files
03:22
Lecture 7
Installing The Sample Data And Using The Working Files
03:05
Section 2: Useful Skills
Lecture 8
Converting Datatypes
07:58
Lecture 9
Creating A Temporary Table
06:02
Lecture 10
The DISTINCT And TOP Keywords In Action
05:20
Lecture 11
Indexing To Speed Up Your Life
08:00
Lecture 12
Declaring And Using Variables
06:50
Section 3: The Subquery
Lecture 13
What Is A Subquery?
06:00
Lecture 14
Subquery Vs Joins
04:59
Lecture 15
Using Correlated Subqueries
07:05
Lecture 16
Using The EXISTS Keyword
04:47
Lecture 17
Finding Duplicate Records
05:45
Section 4: The CASE Statement
Lecture 18
Getting Started With The CASE Statement
06:34
Lecture 19
Using The CASE Statement With Criteria On Multiple Columns
05:34
Lecture 20
Multiple Criteria Within The CASE Statement
06:10
Lecture 21
CASE In WHERE, ORDER BY, And GROUP BY Clauses
04:49
Lecture 22
CASE In UPDATE And INSERT Statements
06:33
Lecture 23
CASE Within Subqueries
06:04
Section 5: Numbering And Ranking
Lecture 24
Numbering Or Ranking Records In A SELECT Statement
06:20
Lecture 25
Filtering Results Based On Numbering Ranking
05:53
Lecture 26
Using Numbering Within Groups
04:45
Lecture 27
Filtering A Ranked Group To Determine Top N
05:17
Section 6: Functions
Lecture 28
Using Built In Functions
07:35
Lecture 29
Creating And Using Your Own Functions (UDF)
05:07
Section 7: Views
Lecture 30
Creating A View
05:20
Lecture 31
Example Views And Views In Views
05:06
Lecture 32
Using The UNION Clause
06:24
Section 8: Stored Procedures
Lecture 33
What Is A Stored Procedure?
08:03
Lecture 34
Creating A Stored Procedure
05:34
Lecture 35
Running A Stored Procedure
04:55
Lecture 36
Stored Procedures Within Stored Procedures
05:28
Lecture 37
The Global Variables @@Identity And @@Rowcount
08:06
Lecture 38
Looping With WHILE And IF
06:58
Lecture 39
Dynamically Build SQL Statements
07:43
Lecture 40
TRY And CATCH For Error Trapping
04:30
Lecture 41
Cursors In Use - Part 1
06:32
Lecture 42
Cursors In Use - Part 2
05:30
Lecture 43
Use Of Transactions
06:41
Section 9: Conclusions
Lecture 44
Wrap Up
06:37