facebook
favorite button
member since icon
منذ يناير 2025
أستاذ منذ يناير 2025
Master C# Programming with an Experienced Developer – Beginner to Advanced Levels
course price icon
من 1398.91 EGP
arrow icon
Are you ready to master C# programming or SQL Server database design? With over 20 years of experience in software development, I provide tailored lessons designed to make learning practical, engaging, and applicable to real-world scenarios.

For C#, I cover programming fundamentals, object-oriented principles, and best practices for writing clean, efficient code. If you’re interested in SQL Server, I specialise in database design, creating and managing tables, building and optimising views, and writing stored procedures to handle complex operations.

Each lesson is customised to suit your needs, whether you’re a beginner or looking to enhance your skills. With hands-on exercises, clear explanations, and personalised feedback, I’ll help you gain the confidence and expertise to succeed.

Choose your focus—C# programming or SQL Server—and let’s start working toward your goals today!
معلومات إضافية
Lessons are fully tailored to your goals, whether you're preparing for a project, an interview, or improving your skills. I use practical, real-world examples to make learning engaging and effective. No prior knowledge is required, and I will guide you step by step. Lessons are flexible to suit your schedule, and I provide follow-up resources to help you reinforce what you’ve learned. My aim is to help you gain confidence and achieve your programming or database goals.
المكان
location type icon
عبر الانترنت من إسرائيل
من أنا؟
Are you ready to master C# programming or SQL Server database design? With over 20 years of experience in software development, I provide tailored lessons designed to make learning practical, engaging, and applicable to real-world scenarios.

For C#, I cover programming fundamentals, object-oriented principles, and best practices for writing clean, efficient code. If you’re interested in SQL Server, I specialise in database design, creating and managing tables, building and optimising views, and writing stored procedures to handle complex operations.

Each lesson is customised to suit your needs, whether you’re a beginner or looking to enhance your skills. With hands-on exercises, clear explanations, and personalised feedback, I’ll help you gain the confidence and expertise to succeed.

Choose your focus—C# programming or SQL Server—and let’s start working toward your goals today!
المستوى التعليمي
Southgate University UK
Main education has been on the job working in many different fields over a period of several decades. I have developed many programs that are being used on a daily basis for many years.
الخبرة / المؤهلات
Computer Courses and 20 years of development experience. I have developed many programs that are being used on a daily basis for many years.
السن
شباب (13-17 سنة)
الكبار (18-64 سنة)
الكبار (65 سنة فأكثر)
مستوى الطالب
مبتدئ
متوسط
المدة
60 دقيقة
الدرس يدور باللغة
الإنجليزية
الجاهزية في الأسبوع العادي
(GMT -05:00)
نيويورك
at teacher icon
على الانترنت عبر كاميرا ويب
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
فصول مماثلة
arrow icon previousarrow icon next
verified badge
Brahim
Module 1: SQL Overview
Outlining SQL as the cornerstone of database activity
Applying the ANSI/ISO standards
Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys

Module 2: Building the Database Schema
- Creating tables and columns
Building tables with CREATE TABLE
Modifying table structure with ALTER TABLE
Adding columns to an existing table
Removing tables with DROP TABLE

- Protecting data integrity with constraints
Guaranteeing uniqueness with primary key constraints
Enforcing integrity with foreign key constraints
Imposing business rules with check constraints

- Improving performance with indexes
Expediting data retrieval with indexes
Recommending guidelines for index creation

Module 3: Manipulating Data
- Modifying table contents
Adding table rows with INSERT
Changing row content with UPDATE
Removing rows with DELETE

- Applying transactions
Controlling transactions with COMMIT and ROLLBACK
Deploying BEGIN TRANSACTION in SQL Server

Module 4: Working with the SELECT Statement
- Writing Single Table queries
Retrieving data with SELECT
Specifying column expressions
Sorting the result with ORDER BY
Handling NULL values in expressions

- Restricting rows with the WHERE filter
Testing for equality or inequality
Applying wildcard characters
Avoiding NULL value pitfalls

