Professional Web Development Multi-Language with(ASP.Net) and WordPress. All our prebuild websites includes the following services:

 

DATABSE DEVELOPMENT AND ADMINISTRATION TUTORIALS

SQL is a standard language for accessing and manipulating databasesLearning SQL can be very rewarding. Once you have a basic understanding of SQL, you can start to develop more advanced databases.  This course covers the SQL syntax and its various SQL commands. It assumes a basic knowledge of databases and database design. 

Target AudienceIs a Master relational databasesDiscover what is happening within SQL Server and learn its awesome capabilitiesRaise the performance of their database systems to exceptional levels. Implement the industry's best practices for SQL Server.

Course ObjectivesIs for anyone who wishes to learn how to use SQL Server. It assumes a basic understanding of databases and how they workSQL is a language that enables you to work with a database. A standard programming language aimed at enabling the administration and communication of databases. It is widely used in the Internet (e.g. Microsoft SQL Server, MySQL, etc). 

Course Duration8 classes, two hours per class, or (Any time which suit you)

Course Fee480 per course .

Course Content: 

Chapter 1:  Introduction        

  • Introduction to Database Management System (DBMS)
  • Introduction to SQL SERVER          
  • SQL SERVER Installation Steps
  • Getting Started With SQL Server
  • What Does SSMS Look Like?
  • How to Create a New Database?        
  • Other Options  
  • SQL Server System Databases

CHAPTER 2:  Understanding Core Database Concepts         

  • Understanding Databse Concepts
  • Definition        
  • Microsoft SQL Server
  • Database management system
  • Types of databases      
  • Understanding Flat-Type Databases  
  • Understanding Hierarchical Databases          
  • Understanding Relational Databases  
  • Installing SQL Server & SSMS          
  • Constraints      

2.2) Using SQL Server Management Studio (SSMS)

  • What Does SSMS Look Like?
  • Creating a Database Using SSMS      
  • Creating a Table Using SSMS
  • Insert Data into a Table          
  • Select Data From a Table       
  • Update Data in a Table           
  • Delete Data From a Table       
  • System Tables 

Chapter 3: SQL Data Types and Constraints

  • SQL Data Types 
  • Character strings         
  • Unicode strings           
  • Binary types    
  • Number types (Whole numbers)        
  • Number types (Real numbers)
  • Date types       
  • Other data types          
  • SQL Constraints 
  • SQL NOT NULL Constraint   
  • SQL UNIQUE Constraint       
  • SQL PRIMARY KEY Constraint       
  • SQL FOREIGN KEY Constraint        
  • SQL CHECK Constraint         
  • SQL DEFAULT Constraint    
  • SQL CREATE INDEX Statement       
  • SQL IDENTITY Field 
  • The TRUNCATE TABLE Statement

Chapter 4: Core Understanding Commands in SQL SERVER        

  • Understanding Data Manipulation Language (DML)   
  • SQL SELECT Statement        
  • SQL SELECT DISTINCT       
  • SQL INSERT INTO Statement           
  • SQL UPDATE Statement       
  • SQL DELETE Statement        
  • SQL MERGE Statement         

4.2) Understanding Data Definition Language (DDL)         

  • USE Command
  • CREATE Statement    
  • ALTER Statement
  • DROP Statement         
  • TRUNCATE Command          
  • DELETE Statement    
  • SQL Commands Operators and Clauses
  • The WHERE Clause   
  • SQL HAVING Clause 
  • AND Operator 
  • OR Operator    
  • Combining AND & OR          
  • SQL ORDER BY         
  • SQL TOP Clause         
  • SQL LIKE Operator    
  • SQL IN Operator         
  • SQL BETWEEN Operator    
  • SQL NOT Operator   
  • Group By Errors in SQL Server         

CHAPTER 5: Aggegate Functions in SQL Server        

  • SQL Aggegate Functions          
  • SQL AVG() Function  
  • SQL COUNT() Function         
  • SQL MAX() Function 
  • The MIN() Function
  • SQL SUM() Function 
  • SQL FIRST() Function
  • SQL LAST() Function
  • SQL Scalar Functions      
  • SQL GROUP BY Statement   
  • The UPPER() Function           
  • The LOWER() Function         
  • SQL LEN() Function  
  • SQL ROUND() Function        
  • SQL MID() Function
  • SQL Alias

Chapter 6: Joins in SQL SERVER    

  • SQL Joins           
  • SQL INNER JOIN       
  • SQL LEFT JOIN         
  • SQL RIGHT JOIN       
  • SQL FULL JOIN         
  • SQL CROSS JOIN      
  • SQL UNION Operator
  • SQL UNION All Operator      
  • SQL EXCEPT 
  • SQL INTERSECT       

Chapter 7: SQL Objects Views, Index and Stored Procedures

  • Casting and Converting 
  • Creating Views  
  • User-defined functions  
  • System Functions           
  • Creating Stored Procedures       
  • Stored Procedures Without Parameters         
  • Stored Procedures with Parameters    
  • SQL Injection     
  • SQL Indexes       
  • Clustered indexes        
  • Create Nonclustered Indexes  
  • System Stored Procedures in SQL Server         
  • Examples in SQL SERVER    

Chapter Eight: Normalisation and Administration Database          

  • Normalisation    
  • First Normal Form (1NF)       
  • Second Normal Form (2NF)   
  • Third Normal Form (3NF)      
  • Fourth / Fifth Normal Form (4NF/5NF)        
  • Understand Database Security Concepts           
  • Essential details          
  • Server-Level Security 
  • Service Accounts        
  • Understanding Database Server Roles           
  • Understanding Object Permissions    
  • Understand database backup and restore
  • Essential details          
  • Understanding Recovery Models       
  • Understanding Database Backups      
  • Partial and differential partial backups          
  • Understanding Database Restores      
  • BACKUP and RESTORE Commands 


 



تصميم و إنشاء مواقع إلكترونية إحترافية متعدد اللغات اى اس بي و ووردبرس ويضم جميع خدمات الإنشاء و التصميم في الأتي :

Designed & developed by: ITQAN Software