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

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

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

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

تولید کننده: Udemy