SQL : Sql for Beginners

SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database.SQL is the standard language for Relational Database System. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database language.

SQL is widely popular because it offers the following advantages ,Allows users to access data in the relational database management systems.Allows users to describe the data.Allows users to define the data in a database and manipulate that data.Allows to embed within other languages using SQL modules, libraries & pre-compilers.Allows users to create and drop databases and tables.Allows users to create view, stored procedure, functions in a database.Allows users to set permissions on tables, procedures and views.

• SQL Fundamentals 2:43:00

  • 1: SQL-Introduction,,sql server 2014 express edition Installation (resource file) Preview 13:00
  • 2: working with sql server management studio Preview 02:48
  • 3: Create Table syntax Preview 04:32
  • 4: Alter Table-ALTER Column,Drop column,Add column 06:45
  • 5: Create table with Auto-Increment primary key Preview 04:51
  • 6: Insert Into TABLE-Syntax Preview 08:47
  • 7: Select from table,Select Distinct Preview 08:10
  • 8: Update query 06:40
  • 9: Delete query 04:41
  • 10: Drop Database Preview 04:13
  • 11: Drop Table syntax 04:42
  • 12: Primary keys,Foreign keys Preview 04:03
  • 13: Where Clause 03:10
  • 14: Where AND Clause 05:33
  • 15: OR Clause 05:30
  • 16: TOP Clause 01:52
  • 17: Order By clause 03:50
  • 18: GROUP BY Clause 03:26
  • 19: sql UNION ,UNION ALL 03:38
  • 20: sql-sum,average 03:16
  • 21: Sql-Max,Min 02:00
  • 22: Insert subquery 05:07
  • 23: Update-Sub query, (sub queries-resource file) 12:37
  • 24: Delete Subquery 04:56
  • 25: Alias 04:19
  • 26: SQL Joins 22:20
  • 27: Update-where clause 08:14

• Working with Stored Procedures 32:16

  • 28: select for table-Stored Procedure 05:18
  • 29: Insert Into Table-Stored Procedure 06:07
  • 30: Update Table-Stored Procedure 08:32
  • 31: Delete from Table-Stored Procedure 12:19

• Problem statement 11:00

  • 32: SQL-Problem statements 11:00

• 3 Real time Examples 03:00

  • 33: 3 real time examples 03:00

SQL is designed for a specific purpose: to query data contained in a relational database. SQL is a set-based, declarative programming language, not an imperative programming language like C or BASIC. However, extensions to Standard SQL add procedural programming language functionality, such as control-of-flow constructs.

Topics covered :-

• Sql required for Analysts etc,Sql basics related to Microsoft Developers
• WORKING with Stored Procedures,DDL AND DML Basics..
• working with SQL SERVER MANAGEMENT STUDIO
• Sql sub queries ,correlated queries

• students looking for career in sql development ,data analytics, databse administrations
• the RDBMS basic concepts like what is a database,field,tuple etc., is optional

• no complex programming knowledge required

students looking for career development in sql developement, administrations and data analytics ..

Currently there are no Q&As for this course. Be the first to ask a question.

Reed courses certificate of completion

Digital certificate - Included