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
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Emotional Intelligence CBT
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
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
30-Day Money-Back Guarantee
Development Web Development SQL Server

A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course

Learn SQL, SQL Server, SSMS, ASP.NET, Visual Studio, C#, HTML and More!
Rating: 4.4 out of 54.4 (1,202 ratings)
10,155 students
Created by A O
Last updated 5/2019
English
English [Auto], Italian [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn SQL
  • Learn SQL Server
  • Learn the Basics of Microsoft Visual Studio 2017 Community
  • Learn the Basics of Microsoft ASP.NET with SQL Server
  • Learn Enough C# To Connect to Databases
  • Learn Enough JQuery to Make Database Controls Interctive (jQuery is used on the bottom of the course)
  • Learn the Fundamentals of SQL Server Administration
  • Learn how to work with built in functions
  • Learn how to write joins
  • Learn how to make web pages for collecting and storing information
  • Learn how to format data in web pages and tables
  • Learn how to represent queries with pictures for easier understanding
  • Learn how to use program flow control features like if/else and more
  • Learn how to write stored procedures
  • Learn how to write user defined functions
  • Learn how to write views and triggers
  • Learn how to use the SQL Server debugger
  • Learn how to create, save, commit and roll back transactions
  • Learn how to create users, database roles, logins, and work with securables
  • Learn how to backup, restore, attach and detach databases
  • Learn how to import data into SQL Server from other programs
  • Learn how to bring tables into first, second and third normal form
  • Learn how to work with XML in SQL Server and ASP.NET Controls
  • Learn how to use and save Table variables
  • Learn how to create and use Common Table Expressions
  • Learn how to work with string functions like char, and substring
  • Learn how to use the Lag/Lead Functions and the Over Clause
  • Learn how to work with date functions like Datename, Datepart, getDate and more
  • Learn how to build dynamic theme switching with JQuery
  • Learn how to build dashboard with C#/CSS/HTML/SQL and JQuery
  • Learn how to perform data validation
  • Learn how to print to printers, PDF's, Google Drive, and the Cloud
  • Build a web based data entry system with C#/SQL, CSS and VS
  • Understand how to use begin/end/go and ;
  • Learn how to build a web interface layout that can be dragged, dropped and saved between page loads
Curated for the Udemy for Business collection

Course content

15 sections • 87 lectures • 18h 49m total length

  • Preview05:14
  • Preview05:26
  • Configure the Layout of Panels in the Management Studio and Visual Studio
    03:50

  • Create a Table and Write a Simple Query and Display the Results
    13:58
  • Simple Queries
    6 questions
  • Preview04:25
  • Adding a Simple Where Restriction
    3 questions
  • Write a Query with a Where and an Order By
    09:08
  • Order By Clauses
    5 questions
  • Filtering with Where and Between
    09:05
  • Using Between
    3 questions
  • Aliasing Columns
    11:03
  • Aliasing Columns
    2 questions
  • Aliasing Computed Columns
    10:38
  • Computed Values
    4 questions
  • Use The Query Designer
    06:40
  • Query Designer
    3 questions
  • Make an ASP.NET Web Page with SQL Server
    19:24
  • ASP.NET Pages
    6 questions
  • Summarize Blocks of Records with Group By
    11:30
  • Group By
    5 questions
  • Having Clause
    07:10
  • Having Clause
    4 questions
  • Select Into
    08:03
  • Select Into
    6 questions
  • Add Multiple Parameters to an ASP.NET Page
    19:26
  • Multiple Parameters
    3 questions

  • Table Creation and Data Insertion
    08:18
  • Table creation and Data Insertion
    5 questions
  • Updating Records
    06:19
  • Update Records
    2 questions
  • ASP.NET Page with Updating and Deleting
    16:49
  • Updating, Deleting and Inserting Through Web Pages
    4 questions
  • 1st Normal Form
    12:12
  • First Normal Form
    6 questions
  • Second Normal Form
    09:57
  • Second Normal Form
    2 questions
  • Third Normal Form
    08:25

  • Inner Join
    11:49
  • Inner Joins with Editor Window and Where Statements
    08:12
  • Inner Joins
    5 questions
  • Left Join
    10:45
  • Left Joins with Editor and Where Statement
    15:24
  • Left Joins
    4 questions
  • Right Join
    10:14
  • Right Joins with Query Editor and Filtering Conditions
    10:19
  • Right Joins
    3 questions
  • Full Joins with The Query Editor
    06:42
  • Full Joins
    6 questions

  • Connect Gridview to Tables with C#
    19:38
  • Create a Query Editor with C#
    25:05

  • Create a Table Suited For XML Output
    12:41
  • Create a Page With a Control That Connects to the XML Table
    11:00
  • XML Tables
    7 questions

  • In Logical Operator
    08:40
  • Where with Like
    10:45
  • Like, And and In
    3 questions
  • Scalar Functions
    12:20
  • Scalar Functions
    7 questions
  • Aggregate Functions
    12:04
  • Aggregating Functions
    4 questions
  • Summarzing Records with Over
    16:58
  • Over Statement
    3 questions

  • Subqueries in Select Clauses
    06:30
  • Subqueries in Selects
    3 questions
  • Subqueries in From
    13:04

  • Write and Execute a Simple Stored Procedure
    08:22
  • Simple Stored Procedures
    7 questions
  • Part 1: Write a Parametrized Procedure
    17:37
  • Part 2: Asp.NET Page Powered by Parametrized Store Procedure
    18:05
  • Procedures with Parameters
    5 questions
  • Add IF/Else Blocks
    13:11
  • If/Else Blocks
    5 questions
  • Case and When Statements with Functions
    16:50
  • Case and When
    3 questions
  • While Blocks, Variables
    13:32
  • While, Variables
    2 questions
  • Stored Procedures with Output Parameters
    09:24
  • Try/Catch Error Handling
    10:24
  • Try/Catch
    4 questions
  • Comparing Values Between Records with the Lag Function
    15:39
  • Common Table Expressions
    09:11
  • Using the Lead Function with Grouped Data and CTE's
    11:35
  • Lead and Lag Functions
    5 questions
  • CTE with Inner Join and Aggregating Functions and CSV Files
    16:00
  • Nesting Functions and Pivoting Tables
    11:04
  • Nesting Functions and Pivoting Tables
    3 questions

  • Scalar Valued Functions
    13:00
  • User Defined Scalar Functions
    5 questions
  • Table valued Functions
    15:06
  • Table valued functions
    5 questions
  • Table Variables
    12:26
  • Table Variables
    3 questions
  • ASP.NET/SQL Server/LINQ
    Preview22:57

Requirements

  • Ability to download and install SQL Server 2014 (100% Free)
  • Ability to download and install Visual Studio 2017
  • The SQL begins at the beginner level and progresses through more advanced lessons.
  • The C# begins at the intermediate level.
  • If you use previous versions of SQL Server, like 2008 or 2012, you will have problems with the files used. It's best to use 2014 and up.

Description

Who Should Join: 

1. Friends, please take the time to review the curriculum carefully before buying so you can see exactly whether this is the right course for you. Please kindly refrain from enrolling until this very important step is complete.

2. Please watch the free preview videos so you can see whether the presentation style works for you. Please remember  I am just one person, and I make my videos often after I have been working for many hours already. 

3. You are interested in real coding.

4. You enjoy detailed explanations at an introductory level. Please answer the questions in the quizzes based on the course content, and not external knowledge you might already have. This is very important in order for the quizzes to work correctly.

    Very important note: this course is a general overview of many topics, so not every topic can be explored in great depth and at         every level of subtlety.

5. You can take videos that are 13 minutes on average.

6. You enjoy seeing how different technologies interact.

7. You understand that most of the SQL is done in the Microsoft Management Studio, and not Visual Studio.

9. You're NOT looking for fancy graphics, a talking head, or entertainment. 

9. You're looking for practical, carefully explained examples, where the code is written line by line.

10. I made all the code in a fairly big font to be sure it's easy to see.

11. If you use SQL Server versions below 2014, some of the code will not work. You must use versions 2014 and above. 

12. This course uses ASP.NET and C# and not MVC. 

13. You understand this is a beginners course, and therefore everything is developed over a period of 18 hours, but by the end, assuming you complete the course, you will have many powerful, practical skills. 

14. I don't have an intense amount of energy in my videos because they are made after I've been at work for many hours already. 

Major benefits of the course: 

1) Learn query writing by using the Microsoft Management Studio

