پیشنهاد فرادرس

آموزش دستورات SQL

دسته بندی ها: آموزش SQL Server ، آموزش های یودمی (Udemy) ، پایگاه داده ، آموزش SQL

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

به این نوشته امتیاز دهید 1 2 3 4 5 بدون امتیاز
Udemy SQL - Beyond The Basics

پیشنهاد فرادرس

لینک های دانلود حجم فایل: 440.0MB Udemy SQL - Beyond The Basics_git.ir.rar