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

SQL Server Essentials, from Scratch

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

Step-by-Step Beginner's Training Course in SQL Server. No prior database knowledge is needed.


01 - Foundation
  • 001 Welcome
  • 002 SqlEssentials-Learning-Plan.pdf
  • 003 SqlEssentials-Learning-Outline.pdf
  • 004 SqlEssentials-Pre-Assessment.pdf
  • 005 SqlServerVocabularyWorksheet.pdf
  • 006 Installing SQL Server Developer Edition
  • 007 Installing SQL Server Management Studio
  • 008 Installing Training Database - SQLTrainingOnlineSimpleDB
  • 009 Installing Training Database - AdventureWorks
  • external-links.txt

  • 02 - Module #1 Introduction to Databases
  • 001 Lesson #1 Overview of Databases
  • 001 Lesson-1-Introduction-to-Databases-Review.pdf
  • 001 Lesson-1-Sql-Training-Academy-Overview-of-Databases.pdf
  • 002 Lesson #2 SQL How to Talk to Databases
  • 002 Lesson-2-SQL-How-to-talk-to-Databases-Review.pdf
  • 002 Lesson-2-Sql-Training-Academy-SQL-How-to-talk-to-a-database.pdf
  • 003 Lesson #3 Client-Server Relationships Part 1
  • 004 Lesson #4 Client-Server Relationships Part 2
  • 004 Lesson-3-and-4-Client-Server-Relationships-Review.pdf
  • 004 Lesson-4-Sql-Training-Academy-ClientServerRelationship.pdf

  • 03 - Module #2 Management Studio
  • 001 Lesson #5 Introduction Management Studio Part 1
  • 002 Lesson #6 Introduction Management Studio Part 2
  • 002 Lesson-5-and-6-Introduction-Management-Studio-Review.pdf
  • 002 Lesson-6-Sql-Training-Academy-Management-Studio-Overview.pdf
  • 003 Lesson #7 Database Objects Part 1
  • 004 Lesson #8 Database Objects Part 2
  • 004 Lesson-7-and-8-Database-Object-Hierarchy-Review.pdf
  • 004 Lesson-8-Sql-Training-Academy-Database-Objects.pdf
  • 005 Lesson #9 Tables Part 1
  • 006 Lesson #10 Tables Part 2
  • 006 Lesson-9-and-10-Tables-Review.pdf
  • 006 Lesson-10-Sql-Training-Academy-Tables.pdf
  • 007 Lesson #11 Creating Stuff Part 1
  • 007 Lesson-11-Sql-Training-Academy-Creating-Stuff.pdf
  • 008 Lesson #12 Creating Stuff Part 2
  • 008 Lesson-11-and-12-Creating-Stuff-Review.pdf
  • 009 Lesson #13 Creating Stuff with Scripts Part 1
  • 009 Lesson-13-Sql-Training-Academy-Creating-Stuff-with-Scripts.pdf
  • 010 Lesson #14 Creating Stuff with Scripts Part 2
  • 010 Lesson-13-and-14-Creating-Stuff-with-Scripts-Review.pdf

  • 04 - Module #3 Writing SQL
  • 001 Lesson #15 CRUD Part 1
  • 001 Lesson-15-Sql-Training-Academy-CRUD.pdf
  • 002 Lesson #16 CRUD Part 2
  • 002 Lesson-15-and-16-CRUD-Review.pdf
  • 003 Lesson #17 Beginning Select Statements
  • 003 Lesson-17-to-26-Sql-Training-Academy-Select-Statements.pdf
  • 004 Lesson #18 Where Clause Part 1
  • 005 Lesson #19 Where Clause Part 2
  • 005 Lesson-18-and-19-Where-Clause-Review.pdf
  • 006 Lesson #20 Sorting
  • 006 Lesson-20-Sorting-Review.pdf
  • 007 Lesson #21 Column List Part 1
  • 008 Lesson #22 Column List Part 2
  • 008 Lesson-21-and-22-Column-List-Review.pdf
  • 009 Lesson #23 Group By
  • 009 Lesson-23-Group-By-Review.pdf
  • 010 Lesson #24 Having Clause
  • 010 Lesson-24-Having-Clause-Review.pdf
  • 011 Lesson #25 Joining Part 1
  • 012 Lesson #26 Joining Part 2
  • 012 Lesson-25-and-26-Join-Clause-Review.pdf

  • 05 - Module #4 Advanced Objects
  • 001 Lesson #27 Views Part 1
  • 001 Lesson-27-and-28-Sql-Training-Academy-Views.pdf
  • 002 Lesson #28 Views Part 2
  • 002 Lesson-27-and-28-View-Review.pdf
  • 003 Lesson #29 Scripting with Variables Part 1
  • 003 Lesson-29-and-30-Sql-Training-Academy-Scripting-with-Variables.pdf
  • 004 Lesson #30 Scripting with Variables Part 2
  • 004 Lesson-29-and-30-Scripting-with-Variables-Review.pdf
  • 005 Lesson #31 Stored Procedures Part 1
  • 005 Lesson-31-and-32-Sql-Training-Academy-Stored-Procedures.pdf
  • 006 Lesson #32 Stored Procedures Part 2
  • 006 Lesson-31-and-32-Stored-Procedures-Review.pdf
  • 007 Lesson #33 Functions Part 1
  • 007 Lesson-33-and-34-Sql-Training-Academy-Functions.pdf
  • 008 Lesson #34 Functions Part 2
  • 008 Lesson-33-and-34-Functions-Review.pdf

  • 06 - Module #5 Advanced Database Concepts
  • 001 Lesson #35 Security Part 1
  • 002 Lesson #36 Security Part 2
  • 002 Lesson-36-and-37-Sql-Training-Academy-Security.pdf
  • 003 Lesson #37 Security Part 3
  • 003 Lesson-35-and-36-and-37-Security-Review.pdf
  • 004 Lesson #38 Backups Part 1
  • 005 Lesson #39 Backups Part 2
  • 005 Lesson-38-and-39-Backups-Review.pdf
  • 005 Lesson-39-Sql-Training-Academy-Backups.pdf
  • 006 Lesson #40 Indexes Part 1
  • 007 Lesson #41 Indexes Part 2
  • 008 Lesson #42 Indexes Part 3
  • 008 Lesson-40-and-41-and-42-Indexes-Review.pdf
  • 008 Lesson-42-Sql-Training-Academy-Indexes.pdf

  • 07 - Bonuses
  • 001 Bonus #1 SQL and SQL Server Reporting Services
  • 002 Bonus #2 SQL and Microsoft Excel
  • 003 Bonus #3 SQL and Power Pivot
  • 004 Bonus #4 SQL and Microsoft Access
  • 005 Bonus #5 SQL Import and Export
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 19498
    حجم: 4357 مگابایت
    مدت زمان: 796 دقیقه
    تاریخ انتشار: 13 مهر 1402
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید