Najlepsze kursy internetowe w kategorii IT i oprogramowanie

[100% Off] Microsoft SQL Server Development for Everyone!| Worth 129,99$

 

Learn the fundamentals of database design, development and querying using Microsoft SQL Server 2017

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

This course includes:

  • 6 hours on-demand video
  • 1 article
  • 18 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion


Aucun commentaire