About This Course
This course lays the foundations for understanding the basics of SQL programming. We’ll accomplish this by examining the various data estate professions. Additionally, we'll discuss the fundamentals of database planning and modeling, primary database objects, SQL syntax basics and relational data access.
What You'll Learn
- Fundamentals of Relational Theory and the Normalization process
- Techniques for using graphical and command-line tools to work with SQL Server and its objects
- How to connect to SQL Server databases
- Methods for writing, testing and tuning advanced T-SQL language elements
- How to design relational database structures from a set of business requirements
- The basics of Microsoft Cloud Data Services
Get Hands-On Experience
- Build and deploy a database as your final project, delivered as a series of scripts, along with the entity relationship diagram (ERD) and pertinent conceptual documents
- Practice using tools such as SQL Server Management Studio, Microsoft PowerShell, and Git source code control
