SQL Server Specialist

This course provides knowledge on advanced database technologies.

+ View more
Course overview

Course Description

This course provides knowledge on advanced database technologies. It covers the more sophisticated aspects including: Object-oriented model, object-relational model, conceptual database design; Transaction processing: transactions, failure and recovery, and concurrency control techniques; Database backup and recovery; Query processing and optimization; Database security; Distributed databases: distributed data storage, distributed query processing, distributed transaction processing, Business Intelligence and concurrency control.

Textbook
  • Database Systems: A Practical Approach to Design, Implementation and Management, Connolly, T. M. &Begg, C., 6th Edition (2016), Addison-Wesley
  • SQL The Complete Reference, Third Edition, Games R.Groff at el.
  • SQL for Data Analytics Perform fast and efficient data analysis with the power of SQL by Upom Malik, Matt Goldwasser, Benjamin Johnston

What will i learn?

  • Manage SQL Server Administration; install SQL Server in a Production environment following best practice, review storage, data and log files necessities, understand the importance of backups and restores, configure security and more
  • By the end of this course you will be a professional SQL database administrator and be able to apply for SQL jobs
  • You will be able to troubleshoot everyday SQL related issues
  • You will learn 150+ SQL queries
  • Students will be able to run reports for management so they can make financial decisions
Requirements
  • Specific knowledge of SQL Server is helpful, but not required
  • A PC or MAC with at least 4-8G of RAM
  • Positive attitude and desire to learn
Curriculum for this course
Intro & Installations
  • Course Intro
  • SQL Intro
  • SQL Server Installations
  • SSMS Overview
  • Azure Data Studio Overview
  • Sample Databases
RDBMS
  • Types of Keys
  • ERD
  • Normalization
Database Design
  • Types of Commands
  • Data Types
  • Database
  • Tables
  • Constraints
Select Statement
  • Select
  • Select Column List
  • Where Clause
  • Comparison Operators
  • Like Operator
  • IN operator
  • Any & All
  • Distinct
Clause & Operators
  • Order by Clause
  • Top n Clause
  • Set operators
  • Group by clause
  • Having clause
Joins and special operators
  • Some operator
  • Exists Operator
  • Joins
  • Inner join
  • Outer join
  • Cross join
  • Non-ANSI Joins
Data Manipulation Language - DML
  • Insert Statement
  • Sequence Object
  • Update Statement
  • Delete Statement
  • Cascading referential integrity
  • Merge Statement
  • Output Clause
Built-in Functions
  • Functions
  • String Functions
  • Data time functions
Control-of-flow & Built in Functions
  • Control-of-flow statements
  • Other Scalar functions
  • Ranking Functions
Views & User Defined functions
  • Simple View
  • Complex View
  • Views advance features
  • Scalar Valued functions
  • Tabled valued functions
  • Functions advance features
Stored Procedures & Triggers
  • Stored Procedure
  • Stored Procedure output
  • Advance SP
  • DML Triggers
  • DDL Triggers
Exception handling & Indexing
  • Indexing
  • Try Catch
  • Transactions
+ View more
Other related courses
AWS Developer Associate
Updated Thu, 09-Jun-2022
AWS SysOps Administrator
Updated Thu, 09-Jun-2022
Data Science
Updated Thu, 09-Jun-2022
Apply Now
Includes:
  • Verified Certificate
  • Internship Opportunity
  • Career Development

Copyright © 2024 DigiPAKISTAN - National Skills Development Program. All Rights Reserved