Jenny's School

SQL Server A database language is used to store and retrieve information. The outstanding features of this language have led to its use in commercial and scientific applications, and its importance is such that it is even taught in some academic disciplines worldwide. At present, the goal is to describe SQL capabilities in a practical way, based on real-world examples. The present course can be useful for programmers, computer and information technology students with all orientations and IT staff of different organizations and institutions.

Further Details

SQL Server A database language is used to store and retrieve information. The outstanding features of this language have led to its use in commercial and scientific applications, and its importance is such that it is even taught in some academic disciplines globally. Currently, most software developers design and develop commercial software in this database language, but the lack of familiarity of most of them with the capabilities of this software, has caused some operations at the application level. Do themselves, which in turn creates many challenges and difficulties for them.

Adequate and appropriate view of SQL capabilities such as: triggers, stored procedures, transactions, exception management, etc. can lead to the rapid development of software products, increase the reliability of software performance, increase the execution speed of programs, reduce errors Probably, the simplicity of programming and most importantly increase the fun of programming. At present, the goal is to describe SQL capabilities in a practical way, based on real-world examples. The present course can be useful for programmers, computer and information technology students with all orientations and IT staff of different organizations and institutions.

The list of topics and outlines of the topics discussed in this training series is as follows:

• Lesson One: Saved Procedures
  • Express basic concepts and apply stored procedures
  • A variety of pre-saved procedures
  • How to define a new procedure
  • Define the variable and send the parameter to the stored procedure
  • Example
• Lesson Two: Triggers
  • Expression of basic concepts and application of triggers
  • How to define and use triggers
  • Inserted role in trigger
  • Deleted role in the trigger
• Lesson three: Transactions
  • Expression of basic concepts and application of transactions
  • Create a transaction and name it
  • Successful execution of a transaction
  • Figma execution of a transaction
• Lesson 4: Managing Exceptions
  • Explain the basic concepts in relation to the management of exceptions
  • The role of Try in managing exceptions
  • The role of Catch in managing exceptions
  • Throw role in managing exceptions
  • Mention a few examples of combinations and shortening of strings
• Lesson 5: Security and Encryption in SQL
  • Express basic concepts about security and its challenges
  • Define different access levels for users
  • Assignment and amendment of assigned rights
  • Data encryption in SQL
  • Decrypt data in SQL
  • Automatic backup
• Lesson 6: Conditional Commands and Cursors
  • Express basic concepts in relation to conditional statements
  • Introducing the if statement
  • Introducing the while command
  • Introducing Cursors
• Lesson 7: A set of key commands
  • Introduce and display database schema
  • Move information from one table to another table
  • Copy the information of a table
  • Data transfer between databases
  • Move database files
  • Upload and load data in SQL
  • Introduce the split operator and implement it
• Lesson 8: Using SQL on Local Area Networks and the Web
  • Explain the problem
  • Preliminary network reviews
  • Required settings in SQL
  • Performance testing and evaluation

Useful for strings

• Computer Engineering
• Information Technology

Prerequisites

 SQL Server Tutorial - Basic

What you will see in this tutorial:

Faders-approved video tutorial

File programs and executed projects

Training related software

 Microsoft SQL Server 2014

Previews