Laravel – Tutorial



How to install it

You need to get “composer” first

#-> composer create-project –prefer-dist laravel/laravel:^7.0 blog

Laravel has “artisan” file at Root directory.

#-> php artisan key:generate “PHP artisani kosturur, -arguments i pass edersin. ”

web :80/laravel/blog/public/

# -> Routes Located  :    project/routes/web.php

#-> views Located :    project/resources/views/welcome.blade.php


# -> Middleware : Between Request – And Response Filter  (Config Stored at   project/Http/Kernel.php)

  • Global Middleware :  will run on every HTTP request
  • Route Middleware  :


Another Route


#-> Changing Default NameSpace

#-> Controller


Controller Calls Middleware

#-> Path Route

GET /my index my.index
GET /my/create create my.create
POST /my store
GET /my/{my} show
GET /my/{my}/edit edit my.edit
PUT/PATCH /my/{my} update my.update
DELETE /my/{my} destroy my.destroy

# You Can Assign Interface   – Implicit Controller.


#->  URL Checking

#-> Post Registration


#-> Response with cookie


#-> ServiceProvider : Sharing data with all views.

# -> Using Blade : new View

#-> welcome . blade.php


#-> Error Logging

#-> Forms

#-> Localization

#-> Session

#-> Validation Controller

#-> Mailer

#-> Ajax Controller

#Error Handling.





Minimum Requirements to Run SQL Server 2012 Express and SQL Server Management Studio


Minimum Requirements to Run SQL Server 2012 Express and SQL Server Management Studio
To begin, please make sure the computer you will be using meets these minimum requirements:

  • Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2 or Windows Vista (SP2 or later).
  • Internet Explorer 7 or higher. A free download is available from Microsoft — please click here.
  • For 32-bit systems, 1 GHz Intel or compatible processor (2 GHz or higher recommended).
  • For 64-bit systems, 1.4 GHz Intel or compatible processor (2 GHz or higher recommended).
  • 512 MB RAM (1 GB or more is recommended) and at least 2.2 GB of hard disk space for SQL Server Express and related components, plus at least 1 GB for ReliaSoft desktop applications.
  • SVGA display (1,024×768 pixels)
  • Microsoft .NET Framework 3.5 SP1 AND Microsoft .NET Framework 4.0. (.NET 3.5 is no longer included in the SQL Server installation; if it is not already on your computer, a free download is available from Microsoft– please click here. .NET 4.0 is included in the SQL Server 2012 installation files or a free download is also available separately from Microsoft — please click here.)
  • Microsoft Office 2000 or higher (Excel and Word) for automated report generation.

    These requirements satisfy the minimum specifications for SQL Server 2012 Express, SQL Server Management Studio Express and ReliaSoft desktop applications. For more details on Microsoft’s recommended minimum specifications for SQL Server 2012 Express, click here. For more details on our recommended minimum specifications for ReliaSoft applications, click here.

Mssql Server Comparison


Microsoft SQL server is the most popular and advanced Relational Database Management System (RDBMS)
by Microsoft. It is basically a software-based product and its primary role is storage and retrieval of data as per the request of the applications on
either the same system or a system on another network.

It supports large applications with millions of users or huge databases with advanced
features and security. SQL Server is fully compatible with MS Access database.
Data can be easily imported or exported between these two.

Microsoft SQL server is widely used for e-commerce, line-of-business, and data warehousing solutions.
There are dozens of different editions or versions of Microsoft SQL server provided by
Microsoft with different feature sets and pricing options. From many of them,
we are going to discuss two editions in this article. They are Microsoft SQL Server Express edition and Microsoft SQL Server Web edition.

Microsoft SQL Server Express edition

It is a scaled down, entry-level database option to learn and build desktop and small server
applications. It provides a number of features of the paid editions but some technical limitations
in terms of database size and the number of users make it unsuitable for large-scale installations.
Thus, it is a good choice for developers, independent software vendors (ISVs) and for those who build small client applications.

In case you need more advanced features of the database, SQL server express edition can be
upgraded to high-end versions. There are various versions of Microsoft SQL server express edition.
Here is a summary with the years in which they were released:

2017 None
2016 SP1
2014 SP1 and SP2
2012 SP1, SP2 and SP3
2008 R2 RTM, R2 SP1 and R2 SP2
2005 SP1, SP2, SP3 and SP4


  • There is no requirement of a license for using it, as it is free for distribution.
  • It is an easy to use version, designed for building simple data-driven applications up to 10 GB in size.
  • Includes SQL Server Management Studio. This helps administrators and developers of different skill levels use SQL Server efficiently.
  • Applications develop faster through the deep integration with Visual Web Developer, Visual Studio, and so on.
  • Enhanced reporting services help create and share reports that answer complex questions through rich visualizations.
  • Easy backup and restore functionality to Microsoft Azure.
  • It comes with same monitoring tools that come with Standard and Enterprise editions.
  • It comes with various security features  – row-level security, always encrypted, dynamic data masking, basic auditing, and fine-grained auditing. One also gets features like user- defined roles and contained databases.
  • It allows one to install Machine Learning services with both Python and R language.
  • It allows you to scale your applications across Server editions as you grow – without modifying application code.
  • It’s completely supported by Microsoft, including updates and patches from time to time.


  • SQL Server Express can be installed on a server with many CPUs. But, it can use only one CPU at a time.
  • 4GB database size limit was there for SQL2005/2008 but after 2008R2 it has been increased to up to 10GB for each database. The limit is applicable on database data files and not log files.
  • Can only use a maximum of 1410 MB memory per instance.
  • There’s no SQL Server Agent with the Express edition.
  • The performance analysis tool, Profiler, is not included with the SQL Server Express edition.
  • The functionality to create and attach a schedule to a job (Job Scheduler) is not available with the express edition.
  • Analysis and Integration Services are also not provided, but you can import or export the data with SQL Server Import and Export Wizard feature available with the SQL server express.

