Introduction to Sql Language

[vc_row][vc_column][vc_column_text]

COURSE OVERVIEW

SQL (Structured Query Language) is a common tool for retrieving data from relational databases such as SQL Server, MySQL, MariaDB, and PostgreSQL. This course provides an introduction to this core programming language. Learn how to request data from a server, limit and sort the responses, aggregate data from multiple tables with joins, and edit and delete data. Instructor also shows how to perform simple math operations and transform data into different formats.

COURSE SUMMARY

By the end of this course, you should be able to learn and implement:

• Understanding SQL terminology and syntax
• Creating new tables
• Inserting and updating data
• Writing basic SQL queries
• Sorting and filtering
• Accessing related tables with JOIN
• Working with strings
• Understanding numeric types
• Using aggregate functions and transactions
• Automating data with triggers
• Creating views
• Defining functions in PHP

[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][academia_heading title=”Curriculum” title_size=”fs-18″ text_align=”text-left”][vc_empty_space][academia_course_sections title=”Section 1″][academia_course_lesson badge=”exercise” icon_tool_tip=”Exercise” title=”Introduction to SQL”]

• The various types of databases
• introduction to Structured Query Language
• distinction between client server and file server databases
• understanding SQL Server Management Studio
• SQL Table basics
• data types and functions
• Transaction-SQL
• authentication for Windows
• Data control language
• Identification and Keywords in T-SQL
• Drop Table

[/academia_course_lesson][/academia_course_sections][academia_course_sections title=”Section 2″][academia_course_lesson badge=”exercise” icon_tool_tip=”Exercise” title=”SQL operators”]

• Introduction to relational databases
• basic concepts of relational tables
• working with rows and columns
• various operators used like logical and relational
• domains
• constraints
• stored procedures
• indexes
• primary key and foreign key
• understanding group functions
• unique key

[/academia_course_lesson][/academia_course_sections][academia_course_sections title=”Section 3″][academia_course_lesson badge=”exercise” icon_tool_tip=”Exercise” title=”Working With SQL –Join,Tables,Variables”]

• Deep dive into SQL Tables
• working with SQL functions
• operators and queries
• creation of tables
• retrieving data from tables
• combining rows from tables using Inner
• Outer
• Cross and Self joins
• deploying Operators like Union, Intersect, Except, 
• creation of Temporary Table
• Set Operator rules
• working with Table variables

[/academia_course_lesson][/academia_course_sections][academia_course_sections title=”Section 4″][academia_course_lesson badge=”exercise” icon_tool_tip=”Exercise” title=”Deep dive into SQL Functions”]

• Understanding what SQL functions do
• aggregate functions
• scalar functions
• functions that work on different data sets like numbers, characters & strings, dates
• learning Inline SQL functions
• general functions and duplicate functions

[/academia_course_lesson][/academia_course_sections][academia_course_sections title=”Section 5″][academia_course_lesson badge=”exercise” icon_tool_tip=”Exercise” title=”WORKING WITH SUBQUERIES”]

• Understanding of SQL Subqueries
• rules of Subqueries, the statements and operators with which Subqueries can be used
• modification of sub queries using set clause
• understanding the different types of Subqueries – Where, Insert, Update, Select, Delete, etc.
• ways to create and view Subqueries.

[/academia_course_lesson][/academia_course_sections][academia_course_sections title=”Section 6″][academia_course_lesson badge=”exercise” icon_tool_tip=”Exercise” title=”SQL Views,Functions,Stored Procedures”]

• Learning about SQL Views
• ways of creating, using, altering, dropping, renaming and modifying Views
• understanding Stored Procedures
• key benefits of it
• working with Stored Procedures
• error handling
• studying user-defined functions

[/academia_course_lesson][/academia_course_sections][academia_course_sections title=”Section 7″][academia_course_lesson badge=”exercise” icon_tool_tip=”Exercise” title=”Deep Dive into User-defined Functions”]

