لیست مطالب


Complete SQL, Web, MVC

  • Introduction to T-SQL Querying
  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2012 Data Types
  • Using Built-In
  • Grouping and Aggregating Data
  • Using Sub queries
  • Using Table Expressions
  • Using Set Operators
  • Using Window Ranking, Offset and Aggregate Functions
  • Pivoting and Grouping Sets
  • Querying SQL Server
  • Executing Stored Procedures
  • Programming with T-SQL
  • Implementing Error Handling
  • Implementing Transactions
  • Introduction to SQL Server and its Toolset
  • Preparing Systems for SQL Server
  • Installing and Configuring SQL Server
  • Working with Databases
  • Understanding SQL Server Recovery Models
  • Backup of SQL Server Databases
  • Restoring SQL Server Databases
  • Importing and Exporting Data
  • Authenticating and Authorizing Users
  • Assigning Server and Database Roles
  • Authorizing Users to Access Resources
  • Auditing SQL Server Environments
  • Automating SQL Server 2012 Management
  • Configuring Security for SQL Server Agent
  • Monitoring SQL Server with Alerts and Notifications
  • Performing Ongoing Database Maintenance
  • Tracing Access to SQL Server
  • Monitoring SQL Server
  • Managing Multiple Servers
  • core programming
  • object-oriented programming
  • general software development
  • .NET Framework concepts
  • namespaces and classes in the .NET Framework
  • .NET code compilation
  • I/O classes in the .NET Framework
  • security
  • .NET languages
  • memory management
  • Programming web applications
  • Troubleshooting and debugging web applications
  • Working with client-side scripting
  • Configuring and deploying web applications
  • Manage the application life cycle
  • Build the user interface (UI) by using HTML5
  • Format the user interface by using Cascading Style Sheets (CSS)
  • Code by using JavaScript
  • Data Access Layer
  • LinQ to SQL Classes
  • Entity Framework
  • Web World Intro
  • MVC Introduction
  • Controllers
  • Views
  • Models
  • Forms and HTML Helpers
  • Data Annotations and Validation
  • Membership, Authorization,and Security
  • Ajax