Data Science with SQL
About Course:
 
The fields of Data Science and Data base management involve in the development of  report which is very essential for today's Health care research and other Business industries.Application of  Excel to make understand Health care discoveries. A solid background in Excel and other industry is extremely helpful to improve research and business.

Data Science with SQL

₹9,000.00Price
  • Syllabus:
     
    • Introduction to SQL  
      Data Definition Language (DDL)
      Data Manipulation Language (DML)
       Introduction to  SQL Server.
      SQL Server Management Studio
      Create a new Database
      Queries
      CREATE TABLE
      Create Tables using the Designer Tools
      SQL Constraints
      PRIMARY KEY
      FOREIGN KEY
      NOT NULL / Required Columns
      UNIQUE
      CHECK
      ALTER TABLE
      INSERT INTO
      UPDATE
      DELETE
      SELECT
      The ORDER BY Keyword
      SELECT DISTINCT
      The WHERE Clause
      Operators
      LIKE Operator
      IN Operator
      BETWEEN Operator
      Wildcards
      AND & OR Operators
      SELECT TOP Clause.
      Joins
      Different SQL JOINs
       SQL Scripts
      Comments
      Single-line comment
      Multiple-line comment
      Variables
      Built-in
      Global Variables
      @@IDENTITY
      Flow Control
      IF – ELSE
      WHILE
       Views
      Stored Procedures
      Functions
      Built-in Functions
      String Functions
      Date and Time Functions
      Mathematics and Statistics Functions
      AVG()
      COUNT()
      The GROUP BY Statement
      The HAVING Clause
      User-defined Functions
      Triggers
       Communication from other Applications
      ODBC
      Microsoft Excel