Learning Database Development with SQL [Integrated Course]

Learning Database Development with SQL [Integrated Course]

This video is included in a Mapt subscription
Aaron Barczewski, Ravindra Hirlekar

Get a head start on your aspiration of becoming a SQL developer
$0.00
$37.50
$29.99p/m after trial
RRP $124.99
Subscription
Video
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 4,000+ eBooks & Videos
  • 40+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Video Details

ISBN 139781788296816
Course Length1 hours 13 minutes

Video Description

Get started with SQL if you haven't yet! And explore SQL queries using the ever popular Microsoft SQL Server.

While Database management is a complicated process, SQL is the cost-efficient database management system. With this powerful and easy-to-use query language, tackle large datasets efficiently.

It has gained popularity in the recent years because of its dynamic and rich analytical capabilities. With this course, get a solid foundation in SQL and design efficient flexible database. Learning Database Development with SQL will help web- and back-end developers create robust SQL relational databases from scratch. This is a useful skill to have when wanting to create web-based applications.

This course will introduce them to all the fundamental and essential concepts of SQL. From designing your database to creating a simple web-application that stores data in a SQL database, learn all the quintessentials with ease. All examples are created by using SQL Server, an open-source RDBMS that can run on many platforms. We start off with a brief introduction to databases and database designs. We will swiftly move on to the fundamentals of SQL server and SQL and help you in creating their own relational databases.

This is the ideal course you need, to get a started with most highly in-demand skills--SQL and database management! Take your first step towards becoming a database administrator or a data analyst today.

Key Features

  • Fundamental information regarding SQL server
  • Basic idea about SQL database design and how to create your very first database
  • Design databases, tables, complex views, queries, functions and stored procedures through hand coding, point-and-click, or a mix of both
  • 16 assessment questions specific to the course
  • Supporting text files for theoretical information

Who this course is for

This course is particularly for novice web-based developers and SQL developers. This can be taken by anyone from newbies to database aficionados.

Table of Contents

Introduction to Databases
Course Overview
DBMS, DDL, and DML – Oh CRUD!
Differences among Database Engines, Servers, and Software
Tables, Attributes, and Records
Primary and Foreign Keys
Data Integrity and Consistency
Import and Export Data
Introduction to Database Design
Determine Data Requirements and Relationships
Entity-Relationship Model and Diagrams
Database Normalizing and Normal Forms
Introduction to MS SQL Server
Login to SQL Server Database
Create and Select Database
Backup and Restore Database
Introduction to SQL
SQL Syntax and Comments
Add Tables and Records
Add Consistency Constraints
Update and Delete Records

What You Will Learn

  • Understanding the basics of SQL server
  • Setting up the working environment for SQL server
  • Configuring and establishing connections
  • Introduction to database designs
  • Monitoring tables and usage of database metadata

Authors

Table of Contents

Introduction to Databases
Course Overview
DBMS, DDL, and DML – Oh CRUD!
Differences among Database Engines, Servers, and Software
Tables, Attributes, and Records
Primary and Foreign Keys
Data Integrity and Consistency
Import and Export Data
Introduction to Database Design
Determine Data Requirements and Relationships
Entity-Relationship Model and Diagrams
Database Normalizing and Normal Forms
Introduction to MS SQL Server
Login to SQL Server Database
Create and Select Database
Backup and Restore Database
Introduction to SQL
SQL Syntax and Comments
Add Tables and Records
Add Consistency Constraints
Update and Delete Records

Video Details

ISBN 139781788296816
Course Length1 hours 13 minutes
Read More

Read More Reviews

Recommended for You

Getting Started with Deep Learning with R [Integrated Course] Book Cover
Getting Started with Deep Learning with R [Integrated Course]
$ 124.99
$ 37.50
Automated Machine Learning Pipeline with Mesos [Integrated Course] Book Cover
Automated Machine Learning Pipeline with Mesos [Integrated Course]
$ 124.99
$ 37.50
Object-oriented and Functional Programming with Java 8 [Integrated Course] Book Cover
Object-oriented and Functional Programming with Java 8 [Integrated Course]
$ 124.99
$ 37.50
Dockerization - Do more with Docker [Integrated Course] Book Cover
Dockerization - Do more with Docker [Integrated Course]
$ 124.99
$ 37.50
Getting Started with Ansible [Integrated Course] Book Cover
Getting Started with Ansible [Integrated Course]
$ 124.99
$ 37.50
Getting started with Go Programming Language [Integrated Course] Book Cover
Getting started with Go Programming Language [Integrated Course]
$ 124.99
$ 37.50