C#, Oops Concepts & SQL Server: Learn Fundamentals by Coding

Each and every topic is demonstrated with real- examples.

You will learn C#, OOPS Concepts and SQL Server in this course with practical examples. At the end of each topic, there are exercises to practice as well. Following is the topic listing:

C# Basics :-> Comments, Variables and User Input

Data Types :-> Data Types, Type Casting and Operators

Decision Making Statements :-> If, If-Else, If-Else-If, Switch and Goto Statement

Loops :-> While Loop, For Loop, Do While Loop, Infinite Loops & Nested Loops

Arrays :-> Array, Multi Dimensional Array and Array Class

Functions :-> Functions, Call by Value and Reference and Out Parameter

Classes/Objects :-> Classes/Objects, Class Members, Constructors, Destructors, This, Static Class, Static Constructor, Access Modifiers, Properties, Enums and Structs

Inheritance :-> Inheritance

Polymorphism :-> Method Overloading, Operator Overloading and Method Overriding

Abstraction :-> Abstract Class, Interface, Base Keyword, Sealed Keyword and Method Hiding

Exception Handling :-> Exception Handling and User Defined Exception

File I/O :-> Working with Files

SQL Server Introduction :-> Introduction to SQL, Installing Microsoft SQL Server Express, Connecting to SQL Server using SSMS and Connecting to AdventureWorks Database

Working with Database and Tables :-> Create and Delete Database, Create and Delete Table, Alter Table

Constraints :-> Default Constraint, Check Constraint, NOT NULL Constraint, Unique Constraint, Primary Key, For Key

Modifying Data :-> INSERT Single Row, INSERT Multiple Rows, UPDATE Statement, DELETE Statement, Truncate Table

Querying Data :-> Literal Select Statement, Basic Select Statement and Select TOP Statement

Filtering Data :-> DISTINCT Clause, WHERE Clause, Filtering with Wildcards, Filtering with Multiple Predicates (AND,OR,NOT), Working with Nothing (will check how NULL values affect the result), Column & Table Aliases

Sorting Data :-> Order By Clause

Grouping Data :-> Group By Clause and Having Clause

Using Functions and Expressions :-> MIN, MAX, COUNT, SUM, AVG and Case Statement

Joins :-> Joins, Inner Join, Full Outer Join, Left Join, Right Join, Cross Join and Self Join

Sub Queries :-> Sub Query, Exists, ANY and ALL

Set Operators :-> Union, Intersect and Except

Stored Procedures :-> Stored Procedures, If Else in Stored Procedures

Exercises at the end of each topic

There is no prerequisite to start this course

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:

C

C++

Java

Perl

PHP

Python

Similarly, Once you learn SQL Server, you will be able to learn other databases (Oracle, SQL lite, etc.) easily.

Anyone(From Zero experience to expert) having basic computer knowledge can start this course.



DOWNLOAD
uploadgig


rapidgator


nitroflare