placing your order...
Don't refresh or navigate away from the page.
Microsoft SQL Server Development for Everyone (liveVideo) added to cart
continue shopping
adding to cart
- customers also bought these items
- C# 10 and .NET 6 for Absolute Beginners
- Mastering Apache Maven
- Building Web APIs with ASP.NET Core
- Testing Web APIs
- Machine Learning Algorithms in Depth
choose your plan
pro
monthly
annual
$24.99
$249.99
only $20.83 per month
- share your subscription with one other person
- 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
Microsoft SQL Server Development for Everyone eBook for free
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?
- Quality lessons from expert programmers.
- Rich, interactive transcripts for navigation.
- Exercise driven learning.
what's a liveVideo?
