Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication 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 Certifications Network & Security Hardware Operating Systems & Servers 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 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 Paid 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 & Gardening 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 & Diet Yoga Mental Health Martial Arts & 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 Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js Typescript HTML5 PHP
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Data Analysis Data Warehouse Business Intelligence Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin SwiftUI Mobile App Development
Graphic Design Photoshop Adobe Illustrator Drawing Canva Digital Painting InDesign Design Theory Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Sound Therapy Emotional Intelligence Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Online Business Startup Business Plan Blogging Amazon Kindle Direct Publishing (KDP)
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Copywriting Email Marketing Google Analytics Startup Advertising Strategy

DevelopmentDatabase Design & DevelopmentSQL Server

Microsoft SQL Server Development for Everyone

Learn the fundamentals of database design, development and querying using the latest Microsoft SQL Server
Rating: 4.7 out of 54.7 (1,395 ratings)
135,822 students
Created by Trevoir Williams, Learn IT University, Andrii Piatakha
Last updated 4/2022
English
English [Auto]

What you'll learn

  • Basic Database Design (Tables, Columns, Data Types, Primary Keys, Normalization)
  • Using Microsoft SQL Management Studio
  • SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping)
  • DELETE: How to remove data from a database
  • INSERT INTO: How to insert data into a table
  • UPDATE: How to update existing data
  • Filter groups of data using the HAVING clause
  • Overall Database Development Best Practices
  • Creating Relationships and Foreign Keys
  • How to query related data from multiple tables
  • Using Aggregate Functions in SQL
  • How to export Query Results to Excel
  • How to craft SQL statements based on real scenarios
  • Create Complex Database Objects (Stored Procedures, Functions, Views, Triggers)
  • Backup and Restore Databases
  • Generate Database Scripts for Automation

Requirements

  • A Computer
  • A desire to learn database development

Description

Overview

This is a zero to hero course on Microsoft SQL Databases and Querying. There are no pre-requisites for this course. This course provides you with fundamental SQL Server training and is enough to get you started as a Database Developer or Junior Database Administrator.

This course will teach you how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world.

Why Learn Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications

We will explore best practices in database development using SQL Server and will be building a small school management system database.

All you need is a windows machine and we will walk through setting up an environment, to creating a database, creating your first table and writing queries.

At the end of this course, you should be comfortable writing queries for multiple situations and reports.

What you’ll learn

  • Install SQL Server and SQL Server Management Studio

  • Connect to a Database Instance

  • Create a Database

  • Create Tables

  • Run Queries against Tables

  • General use of the Management Studio

  • Create Relationships (Normalization)

  • Use Aggregate functions to do quick mathematical operations

  • Export data to Excel using the Management Studio

  • Practical use of SQL

  • Creating and Managing Database Views

  • Creating and Managing Custom Functions; Table Triggers and Stored Procedures

  • How to Backup and Restore Databases

Are there any course requirements or prerequisites?

  • A Windows PC (or Windows running on a Virtual Machine if using Linux/Mac)

Who this course is for:

  • This course is for beginners with absolutely no experience.

  • This course is for you if you are already comfortable with basic database operations.

  • This course is for you if you feel a bit 'rusty' and need to refresh your knowledge.

  • This course is for you if you want to understand design principles in database development.

  • This course is for you if you are proficient in Microsoft Access and want to learn a new Database Management System

  • This course is for EVERYONE!

Content and Overview

This is a complete course. Over 6 hours of premium content, all put together to ensure that you get up and running with becoming a Database Developer and/or Administrator. I take you through various scenarios and techniques to write queries, build a database and further administrate, then we touch more advanced topics that are in great demand in the workplace.

By the time you have finished the course you will have moved around in Microsoft SQL Manager Studio so much, that it will become second nature for you when interacting with your databases, found on different servers. This will put your new learned skills into practical use and impress your boss and coworkers.

The course is complete with working files and scripts, making it easy for you to replicate the code being demonstrated. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.

Clicking the Take This Course button could be the best step you could take towards quickly increasing your income and marketability! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund!


It's time to take action! This deal will not be available forever!

See you in the course!

Who this course is for:

  • Beginner Database Developer
  • Intermediate Database Developers
  • Potential Database Administrators
  • Those who work in organizations where the company typically uses Microsoft databases.

Instructors

Trevoir Williams
Top-Rated Instructor • 350,000+ Students
Trevoir Williams
  • 4.6 Instructor Rating
  • 9,968 Reviews
  • 362,318 Students
  • 23 Courses

Trevoir Williams is a passionate software and system engineer with a strong drive to share the best of his knowledge with students around the globe. His educational achievements include a Master’s degree in Computer Science (major in Software Development) and several Microsoft Azure Certifications.

His impressive work experience includes software consulting, software engineering, database development, cloud system, and server administration, lecturing, and he’s also a musician!

Trevoir enjoys teaching IT and development skills and guides students in gaining the latest knowledge with practical application in the modern industry.

Learn IT University
The Best Programming Courses
Learn IT University
  • 4.5 Instructor Rating
  • 29,523 Reviews
  • 783,086 Students
  • 30 Courses

We are group of teachers that creates programming courses for everyone: beginners and experts.

Together we helped 150k+ students from more than 150 countries to start IT career and to sharp existing skills.

We constantly work on updates and new courses to provide our students with the relevent and up-to-date knowledge.

Andrii Piatakha
Founder and CEO in IT-Bulls, Founder of Learn-IT University
Andrii Piatakha
  • 4.5 Instructor Rating
  • 29,767 Reviews
  • 786,528 Students
  • 38 Courses

Founder and CEO in IT-Bulls. IT-Bulls is a consultancy company that promotes engineering excellence standards, holds audits of software projects, and provides private consultancy.

Creator of Learn-IT Online University and mobile application that help to get certified in different domains.

Tutor with 5+ years of experience. Key Java Tutor in outsourcing companies. Andrii helps to teach Java software engineers from zero till their first job assignment.

You can find courses in different areas. But one of his most popular courses "Java from Zero to First Job". The Java course is used to train people with zero programming knowledge to prepare them for real work in different companies.

When you are taking Andrii's courses you can be sure that you will learn the right things in the right way in the shortest possible amount of time.

All Andrii's courses are proven by time and success stories of the students.

Not all tutors were professional programmers in past. Huge engineering experience allowed Andrii to run his own IT company. During the teaching, Andrii focuses students' attention only on the most important things.

Feel free to check out Andrii's LinkedIn profile and especially confirmation of the skills. Already more than 1000+ professional engineers, managers, and software architects all over the World confirmed Andrii's skills in Java EE technologies stack.

Andrii spent a lot of time tutoring offline to understand students and key issues they face with during their education process. Detailed homeworks and practical experience - that's what help students to get knowledge.

IT-Bulls creates applications with students which allow people to pass internship and get more practical experience.

The best students managed to get their first job in IT-Bulls and now become leading engineers in the company!

So be prepared to become the best friend of IT-Bulls company.

Learn more about Andrii's career and skills in LinkedIn profile and follow Andrii on Instagram! 

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Terms
  • Privacy policy
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.