Udemy - Complete beginners introduction to SQL [Course Drive]

seeders: 0
leechers: 0
updated:
Download torrent
Added by coursedrive in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 78
  • Language: English

Files

Complete beginners introduction to SQL Complete beginners introduction to SQL 05 Filtering Records and Case expressions
  • 036 Filtering data with logical operators.mp4 (47.3 MB)
  • 034 CASE Expressions.mp4 (29.0 MB)
  • 035 Filtering data with NULL.mp4 (12.3 MB)
  • 037 Filtering data with string comparison.mp4 (29.7 MB)
  • 038 Filtering Records with Comparison filters.mp4 (15.6 MB)
  • 039 Filtering Records with equality filter.mp4 (39.3 MB)
  • 040 Grouping Data.mp4 (25.5 MB)
  • ReadMe.txt (0.4 KB)
  • Visit Coursedrive.net.url (0.1 KB)
    • 01 Introduction and Database Setup
    • 001 Introduction.mp4 (4.0 MB)
    • 002 What is SQL.mp4 (4.1 MB)
    • 003 What is T-SQL.mp4 (4.4 MB)
    • 004 Database concepts.mp4 (7.2 MB)
    • 005 Hardware and software requirements.mp4 (8.6 MB)
    • 006 SQL Server Download.mp4 (9.4 MB)
    • 007 installing SQL Server 2014.mp4 (12.0 MB)
    • 008 Introduction to SSMS.mp4 (13.2 MB)
    • 009 Download Adventureworks Database.mp4 (10.3 MB)
    • 010 Attaching Adventureworks Database.mp4 (9.5 MB)
    • 011 What is Query.mp4 (16.8 MB)
    • Must Read.txt (0.4 KB)
    • Visit Coursedrive.net.url (0.1 KB)
    02 Performing A CRUD Operation
    • 012 Introduction to CRUD.mp4 (2.2 MB)
    • 013 Creating a view.mp4 (20.1 MB)
    • 014 Retrieving and Reading data with SELECT.mp4 (28.2 MB)
    • 015 Adding Records to a table.mp4 (26.6 MB)
    • 016 ORDER BY Clause.mp4 (7.9 MB)
    • 017 Updating existing database records.mp4 (19.1 MB)
    • 018 Deleting Records from a table.mp4 (16.2 MB)
    • 019 Using Aliases.mp4 (14.2 MB)
    • 020 Removing Duplicates.mp4 (17.2 MB)
    • 021 Sorting Data in ascending order.mp4 (10.6 MB)
    • 022 Sorting data by multiple columns.mp4 (13.2 MB)
    • 023 Using Comments in your queries.mp4 (16.4 MB)
    03 Introduction to Joining Tables
    • 024 Why do we Join Tables.mp4 (1.4 MB)
    • 025 INNER JOIN.mp4 (26.7 MB)
    • 026 Left Outer Join.mp4 (28.6 MB)
    • 027 Right Outer Join.mp4 (20.1 MB)
    04 Aggregate Functions
    • 028 What are aggregate functions.mp4 (4.2 MB)
    • 029 COUNT.mp4 (20.3 MB)
    • 030 SUM.mp4 (15.4 MB)
    • 031 AVG.mp4 (18.5 MB)
    • 032 MIN.mp4 (14.3 MB)
    • 033 MAX.mp4 (13.7 MB)
    • Visit Coursedrive.net.url (0.1 KB)
    • Course Downloaded from coursedrive.net.txt (0.4 KB)

Description

Complete beginners introduction to SQL Download

Learn the basics of SQL in practical hands -on steps





What you'll learn

Download SQL Server
Install SQL Server
Download sample database
Attach sample database to SQL Server
Create a database table
Create a view
Update Records
Delete records
Retrieve and read data from database
Use SSMS Tool
Join tables

Requirements

Basic knowledge of using a pc

Description

SQL -Structural Query language is the language used to interrogate and manipulate Microsoft SQL Server Databases.

SQL is one of the most in demand IT Skills and has been that way for quite a long time.  Data  growth is increasing and so also is the demand for professionals with SQL skills.

This course is a complete beginners course for those who have had no exposure to SQL.
It is a very basic and practical hands on course to introduce you to SQL.
We will be using SQL Server as our database engine for this course.
Microsoft SQL Server is robust relational database management system used by so many
organizations of various sizes including top fortune 100 companies.

In this course we will cover:

Download  and Install SQL Server
Database concepts
Download  sample database
Attach sample database
Create a view
Create a table
Retrieve and reading data from a database using SELECT Statement
Updating existing data in the database
Deleting records from a database

Use Aliases
Use order by clause
Sort data by ascending order
Sort data by multiple columns
Add new records
Update existing records
Delete records
Joining Tables
Inner joins
Left outer joins
Right Outer joins

SQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language. In this course, you learn to use the full potential of SQL to write simple queries for SQL Server databases.

Who is the target audience?

Basic knowledge of navigating the internet



Download More Latest Courses Visit -->> Course Drive



Download torrent
653.4 MB
seeders:0
leechers:0
Udemy - Complete beginners introduction to SQL [Course Drive]
Loading...