• Detailed study of user-defined functions
• various types of UDFs like Scalar
• Inline Table Value
• multi-statement Table
• what are Stored Procedures? 
• when to deploy Stored Procedures? 
• What is Rank Function? 
• Triggers
• when to execute Triggers?

[/academia_course_lesson][/academia_course_sections][academia_course_sections title=”Section 8″][academia_course_lesson badge=”exercise” icon_tool_tip=”Exercise” title=”SQL Optimisation & Performance”]

• Detailed understanding of SQL Server Management Studio 
• learning what is Pivot in Excel and SQL Server
• XL path
• differentiating between Char
• Varchar and NVarchar
• working with Indexes
• creation of Index
• advantages
• records grouping
• searching, sorting
• modifying data
• creation of clustered indexes
• using index to cover queries
• index guidelines and Common Table Expression

[/academia_course_lesson][/academia_course_sections][academia_course_sections title=”Section 9″][academia_course_lesson badge=”exercise” icon_tool_tip=”Exercise” title=”Design and implement database objects”]

• Design and implement a relational database schema
• design and implement indexes
• distinguish between indexed and included columns
• implementing clustered index
• designing and implementing views
• implementing column store views

[/academia_course_lesson][/academia_course_sections][academia_course_sections title=”Section 10″][academia_course_lesson badge=”exercise” icon_tool_tip=”Exercise” title=”Implementing programmability objects”]

• Defining table and foreign key constraints
• writing Transact-SQL statement
• identifying results of Data Manipulation Language (DML)
• designing stored procedure components
• implementing input and output parameters
• implementing error handling
• transaction control logic in stored procedures
• designing trigger logic
• DDL triggers

[/academia_course_lesson][/academia_course_sections][academia_course_sections title=”Section 11″][academia_course_lesson badge=”exercise” icon_tool_tip=”Exercise” title=”Managing database concurrency”]

• Implementing transactions
• Identifying DML statements based on transaction behaviour
• understanding explicit and implicit transactions
• managing isolation levels
• identifying concurrency and locking behaviour
• implementing memory – optimised tables

[/academia_course_lesson][/academia_course_sections][academia_course_sections title=”Section 12″][academia_course_lesson badge=”exercise” icon_tool_tip=”Exercise” title=”Optimising database objects”]

• Determining accuracy of statistics
• designing statistics maintenance tasks
• using dynamic management objects
• identifying missing indexes
• consolidating overlapping indexes
• analysing and troubleshooting query plans
• managing performance of database instances
• monitoring SQL server performance

[/academia_course_lesson][/academia_course_sections][academia_course_sections title=”SQL Projects”][academia_course_lesson badge=”exercise” icon_tool_tip=”Exercise” title=”Optimising database objects”]Project 1 : Writing complex Sub Queries

Industry : General

Problem Statement : How to create sub queries using SQL

Topics : This project will give you hands-on experience in working with SQL sub-queries and utilizing it in various scenarios. Some of the sub-queries that you will be working with and gain hands-on experiences in are – IN or NOT IN, ANY or ALL, EXISTS or NOT EXISTS, and other major queries.

Highlight :

Accessing and manipulating databases

Operators & Control Statements in SQL

Executing queries in SQL against databases.

Project 2 : Querying a large relational database

Industry : General

Problem Statement : How to get details about customers by querying the database

Description :  In this project you will work on downloading a database and restoring it on the server. You will then query the database to get customer details like name, phone number, email id, sales made in a particular month, increase in month-on-month sales and even total sales made to a particular customer.

Highlights :

Table basics and data types

Various SQL Operators

Various SQL Functions.

Project 3 : Relational database design

Industry :  General

Problem Statement : How to convert a relational design into a table in SQL Server

Topics : In this project you will work on converting a relational design that has enlisted within it the various users, user roles, user accounts and their statuses. You will create a table in SQL Server and insert data into it. With at least 2 rows in each of the tables, you have to ensure that you have created respective foreign keys.

Highlights :

Define Relations/Attributes

Define the Primary Keys

Create Foreign Keys[/academia_course_lesson][/academia_course_sections][/vc_column][/vc_row]