30/10/2022
لو بتسأل عن محتويات الكورس :
📌Introduction to c # and .Net framework
📌C # vs .NET
📌What is CLR?
📌Primitive Types and Expression
-Introduction
-Variables and Constants
-Overflowing
-Scope
-Type Conversion
-Operators
-Comments
📌Non-Primitive Types
-Classes
-Structs
-Arrays
-Strings
-Enums
-Refrence Types and Value Types
📌Control Flow
-Conditional Statements (If/Else and Switch/Case)
-Iteration Statements (for/while/do-while and foreach loop)
📌Arrays and Lists
-Get the number of elements in an array
-Find an element in an array
-Sort an array
-Copy an array
-Clear an array
-Add one or a range of elements to a list
-Remove an element from a list
-Find an element in a list
-Get the number of elements in a list
📌Working with Dates
-DateTime
-TimeSpan
-Custom types
📌Working with Text and Files
-String
-StringBuilder
-System.IO Namespace
-File and FileInfo
-Directory and DirectoryInfo
📌Debugging Applications
-Debugging Tools in Visual Studio
-Removing Side Effects
-Defensive Programming
📌Exception Handling
📌Multi-threading
📌Json vs XML
📌 Front-End Basics (HTML/CSS/JS)
📌 OOP
- Work with classes, constructors, fields, properties, methods and indexers
- Use encapsulation to improve the robustness of the code and reduce the impact of change
- Re-use code using inheritance and composition
- Understand the problems with inheritance and how composition solves these problems
- Change the behavior of an application by extending its code, rather than changing it
- Develop loosely-coupled, testable and extensible applications using interfaces
📌 ASP .NET MVC
-Introduction to MVC
-First MVC Application
-The MVC Pattern
-Exploring Controller’s
-Exploring Razor Views
-HTML Helpers
-Model Binders
-Annotations and Validations
-CRUD Operations using Entity Framework
-Caching in ASP .NET MVC
-Exception Handling in ASP .NET MVC
-Working with Areas
-Ajax and Client Scripting
-Security
New Features of ASP .NET CORE
📌LINQ to SQL
-Defining the Data Model classes
-Using Mapping attributes
-Using the Data Context class
-Defining Relationships using Associations
-Creating a customized Data Context class
-LINQ to SQL Designer (DBML File)
-Performing Add/Edit/Delete/View Operations
-Tracking changes to entities
-Submitting changes
-Join Query
-Validating Entities
-Transaction Handling
-Executing Stored Procedures
📌 SQL Server
👉Database Design
Logical & Physical database design
Relational database design
Creating databases
👉Management Studio
Basics of SQL
Data types, expressions, operators
Working with Queries & Clauses
Creating Databases
Creating Tables, Stored Procedures
Working with Indexes & Views
👉Sub queries
Nested sub queries
Correlated sub queries
Derived tables
Implementation of Data integrity
Entity integrity
Domain integrity
Referential integrity
Types of constraints
Data Definition Language(DDL)
Creation of table
Modifying the structure of a table
Dropping a table
Working with different options
👉Data Manipulation Language(DML)
Inserting, updating & deleting operations
Operators, Built-in functions, Grouping
Working with multiple tables
👉Joins
Introduction to Joins
Inner join
👉Outer join
Cross joins
Unions
👉Working with Indexes
Introduction to indexes
Creating, dropping indexes
Complex indexes
Clustered & non clustered indexes
👉Implementing Views
Introduction & advantages of views
Creating views
Altering, dropping views
👉Data Control Language(DCL)
Creating Users and Roles
Granting & Revoking of Roles & Privileges
👉Transact-SQL (T-SQL)
Introduction
Data types
Statements
Batch Ex*****on
👉stored procedures
Implementing stored procedures
Introduction to stored procedures
Creating, executing, modifying, dropping sp's
Executing extended sp's
👉Implementing User Defined Functions
Introduction
Creating, executing, altering, dropping UDF's
Deterministic, non-deterministic functions
Scalar, multi-statement, built-in functions
👉Implementing Triggers
Introduction to Triggers
Constraints vs Triggers
Creating, altering, dropping triggers
for/after/instead of triggers
📌APIs
📌 project
لو لسه حاسس إن فى حاجه ناقصه قولنا فى رسائل الصفحة و لو شايف الكورس هيفيدك أو هيفيد غيرك يبقى تسجل و تشير الكورس لأصحابك
📌 سجل الآن
https://forms.gle/YUXXesfy6cb9uGPW7
