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 AWS Certified Developer - Associate CompTIA Security+
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness 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 Big Data
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-12-24 11:08:32
30-Day Money-Back Guarantee

This course includes:

  • 4 hours on-demand video
  • 23 downloadable resources
  • 1 practice test
  • Full lifetime access
  • Access on mobile and TV
Development Database Design & Development Database Programming

Essential SQL Server Development Tips for SQL Developers

Sharpen your SQL Server T-SQL programming skills and learn useful database programming techniques
Rating: 5.0 out of 55.0 (8 ratings)
26 students
Created by Artemakis Artemiou
Last updated 11/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • How to efficiently perform essential database development tasks in SQL Server, using a variety of techniques and methodologies
  • How to work with unstructured data in SQL Server using all the available techniques
  • How to implement specialized development-related tasks in SQL Server
  • Useful tips for easily resolving SQL Server database development issues

Course content

7 sections • 47 lectures • 4h 5m total length

  • Preview04:21
  • About SQL Server
    02:28
  • SQL vs T-SQL
    02:47
  • How will this Course Help You?
    00:52
  • This Course’s Demo Environment
    19:24
  • Section Recap
    01:31
  • Introduction
    4 questions

  • Section Overview
    00:49
  • Sequence Objects in SQL Server
    06:21
  • The DATE Data Type in SQL Server
    03:28
  • The TIME Data Type in SQL Server
    03:21
  • DATETIME2 vs DATETIME in SQL Server
    06:32
  • The MERGE Statement in SQL Server
    12:45
  • Row Constructors in SQL Server
    04:59
  • The STRING_SPLIT Function in SQL Server
    03:11
  • Preview04:12
  • Working with Temporal Tables in SQL Server
    10:20
  • Table-Valued Parameters (TVPs) in SQL Server
    05:16
  • Segmenting Strings in SQL Server
    07:19
  • Dynamically Generating T-SQL Statements
    08:05
  • Searching for Keywords in SQL Server Agent Jobs
    08:15
  • Section Recap
    01:19
  • Tips for Programming in SQL Server with T-SQL
    4 questions

  • Section Overview
    01:04
  • How to Import and Export Unstructured Data Using the VARBINARY Data Type
    10:59
  • Preview08:33
  • How to Import and Export Unstructured Data in SQL Server Using FileTables
    09:18
  • Section Recap
    01:26
  • Working with Unstructured Data
    4 questions

  • Section Overview
    00:58
  • Retrieving Security-Related Info for SQL Server Logins
    03:24
  • Inserting Leading Characters to a String
    03:46
  • Getting all the Records from all Tables in all User Databases
    02:56
  • Retrieving SQL Server Instance-Related Information
    03:28
  • Executing T-SQL Statements Against All Databases in SQL Server
    05:48
  • Preview05:46
  • Other Useful T-SQL Scripts
    11:57
  • Section Recap
    01:11
  • Useful T-SQL Tips for SQL Developers
    4 questions

  • Section Overview
    01:47
  • Where are Programmability Objects Stored in SQL Server?
    04:56
  • Executing Heavy Set-Based Operations Against VLDBs in SQL Server
    04:51
  • Using the OUTPUT Clause: A simple Data Archiving Example
    06:20
  • Preview07:31
  • Handling NULL and Empty Values in SQL Server
    06:06
  • The multi-part identifier … could not be bound
    04:42
  • Using the “GO” Command in SQL Server
    05:23
  • How to Suppress the “N Row(s) Affected” Output Message in SQL Server
    03:06
  • Section Recap
    01:47
  • Special SQL Server Development Topics
    4 questions

  • What Have you Learned in this Course?
    03:33
  • Essential SQL Server Development Tips for SQL Developers
    20 questions

  • Bonus Lecture
    06:56

Requirements

  • Basic knowledge of the SQL Server fundamentals
  • Basic knowledge of SQL Server Management Studio (SSMS)

Description

In this course, via a combination of lectures, downloadable resources and over than 30 live demos/hands-on guides, you will learn many useful SQL Server database programming hands-on tips, that will help you efficiently develop data processes for your SQL Server databases, using T-SQL and a variety of methods and techniques.

Microsoft SQL Server, is one of the world's leading Data Platforms. SQL Server, among other, allows you to easily develop sophisticated data processes via it's feature-rich T-SQL scripting language and its powerful Database Engine.

This course, will help you strengthen your SQL Server database programming skills, and thus enable you to easily implement data processes and mechanisms in SQL Server, using its powerful T-SQL scripting language, along with combining it with efficient database programming methodologies and techniques.

The course begins with introducing what you can do with SQL Server, and then jumps right into a rich set of hands-on tips, for programming in SQL Server using its powerful T-SQL scripting language. Then, we talk about all the available techniques and features, for handling unstructured data via SQL Server's Database Engine. After that, we talk about essential T-SQL tips that can be very helpful for SQL developers, and finally we discuss about how you can implement specialized database development tasks in SQL Server.

This is a hands-on course, with many live guides, that show you step-by-step, how you can develop a variety of data processes in SQL Server.


AFTER THE COURSE:

  • You will know how to efficiently perform different development tasks in SQL Server, using a variety of techniques and methodologies

  • You will have strengthen your T-SQL coding skills

  • You will know how to work with unstructured data in SQL Server using all the available techniques

  • You will know how to perform specialized development-related tasks in SQL Server


PREREQUISITES:

  • Basic knowledge of the SQL Server fundamentals

  • Basic knowledge of SQL Server Management Studio


THIS COURSE CONTAINS/OFFERS:

  • 4 hours of high-quality video

  • More than 30 live demonstrations and hands-on guides that will help you perform many essential SQL Server development tasks

  • Useful quizzes for testing your knowledge on each section

  • Many downloadable resources such as T-SQL scripts and links

  • A practice test in the end of the course

  • Ability to ask the instructor questions via the Q&A section

  • Certificate on course completion

Who this course is for:

  • SQL Developers who want to strengthen their SQL Server database programming skills
  • SQL Server DBAs and Computer Programmers who want to learn more about developing in SQL Server
  • IT Architects who want to learn more about SQL Server database development
  • Technology enthusiasts who want to learn more about SQL Server database development

Instructor

Artemakis Artemiou
Award-Winning Database Expert, Trainer, Author, Speaker.
Artemakis Artemiou
  • 4.3 Instructor Rating
  • 395 Reviews
  • 4,051 Students
  • 13 Courses

Artemakis is a Senior SQL Server and Software Architect and a former Microsoft Data Platform MVP (awarded for 9 consecutive years). He has over 20 years of experience and he has taught thousands of people to efficiently work with SQL Server, Data Access/Entity Framework, Azure, .NET/C#, Programming and more, via his video tutorials, blog and guest articles, public speaking, eBooks and online courses.

Artemakis published hundreds of articles and videos that explain in simple words, how to perform complex technical tasks and he really enjoys the interaction with the technical communities.

Besides his regular blogging activities, Artemakis is also a guest author on many prestigious online technology journals.

Moreover, he currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA).

Artemakis, really enjoys sharing hands-on knowledge on a large set of technology topics, and thus helping his fellow tech community members, to easily start using these great technologies. To this end, he is really looking forward to seeing you in his online courses on Udemy!

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