Microsoft SQL Server Web edition


  • You can centrally manage your business infrastructure with its SQL Management Studio and management packs.
  • Provides an added support for Windows PowerShell to automate various management tasks.
  • Has robust development tools integrated into Visual Studio to support next-generation enterprise, web, business intelligence, mobile applications and so on.
  • You get Distributed Replay feature that helps you assess the impact of future upgrades of server, hardware and operating system upgrades.
  • You get SQL Server Agent, which can be used for scheduling maintenance tasks like backups and monitoring their execution status.
  • You can optimize queries with DTA (Database Tuning Advisor).
  •   If you are a DB administrator, you can collect performance related data using in-build performance data collectors.
  • Provides strong support for content management.


  • Buffer pool extension is not available.
  • Analysis services are not there.
  • Not available to be purchased by the public. It is only for the web hosting providers through an SPLA (Service Provider License Agreement).

Important differences between MS SQL Server Express edition and Web edition 

  1. Cross box scale limits:
    Feature name Web edition Express edition
    Maximum memory utilized 64 GB 1410 MB
    Maximum compute capacity Limited to < 4 Sockets or 16 cores Limited to < 1 Socket or 4 cores
    Maximum relational database size 524 PB 10 GB
  2. Management tools:
    Feature name Web edition Express edition
    Distributed replay – Admin tool Yes No
    Distributed replay – Client Yes No
    Distributed replay – Controller Yes (1 Client) No
    SQL server agent Yes No
    Microsoft System Center Operations Manager Management Pack Yes No
  3. RDBMS Manageability:
    Feature name Web edition Express edition
    User instances No Yes
    Dedicated admin connection Yes Yes (with trace flag)
    Policy automation Yes No
    Performance data collector Yes No
    Standard performance reports Yes No
    PowerShell scripting support Yes Yes
    Direct query of indexed views Yes Yes
  4. Programmability:
    Feature name Web edition Express edition
    Full-text and semantic search Yes No
    Basic R & Python integration Yes No
    JSON Yes Yes
    Native XML support Yes Yes
    Specification of language in query Yes No
    Transact-SQL endpoints Yes No
  5. Reporting services:
    Feature name Web edition Express edition
    Supported catalog database Yes Yes
    Supported data source Yes Yes
    Role-based security Yes Yes (with advanced services)
    Export to Excel, PowerPoint, Word, PDF & images Yes Yes (with advanced services)
    Report server Yes Yes (with advanced services)
    Report designer Yes Yes (with advanced services)

servlet vs RESTful web service

  • REST is a software architecture “style”;
  • Servlet is a server-side technology.

You can, for example, implement REST-like services using Servlets.

  1.  Servlets are Java specific but RESTful web services are not.
  2. Servlets are API but RESTful is not.
  3. RESTful web service can use Servlets as there implementation but vice versa is not true.
  4. Servlets can run in Servlet container only but RESTful services can run in web container as well.
  5. RESTful talks about Resources/Entities/Verbs and gives you more Specific way to use the services i.e There is clear explanation on the usage of HTTP verbs.
  6. Request handling in both is totally different e.g. Servlets are multi-threaded inherently but RESTful services are not.
  7. If you want to share the RESTful services with other teams/client/public to consume there are plenty of Document tools which can generate documentation for your REST services (e.g swagger) but you won’t find that kind of documentation tools with Servlets.


There are two flavours of webservices 1) SOAP based 2) RESTful webservices.

Difference between servlets and soap based webservices: i) these webservices can’t be directly accessed through browser. ii) We need not to write webservices prototype separate, which is generating wsdl(which describes webservices using xsd), it can be published to consumers of webservices iii) soap ws are introduced to easily support SOA(Service Oriented Architecture)

Difference between servlets and restful webservices: i) Even though restful webservices directly works on http/https protocal, it provides some other web methods in addition to get, post are put, delete. Which allows to write db operation based structured code easily. ii) As restful webservices allows for pathparameters apart from query parameters, we can easily write class level and method level convenient operations-code. iii) we can use postman like browser plugins to easily check rest-api’s. We can easily add headers, body parameter, selecting different methods, content type along with request to required restful webservice under an URL. iv) we can also provide security to rest-webservices easily through header section of http request msg’s



Reference :

Atul Tiwari, Big data and Analytics (2016-present)