Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2020-11-26 08:14:25
30-Day Money-Back Guarantee

This course includes:

  • 63.5 hours on-demand video
  • 19 articles
  • 21 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Development Programming Languages C#

Complete SQL in C# Design Amazing Database App in C# and SQL

10 in 1:Data Entry App,ADO.Net ,Search SQL in C# ,multi user App,Image in SQL Server ,Backup & Restore,Aggregate,Publish
Rating: 4.2 out of 54.2 (92 ratings)
10,987 students
Created by Musavi Abdullah
Last updated 12/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • 10 Courses in one + 64 Hours + 22 Projects
  • Start Working with SQL Server
  • Build C# Apps by SQL ADO .Net
  • Search the SQL Data by C# App
  • Design Pro Data Entry Forms
  • Save Image in SQL Db by C# App
  • Pro English Dictionary by 176,000 Words!
  • Create Phone Book Project in C#
  • Multi User App & Login Form in C#
  • Backup and Restore SQL Db in C#
  • SQL Aggregates ( Sum, Avg, Max, Min) in C#
  • Publish C# Apps in SQL in Users PC
  • Load,Save,Delete & New By C# in SQL
  • Using Date,Time,Currency & Number in C#
  • Working with Oracle VirtualBox

Course content

96 sections • 697 lectures • 63h 45m total length

  • Preview09:51
  • Preview01:57
  • Download projects and files of this course
    00:53
  • How to increase sound volume of tutorials?
    02:01

  • Visual Studio 2019 Section Intro
    01:09
  • Visual Studio 2019 requirements
    04:18
  • How to Install Visual Studio 2019?
    13:53
  • Working with Visual Studio 2019 and C#
    06:07
  • Compare Visual Studio 2019 & Visual Studio 2017
    05:28

  • Who should watch this section!
    00:54
  • Download SQL Server 2014 express & requirements
    08:07
  • Install SQL 2014 express in Windows 7
    11:47
  • Install SQL 2014 express in Windows 10
    10:17
  • What is SQL Server & its structure?
    03:10
  • Common parts of SQL Server
    02:13
  • What is SQL Server Management Studio (SSMS) ?
    07:22
  • Customize SQL Server Environment
    05:53
  • What is SQL Server database?
    03:45
  • Create SQL Database
    03:29
  • Different parts of the SQL database
    03:33
  • Rename and delete SQL Database
    03:17
  • Default location of the SQL Database files
    03:09
  • Different type of SQL datbase files
    05:05
  • Using SQL Server configuration manager
    06:24
  • What is SQL table?
    03:03
  • Add table to the SQL Database
    12:31
  • Add data to the SQL table
    05:24
  • Load data in to the SQL table
    05:00
  • Change the design of table & save it
    04:17
  • Rename and delete the SQL table
    02:17
  • What is the prefix "dbo" in SQL table name?
    02:50
  • What is SQL Numeric data type?
    03:50
  • Int data type in SQL
    08:23
  • Bit data type in SQL
    05:28
  • Tinyint data type in SQL
    03:40
  • Smallint data type in SQL
    04:19
  • Bigint data type in SQL
    02:55
  • Float data type in SQL
    04:09
  • Decimal data type in SQL
    10:27
  • Char data type in SQL
    07:00
  • Varchar data type in SQL
    05:29
  • Varchar(max) data type in SQL
    06:13
  • Text data type in SQL
    03:28
  • nchar data type in SQL
    07:21
  • nvarchar data type in SQL
    04:45
  • nvarchar Max data type in SQL
    04:09
  • ntext data type in SQL
    04:15
  • What is GUID in SQL?
    03:04
  • Using GUID in SQL Server
    08:21
  • How to detach SQL database?
    04:53
  • How to attach SQL database?
    03:30
  • Attach SQL database without LDF file
    04:31
  • Make SQL database offline and online
    03:27
  • Create sample database to set identity column
    05:03
  • Add identity and auto increment column and test it
    07:33
  • Identity column count in each table
    03:35
  • SQL Date data type
    06:19
  • SQL Smalldatetime data type
    03:58
  • SQL Datetime data type
    02:54
  • SQL Datetime2 data type
    03:39
  • SQL Datetimeoffset data type
    03:01
  • SQL Time data type
    05:34

  • Preview02:20
  • Create "Phone Book" database in SQL
    03:47
  • Add "Phone Book" table to SQL database
    03:52
  • Add personal & contact columns to "Phone Book" table
    08:02
  • Add Address columns to "Phone Book" table
    05:58
  • Add identity and auto increment column
    06:43
  • Add sample data in SQL for "Phone Book" table
    04:03

  • Preview04:40
  • Writing our first Select query
    11:42
  • Use Select query with (*) to show all columns
    02:02
  • Sort the records with Select query
    09:47
  • Show specific number of top rows with Select Query
    04:12
  • Show specific number of bottom rows with Select Query
    03:51
  • Reorder the columns in Select Query
    02:53

  • Section Introduction for SQL ADO.Net
    01:03
  • Preview03:52
  • Create C# Phone Book Project for SQL Server
    05:22
  • Add Dataset to C# project
    07:05
  • Add Table Adapter to Dataset
    11:56
  • SQL Server Connection String in Depth
    07:38

  • Using Manual Query editor in C#
    04:51
  • Using Diagram & Criteria to Create SQL Select Query
    10:58
  • Finish Adding Table Adapter to Dataset
    05:37
  • What is Dataset and Data table in C#
    03:24
  • What is Table Adapter in C#
    04:28
  • How to configure SQL Query in Table Adapter
    05:11

  • Add Datagrid view to Phone Book form
    09:20
  • Resolve errors and create form again
    04:54
  • What is Binding Source?
    04:52
  • Add All Textboxes & Labels to Phone Book Form
    06:45
  • Adding Textbox & Label one by one to Form
    04:39
  • Preview04:36
  • Add Records to Dataset and save in SQL Server Database
    03:49

  • Section intro
    00:55
  • Upgrade to Visual Studio 2019 my Phone Book project
    03:58
  • Add toolbar to data entry form
    07:41
  • Add image to toolbar buttons
    06:20
  • Enable|Disable toolbar buttons by C# code
    07:44
  • Create method for Enable|Disable buttons
    04:19
  • Enable|Disable Datagridview & Groupbox by C# code
    06:09

  • Write "Add New " button code in C#
    04:21
  • Write "Save Changes" button code in C#
    09:13
  • Show message box after saving data to SQL
    04:30
  • Write "Delete" button code in C#
    05:01
  • Write "Edit" & "Cancel" buttons code in C#
    07:37
  • Add empty record guard to "Edit" & "Delete" Buttons
    07:14
  • Disable groupbox Items when click the "Delete" button
    02:09

