What is C#?
C# (pronounced “C sharp”) is a programming language that is designed for creating a variety of applications that run on the .NET Framework. C# is simple, powerful, type-safe, and object-oriented. C# is widely used for developing desktop applications, web applications and web services. It is used in creating applications of Microsoft at a large scale. C# is also used in game development in Unity.
What is SQL server?
SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft.Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with the relational databases. SQL server is tied to Transact-SQL, or T-SQL, the Microsoft’s implementation of SQL that adds a set of proprietary programming constructs.
What is this course all about?
This course is designed for people with NO prior programming experience. You will learn how to write computer programs using C# and how to use SQL server for storing and retrieving data. At the end of every topic, sample exercises are also provided to practice.
What makes this course better than the others?
This course is better than others due to the design of the lectures. Complex topics are explained in a way that anyone can understand. The instructor has decades of experience, and knows where new programmers make mistakes and get confused. All the topics in this course have been designed keeping in mind that student has no prior knowledge of C# and SQL server. He can began from scratch and will be at intermediate level are studying this course.
Can I take the experience from this course to learn new programming languages?
Yes you can! C# is a “C” based programming language. All programming languages in the same family are extremely similar and easy to learn after learning C#. Some examples of “C” based languages are:
Similarly, Once you learn SQL server, you will be able to learn other databases(Oracle, SQL lite, etc.) easily.
Disclosure: when you buy through links on our site, we may earn an affiliate commission.
C#, Oops Concepts & SQL server: Learn Fundamentals by Coding
Wonderful mixture of Theory and Practicals. Each and every topic is demonstrated with real-time examples.
Created by Ingenious Tech Hub
Top C courses:
CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.
Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.
New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.
The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.
Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.
This course contains:
Table of contents
What is C#?
You will learn
✓ C# Basics –> 1. Comments 2. Variables 3. User Input
✓ Data Types –> 1. Data types 2. Type casting 3. Operators
✓ Decision making statements–> 1. If 2. If-Else 3. If-Else-If 4. Switch 5. Goto Statement
✓ Loops–> 1. While 2. For 3. Do while 4. Infinite loops & nested loops
✓ Arrays–> 1. Array 2. Multi dimensional array 3. Array Class
✓ Functions–> 1. Functions 2. Call by value and reference 3. Out parameter
✓ Classes/objects–> 1. Classes/objects 2. Class members 3. Constructors 4. Destructors 5. This 6. Static class 7. Static constructor 8. Access modifiers 9. Properties 10. Enums 11. Structs
✓ Polymorphism–> 1. Method overloading 2. Operator overloading 3. Method overriding
✓ Abstraction–> 1. Abstract class 2. Interface 3. Base Keyword 4. Sealed Keyword 5. Method hiding
✓ Exception handling–> 1. Exception handling 2. User Defined Exception
✓ File I/O–> 1. Working with Files
✓ SQL server Introduction–> 1. Introduction to Sql 2. Installing Microsoft Sql server Express 3. Connecting to Sql server using SSMS and Connecting to AdventureWorks Database
✓ Working with database and tables–> 1. Create and delete database 2. Create and delete table 3. Alter table
✓ Constraints–> 1. Default constraint 2. check constraint 3. NOT NULL constraint 4. Unique Constraint 5. primary key 6. foreign key
✓ Modifying Data–> 1. INSERT single row 2. INSERT multiple rows 3. UPDATE statement 4. DELETE statement 5. Truncate table
✓ Querying Data–> 1. Literal Select Statement 2. Basic Select Statement 3. Select TOP Statement
✓ Filtering Data–> 1. DISTINCT Clause 2. WHERE Clause 3. Filtering with Wildcards 4. Filtering with multiple predicates(AND,OR,NOT) 5. Working with Nothing (will check how NULL values affect the result) 6. Column & table aliases
✓ Sorting Data–> 1. Order By clause
✓ Grouping Data–> 1. Group BY 2. Having
✓ Using Functions and expressions
✓ Joins–> 1. Inner Join 2. Full Outer Join 3. Left Join 4. Right Join 5. Cross Join 6. Self Join
✓ Sub Queries
✓ Stored Procedures
✓ Exercise at the end of each topic