2) Learn how to create database connected web pages using SQL and ASP.NET controls

4) Get PDF's that depict difficult concepts in pictures for improved understanding

5) Get 210 quiz questions so you can feel confident you're making true progress.

6) Learn the basics of database connecting code using Microsoft's  premier  programming language: C# 

7) Get exposure to modern SQL language features like Lag/Lead 

8) Build a dashboard system with SQL Server, ASP Web Forms, C# and JQuery (bottom of course)

Given the number of videos, PDF's, variety of teaching methods, quizzes, and a project that is designed to give you a feeling of what to expect in the real world, we're confident this is by far the best deal on this site. Join today, and learn truly valuable skills. 

jQuery and related marks are trademarks of the JS Foundation, and this course is not affiliated with or endorsed by the JS Foundation.

Parts of promo background licensed from Presenter Media . com

Who this course is for:

  • This course is for those who appreciate fine levels of detail.
  • This course is intended for SQL Server novices
  • This course is intended for ASP.NET novices
  • This course is intended for Visual Studio novices
  • This course is intended for those who are intermediate or above in C#
  • This course is NOT for those who want to be entertained.
  • This course is NOT for those who want 5 minutes videos.

Featured review

Malloy, H. Christopher
Malloy, H. Christopher
147 courses
44 reviews
Rating: 5.0 out of 58 months ago
Well organized and good content. Really dived into the SQL section to the point that it helped me understand the functions under the hood and build a stronger understanding of its application. Highly recommend the course.

Instructor

A O
Spreader of Knowledge
A O
  • 4.4 Instructor Rating
  • 5,825 Reviews
  • 38,822 Students
  • 25 Courses

I love computers , math and programming.

I teach because it gives me great joy to understand things deeply and to share that knowledge with others.


My education: 

1. Master's degree in Statistical Computing

2. BA in mathematics


3. Professional development certificates from Microsoft in each area below: 

     1. Deep learning with Python

     2. Introduction to Artificial intelligence

     3. Data science with Python

     4. Math for machine learning

     5. Data science research methods with Python 


4. Professional certificates from other schools: 

    1. Columbia university certificate in introduction to corporate finance

    2.  MIT certificate in introductory economics

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