Requirements

  • Visual Studio 2017 or 2019 Community edition or other versions
  • General Knowledge of C# Programming
  • Inner Motivation to Learn SQL in C# !

Description

Hi There!

With my 20 years programming skills i'm with you to share my knowledge with you.

So

If you try you will learn using SQL Server Database in C# Application!

If you are beginners or student looking for a tutorial to create database apps in SQL Server and create a application for that in C# in simplest way!

 

I started from beginning and show you how to :

  • Start Working with SQL Server

  • Build C# Apps by SQL ADO .Net

  • Search the SQL Data by C# App

  • Design Pro Data Entry Forms

  • Save Image in SQL Db by C# App

  • Pro English Dictionary by 176,000 Words!

  • Create Phone Book Project in C#

  • Multi User App & Login Form in C#

  • Backup and Restore SQL Db in C#

  • SQL Aggregates ( Sum, Avg, Max, Min) in C#

  • Publish C# Apps in SQL in Users PC

  • Load,Save,Delete & New By C# in SQL

  • Using Date,Time,Currency & Number in C#

  • Working with Oracle VirtualBox

  • and ...

Don't hesitate to start learning SQL Server in C#!

Every thing will be discussed with sample project and you will have lot of fun within my course.

Say Hi SQL & C# world and let's go !!!

Who this course is for:

  • C# programmers who want to work with SQL Server in C# code!
  • C# programmers who want to Learn Quickly SQL Server in C# code!
  • C# programmers who want to make more money by Using SQL Server in C# !

Instructor

Musavi Abdullah
Professional Programmer of C# ,VB.Net,SQL,ASP.Net,setup ...
Musavi Abdullah
  • 4.3 Instructor Rating
  • 820 Reviews
  • 86,294 Students
  • 11 Courses

I'm an experienced software programmer that spent 20+ years designing and developing many windows application, web sites and web services.I believe that programmers can make the world better place to live.

After 17 years o f teaching in high school i hope you have great moments in my courses and really after my classes you will be real programmer!

With My Tutorials:

   - You will learn C #,Vb dot net and programming with easiest method

   - It comes with practical examples and projects.

   - You can become a professional programmer 

In addition I always try to find best solutions for my customer's problems.  Satisfaction of  customers and clients are the main approach that you will see after my jobs done.

General : C#.Net -Vb dot net - Visual Studio 2017- DevExpress - Telerik

Web Applications : ASP.NET - ASP.NET Web Service - HTML- JavaScript - jQuery

Database : MS SQL -MySQL -Access

Reports : Crystal Reports  - Stimulsoft Report- DevExpress Reports

Other skills : Team management  - Arduino and Electronic Circuit Design

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.