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

[mitsumi]

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 119 lectures (13h 3m) | Size: 3.83 GB

Wonderful mixture of Theory and Practicals. Each and every topic is demonstrated with real-time examples.

What you'll learn:
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, Foreign 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

Requirements
There is no prerequisite to start this course

Description
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.

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

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction