SQL

4 out of 5
4
6 reviews

SQL (Structured Query Language) is used to retrieve data or otherwise interface with a relational database. Simple SQL commands like SELECT, ORDER BY and INSERT help administrators to route data in and out of a database table. This goes on over all sorts of platforms, and is a major part of delivering data results in today’s cloud and hybrid distributed systems. Because of the fairly straightforward syntax and ease of use, administrators can focus on the theory of database construction and the logistical aspect of getting data into and out of systems.

Learning SQL will allow you to unearth information from data with greater efficiency. SQL is well suited to data manipulation. Bringing together data from two or more sources can be a time-consuming and scary task. However, SQL makes the process simple using “unions” for joining databases. Extracting key trends and performance indicators from the mass of data that is collected allows a business to operate more effectively.

Main Features

  • Study relational database management theory that you will need in your workplace every day
  • Learn how to create a database from scratch
  • The ability to take control of your dataset – insert, update, and delete records from your database
  • Be confident while working with constraints and relating data tables
  • Become a proficient MySQL Workbench user
  • Acquire top-notch coding techniques and best practices
  • Know how to answer specific business questions by using SQL’s aggregate functions
  • Handle complex SQL joins with ease

Introduction to SQL

1
Installation of SQL
2
SQL Techniques
3
Where to apply SQL
4
Operators in SQL
5
Data Types in SQL
6
Sql Commands
7
Difference between SQL, Mysql
8
How to install Mysql

Database creation

1
What is a database
2
Utility of Database
3
Database Structure
4
Types of database
5
What is RDBMS
6
What is a table: Table Structure
7
Applying different data-types
8
Creating Tables
9
Constraints-Null
10
Not Null
11
Primary key, Foreign Key
12
Unique, Index, Default, Check

Manipulating Tables

1
Steps to Insert values to table
2
What are the requirement
3
Parameters in the query
4
Optional Parameters
5
Why Update query is important
6
The structure of update query
7
Parameters in the Update query
8
Where syntax
9
Utility of Where Syntax
10
Select query, Delete query

Syntaxes

1
Sorting in SQL
2
Order syntax
3
The In syntax
4
Utility of in syntax
5
Between syntax
6
Alias syntax

Joins different types of joins in tables

1
What are joins
2
Why are joins required
3
Left, Right, Inner Joins
4
Full, Self Join
5
Application of Joins

Queries

1
What is a subquery
2
Importance of subquery
3
Order of execution of subquery
4
Importance of group by syntax
5
Union syntax
6
Application of Union Syntax
7
Importance of having syntax
8
Difference between union, having Distinct/Unique clause

Functions in SQL

1
Parameters In function and Importance of parameters
2
Textual functions: NULL, Concat, Format, Insert
3
Lcase, Left, Length, Lower, LTrim
4
Replace, Strcmp, Substring
5
Use of Wildcard Characters
6
Patter Matching
7
Numeric Functions: Sum, Average, Max, Min, Round, Truncate

Date Functions in SQL

1
Different date and time functions: Adddate, Addtime
2
Date, Datediff, Date_ADD, Day, Hour, Month, Now
3
What is a view and its importance
4
Create and use a View

Triggers and Stored Procedures

1
What is a trigger
2
When is a trigger required
3
How to apply a trigger
4
Syntax of a trigger
5
What is a stored procedure
6
Why is a stored procedure important
7
When to apply a stored procedure
Faq Content 1
Faq Content 2

Productivity Hacks to Get More Done in 2018

— 28 February 2017

  1. Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
  2. Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
  3. Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!


4
4 out of 5
6 Ratings

Detailed Rating

Stars 5
3
Stars 4
0
Stars 3
3
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
Add to Wishlist
Enrolled: 34 students
Duration: 10 hours
Lectures: 67
Video: 40 hours
Level: Advanced

Archive

Working hours

Monday 9:30 am - 7.00 pm
Tuesday 9:30 am - 7.00 pm
Wednesday 9:30 am - 7.00 pm
Thursday Closed
Friday 9:30 am - 7.00 pm
Saturday 9:30 am - 7.00 pm
Sunday 9:30 am - 7.00 pm
WhatsApp chat