Course Details

Database Design and Management with SQL

Data Analytics
course-meta
Created by

Last Update

July 05, 2023

Created On

July 05, 2023

Description

SQL stands for Structured Query Language. It is a standard programming language used for managing and manipulating relational databases. SQL allows users to create, modify, and retrieve data from databases, as well as perform various operations such as inserting, updating, and deleting records. It provides a set of commands and statements that enable efficient communication with databases, making it a crucial tool for working with data and information stored in a structured manner.

Overview

Participating in database courses offers valuable skills in managing databases, designing efficient structures, ensuring data integrity, and performing data analysis. These courses enhance career prospects in data analysis, database development, and business intelligence, enabling participants to contribute to effective data management and decision-making processes.

Features

What you'll learn

  • Benefits of Database Management Systems
  • Relational Database Management System Overview
  • Entity-Relationship Modeling and Diagramming
  • Database Normalization Techniques
  • Overview of SQL
  • Data Definition Language (DDL) and Data Manipulation Language (DML) Statements
  • Querying Data with SQL
  • SQL Aggregate Functions
  • Joining Tables and Performing Set Operations
  • Ensuring Data Integrity in Databases
  • Applying Constraints in SQL
  • Creating and Managing Views

Prerequisites

Curriculum

  • 22 modules

Definitions of Data, Field, Record, and Database

Drawbacks of File Management System

Advantages of Database Management Systems Explained

Introduction to Relational Database Management Systems (RDBMS)

Client-Server Model Explained

Requirement Analysis Process

Entity and Relationship Identification

E-R Diagram Creation Methods

Mapping E-R Diagrams to Database Tables

Achieving First Normal Form

Attaining Second Normal Form

Implementing Third Normal Form

Real-world Application of Normalization

SQL Server Version History and Editions Comparison

Installing SQL Server on Windows

Essential Features, Components, and Tools in SQL Server

Managing SQL Server Instances and Services

Overview of SQL Server Management Studio

System Databases in SQL Server

Understanding SQL Statement Types

Categories of SQL Statements

Creating Databases with Management Studio

SQL Server Datatypes Overview

Using Management Studio to Explore DDL Statements on Tables

Advantages of Writing SQL Statements in Frontend Applications

Create, Alter and Drop Table Insert,

Update and Delete Statement Truncate Statement

Implementing Top, Distinct, Null, and other Keywords in DQL

Utilizing String and Arithmetic Expressions in DQL

Examining the Where Clause with Operators in DQL

Employing Advanced Operators in DQL

Sorting Data using the Order By Clause in DQL

Working with Subqueries in DQL

Using functions in Queries

Count, Sum, Min, Max, Avg Group By and Having Clause

Using Group By with Rollup and Cube

Understanding Cross Joins in SQL

Working with Inner Joins in SQL

Exploring Outer Joins in SQL

Performing Self Joins in SQL

Utilizing Co-related Subqueries in SQL

Applying Set Operations (Unions, Intersect, and Except) in SQL

Implementing Domain Integrity in Data

Ensuring Referential Integrity in Data

Various Types of Data Constraints

Unique Constraint

Not NULL Constraint

Primary Key Constraint

Default Constraint

Check Constraint

Foreign Key Constraint

Managing Views in SQL

Exploring Advanced View Creation Options

Understanding SQL Server Catalog Views for Views

Granting and Revoking Roles and Privileges in DCL

Managing Users, Roles, and Privileges using Management Studio in DCL

Introduction Clustered and Non Clustered Index

Creating and Dropping Indexes

Managing Variables in T-SQL Scripts and Batches

Implementing Control Flow Statements in T-SQL

Utilizing Temporary Tables in T-SQL

Handling Errors in T-SQL

Employing System Functions and Global Variables in T-SQL

Dynamic SQL Usage in T-SQL

Advantages of Using Stored Procedures

Managing Stored Procedures in SQL

Working with Parameters in Stored Procedures

Exploring System-defined Stored Procedures and Functions

Creating and Using User-defined Functions

Comparing Constraints and Triggers

Managing Triggers in Database Systems

Different Types of Triggers and Their Usage

Implementing Rollback Tran in Triggers

Comparing Cursors and Select Statements

Exploring Different Types of Cursors

Understanding Locking Mechanisms for Cursors

Benefits and Advantages of Using Cursors

Differentiating Implicit and Explicit Transactions

Managing Locks in Transactional Processing

Exploring Different Types of Locks in TCL

Running SQL Scripts for Backup

Creating Change Scripts for Backup

Performing Database Backup

Restoring Database from Backup

Attaching and Detaching Databases

1. What is SQL? 2. How to create a table in SQL? 3. How to delete a table in SQL? 4. How to change a table name in SQL? 5. How to delete a row in SQL? 6. How to create a database in SQL? 7. What is Normalization in SQL? 8. What is join in SQL? 9. What is SQL Server ? 10. How to insert date in SQL? 11. What is Primary Key in SQL? 12. How do I view tables in SQL ? 13. What is PL/SQL 14. What is MYSQL? 15. How can see all tables in SQL ? 16. What is ETL in SQL? 17. How to install SQL? 18. What is the Update Command in SQL ? 19. How to rename column name in SQL server ? 20. What are the types of SQL Queries? 21. Write a Query to display the number of employees working in each region ? 22. What are nested Triggers ? 23. Write a Query the employee names having a salary greater than 20000 or equal to or less than 10000 24. Given a table Employee having columns empName and empid, what will be the result of the SQL query below? Select empName from Empolyee order by 2 asc; 25. What is OLTP? 26. What is Data Integrity? 27. What is OLAP? 28. Find the constraints information from the table 29. Can you get the list of employees with same salary ? 30. What is an alternative for TOP clause in SQL 31. Will following statement give error or 0 as output ? SELECT AVG (NULL) 32. What is cartesian product of the Table ? 33. What is a schema in SQL? 34. What is the where clause in SQL ? 35. How to delete a column in SQL? 36. What is a unique key in SQL? 37. How to Implement multiple conditions using WHERE Clause ?

1. What is SQL Injection ? 2. What is a Trigger in SQL ? 3. How to insert multiple rows in SQL ? 4. How to find the nth Highest salary in SQL ? 5. How to Copy table in SQL ? 6. How to add a new column in SQL ? 7. How to use LIKE in SQL ? 8. If we drop a table, does it also drops related objects like constraints, indexes, columns, default, views and sorted procedures ? 9. Can we disable trigger? If yes, How ? 10. What is a Live Lock ? 11. How to fetch alternate records from a table ? 12. Define COMMIT and give an example ? 13. Can you join table by itself ? 14. Example Equi join with example ? 15. How do we avoid getting duplicate entries in a query ? 16. How can you create an empty table from an existing table ? 17. Write a query to display odd records from student table ? 18. Explain Non Equi join with example ? 19. How can you delete duplicate records in a table with no primary key ? 20. Difference between NVL and NVL2 functions ? 21. What is the difference between clustered and non-clustered indexes ? 22. What does this query says ? GRANT privilege_name ON object_name TO {user_name|PUBLIC |role_name } [WITH GRANT OPTION];

Instructors

Skoliko Faculty

image not found
₹0.00

Free Course

  • Modules
    22 Modules
  • Category
    Data Analytics

Login to View the Course