Microsoft SQL Server Development for Everyone you own this product

Learn the fundamentals of database design, development and querying using the latest Microsoft SQL Server
Trevoir Williams
  • Course duration: 8h 19m

pro $24.99 per month

  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • share your subscription with another person
  • choose one free eBook per month to keep
  • exclusive 50% discount on all purchases

lite $19.99 per month

  • access to all Manning books, including MEAPs!

team

5, 10 or 20 seats+ for your team - learn more


Look inside

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.

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 database management system.

You will go 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.

This is a zero to hero course on Microsoft SQL Databases and Querying. This course provides you with fundamental SQL Server training and is enough to get you started as a Database Developer or Junior Database Administrator.


Distributed by Manning Publications

This course was created independently by Trevoir Williams and is distributed by Manning through our exclusive liveVideo platform.

prerequisites

No pre-requisites for this course. Anyone who wants to become Database Developer or Junior Database Administrator can take this course.

what you will learn

  • Basic Database Design (Tables, Columns, Data Types, Primary Keys, Normalization)
  • Use 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
  • Create Relationships and Foreign Keys
  • Query related data from multiple tables
  • Use Aggregate Functions in SQL
  • Export Query Results to Excel
  • 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

about the instructor

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

what's a liveVideo?
Find out more

choose your plan

team

monthly
annual
$49.99
$499.99
only $41.67 per month
  • five seats for your team
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • Microsoft SQL Server Development for Everyone liveVideo for free