Module 5: Querying Multiple Tables
- Applying the ANSI/ISO standard join syntax
Matching related rows with INNER JOIN
Including nonmatched rows with OUTER JOIN
Creating a Cartesian product with CROSS JOIN

- Combining results with set operators
Stacking results with UNION
Identifying matching rows with INTERSECT
Utilizing EXCEPT to find nonmatching rows

Module 6: Employing Functions in Data Retrieval
- Processing data with row functions
Conditional formatting with the CASE expression
Utilizing the CASE expression to simulate IF tests
Dealing with NULL values

- Performing analysis with aggregate functions
Summarizing data using SUM, AVG and COUNT
Finding the highest/lowest values with MAX and MIN
Defining the summary level with GROUP BY
Applying filter conditions with HAVING

Module 7: Constructing Nested Queries
- Applying subqueries in filter conditions
Creating correlated vs. noncorrelated subqueries
Testing the existence of rows

- Including subqueries in expressions
Placing subqueries in the column list
Creating complex expressions containing subqueries
Handling subqueries that return no rows

Module 8: Developing In-Line and Stored Views
- Breaking down complex problems
Selecting data from a query result set
Using subqueries in the FROM clause

- Creating views in a database
Building reusable code
Creating updateable vs. non-updateable views
message icon
اتصل بLionel
repeat students icon
الدرس الأول مضمون
بواسطة
ضمان المدرس المناسب
فصول مماثلة
arrow icon previousarrow icon next
verified badge
Brahim
Module 1: SQL Overview
Outlining SQL as the cornerstone of database activity
Applying the ANSI/ISO standards
Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys

Module 2: Building the Database Schema
- Creating tables and columns
Building tables with CREATE TABLE
Modifying table structure with ALTER TABLE
Adding columns to an existing table
Removing tables with DROP TABLE

- Protecting data integrity with constraints
Guaranteeing uniqueness with primary key constraints
Enforcing integrity with foreign key constraints
Imposing business rules with check constraints

- Improving performance with indexes
Expediting data retrieval with indexes
Recommending guidelines for index creation

Module 3: Manipulating Data
- Modifying table contents
Adding table rows with INSERT
Changing row content with UPDATE
Removing rows with DELETE

- Applying transactions
Controlling transactions with COMMIT and ROLLBACK
Deploying BEGIN TRANSACTION in SQL Server

Module 4: Working with the SELECT Statement
- Writing Single Table queries
Retrieving data with SELECT
Specifying column expressions
Sorting the result with ORDER BY
Handling NULL values in expressions

- Restricting rows with the WHERE filter
Testing for equality or inequality
Applying wildcard characters
Avoiding NULL value pitfalls

Module 5: Querying Multiple Tables
- Applying the ANSI/ISO standard join syntax
Matching related rows with INNER JOIN
Including nonmatched rows with OUTER JOIN
Creating a Cartesian product with CROSS JOIN

- Combining results with set operators
Stacking results with UNION
Identifying matching rows with INTERSECT
Utilizing EXCEPT to find nonmatching rows

Module 6: Employing Functions in Data Retrieval
- Processing data with row functions
Conditional formatting with the CASE expression
Utilizing the CASE expression to simulate IF tests
Dealing with NULL values

- Performing analysis with aggregate functions
Summarizing data using SUM, AVG and COUNT
Finding the highest/lowest values with MAX and MIN
Defining the summary level with GROUP BY
Applying filter conditions with HAVING

Module 7: Constructing Nested Queries
- Applying subqueries in filter conditions
Creating correlated vs. noncorrelated subqueries
Testing the existence of rows

- Including subqueries in expressions
Placing subqueries in the column list
Creating complex expressions containing subqueries
Handling subqueries that return no rows

Module 8: Developing In-Line and Stored Views
- Breaking down complex problems
Selecting data from a query result set
Using subqueries in the FROM clause

- Creating views in a database
Building reusable code
Creating updateable vs. non-updateable views
ضمان المدرس المناسب
favorite button
message icon
اتصل بLionel