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

Sybase – Beginners to Advanced

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

1. Sybase - Beginners
  • 1. Introduction to SAP Sybase Beginner
  • 2. What is Sybase
  • 3. Data Modification
  • 4. Creating Tables with Primary Key
  • 5. Creating Tables with Primary Key Continue
  • 6. Assigning Foreign keys
  • 7. Inserting Records Part 1
  • 8. Inserting Records Part 2
  • 9. Inserting Records Part 3
  • 10. Inserting Records Part 4
  • 11. Creating Database
  • 12. Creating Database Continue
  • 13. Altering Tables Part 1
  • 14. Altering Tables Part 2
  • 15. Altering Tables Part 3
  • 16. Altering Tables Part 4
  • 17. Creating Views
  • 18. Creating and Altering DB Space
  • 19. Creating and Altering DB Space Continue
  • 20. Select Data from Tables
  • 21. Select Data from Tables Continue
  • 22. Selecting Data using Operators
  • 23. Selecting Data using Operators Continue
  • 24. Select with where Clause
  • 25. Select with where Clause Continue
  • 26. Like Clause in where
  • 27. Like Clause in where Continue
  • 28. More on Like Clause in where
  • 29. Null Values in Select Queries
  • 30. Subqueries Restrictions
  • 31. Correlation Names
  • 32. Asterisks in Select
  • 33. Delete and Insert
  • 34. Types of Subqueries
  • 35. Types of Subqueries Example
  • 36. Subqueries with Any
  • 37. Subqueries with Any Continue
  • 38. Subqueries used with not Exists
  • 39. Aggregates
  • 40. Count Aggregate Functions
  • 41. Aggregate Functions
  • 42. Group By
  • 43. Having with Group By
  • 44. Having with Group By Continue
  • 45. Compute with Aggregate
  • 46. Compute with Aggregate Continue
  • 47. Compute
  • 48. Union
  • 49. Joins Equi Join
  • 50. Joins Equi Join Continue
  • 51. Self Join
  • 52. Self Join Continue
  • 53. Outer Joins
  • 54. Outer Joins Continue
  • 55. ANSI Inner Join
  • 56. ANSI Inner Join Continue
  • 57. ANSI Outer Join
  • 58. ANSI Outer Join Continue
  • 59. Inserting Data
  • 60. Insert Data with Null
  • 61. IDENTITY Column
  • 62. Not Materialized Column
  • 63. Update Command
  • 64. Delete Command

  • 2. Sybase - Intermediate to Advanced
  • 1. Introduction to SAP Sybase Intermediate
  • 2. Create view 1 Table
  • 3. Update View
  • 4. Select Statement on View
  • 5. Check Option
  • 6. View Resolution
  • 7. Multitable View
  • 8. Creating Defaults
  • 9. Creating Rules
  • 10. Creating Rules Continue
  • 11. Creating and Altering
  • 12. Dropping Precomputed Result set
  • 13. Batch processing
  • 14. If and Else Statements
  • 15. Case Expression
  • 16. Case Expression Examples
  • 17. More on Case Expression
  • 18. While and If
  • 19. Local Variables and Global Variables
  • 20. System Functions
  • 21. Aggregate Functions
  • 22. Mathematical Functions and Date Function
  • 23. Simple Procedure
  • 24. Parameter Procedure
  • 25. Default Parameter
  • 26. Null Parameter
  • 27. Nesting Proc
  • 28. Proc on Temp Tables
  • 29. Return Value
  • 30. Return Value Example
  • 31. Output Parameters
  • 32. System Procedure
  • 33. Extended Stored Procedure
  • 34. Creating Cursor
  • 35. Fetching Data
  • 36. Scroll Cursor
  • 37. Insensitive Cursors
  • 38. More Examples on Cursor
  • 39. Cursor in Stored Proc
  • 40. Creating Triggers
  • 41. For insert Trigger
  • 42. Delete Trigger
  • 43. Update Trigger
  • 44. Multi Row Insert
  • 45. Multi Row Insert Continue
  • 46. Conditional Triggers
  • 47. Enable Disable Trigger
  • 48. Instead of Triggers
  • 49. In-Row LOB
  • 50. Off-Row LOBS
  • 51. Creating Transactions
  • 52. Translate Variable
  • 53. Nested Transaction
  • 54. Isolation Levels of Transactions
  • 55. Cursors and Transactions
  • 56. Triggers and Transactions
  • 57. Locking Commands and Options
  • 58. Roles of SA
  • 59. Performing SA Tasks
  • 60. System Stored Procedures
  • 61. System Administration Tasks
  • 62. Backup Database
  • 63. SP Configure Parameter
  • 64. Configuration Parameter List Part 1
  • 65. Configuration Parameter List Part 2
  • 66. Configuration Parameter List Part 3
  • 67. Configuration Parameter List Part 4
  • 68. Configuration Parameter List Part 5
  • 69. Initializing Database Devices
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 41417
    حجم: 5932 مگابایت
    مدت زمان: 1144 دقیقه
    تاریخ انتشار: 16 آبان 1403
    طراحی سایت و خدمات سئو

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