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 20m
filed under

placing your order...

Don't refresh or navigate away from the page.
liveVideo liveVideo courses make it simple to learn complex concepts and technologies. Through quality lessons and short videos from expert programmers, you'll gain the skills you need to progress your career. $62.99 $69.99 you save $7 (10%)
Microsoft SQL Server Development for Everyone (liveVideo) added to cart
continue shopping
adding to cart

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 eBook every time you renew
  • choose twelve free eBooks per year
  • exclusive 50% discount on all purchases
  • Microsoft SQL Server Development for Everyone eBook for free
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
RECENTLY VIEWED